> We're still considering this architecture - so I don't have any plans.
>
> My question is, does the ANALYZE command, which is only executed on the
> master, mean that the statistics / plans that are used on the master are
> ALSO used on the slaves? OR does the slave create it's own plan?
We're still considering this architecture - so I don't have any plans.
My question is, does the ANALYZE command, which is only executed on the
master, mean that the statistics / plans that are used on the master are
ALSO used on the slaves? OR does the slave create it's own plan?
I would an
> Hi all!
>
> We're working on our architecture for our next set of systems, and we
> normally have a simple master/slave with wal shipping and hot_standby set
> up, with pgpool sitting in front of both to do load balancing.
>
> However, one piece I'm very confused about is the query plans on the
Hi all!
We're working on our architecture for our next set of systems, and we
normally have a simple master/slave with wal shipping and hot_standby set
up, with pgpool sitting in front of both to do load balancing.
However, one piece I'm very confused about is the query plans on the slave
server.