From: Rondat Flyag <rondatflyag@yandex.ru>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: Re: Queries containing ORDER BY and LIMIT started to work slowly
Date: Tue, 29 Aug 2023 21:55:56 +0300
Message-ID: <2854111693335271@mail.yandex.ru> (raw)
In-Reply-To: <CAMkU=1w+RgLQVkqLudpfsax5HQgY94WFmSH+RfydmsN55a_QGQ@mail.gmail.com>
References: <32431693330715@mail.yandex.ru>
<CAMkU=1w+RgLQVkqLudpfsax5HQgY94WFmSH+RfydmsN55a_QGQ@mail.gmail.com>
<div>I took the dump just to store it on another storage (external HDD). I didn't do anything with it.</div><div> </div><div>29.08.2023, 21:42, "Jeff Janes" <jeff.janes@gmail.com>:</div><blockquote><div><div> </div> <div><div>On Tue, Aug 29, 2023 at 1:47 PM Rondat Flyag <<a href="mailto:rondatflyag@yandex.ru" rel="noopener noreferrer">rondatflyag@yandex.ru</a>> wrote:</div><blockquote style="border-left-color:rgb( 204 , 204 , 204 );border-left-style:solid;border-left-width:1px;margin:0px 0px 0px 0.8ex;padding-left:1ex"><div>I have a legacy system that uses `Posgresql 9.6` and `Ubuntu 16.04`. Everything was fine several days ago even with standard Postgresql settings. I dumped a database with the compression option (maximum compression level -Z 9) in order to have a smaller size (`pg_dump --compress=9 database_name > database_name.sql`). After that I got a lot of problems.</div></blockquote><div> </div><div>You describe taking a dump of the database, but don't describe doing anything with it. Did you replace your system with one restored from that dump? If so, did vacuum and analyze afterwards?</div><div> </div><div>Cheers,</div><div> </div><div>Jeff</div></div></div></blockquote>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rondatflyag@yandex.ru, jeff.janes@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: Queries containing ORDER BY and LIMIT started to work slowly
In-Reply-To: <2854111693335271@mail.yandex.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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