Re: Impact of loss of unique SERIAL?

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Impact of loss of unique SERIAL?
Date: 2003-05-02 14:17:57
Message-ID: 20030502141757.GD13419@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-05-02 16:18:30 Re: Changing colums type
Previous Message Tom Lane 2003-05-02 14:16:22 Re: problem after an hd failure