Re: Impact of loss of unique SERIAL? - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Impact of loss of unique SERIAL?
Date
Msg-id 20030502141757.GD13419@libertyrms.info
Whole thread Raw
In response to Re: Impact of loss of unique SERIAL?  (Hacksaw <hacksaw@hacksaw.org>)
List pgsql-admin
On Thu, May 01, 2003 at 07:35:15PM -0400, Hacksaw wrote:

> Well, I've no idea what the PostgreSQL's particular argument might
> have been, but too many indices typically means slower lookups. You
> want the indices to be created based on the fields you will most
> often mention in WHERE statements.

I meant the argument on -hackers, but this one that you present might
well be the one that was used.  In any case, just on grounds of
flexibility I think it's a good thing, especially since the old
behaviour can be so easily emulated if desired.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem after an hd failure
Next
From: Stephan Szabo
Date:
Subject: Re: Changing colums type