Re: new to postgres (and db management) and performance already a problem :-(

Список
Период
Сортировка
От Andrew Sullivan
Тема Re: new to postgres (and db management) and performance already a problem :-(
Дата
Msg-id 20060117132859.GD21092@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: new to postgres (and db management) and performance already a problem :-(  (Antoine)
Список pgsql-performance
Дерево обсуждения
new to postgres (and db management) and performance already a problem :-(  (Antoine, )
 Re: new to postgres (and db management) and performance already a problem :-(  (Andrew Sullivan, )
 Re: new to postgres (and db management) and performance already a problem :-(  (Tom Lane, )
 Re: new to postgres (and db management) and performance already a problem :-(  (<>, )
  Re: new to postgres (and db management) and performance already a problem :-(  (Tom Lane, )
   Re: new to postgres (and db management) and performance  (Markus Schaber, )
 Re: new to postgres (and db management) and performance already a problem :-(  (<>, )
 Re: new to postgres (and db management) and performance already a problem :-(  (Christopher Browne, )
 Re: new to postgres (and db management) and performance already a problem :-(  (<>, )
  Re: new to postgres (and db management) and performance already a problem :-(  (Antoine, )
   Re: new to postgres (and db management) and performance already a problem :-(  (Andrew Sullivan, )
  Re: new to postgres (and db management) and performance  (Markus Schaber, )
On Tue, Jan 17, 2006 at 09:14:27AM +0100, Antoine wrote:
> think about it - we do very little removing, pretty much only inserts and
> selects. I will give it a vacuum full and see what happens.

UPDATES?  Remember that, in Postgres, UPDATE is effectively DELETE +
INSERT (from the point of view of storage, not the point of view of
the user).

A

--
Andrew Sullivan  | 
The plural of anecdote is not data.
        --Roger Brinner

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

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: Autovacuum / full vacuum
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Autovacuum / full vacuum