Hey guyz, thanks for help. I solved the problems. The reason was in bad query, that i've accidentally committed right after upgrading. PostgreSQL 8.4 is perfect! Analyze works like a charm, and MUCH better than in 8.3.
2009/7/31 Kevin Grittner <[email protected]>: > Tom Lane <[email protected]> wrote: >> Scott Carey <[email protected]> writes: >>> Gzip does have some quirky performance behavior depending on the >>> chunk size of data you stream into it. >> >> Can you enlarge on that comment? I'm not sure that pg_dump is aware >> that there's anything to worry about there. > > If the library used here is anything like the native library used by > Java, it'd be worth putting a buffer layer ahead of the calls to gzip, > so it isn't dealing with each individual value as a separate call. I > seem to remember running into that issue in Java, where throwing a > BufferedOutputStream in there fixed the performance issue. > > -Kevin > > -- > Sent via pgsql-performance mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
