Re: [HACKERS] large object regression tests

From: "Bort, Paul" <pbort(at)tmwsystems(dot)com>
To: "PostgreSQL-development" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] large object regression tests
Date: 2006-09-25 01:54:25
Message-ID: DB106B1B5B8F734B8FF3E155A3A556C20548CBF8@clemail1.tmwsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Jeremy Drake wrote:
>
> I am open to suggestions. I saw one suggestion that I use an
> image of an elephant, but I suspect that was tongue-in-cheek.
> I am not very fond of the idea of generating repetitious
> data, as I think it would be more difficult to determine
> whether or not the loseek/tell functions put me in the right
> place in the middle of the file. Perhaps if there was a way
> to generate deterministic pseudo-random data, that would work
> (has to be deterministic so the diffs of the output come out
> right). Anyone have a good example of seeding a random
> number generator and generating a bunch of bytea which is
> deterministic cross-platform?
>

How about just using a mathmatical series, like Fibonacci? You can make
the file as big as you want from a trivial generator. If you store it as
space-separated ASCII ( 1 1 2 3 5 8 13 21 34 ... ), it should be
platform independent and you can compare any range of offsets that
suits.

Regards,
Paul Bort

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ITAGAKI Takahiro 2006-09-25 02:04:16 Questions about guc units
Previous Message Jeremy Drake 2006-09-25 01:21:18 Re: [HACKERS] large object regression tests

Browse pgsql-patches by date

  From Date Subject
Next Message ITAGAKI Takahiro 2006-09-25 02:04:16 Questions about guc units
Previous Message Jeremy Drake 2006-09-25 01:21:18 Re: [HACKERS] large object regression tests