Basic query performance question

From: "Morgan Kita" <mkita(at)verseon(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Basic query performance question
Date: 2005-06-17 01:30:45
Message-ID: 08B420FF5BF7BC42A064212C2EB7688017E4CC@neutron.verseon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have a question about query performance. I have a pretty large query that hits a little of all my tables in the database. It uses only index scans(mostly on my foreign key and primary key indexs). I notice that the first time it is run for a particular set of parameters it takes about a second. However, if I rerun the same exact query it takes about 1/1000 of a second.

I know this is pretty basic, and I think I understand the reasons, but is it just because after the initial query, the pages are now sitting in memory still? Is there anyway to take advantage of that for my initial run of the query?

Thanks,
Morgan

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2005-06-17 11:55:36 Re: Trigger and Trigger function.
Previous Message Matt Iskra 2005-06-16 22:56:31 Trigger and Trigger function.