Re: Re-Create Table make Faster.

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.

See:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=routine-vacuuming.html
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-vacuum.html

Robert Treat

On Sat, 2003-05-24 at 03:44, Yudha Setiawan wrote:
> Dear Milist,
>
> One day i got a problem with my table,
> It's have 35.000 records and 33 Fields.
> I tried to do Update a 30% records from
> it. And I also have an Match Index with
> my condition on Update. Before Updating
> the table, I did the Vacuum and Reindex.
> That table, But it's still taken a long
> time it's about 30 Minutes. I've tried
> Vacuum and Reindex many times for that.
> But it still take a long-long time. And
> Finaly in the middle of my confusing and
> disperate i tried to drop and recreate my
> table again. And my "Update" is walking
> so fast. But i still confusing of how
> could be like that...????, Somebody give
> me some explanation please.
>