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
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 |