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

Re: SELECT performance problem on a join

From: "Eric Naujock " <naujocke(at)abacusii(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>, <patrice(dot)espie(at)univ-lyon2(dot)fr>
Subject: Re: SELECT performance problem on a join
Date: 2001-04-28 11:59:15
Message-ID: saea785e.050@gw5.abacusii.com (view raw or flat)
Thread:
Lists: pgsql-novice
What do you get when you send an explain of the select?

Type this in and tell me that it says.
==============
explain select t_test.doc_id,  t_test.f_num_centre, t_test.f_num_candidat from t_test, doc where t_test.doc_id=doc.id and doc.docsubset_id=2000077392
==============

What will happen is the database will tell you what it did and how long it took to perform each step. That way you can see any bottlenecks or areas that you can try to fix to speed up your database.


>>> Patrice_EspiƩ <patrice(dot)espie(at)univ-lyon2(dot)fr> 04/25/01 10:33AM >>>
Hello,

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 t_test.doc_id=doc.id 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
appears.
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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly


pgsql-novice by date

Next:From: suhail sarwarDate: 2001-04-28 12:38:06
Subject: Inserting data into a postgres table using java
Previous:From: suhail sarwarDate: 2001-04-28 11:58:54
Subject: Attribute 'name' not found ERROR for postgres and java

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