Re: ToDo: show size of partitioned table

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: ToDo: show size of partitioned table
Дата
Msg-id CAFj8pRBfTOkqJEEmNOwcsD66fWwznzLE9g8Yq2nwAGpTS8T2wQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ToDo: show size of partitioned table  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: ToDo: show size of partitioned table  (Michael Paquier <michael@paquier.xyz>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: syntax error: VACUUM ANALYZE VERBOSE (PostgreSQL 11 regression)
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: COPY FROM WHEN condition