Re: Hash Join vs Nested Loops in 7.2.1 ... - Mailing list pgsql-general

From Tom Lane
Subject Re: Hash Join vs Nested Loops in 7.2.1 ...
Date
Msg-id 28415.1018358099@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hash Join vs Nested Loops in 7.2.1 ...  (Ed Loehr <pggeneral@bluepolka.net>)
List pgsql-general
Ed Loehr <pggeneral@bluepolka.net> writes:
> Tom Lane wrote:
> Second, the same query sometimes takes 10-50 seconds shortly after
> possibly a dump or other high-data-volume queries are executed, after
> which it then returns to 1 second execution time.  Getting crowded out
> of shared memory?
>>
>> Sounds like it.  What shared-buffers setting are you using?  How much
>> RAM in the box?

> shared_buffers = 256

That's not a lot --- 256*8K = 2MB.  You might try something in the low
thousands.

> RAM:  2.4GB, maybe?  Not that familiar with HPUX mem setup...

swapinfo won't tell you anything about physical RAM.  If you poke around
in SAM, I think there's some displays in there about hardware ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Daniel Morgan"
Date:
Subject: PostgreSQL and C#
Next
From: "Papp, Gyozo"
Date:
Subject: SPI_execp() failed in RI_FKey_cascade_del()