On Fri, May 27, 2022 at 12:19 PM Alexey Ermakov <
alexey.erma...@dataegret.com> wrote:
> Hello, please look into following example:
>
> postgres=# create table test_array_selectivity as select
> array[id]::int[] as a from generate_series(1, 1000) gs(id);
> SELECT 1000
> postgres=# explain
On Tue, May 31, 2022 at 11:14 AM Praneel Devisetty <
devisettypran...@gmail.com> wrote:
>
> 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
>> $par
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 24 hr it was processing 90 tables per
>>> m
