Re: Sequences/defaults and pg_dump - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Sequences/defaults and pg_dump
Date
Msg-id 20060210212836.GA14483@wolff.to
Whole thread Raw
In response to Re: Sequences/defaults and pg_dump  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
On Fri, Feb 10, 2006 at 07:34:35 -0500,
  Doug McNaught <doug@mcnaught.org> wrote:
> Bruno Wolff III <bruno@wolff.to> writes:
>
> Or, just start your sequence counting at 1000000.  Or use bigint and
> start it at a billion.

That may work if you only have access to one id number, but you don't need
too many id numbers before you can start making good statistical estimates
of the number of users.

In one of my math classes, I was told a story about how statisticians
estimnated the number of tanks produced by germany during world war II
based on serial numbers found on captured tanks. This was supposedly despite
the Germans doing things (leaving gaps and the like) to make this harder.
And supposedly after the war, the statistical results were supposed to have
been more accurate than estimates obtain via other means (such as spies).

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: Re: Tool
Next
From: Tino Wildenhain
Date:
Subject: Re: Tool