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.Grittner@xxxxxxxxxxxx>: > Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> Scott Carey <scott@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
