| From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | Marek Florianczyk <franki(at)tpi(dot)pl> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: performance problem - 10.000 databases |
| Date: | 2003-11-06 14:37:25 |
| Message-ID: | 20031106093725.20d3a43f.threshar@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 06 Nov 2003 15:21:03 +0100
Marek Florianczyk <franki(at)tpi(dot)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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marek Florianczyk | 2003-11-06 14:38:43 | Re: performance problem - 10.000 databases |
| Previous Message | Ravikant Mohite | 2003-11-06 14:28:03 | About Postgres Db size |