From: Dan Lyke <danlyke@flutterby.com>
To: pgsql-sql@postgresql.org
Subject: Re: Serials.
Date: Sat, 24 Mar 2001 18:28:08 -0800 (PST)
Message-ID: <15037.22456.492634.743275@wynand.flutterby.com> (raw)
In-Reply-To: <Pine.LNX.4.21.0103250749520.26144-100000@webster.conprojan.com.au>
References: <20010324125750.906311A62@druid.net>
<Pine.LNX.4.21.0103250749520.26144-100000@webster.conprojan.com.au>
Grant writes:
> I have a message board. Where users can send each other messages. I
> doubt I will ever get 2147483647 messages, but I want to make sure I
> never get an error where the message isn't sent.
Think about loads. If your users are going to be posting 10
messages/second, that's 864000 messages per day, you won't wrap for
nearly 7 years. I've got a pretty heavy mail load, including spam I
probably get 300 messages/day, weekends are lighter, so if you've got
a bunch of weenies who are subscribed to a gazillion mailing lists
you're talking three thousand users for six and a half years.
A little light if you're planning on being the next Hotmail (A test
account set up there gets 70 spams/day without my ever publishing the
address), but for your average mid-range discussion forum you're
probably good for a while. I doubt that, say, Salon's TableTalk forum
gets even 10k new messages per day.
> I guess the best option is to create a function that changes all the
> ids to the lowest values possible and then set the sequence to the
> maximum value + 1.
Better idea, if one of your deletion criteria is going to be age,
would just be to wrap the IDs.
Dan
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: danlyke@flutterby.com
Subject: Re: Serials.
In-Reply-To: <15037.22456.492634.743275@wynand.flutterby.com>
References: <20010324125750.906311A62@druid.net> <Pine.LNX.4.21.0103250749520.26144-100000@webster.conprojan.com.au> <15037.22456.492634.743275@wynand.flutterby.com>
* 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