> 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
> --
On Tuesday, May 31, 2022, Praneel Devisetty
wrote:
>
> Initially it was processing 1000 tables per minute. Performance is
>> gradually dropping and now after 24 hr it was processing 90 tables per
>> minute.
>>
>
That seems like a fairly problematic metric given the general vast
disparities in siz
Hi listers,
Is there any sql query which we can use to find the logical reads performed
by particular sql statement in postgres ??
Thanks,
Goti
--
Thanks,
Goti
On Tue, May 31, 2022 at 08:42:06AM -0700, David G. Johnston wrote:
> Building indexes is so IO heavy that the non-IO bottlenecks that exists
> likely have minimal impact on the overall times this rebuild everything
> will take. That said, I’ve never done anything at this scale before. I
> wouldn’
