Re: Inserting additional data into pg_statistics

Поиск
Список
Период
Сортировка
От Teodor Macicas
Тема Re: Inserting additional data into pg_statistics
Дата
Msg-id 4C1D0BAF.2080604@epfl.ch
обсуждение исходный текст
Ответ на Re: Inserting additional data into pg_statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi Tom,

Thank you again for your quick reply.
Shall we pass the reason for I want to do this ? I can explain, but it's
a long story. The idea is that *for sure* I need those metadata there. I
want to use them on the second machine.

Regards,
Tedy

Tom Lane wrote:
> Teodor Macicas <teodor.macicas@epfl.ch> writes:
>
>> Why I can't ? And for my purpose is not a bad idea. I mean, I have to do
>> this and somehow I should find a solution.
>>
>
>
>> In order to use ANALYZE I need the same data on 2nd machine, but the
>> data is quite large and the only information I need are the statistics
>> from pg_statistic.
>>
>
> Er, if you haven't got the data on the second machine, then you *don't*
> need or want that stuff in its pg_statistic.  It won't do you any good
> to have incorrect information in there.
>
>             regards, tom lane
>


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Inserting additional data into pg_statistics
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Tracking SQLs that update data