On Thu, Oct 1, 2015 at 5:51 PM, Jim Nasby wrote:
> On 10/1/15 8:50 AM, Joseph Kregloh wrote:
>
>> In my testing with pgbench I actually saw a decrease in performance with
>> a ZIL enabled. I ended up just keeping the L2ARC and dropping the. ZIL
>> will not provide you with any speed boost as a da
Hoping to glean some advice from the more experienced
The major component of our application currently tracks a few dozen object
types, and the total number of objects is in the 100s Millions range. Postgres
will potentially be tracking billions of objects.
Right now the primary key for ou
On 9/29/15 9:47 AM, Olivier Dony wrote:
My understanding of the KEY SHARE/NO KEY UPDATE locks introduced in 9.3
was that they would avoid side-effects/blocking between transactions
that are only linked via FK constraints, as long as the target PK was
not touched. Isn't it the case here?
Not qui
Jim Nasby wrote:
> On 10/1/15 12:27 PM, Steve Pribyl wrote:
> >I am in the process of testing out BDR
>
> Please send BDR requests to the BDR mailing list. Thanks!
pgsql-general remains the BDR list.
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Suppo
On 10/1/15 12:27 PM, Steve Pribyl wrote:
I am in the process of testing out BDR
Please send BDR requests to the BDR mailing list. Thanks!
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! htt
On 10/1/15 8:50 AM, Joseph Kregloh wrote:
In my testing with pgbench I actually saw a decrease in performance with
a ZIL enabled. I ended up just keeping the L2ARC and dropping the. ZIL
will not provide you with any speed boost as a database. On a NAS with
NFS shared for example, a ZIL would work
Good Afternoon,
I am in the process of testing out BDR and am having problems rejoining after a
simulated loss of one node. The join hangs while waiting to complete and
there interesting errors in the logs.
Simulation process
After creating the database on both nodes.
Shutdown postgres and
On Wed, Sep 30, 2015 at 5:12 PM, Benjamin Smith
wrote:
> On Wednesday, September 30, 2015 09:58:08 PM Tomas Vondra wrote:
> > On 09/30/2015 07:33 PM, Benjamin Smith wrote:
> > > On Wednesday, September 30, 2015 02:22:31 PM Tomas Vondra wrote:
> > >> I think this really depends on the workload - i
