Re: [GENERAL] Index Analysis: Filters

2004-09-29 Thread Thomas F . O'Connell
Yeah, I suppose this would be faster than the EXTRACT technique, too, eh? Because it requires only a single index and is not an index on an expression, which are generally more expensive? -tfo On Sep 29, 2004, at 6:59 PM, Tom Lane wrote: "Thomas F.O'Connell" <[EMAIL PROTECTED]> writes: Here's wh

Re: [GENERAL] Index Analysis: Filters

2004-09-29 Thread Tom Lane
"Thomas F.O'Connell" <[EMAIL PROTECTED]> writes: > I'm interested to know a little bit more about the postgres > implementation of indexes. I'm specifically wondering what it means in > the output of EXPLAIN when a filter is applied. The index itself is using the condition(s) indicated as "Ind