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

SELECT performance problem on a join

From: Patrice EspiƩ <patrice(dot)espie(at)univ-lyon2(dot)fr>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: SELECT performance problem on a join
Date: 2001-04-25 14:33:13
Message-ID: 00bc01c0cd94$a9bb4450$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

I have a great problem with performances of my database, on the SQL request:
select t_test.doc_id,  t_test.f_num_centre, t_test.f_num_candidat from
t_test, doc where and doc.docsubset_id=2000077392
The doc table has 36.000 rows, and t_test the same. There is an index on doc
(docsubset_id) and an index on t_test (doc_id). There is others index too.

When I send this request, I must wait for about 45 sec. before the results
The server is a BI-PII 266, and there is about no activity on the database
neither on the server.

When I was using this request under MS-SQLServer (v6), the wait time was
about nothing.

What's wrong ?

Thank's a lot
Patrice Espie

In response to


pgsql-novice by date

Next:From: David OlbersenDate: 2001-04-25 16:43:05
Subject: Re: SELECT performance problem on a join
Previous:From: Paul TomblinDate: 2001-04-25 00:27:37
Subject: Re: Re: BETWEEN clause

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