Re: Performance issue - Mailing list pgsql-performance

From Sean Chittenden
Subject Re: Performance issue
Date
Msg-id 20030924174721.GA11474@perrin.nxad.com
Whole thread Raw
In response to Performance issue  (peter <pmcgregor@advso.com>)
List pgsql-performance
> My statistics(Athlon 1.8Ghz)
> ----------------
> 20,000 items            Takes on average 0.078seconds/room
> 385,000 items          Takes on average .11seconds/room
> 690,000 items          takes on average .270seconds/room
> 1,028,000 items       Takes on average .475seconds/room
[snip]
>  I am running Red hat 8. Some of my conf entries that I have changed
> follow
> shared_buffers = 3700
> effective_cache_size = 4000
> sort_mem = 32168

Have you twiddled with your wal_buffers or checkpoint_segments?  Might
be something to look at.

-sc

--
Sean Chittenden

pgsql-performance by date:

Previous
From: "Matt Clark"
Date:
Subject: Re: Index problem
Next
From: Rod Taylor
Date:
Subject: Re: Performance issue