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

Re: ANALYZE patch for review

From: "Mark Cave-Ayland" <m(dot)cave-ayland(at)webbased(dot)co(dot)uk>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-patches(at)postgresql(dot)org>
Subject: Re: ANALYZE patch for review
Date: 2004-02-13 16:47:31
Message-ID: 8F4A22E017460A458DB7BBAB65CA6AE5026564@openmanage (view raw or flat)
Thread:
Lists: pgsql-patches
> -----Original Message-----
> From: pgsql-patches-owner(at)postgresql(dot)org 
> [mailto:pgsql-patches-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
> Sent: 13 February 2004 14:41
> To: Mark Cave-Ayland
> Cc: pgsql-patches(at)postgresql(dot)org
> Subject: Re: [PATCHES] ANALYZE patch for review 
> 
> 
> "Mark Cave-Ayland" <m(dot)cave-ayland(at)webbased(dot)co(dot)uk> writes:
> > The only reason I kept the Relation parameter
> > was because I wasn't sure if there was a historical reason 
> why someone 
> > would need the relation information as well as the attribute 
> > information.
> 
> I can't think of one, but if someone did, they could extract 
> the relation OID from the pg_attribute row and re-open it for 
> themselves. So AFAICS this API does not omit any critical info.

Great.

> I forgot to email you about the fetch_function revision, but 
> I trust it meets with your approval.  Right now it's just a 
> wrapper around heap_fetch, but I thought we might conceivably 
> want something different when we do functional-index stats.  
> The fetch function will give us wiggle room if we need it.

Yep no problems as long as the functionality is there. I think I can
also see where you're going with functional indexes - during an analyze
phase, for a column X, a pseudo-column f(X) is generated from the sample
data before the stats calculation is performed and the results dropped
into pg_statistic. Hopefully this now shouldn't be too difficult for
someone to pick it up and run with it.


Cheers,

Mark.

---

Mark Cave-Ayland
Webbased Ltd.
Tamar Science Park
Derriford
Plymouth
PL6 8BX
England

Tel: +44 (0)1752 764445
Fax: +44 (0)1752 764446


This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender. You
should not copy it or use it for any purpose nor disclose or distribute
its contents to any other person.



pgsql-patches by date

Next:From: Joe ConwayDate: 2004-02-13 17:30:38
Subject: Re: dblink - custom datatypes NOW work :)
Previous:From: Bruce MomjianDate: 2004-02-13 16:22:54
Subject: Re: TODO : Multiple inserts in a single statement

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