Postgres Pro
Downloads
Home   >   mailing lists

Re: User-defined SQL function has slower query on 7.3.3 than 7.1.3 - Mailing list pgsql-sql

From Tom Lane
Subject Re: User-defined SQL function has slower query on 7.3.3 than 7.1.3
Date
Msg-id 1509.1060193172@sss.pgh.pa.us
Whole thread Raw
In response to User-defined SQL function has slower query on 7.3.3 than 7.1.3  (Andrew Droffner <adroffne@advance.net>)
Responses Re: User-defined SQL function has slower query on 7.3.3 than  (Andrew Droffner <adroffne@advance.net>)
List pgsql-sql
Tree view 
Andrew Droffner <adroffne@advance.net> 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 query, which uses an index:
> "select latitude, longitude from geo_zipdata where zip = $1"

How do you know it's using the index?
        regards, tom lane

pgsql-sql by date:

Previous
From: Andrew Droffner
Date:
Subject: User-defined SQL function has slower query on 7.3.3 than 7.1.3
Next
From: "Wilson A. Galafassi Jr."
Date:
Subject: PostgreSql under Linux