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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Droffner <adroffne(at)advance(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: User-defined SQL function has slower query on 7.3.3 than 7.1.3
Date: 2003-08-06 18:06:12
Message-ID: 1509.1060193172@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Andrew Droffner <adroffne(at)advance(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Droffner 2003-08-06 18:34:33 Re: User-defined SQL function has slower query on 7.3.3 than
Previous Message Wilson A. Galafassi Jr. 2003-08-06 18:03:41 PostgreSql under Linux