Received: from lv-fw ([159.148.47.176]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0L83oV48366 for ; Mon, 21 Jan 2002 03:03:50 -0500 (EST) (envelope-from mark@vestnesis.lv) Received: (from mail@localhost) by lv-fw (8.11.1/8.11.1) id g0L9AP434310 for pgsql-admin@postgresql.org; Mon, 21 Jan 2002 11:10:25 +0200 (EET) (envelope-from mark@vestnesis.lv) X-Authentication-Warning: lv-fw: mail set sender to mark@vestnesis.lv using -f Received: from 10.11.12.15 by 64.49.215.8 id F4lQ+uNG ; 21 Jan 2002 11:10:19 EET Received: from varde ([10.11.12.30]) by vestnesis.lv (8.11.6/8.11.6/SuSE Linux 0.5) with ESMTP id g0L8BEH23412 for ; Mon, 21 Jan 2002 10:11:15 +0200 From: "Martins Zarins" To: pgsql-admin@postgresql.org Date: Mon, 21 Jan 2002 10:04:53 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: Performance Reply-to: mark@vestnesis.lv Message-ID: <3C4BE7C5.20198.1107D7@localhost> References: <3C480E69.14246.7A3AD8@localhost> In-reply-to: X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200201/128 X-Sequence-Number: 3015 On 18 Jan 2002, at 9:22, Jeremy Buchmann wrote: > > It's more than just processor cache, it's your whole I/O subsystem. > How fast are your drives? How fast is the drive controller? How much > cache is on each drive? How much cache is on the drive controller? > Are you going to use a RAID? If so, what type? Do you have enough > memory for the size of the database and type of queries you're going > to run? Is there any good doc about this on net? (About disc cache, raid cache processor cache and queries - how they influence each other?) Mark