Re: Slow timestamp query after upgrading from Pg13 to Pg16

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Simon Windsor <simon(dot)windsor(at)cornfield(dot)me(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: Slow timestamp query after upgrading from Pg13 to Pg16
Date: 2025-04-07 14:51:40
Message-ID: 092224fb0376bbc6a5f777199dde3cb9cd1ebf99.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Costa Alexoglou 2025-04-07 15:34:47 Re: Performance regression when adding LIMIT 1 to a query
Previous Message Simon Windsor 2025-04-07 14:48:48 Slow timestamp query after upgrading from Pg13 to Pg16