From: John Vincent <pgsql-performance@lusis.org>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: PGSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Optimizer internals
Date: Thu, 15 Jun 2006 19:23:39 -0400
Message-ID: <c841561b0606151623p3ed68f8g3e1df4143549a8d4@mail.gmail.com> (raw)
In-Reply-To: <20060615222344.GB93655@pervasive.com>
References: <c841561b0606151105v459d830era158b9eea5f59a7e@mail.gmail.com>
<1150396425.31200.66.camel@archimedes>
<c841561b0606151146j5f8410f2qaeaff7649b70cd20@mail.gmail.com>
<1150398064.31200.76.camel@archimedes>
<c841561b0606151221v219987aap376194583dd30940@mail.gmail.com>
<c841561b0606151243m1e55841fkdc10bfcb2a1d1ff9@mail.gmail.com>
<20060615222344.GB93655@pervasive.com>
> decibel=# create index test on i ( sum(i) );
> ERROR: cannot use aggregate function in index expression
> decibel=#
>
> BTW, there have been a number of proposals to negate the effect of not
> having visibility info in indexes. Unfortunately, none of them have come
> to fruition yet, mostly because it's a very difficult problem to solve.
> But it is something that the community would like to see happen.
> --
> Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>
Yeah we got the same thing when we tried it.
I thought about the whole thing on the way home and the downside is that we
might have to ditch pgsql.
As far as implementing it, it might make sense to translate READ UNCOMMITTED
to that new functionality. If the default isolation level stays the current
level, the people who need it can use it via WITH UR or somesuch.
I know it's not that easy but it's an idea. I'm also thinking that the table
inheritance we're going to be taking advantage of in 8.1 on the new server
might make the sequence scan less of an issue. The only reason the sequence
scan really blows is that we have a single table with 220M rows and growing.
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-performance@postgresql.org
Cc: pgsql-performance@lusis.org, jnasby@pervasive.com
Subject: Re: Optimizer internals
In-Reply-To: <c841561b0606151623p3ed68f8g3e1df4143549a8d4@mail.gmail.com>
* 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