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

Поиск
Список
Период
Сортировка
От Dan Langille
Тема Re: Why are selects so slow on large tables, even when indexed?
Дата
Msg-id 20020326234122.9E36B3F28@bast.unixathome.org
обсуждение исходный текст
Ответ на Why are selects so slow on large tables, even when indexed?  ("Robert Wille" <rwille@iarchives.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Robert Wille"
Дата:
Сообщение: Why are selects so slow on large tables, even when indexed?
Следующее
От: Neil Conway
Дата:
Сообщение: Re: Why are selects so slow on large tables, even when