Home > mailing lists

- Mailing list pgsql-general

From	otar shavadze
Subject
Date	August 15, 2021 12:49:34
Msg-id	CAG-jOyCCgAqrAGMh9T0w2n8ZWZBm8H=xaaO+u1UVSt4oBVwc0w@mail.gmail.com Whole thread Raw
Responses	Re: (Michael Goldberg <mic.goldberg@gmail.com>)
List	pgsql-general

How measure table total pages (block) count? would be this correct way? :

SELECT pg_table_size('my_table'::regclass) / current_setting('block_size')::BIGINT;

From: Pól Ua Laoínecháin
Date: 15 August 2021, 11:23:31
Subject: Using a TRIGGER with window functions.

From: Michael Goldberg
Date: 15 August 2021, 13:14:55
Subject: Re: