pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Welty <rwelty@averillpark.net>
To: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: Filesystems WAS: Perfomance Tuning
Date: Tue, 12 Aug 2003 16:31:19 -0400 (EDT)
Message-ID: <E19mfnc-0007W1-8n@skipper.averillpark.net> (raw)
In-Reply-To: <200308121309.42169.josh@agliodbs.com>
References: <71E37EF6B7DCC1499CEA0316A25683280105705B@loki.globexplorer.com>
	<200308121309.42169.josh@agliodbs.com>

On Tue, 12 Aug 2003 13:09:42 -0700 Josh Berkus <josh@agliodbs.com> wrote:
> This idea has been discussed numerous times on the HACKERS list, and is
> a 
> (pretty much) closed issue.   While Oracle and SQL Server use their own 
> filesystems, PostgreSQL will not because:
...
> 2) The filesystem projects out there are (mostly) well-staffed and are 
> constantly advancing using specialized technology and theory.  There's
> no way 
> that the PostgreSQL team can do a better job in our "spare time".

i consider this a fair answer, but i have a slightly different question to
ask, inspired by my discussions with a good friend who is a top notch
Informix DBA.

there are advantages to being able to split the database across a slew of
disk drives. if we accept the notion of using the native OS filesystem on
each, it would seem that being able to direct various tables and indices to
specific drives might be a valuble capability. i know that i could go into
/var/lib/pgsql/data/base and fan the contents out, but this is unweildy and
impractical. has any consideration been given to providing a way to manage
such a deployment?

or is it the judgement of the hackers community that a monsterous raid-10
array offers comparable performance?

i forget how large the data store on my friend's current project is, but
i'll check. knowing the size and transaction rate he's dealing with might
put a finer point on this discussion.

richard
--
Richard Welty                                         rwelty@averillpark.net
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security





view thread (8+ messages)  latest in thread

Message-ID: <E19mfnc-0007W1-8n@skipper.averillpark.net>
Permalink:  ../E19mfnc-0007W1-8n@skipper.averillpark.net/
Also on:    postgresql.org/message-id/E19mfnc-0007W1-8n@skipper.averillpark.net

 · 

reply

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: rwelty@averillpark.net
  Subject: Re: Filesystems WAS: Perfomance Tuning
  In-Reply-To: <E19mfnc-0007W1-8n@skipper.averillpark.net>
  References: <71E37EF6B7DCC1499CEA0316A25683280105705B@loki.globexplorer.com> <200308121309.42169.josh@agliodbs.com> <E19mfnc-0007W1-8n@skipper.averillpark.net>

* 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