Re: Index speeds up one row table (why)?

From: Dave E Martin XXIII <postgresql-to(dot)dave(at)dave(dot)to>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Index speeds up one row table (why)?
Date: 2003-06-02 07:14:30
Message-ID: 3EDAF956.9010307@dave.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

Bruno Wolff III wrote:

>Maybe you should reconsider how badly you want the app to be totally database
>agnostic? Using a sequence might be less of a contortion than using vacuum
>a few times a minute. You are likely to have similar performance issues
>with other databases, so this section of code may not turn out to be very
>portable in any case.
>
>
Maybe I can further abstract out the generate unique-id portion, Since
unique-id generation does seem to be a pretty common database extension
(for some reason...), and then provide a generic schema definition, and
a postgresql specific one (along with whatever others I can drum up).
The generic one will rely on the software to come up with the unique id
in the fashion I'm currently doing.

Speaking of which, is there a better way than what i'm currently doing
(when the database doesn't have any such support)? I've heard of one
method based on something like "select max(id)+1 from table" but this
seems error prone, at the very least, you'd have to have a unique index,
and be prepared to redo on failure, which could get messy if its a big
transaction, and frequent if there is a lot of concurrent inserting
going on.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Childs 2003-06-02 07:51:49 Re: Index speeds up one row table (why)?
Previous Message Greg Sabino Mullane 2003-06-02 00:56:42 Detecting proper bison version before make

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Childs 2003-06-02 07:51:49 Re: Index speeds up one row table (why)?
Previous Message Paul Smith 2003-06-02 05:35:25 Re: FW: Query Plan problem