Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 29 Jan 2008 11:24:23 +0100
- Message-id: <200801291124.23660.andreak@officenet.no> <text/plain>
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 | | ------------------------+---------------------------------------------+
- Follow-Ups:
- Re: Slow Query problem
- From: Premsun Choltanwanich
- Re: Slow Query problem
- References:
- Slow Query problem
- From: Premsun Choltanwanich
- Re: Slow Query problem
- From: Tom Lane
- Re: Slow Query problem
- From: Premsun Choltanwanich
- Slow Query problem
- Prev by Date: Re: Slow Query problem
- Next by Date: Slow GROUP BY query
- Previous by thread: Re: Slow Query problem
- Next by thread: Re: Slow Query problem
- Indexes: