Re: postgres performance tunning
| От | Robert Haas |
|---|---|
| Тема | Re: postgres performance tunning |
| Дата | |
| Msg-id | AANLkTinQmo7F+fu90X10Qy3GkQDZzObZJ1Wp3sC9N=pe@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: postgres performance tunning (Greg Smith <greg@2ndquadrant.com>) |
| Ответы |
Re: postgres performance tunning
|
| Список | pgsql-performance |
On Mon, Dec 20, 2010 at 12:49 PM, Greg Smith <greg@2ndquadrant.com> wrote: > Scott Marlowe wrote: >> I can sustain about 5,000 transactions per second on a machine with 8 >> cores (2 years old) and 14 15k seagate hard drives. > > Right. You can hit 2 to 3000/second with a relatively inexpensive system, > so long as you have a battery-backed RAID controller and a few hard drives. > Doing 5K writes/second is going to take a giant pile of hard drive or SSDs > to pull off. There is no possible way to meet the performance objectives > here without a lot more cores in the server and some pretty beefy storage > too. Is this with synchronous_commit on, or off? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-performance по дате отправления: