[HACKERS] BTree index and optimizer

2003-12-03 Thread Anand, VJ (MED, GEMS-IT)
Hello: I am trying to find out, how is the B-tree index implemented for multiple columns? does Postgres, just concatenate the columns --- if this is the case, then how is the search performed? Also, does the optimizer choose the index, only when the constraining is

[HACKERS] BTree information

2003-11-05 Thread Anand, VJ (MED, GEMS-IT)
I am trying to find information regarding creation of B-tree index in postgres for variable length character data (Char/varchar type). Specifically, what pagination policy is used, does it use prefix, or any other form of compression (encoding)? Regards, VJ Anand ---(