On 06/25/07 09:58, Tom Lane wrote:
[snip]
The fly in the ointment is that if the column value is so high
cardinality as all that, it's questionable whether you want an index
search at all rather than just seqscanning; and it's definite that
the index access cost will be only a fraction of the he
Chris Browne <[EMAIL PROTECTED]> writes:
> But to be sure, there used to be a lot of "burning interest" in
> on-disk bitmap indexes, and in-memory bitmap index scans have quenched
> many of the flames...
Well, we had in-memory bitmaps already in 8.1, and the bitmap index work
happened since that.
[EMAIL PROTECTED] ("Christan Josefsson") writes:
> So you indicate that the so called bitmap index scan, a.k.a
> in-memory bitmap indexes (right?), already adds such an
> improvement when it comes to optimized response time on large
> query sets (having the characteristics as normal
Thanks Robert!
So you indicate that the so called bitmap index scan, a.k.a in-memory bitmap
indexes (right?), already adds such an improvement when it comes to
optimized response time on large query sets (having the characteristics as
normally used to identify cases where bitmap indexes improves
On Thursday 21 June 2007 04:39, Christan Josefsson wrote:
> Ok.
>
> Big thanks for the information.
>
> You mentioned Bizgres, do you have any more information in that direction,
> or do you know who to contact regarding information on Bizgres bitmap
> indexes. If there is a bitmap index patch in B
Christan Josefsson wrote:
> Any guess when 8.4 could be production ready? A year or more?
Why don't you just use Bizgres?
Right, they don't release that often, and 0.9 misses various fixes that
went into PostgreSQL. But if it has what you are after and works for you..
--
Best regards,
Hannes D
On Thu, Jun 21, 2007 at 10:39:29AM +0200, Christan Josefsson wrote:
> Any guess when 8.4 could be production ready? A year or more?
"In the future" is what I'd be willing to state out loud ;-) 8.3
hasn't finished development yet. I wouldn't hold my breath.
You can find out more about bizgres at
Ok.
Big thanks for the information.
You mentioned Bizgres, do you have any more information in that direction,
or do you know who to contact regarding information on Bizgres bitmap
indexes. If there is a bitmap index patch in Bizgres which can be applied to
the latest stable source of PostgreSQL
On 6/20/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Just so there is no confusion. These WILL NOT be in 8.3:
http://developer.postgresql.org/index.php/Todo:PatchStatus
Apologies. I didn't know they had been put on hold.
Alexander.
---(end of broadcast)-
Alexander Staubo wrote:
On 6/20/07, Christan Josefsson <[EMAIL PROTECTED]> wrote:
Anyone using these patchese on production systems?
If these are the same patches that were made for Bizgres, then they
are bound to be in use in some current production systems of that
version of PostgreSQL.
If
"Alexander Staubo" <[EMAIL PROTECTED]> writes:
> On 6/20/07, Christan Josefsson <[EMAIL PROTECTED]> wrote:
>> If there's any PgSQL developer reading this - when can on-disk bitmap
>> indexes be expected to be included in stable PostgreSQL versions?
> It's scheduled for inclusion in 8.3,
Not any m
On 6/20/07, Christan Josefsson <[EMAIL PROTECTED]> wrote:
Anyone using these patchese on production systems?
If these are the same patches that were made for Bizgres, then they
are bound to be in use in some current production systems of that
version of PostgreSQL.
If there's any PgSQL develo
Christan Josefsson wrote:
Hi!
I'm working on building a PostgreSQL based data warehouse, and I'm thus
very interested in any experiences and usage of the PostgreSQL bitmap
index patches (which I've found on pgsql-patches).
Anyone using these patchese on production systems?
Anyone know if t
Hi!
I'm working on building a PostgreSQL based data warehouse, and I'm thus very
interested in any experiences and usage of the PostgreSQL bitmap index
patches (which I've found on pgsql-patches).
Anyone using these patchese on production systems?
Anyone know if the patches run on latest stable
14 matches
Mail list logo
