Re: SERIAL or INT8 / Unique BLOB's

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: Dave Trombley <dtrom(at)bumba(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: SERIAL or INT8 / Unique BLOB's
Date: 2002-01-03 05:36:09
Message-ID: Pine.LNX.4.33.0201022134440.31459-100000@windmill.gghcwest.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2 Jan 2002, Dave Trombley wrote:

> Jeffrey W. Baker wrote:
>
> >
> >yabbut, has anyone seen yet if 7.2 can use bigint in an index (on a 32-bit
> >machine)?
> >
>
> I don't see why it wouldn't! gcc has supported 8-byte longs for a
> (*sigh*) long, long, time now. =)
> This is on my i686-class linux box, build of yesterday's CVS snapshot:

I only asked because 7.1 won't use a bigint index under any circumstances.
I discovered this *after* creating some tremendously large tables :)

-jwb

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeffrey W. Baker 2002-01-03 05:37:41 Re: SERIAL or INT8 / Unique BLOB's
Previous Message Bruce Momjian 2002-01-03 04:56:45 Post-Great Bridge interview