Re: Postgresql selecting strange index for simple query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Maxim Boguk <mboguk(at)masterhost(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql selecting strange index for simple query
Date: 2009-02-26 16:11:26
Message-ID: 17791.1235664686@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Maxim Boguk <mboguk(at)masterhost(dot)ru> writes:
> Somehow postgres think index scan on singlecolumn index slower comparing to scan on 4th field of 4column index.

It does know better than that. I'm wondering if the single-column index
has become very bloated or something. Have you compared the physical
index sizes?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Maxim Boguk 2009-02-26 16:18:26 Re: Postgresql selecting strange index for simple query
Previous Message Richard Huxton 2009-02-26 16:06:39 Re: Off Topic: ICD-10 codes in a database table?