On 24-8-2005 16:43, Alexandre Barros wrote:
Hello,
i have a pg-8.0.3 running on Linux kernel 2.6.8, CPU Sempron 2600+,
1Gb RAM on IDE HD ( which could be called a "heavy desktop" ), measuring
this performance with pgbench ( found on /contrib ) it gave me an
average ( after several runs ) o
> Hello,
> i have a pg-8.0.3 running on Linux kernel 2.6.8, CPU Sempron
2600+,
> 1Gb RAM on IDE HD ( which could be called a "heavy desktop" ),
measuring
> this performance with pgbench ( found on /contrib ) it gave me an
> average ( after several runs ) of 170 transactions per second;
170 tps
Alexandre Barros wrote:
Hello,
i have a pg-8.0.3 running on Linux kernel 2.6.8, CPU Sempron
2600+, 1Gb RAM on IDE HD ( which could be called a "heavy desktop" ),
measuring this performance with pgbench ( found on /contrib ) it gave
me an average ( after several runs ) of 170 transactions
On 8/24/05, Alexandre Barros <[EMAIL PROTECTED]> wrote:
> i wouldn't be so stunned if the newer machine was ( say ) twice faster
> than the older server, but over three times faster is disturbing.
RAID5 on so few spindles is a known losing case for PostgreSQL. You'd
be far, far better off doing
On Wed, 24 Aug 2005 11:43:05 -0300
Alexandre Barros <[EMAIL PROTECTED]> wrote:
> I've googled a little, and maybe the cluster size might be one
> problem, but despite that, the performance dropping when running on
> "server-class" hardware with RAID-5 SCSI-2 drives was way above my
> most delir
