Обсуждение: automatic and randomally population

Hello

 I want try my tables with some thousands of rows. There are any  manner
to make automatic and randomly population ??

  Thank you,
        Gustavo

You can use loops (http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html). Are you trying to do some performance analysis for the database server?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

For doing the performance analysis you can use BenchmarkSQL (http://sourceforge.net/projects/benchmarksql) and while you do the benchmarking make sure you have your PostgreSQL database server properly tuned following the instructions given at http://www.powerpostgresql.com/PerfList/

Hope this helps...
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com )

gustavo halperin wrote:
> On 7/28/06, Shoaib Mir <shoaibmir@gmail.com> wrote:
>>
>> You can use loops (
>> http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html).
>
> Thanks
>
> Are you trying to do some performance analysis for the database server?
>>
>
> Yes I will, but first I want see how the Open Office behave with larger DB.
> I need to build a DB for an old man, and I want give to him the easier
> client toolkit application. Do you have any recommendation ??

There are a bunch of sample databases of various sizes below. Sounds
like it's useful for you.

http://pgfoundry.org/projects/dbsamples/

--
   Richard Huxton
   Archonet Ltd

Richard Huxton wrote:

> gustavo halperin wrote:
>
>> On 7/28/06, Shoaib Mir <shoaibmir@gmail.com> wrote:
>>
>>>
>>> You can use loops (
>>> http://www.postgresql.org/docs/8.1/interactive/plpgsql-control-structures.html).
>>
>>
>>
>> Thanks
>>
>> Are you trying to do some performance analysis for the database server?
>>
>>>
>>
>> Yes I will, but first I want see how the Open Office behave with
>> larger DB.
>> I need to build a DB for an old man, and I want give to him the easier
>> client toolkit application. Do you have any recommendation ??
>
>
> There are a bunch of sample databases of various sizes below. Sounds
> like it's useful for you.
>
> http://pgfoundry.org/projects/dbsamples/

Are you sure that is the right place, I found there just port languages
to PostgreSQL and one little MySQL example ?
Thank you very much any way,
               Gustavo

gustavo halperin wrote:
>>
>> There are a bunch of sample databases of various sizes below. Sounds
>> like it's useful for you.
>>
>> http://pgfoundry.org/projects/dbsamples/
>
> Are you sure that is the right place, I found there just port languages
> to PostgreSQL and one little MySQL example ?

The "dellstore" archive seems to contain a database certainly - I've
just downloaded it a few minutes ago.

--
   Richard Huxton
   Archonet Ltd