Re: problem with select count(*) ..

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: problem with select count(*) ..
Дата
Msg-id 20031119154959.GA18327@wolff.to
обсуждение исходный текст
Ответ на problem with select count(*) ..  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Список pgsql-performance
On Thu, Nov 20, 2003 at 07:07:30 +0530,
  Rajesh Kumar Mallah <mallah@trade-india.com> wrote:
>
> If i dump and reload the performance improves and it takes < 1 sec. This
> is what i have been doing since the upgrade. But its not a solution.
>
> The Vacuum full is at the end of a loading batch SQL file which makes lot of
> insert , deletes and updates.

If a dump and reload fixes your problem, most likely you have a lot of
dead tuples in the table. You might need to run vacuum more often.
You might have an open transaction that is preventing vacuum full
from cleaning up the table.

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: More detail on settings for pgavd?
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: TEXT column and indexing