Postgres Pro
Downloads
Home   >   mailing lists

Re: Understanding sequential versus index scans. - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Understanding sequential versus index scans.
Date
Msg-id dcc563d10907191805s37af2aaby39351ef0d783fb2f@mail.gmail.com
Whole thread Raw
In response to Re: Understanding sequential versus index scans.  (Robert James <srobertjames@gmail.com>)
Responses Re: Understanding sequential versus index scans.
List pgsql-general
Tree view 
On Sun, Jul 19, 2009 at 6:10 PM, Robert James<srobertjames@gmail.com> wrote:
> UNION was better, but still 5 times as slow as either query done
> individually.
> set enable_seqscan=off didn't help at all - it was totally ignored
> Is there anything else I can do?

Did you try union, or union all?

pgsql-general by date:

Previous
From: Robert James
Date:
Subject: Re: Understanding sequential versus index scans.
Next
From: Chris
Date:
Subject: Re: Should I CLUSTER on PRIMARY KEY