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

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

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 send

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 yesterd

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

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

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

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 exe