[GENERAL] BDR: cascading setup

2016-01-11 Thread Oleksii Kliukin
Hi, We are evaluating BDR for a multi-master cross-datacenter replication, with 2 masters actually communicating across datacenter, supplemented by a local in-datacenter replicas to provide HA. Basically, something like M <——> M || S S I could run all nodes as

Re: [GENERAL] dubious optimization of the function in SELECT INTO target list

2015-10-09 Thread Oleksii Kliukin
> On 08 Oct 2015, at 19:54, Alvaro Herrera wrote: > > Oleksii Kliukin wrote: > >> Thank you, now it’s clear. I have to say there is no guarantee that >> the computation would be useless. Someone might be calling a function >> that updates/deletes rows in the SELE

Re: [GENERAL] dubious optimization of the function in SELECT INTO target list

2015-10-09 Thread Oleksii Kliukin
> On 08 Oct 2015, at 16:00, Adrian Klaver wrote: > > On 10/08/2015 01:57 AM, Oleksii Kliukin wrote: >> >>> On 06 Oct 2015, at 23:31, Tom Lane >> <mailto:t...@sss.pgh.pa.us> >>> <mailto:t...@sss.pgh.pa.us <mailto:t...@sss.pgh.pa.us>>&g

Re: [GENERAL] dubious optimization of the function in SELECT INTO target list

2015-10-08 Thread Oleksii Kliukin
> On 06 Oct 2015, at 23:31, Tom Lane wrote: > > Oleksii Kliukin writes: >> This should work, but I'm interested in finding out why the original >> statement behaves the way I’ve described. > > plpgsql's SELECT INTO is only capable of storing a single

Re: [GENERAL] dubious optimization of the function in SELECT INTO target list

2015-10-08 Thread Oleksii Kliukin
> On 06 Oct 2015, at 23:11, Adrian Klaver wrote: > > On 10/06/2015 02:00 PM, Oleksii Kliukin wrote: >> >>> On 06 Oct 2015, at 22:50, Adrian Klaver >> <mailto:adrian.kla...@aklaver.com>> wrote: >>> >>> On 10/06/2015 01:48 PM, Oleksii Kl

Re: [GENERAL] dubious optimization of the function in SELECT INTO target list

2015-10-06 Thread Oleksii Kliukin
> On 06 Oct 2015, at 22:50, Adrian Klaver wrote: > > On 10/06/2015 01:48 PM, Oleksii Kliukin wrote: >> >>> On 06 Oct 2015, at 22:40, Adrian Klaver >> <mailto:adrian.kla...@aklaver.com> >>> <mailto:adrian.kla...@aklaver.com <mailto:adrian.kla..

Re: [GENERAL] dubious optimization of the function in SELECT INTO target list

2015-10-06 Thread Oleksii Kliukin
> On 06 Oct 2015, at 22:40, Adrian Klaver wrote: > > On 10/06/2015 01:13 PM, Oleksii Kliukin wrote: >> >> Basically, if we invoke the first example, the foo table with have only >> 1 row and not 10, as supplied by the generate_series. >> However, when ORDE

[GENERAL] dubious optimization of the function in SELECT INTO target list

2015-10-06 Thread Oleksii Kliukin
Hello, I have an issue with a function that is called as a part of the SELECT INTO target list in pl/pgSQL. I'd like to illustrate it with a simple example: DO $$ DECLARE l_id integer; BEGIN SELECT test(id) INTO l_id FROM generate_series(1,10) t(id); END; $$ LANGUAGE plpgs

Re: [GENERAL] Postgresql upgrade from 8.4 to latest

2015-07-28 Thread Oleksii Kliukin
On Tue, Jul 28, 2015 at 10:35 PM, AI Rumman wrote: > But what I read, in-place upgrade has smaller outage, compared to > dump/restore. Please, keep in mind that while the direct outage (when the database is shut down) is small, there will be a time period right after the upgrade when PostgreSQL w