On Monday 21 June 2010 7:23:06 am Tom Lane wrote:
> Teodor Macicas writes:
> > Modifying the pg_statistics is not a good idea for most
> > practical purposes.
>
> That's what I've been telling you.
>
> > We want to extend the system by doing the physical design
> > outside the production d
Teodor Macicas writes:
> Modifying the pg_statistics is not a good idea for most
> practical purposes.
That's what I've been telling you.
> We want to extend the system by doing the physical design
> outside the production database, and hence need to replicate the
> pg_statistics of
2010/6/21 Teodor Macicas :
> ---
> Hi Tom, Modifying the pg_statistics is not a good idea for most
> practical purposes. The modification, however, becomes a necessity to
> implement automatic physical design techniques. We are developing an
> automatic physical designer for Postgres. The d
---
Hi Tom,
Modifying the pg_statistics is not a good idea for most practical purposes. The modification, however, becomes a necessity to implement automatic physical design techniques. We are developing an automatic physical designer for Postgres. The designer will add features that most comme
Sorry for being so insistent, but I need to solve this one and I think
that you can help me.
Is here anyone who faced the same situation / problem ? If it is, please
tell me how can I manually insert records into pg_statistics.
Thank you again.
Regards,
Tedy
Teodor Macicas wrote:
Hello everyo
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 writes:
Wh
Teodor Macicas 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
Thank you for your reply, Tom.
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 p
Teodor Macicas writes:
> I'm trying to reproduce the pg_statistics catalog from one database
> server to another one.
You can't really, and manually fooling with system catalogs is usually
a bad idea anyway. Just run ANALYZE.
regards, tom lane
--
Sent via pgsql-general
Hello everyone,
I'm new here, but I have a problem and couldn't find a solution so I
hope you will help me.
I'm trying to reproduce the pg_statistics catalog from one database
server to another one. To retrieve the data from the first server was a
trivial job. The trouble was when I tryied to ins
10 matches
Mail list logo