X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 61AED47592C for ; Sun, 2 Feb 2003 14:32:44 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id C5020475925 for ; Sun, 2 Feb 2003 14:32:43 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2820267; Sun, 02 Feb 2003 11:32:44 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Curt Sampson , Neil Conway Subject: Re: Postgres 7.3.1 poor insert/update/search performance Date: Sun, 2 Feb 2003 11:31:30 -0800 User-Agent: KMail/1.4.3 Cc: Bruce Momjian , Andrew Sullivan , pgsql-performance@postgresql.org References: <200302021039.h12Adah03315@candle.pha.pa.us> <1044205301.760.103.camel@tokyo> In-Reply-To: MIME-Version: 1.0 Message-Id: <200302021131.30209.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/8 X-Sequence-Number: 1064 Curt, > (MS SQL Server on Windows NT is a notable exception to this. They do, > however, make you pre-create the data file in advance, and they suggest > doing it on an empty partition, which at the very least would get you > long stretches of the file in contiguous order. They may also be using > tricks to make sure the file gets created in contiguous order, or they > may be able to get information from the OS about the physical block > numbers corresponding to logical block numbers in the file.) MSSQL is, in fact, doing some kind of direct-block-addressing. If you=20 attempt to move a partition on the disk containing MSSQL databases, SQL=20 Server will crash on restart and be unrecoverable ... even if the other fil= es=20 on that disk are fine. Nor can you back up MSSQL by using disk imaging,=20 unless you can recover to an identical model disk/array. --=20 Josh Berkus Aglio Database Solutions San Francisco