Re: [PERFORM] Index on two columns not used

2006-10-23 Thread Péter Kovács
Markus, Thank you for your kind explanation. Peter Markus Schaber wrote: Hi, Peter, Péter Kovács wrote: Sorry for the amateurish question, but what are heap tuples? Also, my understanding is that the following statement applies only for composite indexes: PostgreSQL can't use the values

Re: [PERFORM] Index on two columns not used

2006-10-21 Thread Péter Kovács
Sorry for the amateurish question, but what are heap tuples? Also, my understanding is that the following statement applies only for composite indexes: PostgreSQL can't use the values stored in the index to check the join condition. I assume that PostgreSQL will be able to use