Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT from a set of values really slow? - Mailing list pgsql-general

From CoL
Subject Re: SELECT from a set of values really slow?
Date
Msg-id cjrdsh$2bgc$1@news.hub.org
Whole thread Raw
In response to SELECT from a set of values really slow?  (Tim Smith <reply_in_group@mouse-potato.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Vitaly Belman
Date:
Subject: Re:
Next
From: Gaetano Mendola
Date:
Subject: Re: VACUUM FULL on 24/7 server