Re: Index problem

From: "Matt Clark" <matt(at)ymogen(dot)net>
To: <rigmor(dot)ukuhe(at)finestmedia(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index problem
Date: 2003-09-24 17:35:34
Message-ID: OAEAKHEHCMLBLIDGAFELGEAKDMAA.matt@ymogen.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 verbose analyze
[tablename]'?

Cheers

Matt

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sean Chittenden 2003-09-24 17:47:21 Re: Performance issue
Previous Message Joseph Bove 2003-09-24 17:09:34 Re: Performance issue