Re: looking for large dataset - Mailing list pgsql-performance

From scott.marlowe
Subject Re: looking for large dataset
Date
Msg-id Pine.LNX.4.33.0305051023270.2776-200000@css120.ihs.com
Whole thread Raw
In response to looking for large dataset  (Antoine <asolomon15@nyc.rr.com>)
List pgsql-performance
On 3 May 2003, Antoine wrote:

> I was woundering where could I find a nice large dataset.  Perhaps 50
> thousand records or more

I've attached a PHP script called mktestdb that reads in the dictionary at
/usr/share/dict/words,  and inserts a user defined number of rows into a
user defined number of columns.

It's ugly and simple.  Just pipe the output to a text file or psql and off
you go.

usage:

mktestdb tablename [rows [cols]]

default of 1 column and 1000 rows.

It would be easy enough to rewrite this in something more portable if
someone wanted to.

Attachment

pgsql-performance by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: [SQL] Indices are not used by the optimizer
Next
From: "scott.marlowe"
Date:
Subject: Re: Looking for a cheap upgrade (RAID)