Re: [PERFORM] I could not get postgres to utilizy indexes

2004-08-20 Thread Manfred Koizar
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

Re: [PERFORM] I could not get postgres to utilizy indexes

2004-08-19 Thread Leeuw van der, Tim
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

[PERFORM] I could not get postgres to utilizy indexes

2004-08-18 Thread Igor Artimenko
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

Re: [PERFORM] I could not get postgres to utilizy indexes

2004-08-18 Thread Thomas Swan
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

Re: [PERFORM] I could not get postgres to utilizy indexes

2004-08-18 Thread gnari
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