On Thu, 22 Jul 2004 04:34:26 GMT, "Kevin Macdonald"
>includes the column sobjid because the query projects this col, and its
>inclusion in the index allows it to be serviced without accessing the
No, Postgres always consults the heap to get the desired values. The
most obvious reason is that visibility information is stored in heap
tuples but not in index tuples.
In response to
pgsql-general by date
|Next:||From: Marc G. Fournier||Date: 2004-08-23 18:35:32|
|Subject: Re: Unsupported 3rd-party solutions (Was: Few questions|
|Previous:||From: A Palmblad||Date: 2004-08-23 17:51:21|
|Subject: Re: database troubles - various errors|