Re: Understanding sequential versus index scans.

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Robert James <srobertjames(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Understanding sequential versus index scans.
Date: 2009-07-20 01:05:00
Message-ID: dcc563d10907191805s37af2aaby39351ef0d783fb2f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Jul 19, 2009 at 6:10 PM, Robert James<srobertjames(at)gmail(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2009-07-20 01:23:49 Re: Should I CLUSTER on PRIMARY KEY
Previous Message Robert James 2009-07-20 00:58:05 Re: Understanding sequential versus index scans.