[GENERAL] Experiences of PostgreSQL on-disk bitmap index patch

2007-06-20 Thread Christan Josefsson
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

Re: [GENERAL] Experiences of PostgreSQL on-disk bitmap index patch

2007-06-21 Thread Christan Josefsson
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

Re: [GENERAL] Experiences of PostgreSQL on-disk bitmap index patch

2007-06-25 Thread Christan Josefsson
performance like: low cardinality keys, large data volumes etc), so that the on-disk indexes are not really needed or atleast not worth wile implementing? Regards, Christian 2007/6/25, Robert Treat <[EMAIL PROTECTED]>: On Thursday 21 June 2007 04:39, Christan Josefsson wrote: > Ok

[GENERAL] Advanced query rewrite

2007-04-16 Thread Christan Josefsson
Hi! I was looking into the PostgreSQL RULE system in order to define rewriting / redirecting queries under certain conditions. For my part I would like to fully be able to control the query rewrite, e.g by implemening a stored procedure to define the query rewrite results, since as it seems the m