From: Jim <jim.jim@wp.pl>
To: pgsql-performance@postgresql.org
Subject: Re: SQL stupid query plan... terrible performance !
Date: Mon, 28 Jun 2004 19:44:03 +0200
Message-ID: <40E058E3.5060608@wp.pl> (raw)
In-Reply-To: <18211.1088401723@sss.pgh.pa.us>
References: <40DF684D.9060207@wp.pl>
<16908.1088393386@sss.pgh.pa.us>
<40DFACD5345.1020KG@129.180.47.120>
<18211.1088401723@sss.pgh.pa.us>
2004-06-28 07:48, Tom Lane wrote:
>Klint Gore <kg@kgb.une.edu.au> writes:
>> On Sun, 27 Jun 2004 23:29:46 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> [yawn...] Cast the constants to bigint. See previous discussions.
>
>
[cuuuut]
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 ;)
Greetings,
Jim J.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jim.jim@wp.pl
Subject: Re: SQL stupid query plan... terrible performance !
In-Reply-To: <40E058E3.5060608@wp.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox