On Mon, Aug 8, 2016 at 5:59 PM, Craig Boucher
wrote:
> Thanks Kevin for your response. I've Googled and debated natural
> vs surrogate keys and I just find surrogate keys easier to work
> with (maybe I'm just being lazy). It just seems that a
> description or name is most often the natural key.
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
On Mon, Aug 8, 2016 at 4:01 PM, Craig Boucher wrote:
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
>> I'm pretty skeptical of the notion of redefining what your PK
>> is on performance grounds. With this definition, you'd allow
>> two entries with the same work_session_id, if they chanced to
>> h
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
"Craig Boucher" writes:
> I should have pointed out in my last response that I was wondering if the
> performance of the pk index on work_session would be better if my primary key
> was (customer_id, work_session_id) or if (work_session_id, customer_id) will
> be fine. Customer_id will be rep
On Mon, Aug 8, 2016 at 4:35 PM, Craig Boucher wrote:
> Thanks David. I’ve thought about the hierarchy you mentioned but the
> hierarchy can change and I need to capture it as it was when the data was
> generated.
>
>
>
> I should have pointed out in my last response that I was wondering if the
>
...@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
On Mon, Aug 8, 2016 at 3:06 PM, Craig Boucher wrote:
> Here is one of the tables that can have millions of rows and foreign key
> constraints to 5 other tables.
>
>
>
> CREATE TABLE public.work_session
>
> (
>
> work_session_id integer NOT NULL DEFAULT nextval('worksession_
> worksessionid_seq'
cher
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Column order in multi column primary key
On Mon, Aug 8, 2016 at 1:47 PM, Craig Boucher mailto:cr...@wesvic.com> > wrote:
PG 9.5
I’m in the process of converting our application from Sql Server to Postgresql.
I’m taking adva
On Mon, Aug 8, 2016 at 1:47 PM, Craig Boucher wrote:
> 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
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
11 matches
Mail list logo