Tagged Questions
4
votes
1answer
67 views
How does PostgreSQL physically order new records on disk (after a cluster on primary key)?
Need to know how PostgreSQL orders records on disk. In this case, I would like to take advantage of index combination as stated in the docs, which as I understand uses bitmaps to get matching rows ...
1
vote
3answers
158 views
Usefulness of a multi-attribute index
If an index has more than one attribute in it, is there any speed gained in a select statement whose where clause uses one of the attributes in the index?
For example, take a table T with an index on ...
