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

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
max_fsm_relations = 500
(defaults for the rest)

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

(OS: HP-UX B.11.00 U 9000/800)
$ swapinfo -mt
              Mb      Mb      Mb   PCT  START/      Mb
TYPE      AVAIL    USED    FREE  USED   LIMIT RESERVE  PRI  NAME
dev        2048     147    1901    7%       0       -    1  /dev/vg00/lvol2
reserve       -     312    -312
memory      369     351      18   95%
total      2417     810    1607   34%       -       0    -

> AFAICS the planner will do this one just fine
> without any thumb on the scales.


How to I find the thumb?

Ed