Re: performance problem - 10.000 databases
От | Jeff |
---|---|
Тема | Re: performance problem - 10.000 databases |
Дата | |
Msg-id | 20031106093725.20d3a43f.threshar@torgo.978.org обсуждение исходный текст |
Ответ на | Re: performance problem - 10.000 databases (Marek Florianczyk <franki@tpi.pl>) |
Ответы |
Re: performance problem - 10.000 databases
Re: performance problem - 10.000 databases |
Список | pgsql-admin |
On 06 Nov 2003 15:21:03 +0100 Marek Florianczyk <franki@tpi.pl> wrote: > fsync = false HOLD THE BOAT THERE BATMAN! I would *STRONGLY* advise not running with fsync=false in production as PG _CANNOT_ guaruntee data consistancy in the event of a hardware failure. It would sure suck to have a power failure screw up your nice db for the users! > wal_buffers = 1024 This also seems high. come to think about it- shared_buffers is also high. > commit_delay = 10000 I could also read to data loss, but you'll get a speed increase on inserts. One of the best things you can do to increase insert speed is a nice, battery backed raid card with a pile of disks hanging off of it. -- Jeff Trout <jeff@jefftrout.com> http://www.jefftrout.com/ http://www.stuarthamm.net/
В списке pgsql-admin по дате отправления: