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

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?

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?

> 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?

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?

> 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?

> 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?

> 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?

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?

> 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?

> 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?

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?

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