2004-06-28 07:48, Tom Lane wrote:
Klint Gore <[EMAIL PROTECTED]> writes:
On Sun, 27 Jun 2004 23:29:46 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
[yawn...] Cast the constants to bigint. See previous discussions.
[ct]
Thanks a lot guys. The term "Cast the constants to bigint" It is what I
w
Klint Gore <[EMAIL PROTECTED]> writes:
> On Sun, 27 Jun 2004 23:29:46 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
>> [yawn...] Cast the constants to bigint. See previous discussions.
> Would there be any way of adding some sort of indicator to the plan as
> to why sequential was chosen?
Not real
On Sun, 27 Jun 2004 23:29:46 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> Jim <[EMAIL PROTECTED]> writes:
> > I have one performance issue... and realy have no idea what's going on...
>
> [yawn...] Cast the constants to bigint. See previous discussions.
>
> regards, tom la
Jim <[EMAIL PROTECTED]> writes:
> I have one performance issue... and realy have no idea what's going on...
[yawn...] Cast the constants to bigint. See previous discussions.
regards, tom lane
---(end of broadcast)---
TIP 9
On Jun 27, 2004, at 8:37 PM, Jim wrote:
Hi,
I have one performance issue... and realy have no idea what's going
on...
When I set enable_seqscan to 0, query2 runs the same way...
upload => 60667 entities
uploadfield => 506316 entities
Have you vacuum analyze'd recently?
--
Jeff Trout <[EMAIL
