pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (11+ messages)  latest in thread

Message-ID: <15037.22456.492634.743275@wynand.flutterby.com>
Permalink:  ../15037.22456.492634.743275@wynand.flutterby.com/
Also on:    postgresql.org/message-id/15037.22456.492634.743275@wynand.flutterby.com

 · 

reply

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