On 5/22/07, Stephane Bailliez <[EMAIL PROTECTED]> wrote:
Out of curiosity, can anyone share his tips & tricks to validate a
machine before labelling it as 'ready to use postgres - you probably
won't trash my data today' ?
I'm looking for a way to stress test components especially kernel/disk
to have confidence > 0 that I can use postgres on top of it.
Any secret trick is welcome (beside the memtest one :)
Compile the Linux kernel -- it's a pretty decent stress test.
You could run pgbench, which comes with PostgreSQL (as part of the
contrib package). Give a database size that's larger than the amount
of physical memory in the box.
Alexander.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
