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

[BUGS] BUG #6191: One click installer fails

2011-08-31 Thread Mark Lamberton
The following bug has been logged online: Bug reference: 6191 Logged by: Mark Lamberton Email address: m...@penguinsystems.com.au PostgreSQL version: 9.0.4-1 Operating system: Windows 7 Description:One click installer fails Details: Problem signature: Problem Even

[BUGS] The translation into Bulgarian

2011-08-31 Thread Albert Ward
Hello, I am interested in your publication http://www.postgresql.org/docs/8.1/static/kernel-resources.html and would like to translate it to Bulgarian language, so I can share it with the readers on my blog. For doing that I need your written permission. Of course, I will credit you as an autho

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

[BUGS] BUG #6189: libpq: sslmode=require verifies server certificate if root.crt is present

2011-08-31 Thread Srinivas Aji
The following bug has been logged online: Bug reference: 6189 Logged by: Srinivas Aji Email address: srinivas@emc.com PostgreSQL version: 9.0.4 Operating system: Linux Description:libpq: sslmode=require verifies server certificate if root.crt is present Details: