Re: Hash Join vs Nested Loops in 7.2.1 ...

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