Craig James wrote:
Justin wrote:
2000 tps ??? do you have fsync turned off ?
Dave
No its turned on.
Unless I'm seriously confused, something is wrong with these numbers.
That's the sort of performance you expect from a good-sized RAID 10
six-disk array. With a single 7200 rpm SATA disk and XFS, I get 640
tps. There's no way you could 2000 tps from a single disk.
Craig
it is a RAID 10 controller with 6 SAS 10K 73 gig drives. The server
is 3 weeks old now.
it has 16 gigs of RAM
2 quad core Xenon 1.88 Ghz processors
2 gig Ethernet cards.
RAID controller perc 6/i with battery backup 512meg cache, setup not lie
about fsync
WAL is on a RAID 0 drive along with the OS
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
