On 9/18/11 1:18 PM, Stefan Keller wrote:
Hi,
Sorry if this is an odd question:
I assume that Postgres indexes don't store records but only pointers
to the data.
This means, that there is always an additional access needed (real table I/O).
Would an index containing data records make sense?
See my post entitled, "How to make hash indexes fast" for a solution to the
additional-disk-access problem.
Craig
Stefan
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
