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 sends a
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 to off/on geqo
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
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
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