Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 00CF61337CD0 for ; Thu, 14 Oct 2010 07:15:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 77313-03-5 for ; Thu, 14 Oct 2010 10:15:39 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id 71A9F1336705 for ; Thu, 14 Oct 2010 07:04:55 -0300 (ADT) Received: by mail-gy0-f174.google.com with SMTP id 5so16409gye.19 for ; Thu, 14 Oct 2010 03:04:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:cc:references :in-reply-to:subject:date:message-id:mime-version:content-type :content-transfer-encoding:x-mailer:thread-index:content-language; bh=G9iXjFZwcakWfuvnSsLaHT4zU8C7Sg9tWiQeb1FGAKM=; b=XkSlqA14ZGf6Hxqb6NvchxjkGrBVrs/wvnYxGy78ZPlzUWqDXvzfWk7cvOunGwWeTG jsYEqBUsGVI/B0CtxIhhSNH900+fNDalzlnZckhV1TvXMRlJyY6ZN4xaRngczXlsqGgC 5U9s8+JuqNA6OcIcExlGbrj9bNYzs2gcJNIm4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:cc:references:in-reply-to:subject:date:message-id :mime-version:content-type:content-transfer-encoding:x-mailer :thread-index:content-language; b=MytHaTZzEqgo1z25hnoFgZDoVREMjWRCw4XaA5PtR2oor+dIeAKX3Cn9Ud69Hd+0HL A6PSu64hkvAC/zDG90YJvr3hJtVYdw6TTvFEAZ1vdQF8C4xL7NKlLkjNx8KcjtCp71h+ s/IDcoqrslU1JZb/YzV0KGitOaJnffql6p0dI= Received: by 10.150.138.19 with SMTP id l19mr2470696ybd.384.1287030139548; Wed, 13 Oct 2010 21:22:19 -0700 (PDT) Received: from Duality (174-16-121-37.hlrn.qwest.net [174.16.121.37]) by mx.google.com with ESMTPS id f43sm8246935yhc.26.2010.10.13.21.22.17 (version=SSLv3 cipher=RC4-MD5); Wed, 13 Oct 2010 21:22:18 -0700 (PDT) From: "mark" To: "'Robert Haas'" , "'Neil Whelchel'" Cc: References: <201010091626.18636.neil.whelchel@gmail.com> <201010130138.39893.neil.whelchel@gmail.com> <4CB572CF.4080709@catalyst.net.nz> <201010130316.12922.neil.whelchel@gmail.com> In-Reply-To: Subject: Re: Slow count(*) again... Date: Wed, 13 Oct 2010 22:22:16 -0600 Message-ID: <008701cb6b57$634f2890$29ed79b0$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Actq2qhYlFGjkFmLSeOrWoAq58PDrAAe7TIQ Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201010/229 X-Sequence-Number: 40647 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 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