From: | Ed Loehr <pggeneral(at)bluepolka(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Hash Join vs Nested Loops in 7.2.1 ... |
Date: | 2002-04-09 05:36:51 |
Message-ID: | 3CB27DF3.8010108@bluepolka.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2002-04-09 06:22:53 | Re: [GENERAL] now() AT TIME ZONE 'GMT'; |
Previous Message | Tom Lane | 2002-04-09 05:07:26 | Re: Hash Join vs Nested Loops in 7.2.1 ... |