Re: pg_advisor schema proof of concept

Christopher Kings-Lynne wrote:

>>> (6) possible inclusion in postgresql?
>>>  - among other contributions? what about contrib/advisor?
>>>  - added to template1 on default installation?
>>>    maybe not for a first release? or yes? it is easier to communicate
>>>    about
>>
>>
>> I think we're going to want a gborg project for 
>> developing/coordinating tests anyway. Having the schema included in 
>> contrib/ might help adoption, but so would pgadmin/phpgadmin. Any 
>> client-builders reading this? What do you think?
>
>
> Both phpPgAdmin (me) and the pgAdmin team have added or have thought 
> about adding some 'schema analysis' features to our products.  If 
> pg_advisor is available, I certainly won't bother and I will just 
> recommend to people that they install it.
>
> I think it probably should live in userland...

Yeah, this should live in userland.
Maybe this could be implemented as set of some descriptions, which is 
interpreted by a standalone tool, or interpreted by the gui tools 
available. This way, we could include a set of them into the admin tool 
distributions, ensuring a basic set is noticed by the admins (subject to 
update from contrib).

Currently, a check for old style fk triggers is hard-coded into pgadmin3 
(to detect missing adddepend), because fk triggers are considered 
internal and thus suppressed.

There are plans (and basic work) for a FK index tool, which wouldn't be 
obsolete if a pg_advisor would detect it because it's intended to have a 
checkbox "fix this" in the list of detected fks.

Regards,
Andreas