Thread: Postgresql 9.0.6 alway run VACUUM ANALYZE pg_catalog.pg_attribute
Hello
I am using PostgreSQL 9.0.6 64 bit on Windows 2003 64bit.
When i view Postgresql status, there are some autovaccum alway run. Ex VACUUM ANALYZE pg_catalog.pg_attribute.
Is it problem of PostgreSQL? Please help me.
Tuan Hoang Anh.
On Thu, 2012-06-28 at 21:41 +0700, tuanhoanganh wrote:
> Hello
> I am using PostgreSQL 9.0.6 64 bit on Windows 2003 64bit.
> When i view Postgresql status, there are some autovaccum alway run.
> Ex VACUUM ANALYZE pg_catalog.pg_attribute.
>
>
> Is it problem of PostgreSQL? Please help me.
Do you have activity on the database? If so, autovacuum is normal.
Regards,
Jeff Davis
Yes I have more than 10 activity connect on the database.
But VACUUM ANALYZE pg_catalog.pg_attribute, pg_catalog.pg_type, pg_catalog.pg_depend run all time of day.
Is it normal in Postgres?
Tuan Hoang Anh
On Fri, Jun 29, 2012 at 1:34 AM, Jeff Davis <pgsql@j-davis.com> wrote:
Do you have activity on the database? If so, autovacuum is normal.On Thu, 2012-06-28 at 21:41 +0700, tuanhoanganh wrote:
> Hello
> I am using PostgreSQL 9.0.6 64 bit on Windows 2003 64bit.
> When i view Postgresql status, there are some autovaccum alway run.
> Ex VACUUM ANALYZE pg_catalog.pg_attribute.
>
>
> Is it problem of PostgreSQL? Please help me.
Regards,
Jeff Davis
tuanhoanganh <hatuan05@gmail.com> wrote: > VACUUM ANALYZE pg_catalog.pg_attribute, pg_catalog.pg_type, > pg_catalog.pg_depend run all time of day. > > Is it normal in Postgres? Do you create and drop a lot of tables (including temporary tables)? What are the results of running the query on this page?: http://wiki.postgresql.org/wiki/Server_Configuration How is overall performance on the machine? -Kevin
Thanks for your help
Here is my config
"version";"PostgreSQL 9.0.6, compiled by Visual C++ build 1500, 64-bit"
"autovacuum_analyze_threshold";"250"
"autovacuum_vacuum_threshold";"1000"
"bytea_output";"escape"
"checkpoint_segments";"64"
"client_encoding";"UNICODE"
"custom_variable_classes";"symmetric"
"effective_cache_size";"4GB"
"enable_seqscan";"off"
"extra_float_digits";"2"
"lc_collate";"English_United States.1252"
"lc_ctype";"English_United States.1252"
"listen_addresses";"*"
"log_destination";"stderr"
"log_line_prefix";"%t "
"logging_collector";"on"
"maintenance_work_mem";"1GB"
"max_connections";"100"
"max_locks_per_transaction";"2000"
"max_stack_depth";"2MB"
"max_wal_senders";"5"
"port";"5433"
"server_encoding";"UTF8"
"shared_buffers";"2GB"
"shared_preload_libraries";"$libdir/plugins/plugin_debugger.dll"
"TimeZone";"Asia/Bangkok"
"wal_buffers";"2MB"
"wal_keep_segments";"128"
"wal_level";"hot_standby"
"work_mem";"64MB"
On Fri, Jun 29, 2012 at 9:13 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
tuanhoanganh <hatuan05@gmail.com> wrote:Do you create and drop a lot of tables (including temporary tables)?
> VACUUM ANALYZE pg_catalog.pg_attribute, pg_catalog.pg_type,
> pg_catalog.pg_depend run all time of day.
>
> Is it normal in Postgres?
What are the results of running the query on this page?:
http://wiki.postgresql.org/wiki/Server_Configuration
How is overall performance on the machine?
-Kevin