Re: Why are selects so slow on large tables, even when indexed?

From: "Dan Langille" <dan(at)langille(dot)org>
To: "Robert Wille" <rwille(at)iarchives(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why are selects so slow on large tables, even when indexed?
Date: 2002-03-26 23:41:15
Message-ID: 20020326234122.9E36B3F28@bast.unixathome.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2002-03-26 23:47:53 Re: Why are selects so slow on large tables, even when
Previous Message Robert Wille 2002-03-26 23:28:54 Why are selects so slow on large tables, even when indexed?