CODEWITHSUNDEEP
postgresql
Abubacker Nainamohamed
Abubacker Nainamohamed

Reputation: 4797

postgres software configuration to achieve 15000 statements per sec

I have system of 

17.9GB 
64-bit 2 cores each 5346 bogomips

I have a postgres server 8.4 , my requirement is to run

5000 insert statement

5000 update statement

5000 select statement

I want all this 15000 statements to be run in a second ( may be my expectation is too high )

Please tell me the right postgres configuration for this

Note : IO respond time should not have much deviation time to time ( should be static ).

Thanks in advance !

Upvotes: 0

Views: 323

Answers (2)

Scott Marlowe
Scott Marlowe

Reputation: 8870

You'll need an IO subsystem that's quite impressive to keep up. I've got a machine with 48 Magny Cours cores and 128 Gig RAM and 34 spinning 15k SAS drives that can sustain about 8000 transactions per second, which is right in the range of what you're looking for.

I could likely do that on far fewer cores, but for what these machines do they need all the CPU they can get.

For you the number of cores will likely need to be numbered in the dozen or more, and you'll need something on the order of a dozen or so SSD drives or 30 to 100 spinning SAS drives to do it.

Also, how big will your db be? You've really only given a tiny bit of the information needed to answer this question.

Upvotes: 2

Frank Heikens
Frank Heikens

Reputation: 127116

Push as many statements in a single transaction as possible. Optimize the Write Ahead Log to write all these statements together to disk.

Upvotes: 2

Related Questions