Hannu, > 1) possibility to explicitly change table status to READ-ONLY . > > 2) setting a flag CAN_OMIT_HEAP_CHECK after REINDEX TABLE for tables > that are READ-ONLY > > 3) changing postgres planner/executor to make use of this flag, by not > going to heap for tuples on tables where CAN_OMIT_HEAP_CHECK is true.
As soneone who appears to be all about data warehousing these days, let me speak in favor of this idea. Â ÂAnd say that you're welcome to submit it to the Bizgres distribution so we can test it out .... -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])