Re: pg_advisor schema proof of concept

Поиск
Список
Период
Сортировка
От Andreas Pflug
Тема Re: pg_advisor schema proof of concept
Дата
Msg-id 40697529.8080201@pse-consulting.de
обсуждение исходный текст
Ответ на Re: pg_advisor schema proof of concept  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список pgsql-hackers
Hi Fabien,


Fabien COELHO wrote:

>Hello Andreas,
>
>  
>
>>No problem, as long as referencing data is contained in the advice
>>tables (i.e. referencing the 'offending' object), not just text so the
>>advice can be shown as attribute of each object.
>>    
>>
>
>What do you mean by 'referencing data'?
>Things like oid attributes referencing pg_class or pg_constraint or
>pg_index?
>  
>
in a way. If you're advising about e.g. a table, the row should 
reference that table by oid. This way, admin tools can LEFT JOIN the 
advisory table to display that data.

Regards,
Andreas






В списке pgsql-hackers по дате отправления:

Предыдущее
От: Gavin Sherry
Дата:
Сообщение: Re: pg_dump end comment
Следующее
От: Fabien COELHO
Дата:
Сообщение: with vs without oids in pg_catalog.*