Re: seq scan woes

From: "Dan Langille" <dan(at)langille(dot)org>
To: Rod Taylor <ports(at)rbt(dot)ca>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: seq scan woes
Date: 2004-06-07 22:55:24
Message-ID: 40C4BA1C.26370.498870C7@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 7 Jun 2004 at 18:49, Dan Langille wrote:

> On 7 Jun 2004 at 16:38, Rod Taylor wrote:
> > * random_page_cost (good disks will bring this down to a 2 from a
> > 4)
>
> I've got mine set at 4. Increasing it to 6 gave me a 1971ms query.
> At 3, it was a 995ms. Setting it to 2 gave me a 153ms query.
>
> How interesting.

The explain analyse: http://rafb.net/paste/results/pWhHsL86.html
--
Dan Langille : http://www.langille.org/
BSDCan - http://www.bsdcan.org/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josué Maldonado 2004-06-07 23:12:44 Re: Join slow on "large" tables
Previous Message Dan Langille 2004-06-07 22:49:46 Re: seq scan woes