Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow timestamp query after upgrading from Pg13 to Pg16 - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Slow timestamp query after upgrading from Pg13 to Pg16
Date
Msg-id 092224fb0376bbc6a5f777199dde3cb9cd1ebf99.camel@cybertec.at
Whole thread Raw
In response to Slow timestamp query after upgrading from Pg13 to Pg16  (Simon Windsor <simon.windsor@cornfield.me.uk>)
Responses Re: Slow timestamp query after upgrading from Pg13 to Pg16
List pgsql-general
Tree view 
On Mon, 2025-04-07 at 15:48 +0100, Simon Windsor wrote:
> After upgrading a Db from Pg13 (Centos) to Pg16(Ubuntu) some queries
> on a simple, large table (200M rows) are very slow

If you used "pg_upgrade", did you ANALYZE the database?

If that is not the problem, we can't guess what your problem might be
unless you provide EXPLAIN (ANALYZE, BUFFERS, SETTINGS) output for auch a
slow query.  Ideally, add the same information for the fast v13 case.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Simon Windsor
Date:
Subject: Slow timestamp query after upgrading from Pg13 to Pg16
Next
From: Costa Alexoglou
Date:
Subject: Re: Performance regression when adding LIMIT 1 to a query