Re: Unusual table size and very slow inserts

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Unusual table size and very slow inserts
Дата
Msg-id dcc563d11002021306v41ca19bbmea617e5b8a691056@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unusual table size and very slow inserts  (Ivano Luberti <luberti@archicoop.it>)
Список pgsql-general
On Tue, Feb 2, 2010 at 1:45 PM, Ivano Luberti <luberti@archicoop.it> wrote:
> In this table and all her sisters in the other schemas, records are only
> inserted and deleted. No update

same diff.  In pgsql an update equals a delete and an insert.  deleted
rows use up space just like former versions from an update.  If you're
deleting a lot of rows then you'll have a lot of bloat.

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

Предыдущее
От: Ivano Luberti
Дата:
Сообщение: Re: Unusual table size and very slow inserts
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Questions on PostGreSQL Authentication mechanism...