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

Re: Slow Query problem

From: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
To: "Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Slow Query problem
Date: 2008-01-29 10:24:23
Message-ID: 200801291124.23660.andreak@officenet.no (view raw or flat)
Thread:
Lists: pgsql-sql
On Tuesday 29 January 2008 09:18:00 Premsun Choltanwanich wrote:
> I already install the latest version of PostgreSQL on my machine then try
> again. I found that it has a little improvement about 0.5 second but I
> think it still slow.
>
> What is the 'more detail' you need?

Your tables, views and index definitions.

> Any other advise?

You haven't provided any information on how your tables/views look like and 
what indexes you have defined. A rule of thumb is to define an index for each 
column you join on.

-- 
Andreas Joseph Krogh <andreak(at)officenet(dot)no>
Senior Software Developer / Manager
------------------------+---------------------------------------------+
OfficeNet AS            | The most difficult thing in the world is to |
Karenslyst Allé 11      | know how to do a thing and to watch         |
PO. Box 529 Skøyen      | somebody else doing it wrong, without       |
0214 Oslo               | comment.                                    |
NORWAY                  |                                             |
Tlf:    +47 24 15 38 90 |                                             |
Fax:    +47 24 15 38 91 |                                             |
Mobile: +47 909  56 963 |                                             |
------------------------+---------------------------------------------+

In response to

Responses

pgsql-sql by date

Next:From: Stuart BrooksDate: 2008-01-29 14:43:31
Subject: Slow GROUP BY query
Previous:From: Premsun CholtanwanichDate: 2008-01-29 08:18:00
Subject: Re: Slow Query problem

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