REINDEXdb performance degrading gradually PG13.4

> Hi, > > We are trying to reindex 600k tables in a single database of size 2.7TB > using reindexdb utility in a shell script > reindexdb -v -d $dbname -h $hostname -U tkcsowner --concurrently -j > $parallel -S $schema > > our config is as below > name | setting > --

Re: REINDEXdb performance degrading gradually PG13.4

On Tue, May 31, 2022 at 9:12 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tuesday, May 31, 2022, Praneel Devisetty > wrote: > >> >> Initially it was processing 1000 tables per minute. Performance is >>> gradually dropping and now after 2

Planner choosing nested loop in place of Hashjoin

Hi, I have a query which is taking roughly 10mins to complete and the query planner is choosing a nested loop. query and query plan with analyze,verbose,buffers qsEn | explain.depesz.com Disabling the nested loop on session is allowing the query planner t