From: M.Feldtmann@t-online.de
To: Steve Wampler <swampler@noao.edu>
Cc: Poet/Joshua Drake <poet@linuxports.com>
Cc: postgres-sql <pgsql-sql@postgresql.org>
Subject: Re: Using a postgres table to maintain unique id?
Date: Mon, 13 Nov 2000 20:18:49 +0000
Message-ID: <3A104CA9.6E313C9F@toppoint.de> (raw)
References: <Pine.LNX.4.30.0011130925400.2094-100000@crazypenguins.commandprompt.com>
<3A102875.C545E345@noao.edu>
Steve Wampler schrieb:
>
> Poet/Joshua Drake wrote:
> ?
> ? ?However, I also use Postgres (7.0.2) throughout this
> ? ?application and it seems cleaner to me to keep the current
> ? ?id value in a table and just use postgres to provide access
> ? ?(with a trigger function to increment the id on access).
> ?
> ? Why not a sequence?
>
> Can someone show me how to create (and use) an int8 sequence?
>
> ? ?Is this reasonable? Is it fast? (I need 10 or more IDs
> ? ?generated each second.) Can I avoid having the table
> ? ?gradually fill with "old" rows for this entry, and this
> ? ?avoid the need to run VACUUM ANALYZE periodically?
Throw away all the "hardwired"-stuff and do it with software. I
once described an algorithm in one of this lists how to create
unique values for clients without minimum interaction with the
database.
The result: query once in the beginning of your application,
generate your id's "offline" at the maximum speed you may
have and store your last generated id when your client
finished. Superior to all the "hardwired"-database solutions !
Marten
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: M.Feldtmann@t-online.de, swampler@noao.edu, poet@linuxports.com
Subject: Re: Using a postgres table to maintain unique id?
In-Reply-To: <3A104CA9.6E313C9F@toppoint.de>
References: <Pine.LNX.4.30.0011130925400.2094-100000@crazypenguins.commandprompt.com> <3A102875.C545E345@noao.edu> <3A104CA9.6E313C9F@toppoint.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox