Re: "fun with multipart primary keys" hobby kit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Trawick <ctrawick(at)cultured(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: "fun with multipart primary keys" hobby kit
Date: 2004-01-03 05:57:54
Message-ID: 19196.1073109474@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Trawick 2004-01-03 06:07:14 Re: "fun with multipart primary keys" hobby kit
Previous Message Chris Trawick 2004-01-03 05:37:43 "fun with multipart primary keys" hobby kit