:
On Tue, Jan 10, 2017 at 2:33 PM, Craig Boucher mailto:cr...@wesvic.com> > wrote:
I have a multi-tenant database that I'm migrating from SQL Server to PostgreSQL
9.6.1. I read the recent articles about the potential write amplification
issue in Postgres. I have one particular tab
Thanks for the insights. I don’t think we have any where clauses that would
filter on a column from the related table.
Craig
From: David G. Johnston [mailto:david.g.johns...@gmail.com]
Sent: Tuesday, January 10, 2017 1:42 PM
To: Craig Boucher
Cc: pgsql-general@postgresql.org
Subject
I have a multi-tenant database that I'm migrating from SQL Server to
PostgreSQL 9.6.1. I read the recent articles about the potential write
amplification issue in Postgres. I have one particular table that has 14
columns, a primary key, five foreign keys, and eight indexes. We have a
little over
st 8, 2016 2:44 PM
To: Craig Boucher
Cc: Tom Lane ; David G. Johnston
; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Column order in multi column primary key
On Mon, Aug 8, 2016 at 4:01 PM, Craig Boucher wrote:
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
>> I'm pret
47 PM
To: Craig Boucher
Cc: 'David G. Johnston' ;
pgsql-general@postgresql.org
Subject: Re: [GENERAL] Column order in multi column primary key
"Craig Boucher" writes:
> I should have pointed out in my last response that I was wondering if the
performance of the pk index on
...@gmail.com]
Sent: Monday, August 8, 2016 12:43 PM
To: Craig Boucher
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Column order in multi column primary key
On Mon, Aug 8, 2016 at 3:06 PM, Craig Boucher mailto:cr...@wesvic.com> > wrote:
Here is one of the tables that can have millions o
MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT unq_department_customerid_departmentname UNIQUE (customer_id,
department_name)
)
Thanks,
Craig
From: David G. Johnston [mailto:david.g.johns...@gmail.com]
Sent: Monday, August 8, 2016 11:33 AM
To: Craig Bou
PG 9.5
I'm in the process of converting our application from Sql Server to
Postgresql. I'm taking advantage of this process to make some database
design changes.
Our database contains data for many customers and I have a customer_id
column in every customer related table. One of the cha
