Re: zheap: a new storage format for PostgreSQL

Поиск
Список
Период
Сортировка
Искать
От
Aleksander Alekseev
Тема
Re: zheap: a new storage format for PostgreSQL
Дата
Msg-id
20180302133653.GE29307@e733.localdomain
Ответ на
Список
Дерево обсуждения
zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
RE: zheap: a new storage format for PostgreSQL "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: zheap: a new storage format for PostgreSQL Robert Haas <robertmhaas@gmail.com>
Re: zheap: a new storage format for PostgreSQL Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: zheap: a new storage format for PostgreSQL Daniel Westermann <daniel.westermann@dbi-services.com>
Re: zheap: a new storage format for PostgreSQL Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Adam Brusselback <adambrusselback@gmail.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Daniel Westermann <daniel.westermann@dbi-services.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Daniel Westermann <daniel.westermann@dbi-services.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Darafei "Komяpa" Praliaskouski <me@komzpa.net>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Hakan Kocaman <hkocam@gmail.com>
Re: zheap: a new storage format for PostgreSQL Thomas Munro <thomas.munro@enterprisedb.com>
Re: zheap: a new storage format for PostgreSQL Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: zheap: a new storage format for PostgreSQL Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Fabien COELHO <coelho@cri.ensmp.fr>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Satyanarayana Narlapuram <Satyanarayana.Narlapuram@microsoft.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Hartmut Holzgraefe <hartmut.holzgraefe@gmail.com>
Re: zheap: a new storage format for PostgreSQL Mithun Cy <mithun.cy@enterprisedb.com>
Re: zheap: a new storage format for PostgreSQL Pavel Stehule <pavel.stehule@gmail.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Mithun Cy <mithun.cy@enterprisedb.com>
Re: zheap: a new storage format for PostgreSQL Pavel Stehule <pavel.stehule@gmail.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Pavel Stehule <pavel.stehule@gmail.com>
Re: zheap: a new storage format for PostgreSQL Robert Haas <robertmhaas@gmail.com>
Re: zheap: a new storage format for PostgreSQL Pavel Stehule <pavel.stehule@gmail.com>
Re: zheap: a new storage format for PostgreSQL Robert Haas <robertmhaas@gmail.com>
Re: zheap: a new storage format for PostgreSQL Pavel Stehule <pavel.stehule@gmail.com>
Re: zheap: a new storage format for PostgreSQL Robert Haas <robertmhaas@gmail.com>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Pavel Stehule <pavel.stehule@gmail.com>
Re: zheap: a new storage format for PostgreSQL Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: zheap: a new storage format for PostgreSQL Amit Kapila <amit.kapila16@gmail.com>
Re: zheap: a new storage format for PostgreSQL Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Hello Amit,

> Sometime back Robert has proposed a solution to reduce the bloat in
> PostgreSQL [1] which has some other advantages of its own as well.  To
> recap, in the existing heap, we always create a new version of a tuple on
> an update which must eventually be removed by periodic vacuuming or by
> HOT-pruning, but still in many cases space is never reclaimed completely.
> A similar problem occurs for tuples that are deleted.  This leads to bloat
> in the database.

This is an impressive work!

Personally I would like to note that performance is probably not a
priority at this stage. Most important parts, in my humble opinion at
least, are correctness, maintainability (tests, documentation, how
readable the code is), extendability (e.g. an ability to add point in
time recovery in the future), interfaces and heap format. There is some
saying on premature optimization... don't remember exact words and who
said this.

-- 
Best regards,
Aleksander Alekseev
В списке pgsql-hackers по дате отправления
От: Magnus Hagander
Дата:
От: David Steele
Дата:
FAQ