Re: 8.2.4 serious slowdown

On Jan 10, 2008 12:33 PM, Sim Zacks <sim(at)compulab(dot)co(dot)il> wrote:
> > Perhaps a suboptimal plan is picked due to configuration issues, e.g.
> > memory constraints? Could you post your postgresql.conf as well?
>
> Below is the postgresql.conf file for 8.2.4. The server has 2 GB of RAM and it was not maxed out when I ran the query.
> As I mentioned, I tried running both 8.0.11 and 8.2.4 on the same hardware, so that I would see if it was a difference in the hardware or the database.
>
> # -----------------------------
> # PostgreSQL configuration file
> # -----------------------------

> shared_buffers = 24MB# min 128kB or max_connections*16kB
That's really low. Try setting it to something a bit more aggressive,
say 100MB to 500MB. On a machine with 2 Gig ram, that's a pretty
reasonable range.

> #work_mem = 1MB# min 64kB
Try setting this a little higher, say 16 to 32 Megs.