| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'fx TATEISHI KOJI *EXTERN*'" <koji(dot)tateishi(at)fujixerox(dot)co(dot)jp>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Performance degradation from PostgreSQL 8.2.21 to PostgreSQL 9.3.2 |
| Date: | 2017-07-19 06:46:43 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B53A8464B@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
fx TATEISHI KOJI wrote:
> Issuing exactly the same query as PostgreSQL 8.2.21 and PostgreSQL 9.3.2 will slow the
> response by 6.4 ms on average.
> What could be the cause?
> Measurement method is as follows.
> ・ PostgreSQL 8.2.21 installation
> ★Measurement
> ・ Export DUMP of PostgreSQL 8.2.21
> ・ PostgreSQL 8.2.21 uninstallation
> ・ PostgreSQL 9.3.2 installation
> ・ Dump import
> ★Measurement
It is impossible to answer this with certainty without
EXPLAIN (ANALYZE, BUFFERS) output, but my first guess is that
the statistics on the 9.3 installation are not up to date.
ANALYZE all involved tables, then try again and see if the
performance degradation has vanished.
If not, start studying the execution plans.
Are the parameters in postgresql.conf set the same?
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Nadeau | 2017-07-19 11:48:54 | Re: Very poor read performance, query independent |
| Previous Message | fx TATEISHI KOJI | 2017-07-19 01:54:46 | Performance degradation from PostgreSQL 8.2.21 to PostgreSQL 9.3.2 |