| From: | Andrew Rawnsley <ronz(at)ravensfield(dot)com> |
|---|---|
| To: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: annoying query/planner choice |
| Date: | 2004-01-12 04:05:10 |
| Message-ID: | 83C6D7BA-44B4-11D8-8262-000393A47FCC@ravensfield.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Low (1000). I'll fiddle with that. I just noticed that the machine only
has 512MB of ram in it, and not 1GB. I must
have raided it for some other machine...
On Jan 11, 2004, at 10:50 PM, Dennis Bjorklund wrote:
> On Sun, 11 Jan 2004, Andrew Rawnsley wrote:
>
>> 20-25% of the time. Fiddling with CPU_TUPLE_COST doesn't do anything
>> until I exceed 0.5, which strikes me as a bit high (though please
>> correct me if I am assuming too much...). RANDOM_PAGE_COST seems to
>> have
>> no effect.
>
> What about the effective cache size, is that set properly?
>
> --
> /Dennis Björklund
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
>
--------------------
Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-01-12 05:40:13 | Re: annoying query/planner choice |
| Previous Message | Christopher Browne | 2004-01-12 03:56:59 | Re: annoying query/planner choice |