Hello, table design http://pastebin.com/RW6vLAVP
And configuration: ssl = false shared_buffers = 900MB # min 128kB work_mem = 100MB # min 64kB maintenance_work_mem = 524MB # min 1MB fsync = off # turns forced synchronization on or off synchronous_commit = off # immediate fsync at commit full_page_writes = off # recover from partial page writes effective_cache_size = 1GB default_statistics_target = 8000 # range 1-10000 Also tried change maintenance_work_mem to 2G and same result. Imposible to set over 2GB (FATAL: 3145728 is outside the valid range for parameter "maintenance_work_mem" (1024 .. 2097151)) Problem seems to be in default_statistics_target values from approx 6300. Up to 6300 analyze works but on another machine (64bit) works 10000 without problems on same but larger table (more data) 2011/8/30 Tom Lane <t...@sss.pgh.pa.us>: > "Lampa" <lamp...@gmail.com> writes: >> Trying analyze table (ANALYZE TABLE table or VACUUM ANALYZE table) with >> 3051316 rows (displayed size 2521MB in \dt+) > > What have you got maintenance_work_mem set to? shared_buffers might > also be interesting. > > regards, tom lane > -- Lampa -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
