Re: very slow after a while...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: very slow after a while...
Дата
Msg-id 28287.1112806768@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: very slow after a while...  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Richard Huxton <dev@archonet.com> writes:
> Costin Manda wrote:
>> I thought the problem lied with step 4, but now I see that step 3 was
>> the culprit and that , indeed, I did not do drop table, create table but
>> delete from and inserts. I think that recreating these two tables should
>> solve the problem, isn't it?

> Hmm - try TRUNCATE rather than DELETE.

Or VACUUM between deleting and inserting.  But TRUNCATE would be better
if you can do it.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Big trouble with memory !!
Следующее
От: Ragnar Hafstað
Дата:
Сообщение: Re: very slow after a while...