[SQL] User-defined SQL function has slower query on 7.3.3 than 7.1.3

I have this QUERY (below) that PostgreSQL 7.3.X servers run MUCH slower than the 7.1.3 server does. It makes sense that both servers have to do a sequential scan over the ZIPCODE column. There are over 7,500 rows in the LOCATIONS table. Does anyone know what changed in the planner or optimizer? Can

Re: [SQL] User-defined SQL function has slower query on 7.3.3 than 7.1.3

Andrew Droffner <[EMAIL PROTECTED]> writes: > I have this QUERY (below) that PostgreSQL 7.3.X servers run MUCH slower > than > the 7.1.3 server does. I know of no reason for that to happen. Have you vacuum analyzed the 7.3 database? > It finds the ZIPs locations with a prepared > (and saved) SPI