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)
Show quoted text
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
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 ??
Thank you again,
Gustavo
--
Show quoted text
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
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)
Show quoted text
On 7/28/06, gustavo halperin <ggh.develop@gmail.com> 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 ??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
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.
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.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