From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | Yudha Setiawan <inas_husband(at)bonbon(dot)net> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Re-Create Table make Faster. |
Date: | 2003-05-30 22:03:32 |
Message-ID: | 1054332212.31884.16.camel@camel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2003-05-30 23:02:03 | Re: Elog |
Previous Message | btober | 2003-05-30 21:29:54 | Re: Moving a table to a different schema |