Some indexing advice for a Postgres newbie, please?

From: brian <brian(at)meadows(dot)pair(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Some indexing advice for a Postgres newbie, please?
Date: 2015-02-19 16:10:44
Message-ID: mn1cea5aurdihk12as43eubfbrkdn8qk94@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi folks,

I have a single-user application which is growing beyond the
fixed-format data files in which it currently holds its data, I need a
proper database as the backend. The front end is written using Lazarus
and FreePascal under Linux, should anyone feel that makes a
difference. The database will need to grow to around 250,000 records.

My problem is with the data field which is the (unique) key. It's
really a single 192-bit integer (it holds various bits of bitmapped
data) which I currently hold as six 32-bit integers, but can convert
if needed when transferring the data.

How would you advise that I hold this field in a Postgres database,
given the requirement for the whole thing to be a unique key? The
first 64 bits change relatively infrequently, the last 128 bits will
change with virtually every record. The last 128 bits will ALMOST be
unique in themselves, but not quite. :(

Thanks,

Brian.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brian Dunavant 2015-02-19 16:14:04 Re: Some indexing advice for a Postgres newbie, please?
Previous Message Tom Lane 2015-02-19 14:54:19 Re: Failure loading materialized view with pg_restore