Skip site navigation (1) Skip section navigation (2)

Re: possible TODO: read-only tables, select from indexes only.

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: possible TODO: read-only tables, select from indexes only.
Date: 2005-04-23 22:04:13
Message-ID: 426AC65D.8020408@cheapcomplexdevices.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Bruce Momjian wrote:
> See this TODO: * Allow data to be pulled directly from indexes 
> I think this is the direction we should be heading because it has more
> general usefulness.

I think read-only tables would have a few different types
of general usefulness in addition to enabling index scans.

Is this a fair summary of the potential benefits of READ-ONLY
tables? (from both this thread and the archives):

  1.  Index-only scans are made possible fairly easily because
      you wouldn't need to check the heap for visibility.

  2.  Simple tables can be much smaller since you don't need
      most of the HeapTupleHeaderData.   This reduction in
      space translates to a reduction in I/O through better
      use of the shared memory and OS caches.

  3.  A Read-Only Clustered table could be assumed to be
      sorted, so you could avoid some Sort steps
      for things like GroupAggregates and Merge Joins.

Any others?

The biggest/slowest tables in my database happen to be
entirely read only (road network and other GIS features
for the country; and data warehouse tables representing
previous quarter's data).

In response to

Responses

pgsql-hackers by date

Next:From: Ron MayerDate: 2005-04-23 22:12:12
Subject: Re: possible TODO: read-only tables, select from indexes
Previous:From: Antoine MartinDate: 2005-04-23 14:53:25
Subject: Re: Postgres: pg_hba.conf, md5, pg_shadow, encrypted

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group