Re: pgstattupple vs pg_total_relation_size

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Jehan-Guillaume (ioguix) de Rorthais" <ioguix@xxxxxxx> writes:
> On Wed, 30 Jan 2019 14:19:52 +0100
> Tumasgiu Rossini <rossini.t@xxxxxxxxx> wrote:
>> According to the doc [1],
>> pg_total_relation_size add toasted data *and* indexes to the mix.

> *and* FSM *and* VM.

Yeah.  In this particular case, the other page presumably belongs to the
toast table's index, which will have a metapage even if the table is
empty.

			regards, tom lane




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux