Postgres Pro
Downloads
Home   >   mailing lists

Re: much slower query in production - Mailing list pgsql-performance

From Jeff Janes
Subject Re: much slower query in production
Date
Msg-id CAMkU=1yhN7Hum7wDLa71dC3AeYHxQDNGosN5-yefWrnauR-GBg@mail.gmail.com
Whole thread Raw
In response to much slower query in production  (Guillaume Cottenceau <gc@mnc.ch>)
List pgsql-performance
Tree view
On Wed, Feb 26, 2020 at 11:17 AM Guillaume Cottenceau <gc@mnc.ch> wrote:
Dear all,

I am facing a much, much slower query in production than on my
development computer using a restored production backup, and I
don't understand why nor I see what I could do to speedup the
query on production :/

You've already seen a VACUUM fixed it.

This must have been a logical restore (from pg_dump), not a physical restore (from pg_basebackup for example) correct?

A physical restore should have resulted in a database in the same state of vacuuming as its source was.  A logical restore will not, and since it is an append-only process it will not trigger autovacuum to run, either.

If you do a logical restore, probably the first should you do afterwards is a VACUUM ANALYZE.

Cheers,

Jeff

pgsql-performance by date:

Previous
From: Guillaume Cottenceau
Date:
Subject: Re: much slower query in production
Next
From: Jeff Janes
Date:
Subject: Re: much slower query in production