Re: SELECT from a set of values really slow?

From: CoL <col(at)mportal(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SELECT from a set of values really slow?
Date: 2004-10-04 11:58:08
Message-ID: cjrdsh$2bgc$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

Tim Smith wrote:
>
> What's going on here?
>

#>explain analyze SELECT id FROM bench WHERE data IN ('X', 'Y');
#>set enable_seqscan to off;
#>explain analyze SELECT id FROM bench WHERE data IN ('X', 'Y');

result?

C.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff MacDonald 2004-10-04 13:33:16 weird issues with plpgsql calls.
Previous Message Antonios Christofides 2004-10-04 10:19:14 Is Win32 port good for operational use?