Re: Queries containing ORDER BY and LIMIT started to work slowly

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Queries containing ORDER BY and LIMIT started to work slowly
Дата
Msg-id CAMkU=1w+RgLQVkqLudpfsax5HQgY94WFmSH+RfydmsN55a_QGQ@mail.gmail.com
обсуждение исходный текст
Список pgsql-performance
Дерево обсуждения


On Tue, Aug 29, 2023 at 1:47 PM Rondat Flyag <rondatflyag@yandex.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

В списке pgsql-performance по дате отправления:

Предыдущее
От: jayaprabhakar k
Дата:
Сообщение: Re: Index bloat and REINDEX/VACUUM optimization for partial index
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Index bloat and REINDEX/VACUUM optimization for partial index