From: Josh Berkus <josh@agliodbs.com>
To: Curt Sampson <cjs@cynic.net>
To: Neil Conway <neilc@samurai.com>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Andrew Sullivan <andrew@libertyrms.info>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres 7.3.1 poor insert/update/search performance
Date: Sun, 2 Feb 2003 11:31:30 -0800
Message-ID: <200302021131.30209.josh@agliodbs.com> (raw)
In-Reply-To: <Pine.NEB.4.51.0302030207200.509@angelic.cynic.net>
References: <200302021039.h12Adah03315@candle.pha.pa.us>
<1044205301.760.103.camel@tokyo>
<Pine.NEB.4.51.0302030207200.509@angelic.cynic.net>
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
attempt to move a partition on the disk containing MSSQL databases, SQL
Server will crash on restart and be unrecoverable ... even if the other files
on that disk are fine. Nor can you back up MSSQL by using disk imaging,
unless you can recover to an identical model disk/array.
--
Josh Berkus
Aglio Database Solutions
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, cjs@cynic.net, neilc@samurai.com, pgman@candle.pha.pa.us, andrew@libertyrms.info
Subject: Re: Postgres 7.3.1 poor insert/update/search performance
In-Reply-To: <200302021131.30209.josh@agliodbs.com>
References: <200302021039.h12Adah03315@candle.pha.pa.us> <1044205301.760.103.camel@tokyo> <Pine.NEB.4.51.0302030207200.509@angelic.cynic.net> <200302021131.30209.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox