Re: getting better performance

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Eugeny N Dzhurinsky <bofh(at)redwerk(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: getting better performance
Date: 2006-07-07 08:28:54
Message-ID: 44AE1B46.6090908@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Markus Schaber 2006-07-07 08:32:07 Re: need vacuum after insert/truncate/insert?
Previous Message Gene 2006-07-07 07:51:38 Update INSERT RULE while running for Partitioning