Postgres Pro
Downloads
Home   >   mailing lists

Re: Why are selects so slow on large tables, even when indexed? - Mailing list pgsql-general

From Dan Langille
Subject Re: Why are selects so slow on large tables, even when indexed?
Date
Msg-id 20020326234122.9E36B3F28@bast.unixathome.org
Whole thread Raw
In response to Why are selects so slow on large tables, even when indexed?  ("Robert Wille" <rwille@iarchives.com>)
List pgsql-general
Tree view 
On 26 Mar 2002 at 16:28, Robert Wille wrote:

> Attached are two scripts. One creates the table, the other populates it. I
> typed "create index index_a on a(id)" and "vacuum" by hand.


What was the vacuum command you issued?  I hope it was "vacuum analyze".
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples

pgsql-general by date:

Previous
From: "Robert Wille"
Date:
Subject: Why are selects so slow on large tables, even when indexed?
Next
From: Neil Conway
Date:
Subject: Re: Why are selects so slow on large tables, even when