Re:

2021-08-15 Thread otar shavadze
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'

[no subject]

2021-08-15 Thread otar shavadze
How measure table total pages (block) count? would be this correct way? : SELECT pg_table_size('my_table'::regclass) / current_setting('block_size')::BIGINT;

Re: Column reset all values

2020-05-14 Thread otar shavadze
. 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: &

Column reset all values

2020-05-13 Thread otar shavadze
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