Re: Slow count(*) again... - Mailing list pgsql-performance

From mark
Subject Re: Slow count(*) again...
Date
Msg-id 008701cb6b57$634f2890$29ed79b0$@com
Whole thread Raw
In response to Re: Slow count(*) again...  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Slow count(*) again...  (Jesper Krogh <jesper@krogh.cc>)
Re: Slow count(*) again...  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-performance
Could this be an interesting test use of https://www.fossexperts.com/ ?

'Community' driven proposal - multiple people / orgs agree to pay various
portions? Maybe with multiple funders a reasonable target fund amount could
be reached.

Just throwing around ideas here.


Mark

-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Robert Haas
Sent: Wednesday, October 13, 2010 7:29 AM
To: Neil Whelchel
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Slow count(*) again...

On Wed, Oct 13, 2010 at 6:16 AM, Neil Whelchel <neil.whelchel@gmail.com>
wrote:
> I might go as far as to rattle the cage of the developers to see if it
makes
> any sense to add some column oriented storage capability to Postgres. That
> would be the hot ticket to be able to specify an attribute on a column so
that
> the back end could shadow or store a column in a column oriented table so
> aggregate functions could work on them with good efficiency, or is that an
> INDEX?

I'd love to work on that, but without funding it's tough to find the
time.  It's a big project.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Slow count(*) again...
Next
From: Ants Aasma
Date:
Subject: Re: Bogus startup cost for WindowAgg