Re: [PERFORM] Performance difference between Slon master and slave

Hi Jim, Thanks for your response. Yes the tables have been analysed and I have also re-indexed and vacuumed the slave database. Regards Matthew Sent from my iPad > On 14 Dec 2015, at 17:49, Jim Nasby wrote: > >> On 12/14/15 11:16 AM, Matthew Lunnon wrote: >>

Re: [PERFORM] Performance difference between Slon master and slave

On 12/14/15 11:16 AM, Matthew Lunnon wrote: Inspecting the execution plan shows that there are some differences, for example, the slave is using a HashAggregate when the master is simply grouping. There also seems to be a difference with the ordering of the sub plans. Have you tried analyzing