Eugeny N Dzhurinsky wrote:
On Wed, Jul 05, 2006 at 09:39:31AM -0400, Tom Lane wrote:
Eugeny N Dzhurinsky <[EMAIL PROTECTED]> writes:
but it seems pg_autovacuum does not do vacuuming on system tables.
There was a bug awhile back whereby autovac failed to notice temp table
cleanup at connection
On Wed, Jul 05, 2006 at 09:39:31AM -0400, Tom Lane wrote:
> Eugeny N Dzhurinsky <[EMAIL PROTECTED]> writes:
> > but it seems pg_autovacuum does not do vacuuming on system tables.
>
> There was a bug awhile back whereby autovac failed to notice temp table
> cleanup at connection end --- maybe you n
Eugeny N Dzhurinsky <[EMAIL PROTECTED]> writes:
> but it seems pg_autovacuum does not do vacuuming on system tables.
There was a bug awhile back whereby autovac failed to notice temp table
cleanup at connection end --- maybe you need to update?
regards, tom lane
-
Hello!
I facing some strange problems with PostgreSQL 8.0 performance.
I have application which handles a lot of tasks, each task is keps in separate
table. Those tables are dropped and created again periodically (precisely -
when new task results came back from remote server). Also each table can
