From: Luke Lonergan <llonergan@greenplum.com>
To: Dave Cramer <pg@fastcrypt.com>
Cc: Greg Stark <gsstark@mit.edu>
Cc: Joshua Marsh <icub3d@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware/OS recommendations for large databases (
Date: Fri, 18 Nov 2005 07:30:31 -0800
Message-ID: <BFA33397.1403A%llonergan@greenplum.com> (raw)
In-Reply-To: <A4D5EB2A-73BC-43F8-8B5A-36268193A047@fastcrypt.com>
Dave,
On 11/18/05 7:25 AM, "Dave Cramer" <pg@fastcrypt.com> wrote:
> Luke,
>
> Interesting numbers. I'm a little concerned about the use of blockdev ‹setra
> 16384. If I understand this correctly it assumes that the table is contiguous
> on the disk does it not ?
For optimum performance, yes it does. Remember that the poster is asking
about a 5TB warehouse. Decision support applications deal with large tables
and sequential scans a lot, and the data is generally contiguous on disk.
If delete gaps are there, they will generally vacuum them away.
- Luke
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: llonergan@greenplum.com, pg@fastcrypt.com, gsstark@mit.edu, icub3d@gmail.com
Subject: Re: Hardware/OS recommendations for large databases (
In-Reply-To: <BFA33397.1403A%llonergan@greenplum.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