Re: Re-Create Table make Faster.
От | Robert Treat |
---|---|
Тема | Re: Re-Create Table make Faster. |
Дата | |
Msg-id | 1054332212.31884.16.camel@camel обсуждение исходный текст |
Ответ на | Re-Create Table make Faster. ("Yudha Setiawan" <inas_husband@bonbon.net>) |
Список | 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. >
В списке pgsql-general по дате отправления: