Re: WITHOUT OIDS
От | Neil Conway |
---|---|
Тема | Re: WITHOUT OIDS |
Дата | |
Msg-id | 1046241625.433.60.camel@tokyo обсуждение исходный текст |
Ответ на | WITHOUT OIDS ("Andrew Bartley" <abartley@evolvosystems.com>) |
Список | pgsql-general |
On Tue, 2003-02-25 at 19:59, Andrew Bartley wrote: > The Function slows down during the day considerably. I suspect it is due > the constant creation and dropping of temp tables. If I vacuum full > pg_attribute and pg_class it fixes the problem. Does a regular VACUUM accomplish the same result? > But unfortunately vacuuming these table every run is not practical as > it takes so much time. Can you elaborate? VACUUMing *just* the pg_attribute and pg_class tables takes an excessive amount of time? (You're aware you can VACUUM specific tables, as well as entire databases, right?) > If I were to create the temp tables without oids, does this mean both > pg_attribute and pg_class will not be as affected. AFAIK, it wouldn't affect either significantly. Cheers, Neil -- Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
В списке pgsql-general по дате отправления: