html / rtf format?
About full quoting: my apologies.
-Original Message-
From: Manfred Koizar [mailto:[EMAIL PROTECTED]
Sent: vrijdag 20 augustus 2004 15:38
To: Leeuw van der, Tim
Cc: Igor Artimenko; [EMAIL PROTECTED]
Subject: Re: [PERFORM] I could not get postgres to utilizy indexes
O
On Thu, 19 Aug 2004 09:54:47 +0200, "Leeuw van der, Tim"
<[EMAIL PROTECTED]> wrote:
>You asked the very same question yesterday, and I believe you got some useful
>answers. Why do you post the question again?
Tim, no need to be rude here. We see this effect from time to time when
a new user send
lto:[EMAIL PROTECTED] Behalf Of Igor
Artimenko
Sent: dinsdag 17 augustus 2004 16:23
To: [EMAIL PROTECTED]
Subject: [PERFORM] I could not get postgres to utilizy indexes
Hi verybody!
I can't make use of indexes even I tried the same test by changing different settings
in postgres.conf like geqo t
I ("gnari" <[EMAIL PROTECTED]>) miswrote:
> Actually, I think it was determined that the problem was due to the
> int index
of course, i meant int8 index
gnari
---(end of broadcast)---
TIP 8: explain analyze is your friend
"Thomas Swan" <[EMAIL PROTECTED]> says:
> Igor Artimenko wrote:
>
[ snipped question that was almost exactly a repeat
of one we saw yesterday ]
> >
> >
> Igor, you may want to run "vacuum analyze" and see if your results change.
Actually, I think it was determined that the problem was due to
Igor Artimenko wrote:
Hi verybody!
I can't make use of indexes even I tried the same test by changing different settings in postgres.conf like geqo to off/on & geqo related parameters, enable_seqscan off/on & so on. Result is the same.
Here is test itself:
I've created simplest table test and exe
Hi verybody!
I can't make use of indexes even I tried the same test by changing different settings
in postgres.conf like geqo to off/on & geqo related parameters, enable_seqscan off/on
& so on. Result is the same.
Here is test itself:
I've created simplest table test and executed the same sta
