Re: Inserting additional data into pg_statistics - Mailing list pgsql-general

From Teodor Macicas
Subject Re: Inserting additional data into pg_statistics
Date
Msg-id 4C1D0BAF.2080604@epfl.ch
Whole thread Raw
In response to Re: Inserting additional data into pg_statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inserting additional data into pg_statistics
Next
From: Scott Marlowe
Date:
Subject: Re: Tracking SQLs that update data