From: | Teodor Macicas <teodor(dot)macicas(at)epfl(dot)ch> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Inserting additional data into pg_statistics |
Date: | 2010-06-19 18:25:51 |
Message-ID: | 4C1D0BAF.2080604@epfl.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)macicas(at)epfl(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-06-19 20:12:37 | Re: Tracking SQLs that update data |
Previous Message | Tom Lane | 2010-06-19 18:03:04 | Re: Inserting additional data into pg_statistics |