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 <t...@sss.pgh.pa.us>: > Lampa <lamp...@gmail.com> writes: >> default_statistics_target = 8000 # range 1-10000 > >> 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) > > Well, there's a reason why the default value of that parameter is 100 > and not 10000 ;-). The larger it is, the more memory space it's going > to take to do an ANALYZE. I don't see any bug here, you're just trying > to do more than you can do in a 32-bit machine. > > I guess we could improve the documentation of default_statistics_target > to point out that it costs not only more time but more memory in > ANALYZE. > > 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
