Re: Postgres as In-Memory Database? - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Postgres as In-Memory Database?
Date
Msg-id 20131119015602.GB42382@crankycanuck.ca
Whole thread Raw
In response to Re: Postgres as In-Memory Database?  (Stefan Keller <sfkeller@gmail.com>)
Responses Re: Postgres as In-Memory Database?
List pgsql-general
On Tue, Nov 19, 2013 at 02:39:17AM +0100, Stefan Keller wrote:
> Referring to the application is something you can always say - but
> shouldn't prevent on enhancing Postgres.

With respect, that sounds like a sideways version of, "You should
optimise for $usecase".  You could be right, but I think the judgement
of the Postgres developers has generally been that special cases are
not the mainline case.  And indeed, given the specifics of the use
case you're outlining, it's as much a demonstration of that evaluation
as a repudiation of it.

I don't think there's any evidence that the Postgres developers ignore
useful optimisations.  What you're arguing is that the optimisation
you have in mind isn't covered.  What you need is an argument that it
is generally useful.  Otherwise, the right thing to do is get a
specialised tool (which might be a special optimisation of the
Postgres code).

Best,

A

--
Andrew Sullivan
ajs@crankycanuck.ca


pgsql-general by date:

Previous
From: Stefan Keller
Date:
Subject: Re: Postgres as In-Memory Database?
Next
From: Sergey Konoplev
Date:
Subject: Re: Primary Key Index Bloat?