Ed Loehr <pggeneral(at)bluepolka(dot)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