Thanks for your help I don't create and drop alot of tables.7 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"
Tuan Hoang Anh On Fri, Jun 29, 2012 at 9:13 PM, Kevin Grittner <kevin.gritt...@wicourts.gov > wrote: > tuanhoanganh <hatua...@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 >
