Thank you.
On Sun, Aug 15, 2021 at 2:15 PM Michael Goldberg
wrote:
>
> On Sun, Aug 15, 2021 at 12:49 PM otar shavadze
> wrote:
>
>> How measure table total pages (block) count? would be this correct way?
>> :
>>
>> SELECT pg_table_size('my_table'
How measure table total pages (block) count? would be this correct way? :
SELECT pg_table_size('my_table'::regclass) /
current_setting('block_size')::BIGINT;
.
Thanks Olivier, I will test out with second option, you mentioned.
On Wed, May 13, 2020 at 1:15 PM Olivier Gautherot
wrote:
> Hi Otar,
>
> On Wed, May 13, 2020 at 10:15 AM otar shavadze
> wrote:
>
>> postgres version 12
>> I have very simple update query, like this:
&
postgres version 12
I have very simple update query, like this:
update my_table
set
col = NULL
where
col IS NOT NULL;
my_table contains few million rows, col is indexed column
Fastest way would be alter table, drop column and then add column again,
but I can't do this just because on this colu