Re: Follow-Up: How to improve db performance with $7K? - Mailing list pgsql-performance

From PFC
Subject Re: Follow-Up: How to improve db performance with $7K?
Date
Msg-id op.sotbmjp6th1vuj@localhost
Whole thread Raw
In response to Re: How to improve db performance with $7K?  (Bjoern Metzdorf)
Responses Re: Follow-Up: How to improve db performance with $7K?  ("Steinar H. Gunderson")
List pgsql-performance
> and we get about 65MB/sec sustained when writing to an ext3 filesystem
> (actually, when wgetting a file off the gigabit LAN :-) ). I haven't

    Well, unless you have PCI 64 bits, the "standard" PCI does 133 MB/s which
is then split exactly in two times 66.5 MB/s for 1) reading from the PCI
network card and 2) writing to the PCI harddisk controller. No wonder you
get this figure, you're able to saturate your PCI bus, but it does not
tell you a thing on the performance of your disk or network card... Note
that the server which serves the file is limited in the same way unless
the file is in cache (RAM) or it's PCI64. So...


> tested
> reading, though.
>
> /* Steinar */



pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: Follow-Up: How to improve db performance with $7K?
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: Follow-Up: How to improve db performance with $7K?