Re: Re-Create Table make Faster.

From: "Yudha Setiawan" <inas_husband(at)bonbon(dot)net>
To: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re-Create Table make Faster.
Date: 2003-06-02 10:10:08
Message-ID: 000201c32aff$3a94e750$ea00a8c0@yudha
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank's for Dear Robert Treat for your response.

you're wrote;
> Sounds like you need to read up on the vacuum command. Your table
> probably had a lot of dead tuples which were eliminated by a
> drop/recreate.

Was the night-running do the vacuum and reindex using crontab not enough.
'till i had a lot of dead tuples.

GOD Bless You All.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Verhaag, G. 2003-06-02 10:21:33 ERROR: CreateTrigger: function.....
Previous Message Csaba Nagy 2003-06-02 09:16:00 Re: implicit abort harmful?