Re: how much ram do i give postgres?

On Wed, 20 Oct 2004 19:59:38 +0100, Gary Doades <gpd@gpdnet.co.uk> wrote:
> Hmm, that seems a bit slow. How big are the rows you are inserting? Have you checked
> the cpu and IO usage during the inserts? You will need to do some kind of cpu/IO
> monitoring to determine where the bottleneck is.

The bulk inserts don't take full cpu. Between 40% and 80%. On the
other hand, a select will take 99% cpu.

>
> What hardware is this on? Sorry if you specified it earlier, I can't seem to find mention of
> it.

It's on a P4 HT with 1,128 megs ram.

-Josh