Re: [HACKERS] Why PostgreSQL doesn't implement a semi sync replication?

2016-11-11 Thread Francisco Olarte
should be dessigned to cope with the posibility of not having replicated data after commit, so, why bother with synchronous replication in the first place? Francisco Olarte. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Declarative partitioning - another take

2016-11-01 Thread Francisco Olarte
me others are easier with them is enough for allowing them as an explicit non default for me. Francisco Olarte. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Declarative partitioning - another take

2016-11-01 Thread Francisco Olarte
happily pay that cost for the benefits of not having people unintentionally make non-contiguous date/timestamp intervals, which I periodically suffer. Francisco Olarte. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [HACKERS] Declarative partitioning - another take

2016-11-01 Thread Francisco Olarte
is always that plus the \0, or whatever your minimum is. The problem is with anything similar to a real number, but then there I've always opted for half-open interval, as they can cover the line without overlapping, unlike closed ones. Anyway, as long as anyone makes sure HALF-OPEN intervals ar

Re: [HACKERS] vacuumdb -f and -j options (was Question / requests.)

2016-10-10 Thread Francisco Olarte
On Mon, Oct 10, 2016 at 3:04 PM, Amit Kapila <amit.kapil...@gmail.com> wrote: > On Sun, Oct 9, 2016 at 10:59 PM, Francisco Olarte > <fola...@peoplecall.com> wrote: >> For me -f & -j is not perfect, but better than not having it. It can >> deadlock when given cert

Re: [HACKERS] Question / requests.

2016-10-10 Thread Francisco Olarte
On Mon, Oct 10, 2016 at 4:51 AM, Jim Nasby <jim.na...@bluetreble.com> wrote: > On 10/5/16 9:58 AM, Francisco Olarte wrote: >> Is the system catalog a bottleneck for people who has real use for >> paralell vacuum? I mean, to me someone who does this must have a very &g

Re: [HACKERS] vacuumdb -f and -j options (was Question / requests.)

2016-10-09 Thread Francisco Olarte
obert Haas wrote: >>>> On Wed, Oct 5, 2016 at 10:58 AM, Francisco Olarte >>>> I don't know, but it seems like the documentation for vacuumdb >>>> currently says, more or less, "Hey, if you use -j with -f, it may not >>>> work!", which se

Re: [HACKERS] Question / requests.

2016-10-07 Thread Francisco Olarte
Robert: On Fri, Oct 7, 2016 at 3:20 PM, Robert Haas <robertmh...@gmail.com> wrote: > On Wed, Oct 5, 2016 at 10:58 AM, Francisco Olarte > <fola...@peoplecall.com> wrote: >> On Tue, Oct 4, 2016 at 7:50 PM, Robert Haas <robertmh...@gmail.com> wrote: >>> On Mon,

Re: [HACKERS] Question / requests.

2016-10-05 Thread Francisco Olarte
e I will take a look to see how complex it will be to build to lists, paralell + serial, and loop on them. This could be used on a first approach to split on !pg_catalog + pg_catalog and used as a base for having and explicit list or some flag in the catalog later. Francisco Olarte. -- Sent via pg

Re: [HACKERS] Question / requests.

2016-10-04 Thread Francisco Olarte
On Mon, Oct 3, 2016 at 11:44 PM, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > Robert Haas wrote: >> On Fri, Sep 30, 2016 at 11:20 AM, Francisco Olarte >> What messages are you seeing, exactly? "auto-deadlocking" isn't a thing. > https://www.postgresql.org

[HACKERS] Question / requests.

2016-09-30 Thread Francisco Olarte
a patch for that file, but I'm not confident on integrating it, making git patchs or going further, so I would like to know if doing that would be enough and then I can give the code to someone to review or integrate it. Waiting for orientation. Francisco Olarte. -- Sent via pgsql-hackers