Re: Re-Create Table make Faster. - Mailing list pgsql-general

From Yudha Setiawan
Subject Re: Re-Create Table make Faster.
Date
Msg-id 000201c32aff$3a94e750$ea00a8c0@yudha
Whole thread Raw
In response to Re-Create Table make Faster.  ("Yudha Setiawan" <inas_husband@bonbon.net>)
List 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.




pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Nulls get converted to 0 problem
Next
From: Bruno Wolff III
Date:
Subject: Re: Nulls get converted to 0 problem