WITHOUT OIDS
От | Andrew Bartley |
---|---|
Тема | WITHOUT OIDS |
Дата | |
Msg-id | 000d01c2dd32$55c1e930$3200a8c0@abartleypc обсуждение исходный текст |
Ответ на | create view (Ryan VanderBijl <rvbijl-pgsql@vanderbijlfamily.com>) |
Ответы |
Re: WITHOUT OIDS
Re: WITHOUT OIDS |
Список | pgsql-general |
Hi all, We have a function that runs under cron every 5 minutes. It creates a lot of temp tables. 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. But unfortunately vacuuming these table every run is not practical as it takes so much time. If I were to create the temp tables without oids, does this mean both pg_attribute and pg_class will not be as affected. If so, can I specify without oids when creating a temp table as follows? create temp table test as select * from test2 Thanks Andrew Bartley
В списке pgsql-general по дате отправления: