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
Frank Knobbe <[EMAIL PROTECTED]> writes:
> On Sun, 2004-06-27 at 00:33, Christopher Kings-Lynne wrote:
>>> I upped effective_cache to 16000 KB and I could only up the
>>> shared_buffers to 3000. Anything more and postgres would not start.
>> You need to greatly incrase the shared memory max setti
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
On Sun, 2004-06-27 at 00:33, Christopher Kings-Lynne wrote:
> > I upped effective_cache to 16000 KB and I could only up the
> > shared_buffers to 3000. Anything more and postgres would not start.
>
> You need to greatly incrase the shared memory max setting on your
> machine so that you can use
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
Actually, I have some
queries that are slow, however I was wondering if you could help me write a
query that is rather simple, but I, as a true database novice, can't seem to
conjure. So we have stocks, as I have previously said, and I have a huge table
which contains all of the opening an
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
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
Query1:
select count(*) from Upload NATURAL JOIN UploadField Where Upload.ShopID
= 123123;
181.94
