Re: Server hangs on pg_repack

2021-02-25 Thread Roman Liverovskiy
Thanks, I will try it, but it is not an answer on my question. On Thu, Feb 25, 2021, 19:38 Michael Lewis wrote: > Why not use reindex concurrently? >

Re: Server hangs on pg_repack

2021-02-25 Thread Michael Lewis
Why not use reindex concurrently?

Server hangs on pg_repack

2021-02-25 Thread Roman Liverovskiy
Hello. I have postgresql 12 with a 3.0 GB database with a table containing 10 millions of rows, this table also has 4 indexes. I have an AWS EC2 server with two AMD EPYC 7571 cores, 2 GB of RAM and SSD disk. Because of index bloating I use pg_repack. When I use default postgresql.conf file I have n