From: Hans-Jürgen Schönig <hs@cybertec.at>
To: pgsql-sql@postgresql.org
Subject: Re: select distinct too slow
Date: Mon, 04 Jun 2001 23:45:10 +0200
Message-ID: <3B1C0166.FC3E4CF5@cybertec.at> (raw)
References: <20010601123641.4c0d96c0.gry@ll.mit.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hs@cybertec.at
Subject: Re: select distinct too slow
In-Reply-To: <3B1C0166.FC3E4CF5@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox