Re: zheap: a new storage format for PostgreSQL

Поиск
Список
Период
Сортировка
От Kuntal Ghosh
Тема Re: zheap: a new storage format for PostgreSQL
Дата
Msg-id CAGz5QCJ_Hu4DjoeUTGUzFd6NoghSa-565NnHoBarqW7sZX=u5g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: zheap: a new storage format for PostgreSQL  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Список pgsql-hackers
On Fri, Mar 2, 2018 at 2:42 AM, Alexander Korotkov
<a.korotkov@postgrespro.ru> wrote:
>
> I think results representation should be improved.  You show total size of the database, but it's hard to understand
howbloat degree was really decreased, assuming that there are both update and append-only tables.  So, I propose to
showthe results in per table manner. 
>
> What is total number of transactions processed in both cases?  It would be also more fair to compare sizes for the
samenumber of processed transactions. 
>
> Also, what are index sizes?  What are undo log sizes for zheap?
>
I've added the table sizes and TPS in the performance results. As of
now, we've just performed stress testing using pgbench. We've plans
for performing other tests including:
1. Introduce random delay in the transactions instead of keeping a
transaction open for 15 minutes.
2. Combination of ROLLBACK and COMMIT (As suggested by Fabien)
3. PGbench tests for fixed number of transaction.
4. Modify the distribution (As suggested by Alexander Korotkov)

Do let me know if any other tests are required.

--
Thanks & Regards,
Kuntal Ghosh
EnterpriseDB: http://www.enterprisedb.com

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: 2018-03 Commitfest Summary (Andres #1)
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: zheap: a new storage format for PostgreSQL