From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: Tomeh, Husam <htomeh@firstam.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Vacuum Verbose output
Date: Mon, 31 Oct 2005 22:59:13 -0500
Message-ID: <21438.1130817553@sss.pgh.pa.us> (raw)
In-Reply-To: <1130799160.15018.35.camel@state.g2switchworks.com>
References: <C45835824D00A844BBD0F032D5CDED9202D55552@pisgana01sxch01.ana.firstamdata.com>
<1130799160.15018.35.camel@state.g2switchworks.com>
Scott Marlowe <smarlowe@g2switchworks.com> writes:
> On Mon, 2005-10-31 at 16:34, Tomeh, Husam wrote:
>> Pre-allocating space will prevent extending the datafile during
>> loading massive data (batch processing) and would improve the overall
>> batch write performance.
> Have you got any file system benchmarks that back up this assertion? I
> would love to see something that shows one way or the other if that
> really makes any difference.
Barring some pretty solid evidence, you're unlikely to attract any
enthusiasm among pghackers for this sort of thing. We are generally
disinclined to reinvent functionality that properly belongs to the
kernel or filesystem layer. "Oracle does it" cuts no ice in this
connection, because Oracle is designed around a twenty-year-old
assumption that the database is smarter than the kernel, and the world
has changed a lot since then.
In short: show us some numbers that prove this is worth our attention.
regards, tom lane
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, smarlowe@g2switchworks.com, htomeh@firstam.com
Subject: Re: Vacuum Verbose output
In-Reply-To: <21438.1130817553@sss.pgh.pa.us>
References: <C45835824D00A844BBD0F032D5CDED9202D55552@pisgana01sxch01.ana.firstamdata.com> <1130799160.15018.35.camel@state.g2switchworks.com> <21438.1130817553@sss.pgh.pa.us>
* 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