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