Am Montag, 7. November 2005 18:22 schrieb PostgreSQL:
> My most humble apologies to the pg development team (pg_lets?).
>
> I took Greg Stark's advice and set:
>
> shared_buffers = 10000 # was 50000
> work_mem = 1048576 # 1Gb - was 16384
>
> Also, I noticed that the EXPLAIN ANALYZE consistently thought reads would
> take longer than they actually did, so I decreased random_page_cost down to
> 1 (the server has a SATA Raid at level 10).
Don't do that, use 1.5 or 2, setting it to 1 will only work well if you have
small databases fitting completly in memory.