at 1:31 PM Rondat Flyag <rondatfl...@yandex.ru> wrote:Hi and thank you for the response. I tried VACUUM ANALYZE for three tables, but without success. I also tried to set enable_seqscan=off and the query took even more time. If I set enable_sort=off then the query takes a lot of time and I
, but ISBN is well-known to people. I changed ASIN to ISBN in the text files, but forgot to replace the last time.This is why the names didn't correspond. Cheers,Serg 31.08.2023, 00:43, "David Rowley" :On Thu, 31 Aug 2023 at 06:32, Rondat Flyag <rondatfl...@yandex.ru> wrote: I trie
;Rick Otten" : On Tue, Aug 29, 2023 at 3:57 PM Rondat Flyag <rondatfl...@yandex.ru> wrote:I took the dump just to store it on another storage (external HDD). I didn't do anything with it. 29.08.2023, 21:42, "Jeff Janes" <jeff.ja...@gmail.com>: On Tue, Aug 29, 2023 a
29.08.2023, 23:11, "Jeff Janes" :On Tue, Aug 29, 2023 at 2:55 PM Rondat Flyag <rondatfl...@yandex.ru> wrote:I took the dump just to store it on another storage (external HDD). I didn't do anything with it. I don't see how that could cause the problem, it is probably just a coincidenc
I took the dump just to store it on another storage (external HDD). I didn't do anything with it. 29.08.2023, 21:42, "Jeff Janes" : On Tue, Aug 29, 2023 at 1:47 PM Rondat Flyag <rondatfl...@yandex.ru> wrote:I have a legacy system that uses `Posgresql 9.6` and `Ubuntu 16.04`. Eve
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 >
