From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Insert performance
Date: Sat, 16 Aug 2003 18:22:48 -0400
Message-ID: <m38yptmedj.fsf@chvatal.cbbrowne.com> (raw)
References: <3F3E3B47.13828.333B51D9@localhost>
<200308161140.59764.josh@agliodbs.com>
Martha Stewart called it a Good Thing whenjosh@agliodbs.com (Josh Berkus)wrote:
> Shridhar,
>> Unfortunately he can not use copy due to some constraints.
> Why not use COPY to load the table, and then apply the constraints
> by query afterwords? It might not be faster, but then again it
> might.
If you can transform the information into COPYable form, that's
certainly a good thing. Whether it will be workable or not is another
question.
> ... but that's based on inadequate experimentation, just a few tests
> on Bonnie++ on a Netra running Solaris 8.
As far as the filesystem issues are concerned, you're probably using
an "old, standard" version of UFS. The "high performance" option on
Solaris involves using third-party Veritas software.
The persistence of this is somewhat surprising; I'd somewhat have
expected Sun to have bought out Veritas or some such thing, as it's a
pretty vital technology that _isn't_ totally under their control.
Actually, an entertaining option would be for them to buy out SGI, as
that would get them control of XFS and a number of other interesting
technologies.
My expectations of a Netra wouldn't be terribly high, either; they
seem to exist as a product so that people that need a cheap Sun box
have an option. They are mostly running IDE disk, and the latest
IA-32 hardware is likely to have newer faster interface options.
--
(format nil "~S@~S" "cbbrowne" "ntlug.org")
http://cbbrowne.com/info/advocacy.html
"Windows NT was designed to be administered by an idiot and usually
is..." -- Chris Adams" <adamsc@gigante.ml.org>
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: Insert performance
In-Reply-To: <m38yptmedj.fsf@chvatal.cbbrowne.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