Re: [GENERAL] Query Plans on Slaves

2014-11-09 Thread Tatsuo Ishii
> 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?

Re: [GENERAL] Query Plans on Slaves

2014-11-09 Thread Anthony Presley
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

Re: [GENERAL] Query Plans on Slaves

2014-11-09 Thread Tatsuo Ishii
> 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

[GENERAL] Query Plans on Slaves

2014-11-09 Thread Anthony Presley
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.