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

Re: SQL stupid query plan... terrible performance !

From: Jim <jim(dot)jim(at)wp(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: SQL stupid query plan... terrible performance !
Date: 2004-06-28 17:44:03
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
 2004-06-28 07:48, Tom Lane wrote:

>Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au> writes:
>> On Sun, 27 Jun 2004 23:29:46 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> [yawn...]  Cast the constants to bigint.  See previous discussions.

Thanks a lot guys. The term "Cast the constants to bigint" It is what I 
was looking for. I add explicitly ::data_type in my queries and 
everything works fine now.

One more thanks to Tom Lane - After your answer I found your post on the 
newsgroup about this problem... the date of the post is 2001 year... You 
are really patience man.... :)

But I really have no idea what term I could use to force goggle to give 
me solution ;)

Jim J.

In response to

pgsql-performance by date

Next:From: Josh BerkusDate: 2004-06-28 19:40:02
Subject: Re: postgres 7.4 at 100%
Previous:From: BillDate: 2004-06-28 17:02:40
Subject: Re: Query performance

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