Re: Index problem - Mailing list pgsql-performance

From Matt Clark
Subject Re: Index problem
Date
Msg-id OAEAKHEHCMLBLIDGAFELGEAKDMAA.matt@ymogen.net
Whole thread Raw
In response to Index problem  ("Rigmor Ukuhe" <rigmor.ukuhe@finestmedia.com>)
Responses Re: Index problem  ("Rigmor Ukuhe" <rigmor.ukuhe@finestmedia.com>)
List pgsql-performance
> What causes this behaviour? is there any workaround? Suggestions?
>

How many rows are there in the table, and can you post the 'explain analyze' for both queries after doing a 'vacuum
verboseanalyze 
[tablename]'?

Cheers

Matt



pgsql-performance by date:

Previous
From: Richard Jones
Date:
Subject: Re: Performance issue
Next
From: Sean Chittenden
Date:
Subject: Re: Performance issue