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

2011-09-01 Thread Lampa
emory > and /proc/sys/vm/overcommit_ratio? What is your swap size. They all > influence CommitLimit and the amount of memory, you can get. > -- Valentin > > -- Lampa -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

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_statis

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

2011-08-30 Thread Lampa
00 without problems on same but larger table (more data) 2011/8/30 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?  s

[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

Re: [BUGS] BUG #5010: perl iconv function returns ? character

2009-09-06 Thread Lampa
: postgres=CTc/postgres (3 rows) 2009/9/6 Tom Lane : > Robert Haas writes: >> On Tue, Aug 25, 2009 at 8:15 AM, Lampa wrote: >>> function my_ascii2 is defined: >>> CREATE FUNCTION my_ascii2(text) RETURNS text AS $$ use strict; use >&

[BUGS] BUG #5010: perl iconv function returns ? character

2009-08-25 Thread Lampa
The following bug has been logged online: Bug reference: 5010 Logged by: Lampa Email address: lamp...@gmail.com PostgreSQL version: 8.4.0 Operating system: Debian testing/unstable Description:perl iconv function returns ? character Details: See the difference

[BUGS] BUG #4341: planner doesn't using index for = operation

2008-08-06 Thread Lampa
The following bug has been logged online: Bug reference: 4341 Logged by: Lampa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Debian 2.6.18-6-amd64 #1 SMP Sun Feb 10 17:50:19 UTC 2008 x86_64 GNU/Linux Description:planner doesn't

[BUGS] BUG #4292: directory pg_clog never cleaned

2008-07-10 Thread Lampa
The following bug has been logged online: Bug reference: 4292 Logged by: Lampa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3, 8.1.8 Operating system: Debian x86_64, Debian i686 Description:directory pg_clog never cleaned Details: Directory pg_clog, is