pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Cc: Ashwin Agrawal <aagrawal@pivotal.io>
Cc: PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
Subject: Re: Zedstore - compressed in-core columnar storage
Date: Mon, 15 Apr 2019 14:35:43 -0400
Message-ID: <20789.1555353343@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+TgmoYgatemjoKjOGg3wZ91_OkiEwqQ_cM4fGvYmvr9Kc=a3w@mail.gmail.com>
References: <bf4b8f5f-90c9-025d-013c-87cf998204ad@postgrespro.ru>
	<20190409155121.GA4320@alvherre.pgsql>
	<CA+TgmoardtfM+0nfj=g1qrH5khuHP6Oi5ZS546CLx_iQUG620g@mail.gmail.com>
	<20190414162210.6djspkmbspbd4els@development>
	<20190415123424.GD6197@tamriel.snowman.net>
	<30261.1555341038@sss.pgh.pa.us>
	<CA+TgmoYgatemjoKjOGg3wZ91_OkiEwqQ_cM4fGvYmvr9Kc=a3w@mail.gmail.com>

Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Apr 15, 2019 at 11:10 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> There is a finite limit to how much stuff we can maintain as part of core.

> I don't agree with that at all.

Really?  Let's have a discussion of how thermodynamics applies to
software management sometime.

>>> If we have multiple candidates with sufficient code quality, then we may
>>> consider including both.

>> Dear god, no.

> I hate to pick on any particular part of the tree, but it seems
> entirely plausible to me that a second columnar storage implementation
> could deliver more incremental value than spgist, an index AM you
> committed.

Yeah, and that's something I've regretted more than once; I think SP-GiST
is a sterling example of something that isn't nearly useful enough in the
real world to justify the amount of maintenance effort we've been forced
to expend on it.  You might trawl the commit logs to get a sense of the
amount of my own personal time --- not that of the original submitters ---
that's gone into that one module.  Then ask yourself how much that model
will scale, and what other more-useful things I could've accomplished
with that time.

We do need to limit what we accept into core PG.  I do not buy your
argument that users expect everything to be in core.  Or more accurately,
the people who do think that way won't be using PG anyway --- they'll
be using MSSQL because it comes from their OS vendor.

			regards, tom lane





view thread (123+ messages)  latest in thread

Message-ID: <20789.1555353343@sss.pgh.pa.us>
Permalink:  ../20789.1555353343@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/20789.1555353343@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, robertmhaas@gmail.com, sfrost@snowman.net, tomas.vondra@2ndquadrant.com, alvherre@2ndquadrant.com, k.knizhnik@postgrespro.ru, aagrawal@pivotal.io
  Subject: Re: Zedstore - compressed in-core columnar storage
  In-Reply-To: <20789.1555353343@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox