BIGINT's and indexes.

From: Alexander Deruwe <a(at)deruwe(dot)be>
To: pgsql-sql(at)postgresql(dot)org
Subject: BIGINT's and indexes.
Date: 2001-10-11 10:48:02
Message-ID: 20011011085412.A4CFA9BB7C@pop3.telenet-ops.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have read somewhere (I believe in a review of Postgres 7? Can't find it
right now though) that having BIGINT's as indexes (or primary keys) slows the
database down, since they are 64bit and not supported that good. Is this
still true? Was this ever true?

Alexander.

Browse pgsql-sql by date

  From Date Subject
Next Message Patrik Kudo 2001-10-11 12:28:34 indexing and LIKE
Previous Message Tom Lane 2001-10-11 05:11:06 Re: [NOVICE] Loading current_user and current_timestamp using COPY