Re: Inserting additional data into pg_statistics

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
>

In response to

Browse pgsql-general by date

  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