Re: Improve Postgres Query Speed

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Improve Postgres Query Speed
Дата
Msg-id 1168976529.9586.11.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Improve Postgres Query Speed  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Mon, 2007-01-15 at 23:26, Tom Lane wrote:
> "carter ck" <carterck32@hotmail.com> writes:
> > And you are definitely right when updating the table. The time it takes is
> > getting longer and longer. When I do a select statement, the speed has also
> > degraded.
>
> Seems like you need a VACUUM in there somewhere...

If he hasn't been vacuuming up until now, he'll need a vacuum full.

then regular vacuums.

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: trigger howto question
Следующее
От: "Chad Wagner"
Дата:
Сообщение: Re: Temp Table Within PLPGSQL Function - Something Awry