Re: pglogical extension. - 2 node master <-> master logical replication ?

2019-07-07 Thread Peter Eisentraut
On 2019-07-02 19:54, Day, David wrote: > On attempting the reverse subscription from host1 to host2 > > select pglogical.create_subscription('alabama_sub', > 'host=alabama port=5432 dbname=ace_db user=replicator', > '{connections}', false, false, '{}' ) > > could not connect to the postgresql se

Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Tom Mercha
Hi All As we know, a query goes through number of stages before it is executed. One of these stages is query optimization (QO). There are various parameters to try and influence optimizer decisions and costs. But I wanted to measure the effect of such a stage by turning it off completely and I

Re: Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Rob Sargent
> On Jul 7, 2019, at 5:22 PM, Tom Mercha wrote: > > Hi All > > As we know, a query goes through number of stages before it is executed. > One of these stages is query optimization (QO). > > There are various parameters to try and influence optimizer decisions > and costs. But I wanted to m

Re: Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Tom Mercha
On 08/07/2019 01:46, Rob Sargent wrote: > > >> On Jul 7, 2019, at 5:22 PM, Tom Mercha wrote: >> >> Hi All >> >> As we know, a query goes through number of stages before it is executed. >> One of these stages is query optimization (QO). >> >> There are various parameters to try and influence opti

Re: Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Rob Sargent
> On Jul 7, 2019, at 5:49 PM, Tom Mercha wrote: > > On 08/07/2019 01:46, Rob Sargent wrote: >> >> >>> On Jul 7, 2019, at 5:22 PM, Tom Mercha wrote: >>> >>> Hi All >>> >>> As we know, a query goes through number of stages before it is executed. >>> One of these stages is query optimization

Re: Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Rob Sargent
> On Jul 7, 2019, at 6:01 PM, Rob Sargent wrote: > > > >> On Jul 7, 2019, at 5:49 PM, Tom Mercha > > wrote: >> >> On 08/07/2019 01:46, Rob Sargent wrote: >>> >>> On Jul 7, 2019, at 5:22 PM, Tom Mercha >>> > wrote: Hi

Re: Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Rob Sargent
> On Jul 7, 2019, at 6:02 PM, Rob Sargent wrote: > > > >> On Jul 7, 2019, at 6:01 PM, Rob Sargent > > wrote: >> >> >> >>> On Jul 7, 2019, at 5:49 PM, Tom Mercha >> > wrote: >>> >>> On 08/07/2019 01:46, Rob Sargent wrote: >>>

Re: Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Tom Mercha
On 08/07/2019 02:04, Rob Sargent wrote: > > >> On Jul 7, 2019, at 6:02 PM, Rob Sargent wrote: >> >> >> >>> On Jul 7, 2019, at 6:01 PM, Rob Sargent >> > wrote: >>> >>> >>> On Jul 7, 2019, at 5:49 PM, Tom Mercha >>> > wrote:

Re: Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Rob Sargent
> O > Sorry, maybe my question wasn't clear enough. > > A query can be rewritten in various ways by applying rules and costs of > relational algebra operators, as well as their parallelisation. I am > talking about turning off this query optimization, so I am already > as

Re: Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Rob Sargent
> On Jul 7, 2019, at 6:29 PM, Rob Sargent wrote: > > > >> O >> Sorry, maybe my question wasn't clear enough. >> >> A query can be rewritten in various ways by applying rules and costs of >> relational algebra operators, as well as their parallelisation. I am >> talking ab

Re: Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Ron
On 7/7/19 6:49 PM, Tom Mercha wrote: On 08/07/2019 01:46, Rob Sargent wrote: On Jul 7, 2019, at 5:22 PM, Tom Mercha wrote: Hi All As we know, a query goes through number of stages before it is executed. One of these stages is query optimization (QO). There are various parameters to try and i

Re: Measuring the Query Optimizer Effect: Turning off the QO?

2019-07-07 Thread Tom Lane
Tom Mercha writes: > As we know, a query goes through number of stages before it is executed. > One of these stages is query optimization (QO). > There are various parameters to try and influence optimizer decisions > and costs. But I wanted to measure the effect of such a stage by turning > it