Skip site navigation (1) Skip section navigation (2)

Re: "fun with multipart primary keys" hobby kit

From: Chris Trawick <ctrawick(at)cultured(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: "fun with multipart primary keys" hobby kit
Date: 2004-01-03 06:07:14
Message-ID: 1073110034.733.42.camel@unity.basin.cultured.net (view raw or flat)
Thread:
Lists: pgsql-performance
Actually, it would appear that I was born yesterday.  I had no idea. 
Added the cast and it fell right in.  Thanks!

chris  <--  feeling pretty dumb right now


On Sat, 2004-01-03 at 00:57, Tom Lane wrote:
> Chris Trawick <ctrawick(at)cultured(dot)net> writes:
> >  contactid      | bigint  | not null
>                     ^^^^^^
> 
> > Am I reading this right?  Is it only using half of the fully-qualified
> > pk index?  How do I diagnose this?  Has anyone seen this before?
> 
> Surely you've been around here long enough to remember the
> must-cast-bigint-constants problem.
> 
> 			regards, tom lane


In response to

pgsql-performance by date

Next:From: D. Dante LorensoDate: 2004-01-04 01:18:34
Subject: Indexing a Boolean or Null column?
Previous:From: Tom LaneDate: 2004-01-03 05:57:54
Subject: Re: "fun with multipart primary keys" hobby kit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group