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@xxxxxxxxxxxx> wrote:
tuanhoanganh <hatuan05@xxxxxxxxx> 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
