public inbox for pgsql-performance@postgresql.org
help / color / mirror / Atom feedDB slowness after upgrade from Postgres 9.1 to 9.4
2+ messages / 2 participants
[nested] [flat]
* DB slowness after upgrade from Postgres 9.1 to 9.4
@ 2017-11-10 10:58 p kirti <kirtip92@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: p kirti @ 2017-11-10 10:58 UTC (permalink / raw)
To: pgsql-performance
Hi all,
We have recently upgraded our project with a huge DB from Postgres v9.1 to
v9.4. The whole system performance has degraded alarmingly after the
upgrade. Simple operations that were taking only a few seconds in Postgres
9.1 are now taking minutes of time.
The problem is not specific to one query orany particular kind of query.
Its been generic and overall system has become very slow.
We tried running 'VACUUM ANALYZE' on the DB and that seemed to be helpful
too. But the improvement after this is nowhere close to the performance we
had in 9.1.
We tried changing some of the performance parameters in the
postgres.confirm as follows (our Postgres server has an 8GB RAM) -
shared_buffers = 200MB
maintenance_work_mem = 1000MB
default_statistics_target = 1000
effective_cache_size = 4000MB
And these made absolutely no difference to the query execution time.
The strangest part of the problem is when I EXPLAIN ANALYZE the same query
multiple times in the same Postgres server, it gives me different execution
times every time ranging from 45 ms to 181 ms.
We are absolutely clueless on how to proceed. Any help would be greatly
appreciated.
Thanks in advance.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: DB slowness after upgrade from Postgres 9.1 to 9.4
@ 2017-11-12 19:37 Tom Lane <tgl@sss.pgh.pa.us>
parent: p kirti <kirtip92@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2017-11-12 19:37 UTC (permalink / raw)
To: p kirti <kirtip92@gmail.com>; +Cc: pgsql-performance
p kirti <kirtip92@gmail.com> writes:
> We have recently upgraded our project with a huge DB from Postgres v9.1 to
> v9.4. The whole system performance has degraded alarmingly after the
> upgrade. Simple operations that were taking only a few seconds in Postgres
> 9.1 are now taking minutes of time.
Are you certain nothing else changed? Same hardware, same OS, same
database configuration settings?
Once you've eliminated issues like that, you'd need to drill down deeper.
There's useful advice to help crystallize the situation at
https://wiki.postgresql.org/wiki/Slow_Query_Questions
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-11-12 19:37 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-11-10 10:58 DB slowness after upgrade from Postgres 9.1 to 9.4 p kirti <kirtip92@gmail.com>
2017-11-12 19:37 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox