Re: Operator Classes and ANALYZE

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Rusty Conover" <rconover(at)infogears(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Operator Classes and ANALYZE
Date: 2006-11-06 22:20:54
Message-ID: 1162851654.30200.195.camel@silverbirch.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, 2006-11-06 at 14:47 -0700, Rusty Conover wrote:

> I just
> want the ANALYZE call to use the index's opclass definitions of = and
> < if the index is created with a custom operator class that is not
> the default for the data type.

Which is exactly what the manual specifically says it doesn't do,
therefore you'll need the analyze_function. That capability was put
there deliberately to help you out, in this situation.

> I don't think I need to write my own analyze function

That is the solution, not a workaround.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rusty Conover 2006-11-06 22:54:16 Re: Operator Classes and ANALYZE
Previous Message Rusty Conover 2006-11-06 21:47:55 Re: Operator Classes and ANALYZE