Hello - I am running an application on postgresql 9.5 that features a
515 million record table. The following query used to run in under 10
seconds
SNIP QUERY
Overnight the query is starting to run in 4 plus minutes
so I migrated the database to postgres 12 and now the query runs in a
shade over 2 minutes
However, sudden drastic performance drop smells a lot like imminent disk failure.
On Fri, 15 Jan 2021 16:53:12 -0500, George Neuner wrote:
However, sudden drastic performance drop smells a lot like imminent disk
failure.
Huh? I am an Oracle DBA with some experience in Postgres and have
experienced many performance drops after a version upgrade and precisely
0 of those performance drops were caused by "imminent disk failure".
I would check whether the plans have changed, what is the difference in >parameters, check where the time is spent by using perf or strace and
check the logs. If the plans have changed, try installing pg_hint_plan >extension and force the desired plans. Then compare.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 293 |
Nodes: | 16 (2 / 14) |
Uptime: | 232:01:16 |
Calls: | 6,624 |
Files: | 12,171 |
Messages: | 5,319,447 |