Re: ToDo: show size of partitioned table - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: ToDo: show size of partitioned table
Date
Msg-id CAFj8pRBfTOkqJEEmNOwcsD66fWwznzLE9g8Yq2nwAGpTS8T2wQ@mail.gmail.com
Whole thread Raw
In response to Re: ToDo: show size of partitioned table  (Michael Paquier <michael@paquier.xyz>)
Responses Re: ToDo: show size of partitioned table  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers


st 31. 10. 2018 v 8:38 odesílatel Michael Paquier <michael@paquier.xyz> napsal:
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.

I am not sure - I remember one private test that we did on our patches, and this tests fails sometimes on 32bits. So I afraid about stability.

Regards

Pavel

--
Michael

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: syntax error: VACUUM ANALYZE VERBOSE (PostgreSQL 11 regression)
Next
From: Masahiko Sawada
Date:
Subject: Re: COPY FROM WHEN condition