[PERFORM] Optimizer difference using function index between 7.3 and 7.4

2004-02-18 Thread Jeff Boes
e: 18.125 ms (i.e., apply the function to the data in the temp table), it runs a whole lot faster! Is this a bug in the optimizer? Or did something change about the way functional indexes are used? -- Jeff Boes vox 269.226.9550 ext 24 Database Engineer

[PERFORM] Optimizer differences between 7.2 and 7.3

2003-07-07 Thread Jeff Boes
the same (the default); and the optimizer settings (costs in postgresql.conf) are the same. -- Jeff Boes vox 269.226.9550 ext 24 Database Engineer fax 269.349.9076 Nexcerpt, Inc. http://www