Re: select distinct too slow

From: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: select distinct too slow
Date: 2001-06-04 21:45:10
Message-ID: 3B1C0166.FC3E4CF5@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Did you vacuum analyse your table after creating the index?
A solution for your problem would be to turn sequential scans ofd before querying the table.
This should work somehow like that:

myjava=# SET enable_seqscan TO 'off';
SET VARIABLE
myjava=# show enable_seqscan;
NOTICE: enable_seqscan is off
SHOW VARIABLE

check out the docs for further information.

Hans

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-06-05 00:33:15 Huh? Data typing bug?
Previous Message Hans-Jürgen Schönig 2001-06-04 21:39:26 Re: seleting all dates between two dates