Re: [GENERAL] [GENERAL/INTERFACES] Dynamically detecting need to vacuum?

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: [GENERAL] [GENERAL/INTERFACES] Dynamically detecting need to vacuum?
Дата
Msg-id
Pine.LNX.4.20.9912132250040.361-100000@localhost.localdomain
Ответ на
Список
Дерево обсуждения
Re: [GENERAL] Is it safe to INSERT/DELETE during VACUUM? Adriaan Joubert <a.joubert@albourne.com>
On 1999-12-13, Ed Loehr mentioned:

> documentation recommends to vacuum nightly or after copying a large class
> (not sure exactly what that means) or deleting a large number of records.

copying -- as invoked via the COPY command (in general this means
inserting, though)
large -- probably anything with triple-digit row counts
class -- table, relation; in general rows, records, data, stuff

> [Hackers:  it'd be nice to have pgsql optionally take care of this...]

There are some disabled code fragments that take into account a "vacuum
daemon". It's even on the TODO list, but vacuum itself needs to be sorted
out first.

Sorry, no free lunch here, probably.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


В списке pgsql-general по дате отправления
От: Peter Eisentraut
Дата:
От: Lamar Owen
Дата:
FAQ