| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Rondat Flyag <rondatflyag(at)yandex(dot)ru> |
| Cc: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Queries containing ORDER BY and LIMIT started to work slowly |
| Date: | 2023-08-29 18:42:27 |
| Message-ID: | CAMkU=1w+RgLQVkqLudpfsax5HQgY94WFmSH+RfydmsN55a_QGQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Aug 29, 2023 at 1:47 PM Rondat Flyag <rondatflyag(at)yandex(dot)ru> wrote:
> 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.
>
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?
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rondat Flyag | 2023-08-29 18:55:56 | Re: Queries containing ORDER BY and LIMIT started to work slowly |
| Previous Message | Rondat Flyag | 2023-08-29 17:47:19 | Queries containing ORDER BY and LIMIT started to work slowly |