pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Slowness after 13.7 -> 14.4 2+ messages / 2 participants [nested] [flat]
* Slowness after 13.7 -> 14.4 @ 2022-11-09 00:06 Wells Oliver <wells.oliver@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Wells Oliver @ 2022-11-09 00:06 UTC (permalink / raw) To: pgsql-admin Upgraded 13.7 to 14.4 on RDS by restoring from a snapshot and upgrading that. My configuration files and instance type are exactly the same. After upgrading, I ran vacuumdb -Z -j 8 and that did its thing. The upgraded database is slower. I'm running EXPLAIN ANALYZE for various queries and it's getting to the same plan, but it's taking longer to execute. I've always felt after major upgrades there's some element to "priming the database" where it seems to be much faster a few days in after broader usage. I realize it sounds absurd but I'll swear by this being my experience. So I'm willing to think to some degree that queries will execute faster the more people use the upgraded database. Just wondering if there is anything I might specifically look at that would account for some of the slowness. -- Wells Oliver wells.oliver@gmail.com <wellsoliver@gmail.com> ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Slowness after 13.7 -> 14.4 @ 2022-11-09 01:51 Ron <ronljohnsonjr@gmail.com> parent: Wells Oliver <wells.oliver@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Ron @ 2022-11-09 01:51 UTC (permalink / raw) To: pgsql-admin@lists.postgresql.org On 11/8/22 18:06, Wells Oliver wrote: > Upgraded 13.7 to 14.4 on RDS by restoring from a snapshot and upgrading that. Off-topic, but did you rebuild all indices with text columns? That might not be relevant in RDS (who knows exactly what's underneath the hood?) but it might be. > My configuration files and instance type are exactly the same. After > upgrading, I ran vacuumdb -Z -j 8 and that did its thing. > The upgraded database is slower. I'm running EXPLAIN ANALYZE for various > queries and it's getting to the same plan, but it's taking longer to execute. > > I've always felt after major upgrades there's some element to "priming the > database" where it seems to be much faster a few days in after broader > usage. I realize it sounds absurd but I'll swear by this being my > experience. So I'm willing to think to some degree that queries will > execute faster the more people use the upgraded database. > > Just wondering if there is anything I might specifically look at that > would account for some of the slowness. https://dba.stackexchange.com/a/295145/63913 That answer is about loading the cache yourself, either the old school SELECT * FROM foo WHERE ... method, or using using the pg_prewarm extension. -- Angular momentum makes the world go 'round. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-11-09 01:51 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-11-09 00:06 Slowness after 13.7 -> 14.4 Wells Oliver <wells.oliver@gmail.com> 2022-11-09 01:51 ` Ron <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox