Re: TODO: read-only tables, select from indexes only.
Started by Josh Berkusover 20 years ago1 messages
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-ONLY3) 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
Import Notes
Reply to msg id not found: 200504221151.42536.josh@agliodbs.comReference msg id not found: 20050422181115.1F49353CCC@svr1.postgresql.orgReference msg id not found: 200504221151.42536.josh@agliodbs.com