Re: [BUGS] BUG #6186: out of memory while analyze

2011-09-01 Thread Lampa
Hello, /proc/sys/vm/swappiness = 60 /proc/sys/vm/overcommit_memory = 0 /proc/sys/vm/overcommit_ratio = 50 total used free sharedbuffers cached Mem: 4038 3146892 0 30 3067 -/+ buffers/cache: 49 3989 Sw

Re: [BUGS] BUG #6186: out of memory while analyze

2011-09-01 Thread Valentine Gogichashvili
> > > 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

Re: [BUGS] BUG #6186: out of memory while analyze

2011-08-31 Thread Guillaume Smet
Hi Lampa, On Thu, Sep 1, 2011 at 6:26 AM, Lampa wrote: > With default value 100 have bad perfomance :-( Don't set the default value higher: specify a higher value only where needed. See ALTER TABLE ALTER [ COLUMN ] column SET STATISTICS integer ( http://www.postgresql.org/docs/9.0/interactive/s

Re: [BUGS] BUG #6186: out of memory while analyze

2011-08-31 Thread Lampa
Hello, ok or write that there is limit for 32bit system. With default value 100 have bad perfomance :-( But thank you for yours time. 2011/8/31 Tom Lane : > Lampa writes: >> default_statistics_target = 8000        # range 1-1 > >> Problem seems to be in default_statistics_target values fro

Re: [BUGS] BUG #6186: out of memory while analyze

2011-08-31 Thread Tom Lane
Lampa writes: > default_statistics_target = 8000# range 1-1 > Problem seems to be in default_statistics_target values from approx > 6300. Up to 6300 analyze works but on another machine (64bit) works > 1 without problems on same but larger table (more data) Well, there's a reason

Re: [BUGS] BUG #6186: out of memory while analyze

2011-08-30 Thread John R Pierce
On 08/30/11 10:25 PM, Lampa wrote: 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)) is this a 32bit postgres ? -- john r pierce

Re: [BUGS] BUG #6186: out of memory while analyze

2011-08-30 Thread Lampa
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

Re: [BUGS] BUG #6186: out of memory while analyze

2011-08-30 Thread Tom Lane
"Lampa" 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 -- Sent via pgsql-bugs ma

Re: [BUGS] BUG #6186: out of memory while analyze

2011-08-30 Thread Heikki Linnakangas
On 30.08.2011 14:20, Lampa wrote: Trying analyze table (ANALYZE TABLE table or VACUUM ANALYZE table) with 3051316 rows (displayed size 2521MB in \dt+) Log: ... Analyze: 2236767256 total in 279 blocks; 18080 free (423 chunks); 2236749176 used > ... Hmm, that looks like a memory like in A

[BUGS] BUG #6186: out of memory while analyze

2011-08-30 Thread Lampa
The following bug has been logged online: Bug reference: 6186 Logged by: Lampa Email address: lamp...@gmail.com PostgreSQL version: 9.0.4/8.4.8 Operating system: Linux Debian testing 32bit Description:out of memory while analyze Details: Trying analyze table (ANALYZ