Re: 8.2.4 serious slowdown

On 1/10/08, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> 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.
>

Also, effective_cache_size should be about 1GB on a server with 2GB ram.

See <http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm>
for a quick, up-to-date, intro to postgres tuning.

Kind regards,
Isak