From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrew Droffner <adroffne@advance.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: User-defined SQL function has slower query on 7.3.3 than 7.1.3
Date: Wed, 06 Aug 2003 14:06:12 -0400
Message-ID: <1509.1060193172@sss.pgh.pa.us> (raw)
In-Reply-To: <3F311AF8.5080707@advance.net>
References: <3F311AF8.5080707@advance.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, adroffne@advance.net
Subject: Re: User-defined SQL function has slower query on 7.3.3 than 7.1.3
In-Reply-To: <1509.1060193172@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox