Postgres Pro
Downloads
Home   >   mailing lists

Thread: automatic and randomally population

automatic and randomally population

From
gustavo halperin
Date:
Hello

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

  Thank you,
        Gustavo

Re: automatic and randomally population

From
"Shoaib Mir"
Date:
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)


On 7/28/06, gustavo halperin < ggh.develop@gmail.com> wrote:
Hello

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

  Thank you,
        Gustavo

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings




Re: automatic and randomally population

From
"gustavo halperin"
Date:


On 7/28/06, Shoaib Mir <shoaibmir@gmail.com> wrote:

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 ??

   Thank you again,
               Gustavo 

--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)


On 7/28/06, gustavo halperin < ggh.develop@gmail.com> wrote:
Hello

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

  Thank you,
        Gustavo

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings





Re: automatic and randomally population

From
"Shoaib Mir"
Date:
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 )


On 7/28/06, gustavo halperin <ggh.develop@gmail.com> wrote:



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 ??

   Thank you again,
               Gustavo 

--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)


On 7/28/06, gustavo halperin < ggh.develop@gmail.com> wrote:
Hello

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

  Thank you,
        Gustavo

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings









Re: automatic and randomally population

From
Richard Huxton
Date:
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

Re: automatic and randomally population

From
gustavo halperin
Date:
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

Re: automatic and randomally population

From
Richard Huxton
Date:
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