Re: WITHOUT OIDS
От | Andrew Bartley |
---|---|
Тема | Re: WITHOUT OIDS |
Дата | |
Msg-id | 001301c2dde1$3b021ed0$3200a8c0@abartleypc обсуждение исходный текст |
Ответ на | create view (Ryan VanderBijl <rvbijl-pgsql@vanderbijlfamily.com>) |
Список | pgsql-general |
----- Original Message ----- From: "Neil Conway" <neilc@samurai.com> To: "Andrew Bartley" <abartley@evolvosystems.com> Cc: "PostgreSQL General" <pgsql-general@postgresql.org> Sent: Wednesday, February 26, 2003 5:40 PM Subject: Re: [GENERAL] WITHOUT OIDS > 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? No, a regular vacuum does not seem to make the same difference. > > > 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?) I am aware of this. Time spent vacuuming and performance of these tables is critical. We process around 30,000,000 transnactions a day. We use a batch oriented process that takes these transactions and explodes them into hundreds of normalised tables. This process runs every five minutes. This database also supports a front end reporting system that handles dynamic reporting requests. > > > 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. But it would make a difference.. Right? Thanks for you time Andrew
В списке pgsql-general по дате отправления: