Re: problems with large table

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: problems with large table
Дата
Msg-id
20070912200950.GA5593@alvh.no-ip.org
Ответ на
Список
Дерево обсуждения
problems with large table Mike Charnoky <noky@nextbus.com>
Re: problems with large table "Joshua D. Drake" <jd@commandprompt.com>
Re: problems with large table Alvaro Herrera <alvherre@commandprompt.com>
Re: problems with large table Tom Lane <tgl@sss.pgh.pa.us>
Re: problems with large table Mike Charnoky <noky@nextbus.com>
Re: problems with large table Alvaro Herrera <alvherre@commandprompt.com>
Re: problems with large table "Phoenix Kiula" <phoenix.kiula@gmail.com>
Re: problems with large table Alvaro Herrera <alvherre@commandprompt.com>
Re: problems with large table Tom Lane <tgl@sss.pgh.pa.us>
Re: problems with large table "Phoenix Kiula" <phoenix.kiula@gmail.com>
Re: problems with large table Mike Charnoky <noky@nextbus.com>
Mike Charnoky wrote:

> Alvaro: The cluster suggestion probably won't help in my case since data
> in the table should already be naturally ordered by date.

It's not helpful only for reordering, but also for getting rid of dead
tuples.

-- 
Alvaro Herrera                         http://www.flickr.com/photos/alvherre/
"Porque Kim no hacia nada, pero, eso sí,
con extraordinario éxito" ("Kim", Kipling)
/bin/bash: sigcommand: command not found
В списке pgsql-general по дате отправления
От: Mike Charnoky
Дата:
Сообщение: Re: problems with large table
От: Cultural Sublimation
Дата:
FAQ