Skip site navigation (1) Skip section navigation (2)

BUG #2209: Low performan on consecutive selects

From: "Fahri CAKIROGLU" <fahri(at)gbks(dot)com(dot)tr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2209: Low performan on consecutive selects
Date: 2006-01-25 13:28:18
Message-ID: 20060125132818.72D3EF0A2F@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2209
Logged by:          Fahri CAKIROGLU
Email address:      fahri(at)gbks(dot)com(dot)tr
PostgreSQL version: 8.1
Operating system:   Windows nt 2000
Description:        Low performan on consecutive selects
Details: 

Consecutive selects from three different tables
causes low performance(about 1500 ms).
Same select count from two tables gives good performance(about 30 ms).
All searched keys are indexed and individual execution 
of each query is very fast.

Slow query :
select * from orders where ordernum='1' order by ordernum limit 1;
select * from customers where custnum='1' order by custnum limit 1;
select * from invoice where invnum='1' order by invnum limit 1;

Query with good performance :
select * from orders where ordernum='1' order by ordernum limit 1;
select * from customers where custnum='1' order by custnum limit 1;
select * from orders where ordernum='2' order by ordernum limit 1;
select * from customers where custnum='2' order by custnum limit 1;

pgsql-bugs by date

Next:From: Ricardo SolanillaDate: 2006-01-25 19:44:52
Subject: BUG #2210: an update query bug with a table but not with your backup
Previous:From: Fahri CAKIROGLUDate: 2006-01-25 12:32:31
Subject: BUG #2208: Low performance on select

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group