Re: ToDo: show size of partitioned table

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, mathias(at)brossard(dot)org, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: ToDo: show size of partitioned table
Date: 2018-10-31 07:38:07
Message-ID: 20181031073807.GD7862@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 31, 2018 at 03:34:02PM +0900, Amit Langote wrote:
> On 2018/10/31 15:30, Pavel Stehule wrote:
>> I am not sure. Has not sense run this test over empty database, and some
>> bigger database can increase running.
>>
>> More the size can be platform depend.
>
> Okay, sure.

Well, that would mostly depend on the relation page size which is
defined at compilation, no? The plans of some queries are unstable
depending on the page size so they would fail, but let's limit the
damage if possible.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2018-10-31 07:38:27 Re: syntax error: VACUUM ANALYZE VERBOSE (PostgreSQL 11 regression)
Previous Message Sergei Kornilov 2018-10-31 07:34:51 Re: syntax error: VACUUM ANALYZE VERBOSE (PostgreSQL 11 regression)