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 <kevin.gritt...@wicourts.gov>: > Tom Lane <t...@sss.pgh.pa.us> wrote: >> Scott Carey <sc...@richrelevance.com> 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 (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
