Re: [GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Sébastien Boutté
I manage to have the same performance between ubuntu package and compiled version ; just a few seconds of difference. don't know what parameter i've missed i restart again and again ... Sorry to have pollute the mailing list ;) Thank you Adrian for the tips on pg_config and pg_controldata. Good

Re: Fwd: [GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Adrian Klaver
On 12/26/2015 01:36 PM, Sébastien Boutté wrote: Honestly, not enough information to make a determination. So: 1) Is the order you show above the actual order you did the restores? No, i have made multiples tests but it's always the same order of nature. 2) Are the above timings from one run for

Fwd: [GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Sébastien Boutté
Honestly, not enough information to make a determination. So: 1) Is the order you show above the actual order you did the restores? No, i have made multiples tests but it's always the same order of nature. 2) Are the above timings from one run for each setup or multiple runs? Multiple runs. 3) J

Re: [GENERAL] Recurring and non recurring events.

2015-12-26 Thread Tom Lane
Gavin Flower writes: > The motivation of bottom posting like this: is that people get to see > the context before the reply, AND emails don't end up getting longer & > longer as people reply at the beginning forgetting to trim the now > irrelevant stuff at the end. Of course, this also require

Re: [GENERAL] Recurring and non recurring events.

2015-12-26 Thread Gavin Flower
Pleas don't top post - see comment at the bottom of this email. On 27/12/15 01:03, Kevin Waterson wrote: Thanks, as I am new to postgres, I was unaware of this function. To go with this, I guess I will need a table with which to store intervals, start and end dates? eg CREATE table events(

Re: [GENERAL] Recurring and non recurring events.

2015-12-26 Thread Bruno Wolff III
On Sat, Dec 26, 2015 at 23:03:30 +1100, Kevin Waterson wrote: Thanks, as I am new to postgres, I was unaware of this function. To go with this, I guess I will need a table with which to store intervals, start and end dates? There is are built in range types that might be more efficiebt for i

Re: [GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Adrian Klaver
On 12/26/2015 08:16 AM, Sébastien Boutté wrote: Hi, For my project, to be able to easily manage postgres instance and version, i want to install it in user's directory and launch by user also. For my tests, I've got some issues with pg_restore on three differents installations. First One : Ubu

[GENERAL] Postgres Ubuntu Default Package vs Enterprise DB vs Compiled One

2015-12-26 Thread Sébastien Boutté
Hi, For my project, to be able to easily manage postgres instance and version, i want to install it in user's directory and launch by user also. For my tests, I've got some issues with pg_restore on three differents installations. First One : Ubuntu 15.10 Default Package Second One : Enterprise

Re: [GENERAL] Recurring and non recurring events.

2015-12-26 Thread Kevin Waterson
Thanks, as I am new to postgres, I was unaware of this function. To go with this, I guess I will need a table with which to store intervals, start and end dates? eg CREATE table events( id serial primary key, start_timestamp timestamp, end_timestamp timestamp, interval with dateRa

Re: [GENERAL] BDR and synchronous replication

2015-12-26 Thread Craig Ringer
On 26 December 2015 at 19:29, Nikhil wrote: > Hello, > > i am experimenting BDR project. As BDR does asynchronous replication, i > have a query regarding bdr.synchronous_commit=on option. > > Will aforementioned configuration in postgresql.conf makes the replication > synchronous? > No. It does

[GENERAL] BDR and synchronous replication

2015-12-26 Thread Nikhil
Hello, i am experimenting BDR project. As BDR does asynchronous replication, i have a query regarding bdr.synchronous_commit=on option. Will aforementioned configuration in postgresql.conf makes the replication synchronous? Does this require any other setting? any side effect for using this setu

Re: [GENERAL] Recurring and non recurring events.

2015-12-26 Thread Pavel Stehule
Hi 2015-12-26 8:28 GMT+01:00 Kevin Waterson : > I wish to set up a table of recurring, and non-recurring events. > I have been looking at > http://justatheory.com/computers/databases/postgresql/recurring_events.html > which looks nice (complex but nice) and wonder if there was a better > option f