Re: getting better performance

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: getting better performance
Дата
Msg-id 44AE1B46.6090908@logix-tt.com
обсуждение исходный текст
Ответ на Re: getting better performance  (Eugeny N Dzhurinsky <bofh@redwerk.com>)
Список pgsql-performance
Hi, Eugeny,

Eugeny N Dzhurinsky wrote:

>> Do you add / remove tables a lot?  Could be you've got system catalog
>> bloat.
>
> Yes, almost each table is dropped and re-created in 3-5 days.

If your really recreate the same table, TRUNCATE may be a better
solution than dropping and recreation.

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

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

Предыдущее
От: Gene
Дата:
Сообщение: Update INSERT RULE while running for Partitioning
Следующее
От: Markus Schaber
Дата:
Сообщение: Re: need vacuum after insert/truncate/insert?