Groups | Search | Server Info | Keyboard shortcuts | Login | Register
Groups > comp.databases.postgresql > #896
| From | Mladen Gogala <mgogala@yahoo.com> |
|---|---|
| Newsgroups | comp.databases.postgresql |
| Subject | Re: Postgresql database behaving unpredictably |
| Date | 2021-01-21 04:15 +0000 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <ruav47$13s8$1@gioia.aioe.org> (permalink) |
| References | <3d4228fc-3e2c-4dfb-b0c5-28775615ec9fn@googlegroups.com> <kl240g1u861jn9ntuotetdfac809g2nhpl@4ax.com> |
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. -- Mladen Gogala Database Consultant https://dbwhisperer.wordpress.com
Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar
Postgresql database behaving unpredictably shariqtariq <shariqatariq@gmail.com> - 2021-01-14 17:08 -0800
Re: Postgresql database behaving unpredictably George Neuner <gneuner2@comcast.net> - 2021-01-15 16:53 -0500
Re: Postgresql database behaving unpredictably Mladen Gogala <mgogala@yahoo.com> - 2021-01-21 04:15 +0000
Re: Postgresql database behaving unpredictably George Neuner <gneuner2@comcast.net> - 2021-01-21 14:06 -0500
csiph-web