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
Hi, You asked the very same question yesterday, and I believe you got some useful answers. Why do you post the question again? You don't even mention your previous post, and you didn't continue the thread which you started yesterday. Did you try out any of the suggestions which you got

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