Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Slow Query problem
- From: "Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th>
- To: "Andreas Joseph Krogh" <andreak(at)officenet(dot)no>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: <pgsql-sql(at)postgresql(dot)org>
- Subject: Re: Slow Query problem
- Date: Tue, 29 Jan 2008 15:18:00 +0700
- Message-id: <479F4382.C5F7.004C.0@nsasia.co.th> <text/plain>
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt MS Sans Serif">
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>What is the 'more detail' you need?</DIV>
<DIV> </DIV>
<DIV>Any other advise?</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR><BR>>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 1/29/2008 0:20 >>><BR>Andreas Joseph Krogh <andreak(at)officenet(dot)no> writes:<BR>> On Monday 28 January 2008 08:18:24 Premsun Choltanwanich wrote:<BR>>> I am currently using PostgreSQL database version 8.0.13. My problem<BR>>> relates to a slow result when a query using a defined view joins to another<BR>>> table for a result.<BR><BR>> It is very hard to help without you providing the schema for the tables/views<BR>> involved.<BR><BR>One suggestion is that 8.2.x is significantly smarter about joins to<BR>unions than previous releases were. Whether this would help in your<BR>particular case is impossible to say, though, without more detail.<BR><BR>regards, tom lane<BR><BR>---------------------------(end of broadcast)---------------------------<BR>TIP 9: In versions below 8.0, the planner will ignore your desire to<BR> choose an index scan if your joining column's datatypes do not<BR> match<BR></DIV><BR>
<p>
<font size="2" color="#0033cc" face="Trebuchet MS"><b>NETsolutions Asia
Limited </b></font>
</p>
<p>
<font size="2" color="#0033cc" face="Trebuchet MS"><b>+66 (2) 237 7247 </b></font>
</p>
<p>
<a href="http://www.nsasia.co.th";><img border="0" alt="NETsolutions Asia Limited" src="cid:RQHFQWYUJULD.44e30700.jpg">
</a> </p>
</BODY></HTML>
- Follow-Ups:
- Re: Slow Query problem
- From: Andreas Joseph Krogh
- Re: Slow Query problem
- References:
- Slow Query problem
- From: Premsun Choltanwanich
- Re: Slow Query problem
- From: Andreas Joseph Krogh
- Re: Slow Query problem
- From: Tom Lane
- Slow Query problem
- Prev by Date: Re: Proposed archival read only trigger on rows - prevent history modification
- Next by Date: Re: Slow Query problem
- Previous by thread: Re: Slow Query problem
- Next by thread: Re: Slow Query problem
- Indexes: