Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group