Re: "fun with multipart primary keys" hobby kit - Mailing list pgsql-performance

From Tom Lane
Subject Re: "fun with multipart primary keys" hobby kit
Date
Msg-id 19196.1073109474@sss.pgh.pa.us
Whole thread Raw
In response to "fun with multipart primary keys" hobby kit  (Chris Trawick <ctrawick@cultured.net>)
Responses Re: "fun with multipart primary keys" hobby kit
List pgsql-performance
Chris Trawick <ctrawick@cultured.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

pgsql-performance by date:

Previous
From: Chris Trawick
Date:
Subject: "fun with multipart primary keys" hobby kit
Next
From: Chris Trawick
Date:
Subject: Re: "fun with multipart primary keys" hobby kit