On 05.09.2007 01:15, Scott Marlowe wrote:
On 9/4/07, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> wrote:
Carlo Stonebanks wrote:
A client is moving their postgresql db to a brand new Windows 2003 x64
server with 2 quad cores and 32GB of RAM. It is a dedicated server to run
8.2.4.
Large shared_buffers and Windows do not mix. Perhaps you should leave
the shmem config low, so that the kernel can cache the file pages.
But yeah, the I/O, that's the big one. If it's just a single or a
couple of IDE drives, it's not gonna be able to handle much load.
Right, additionally NTFS is really nothing to use on any serious disc array.
--
Regards,
Hannes Dorbath
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate