pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [ADMIN] Raw vs Filesystem
6+ messages / 4 participants
[nested] [flat]
* Re: [ADMIN] Raw vs Filesystem
@ 2004-03-29 21:56 Jaime Casanova <el_vigia_ec@hotmail.com>
2004-03-30 08:22 ` Re: [ADMIN] Raw vs Filesystem Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 6+ messages in thread
From: Jaime Casanova @ 2004-03-29 21:56 UTC (permalink / raw)
To: pgsql-performance
ok. if i don't misunderstand you (english is not my mother tongue, so i can
be wrong). your point is that speed is not necesarily performance, that's
right.
so, the real question is what is the best filesystem for optimal speed in
postgresql?
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] Raw vs Filesystem
2004-03-29 21:56 Re: [ADMIN] Raw vs Filesystem Jaime Casanova <el_vigia_ec@hotmail.com>
@ 2004-03-30 08:22 ` Richard Huxton <dev@archonet.com>
2004-03-30 16:43 ` Re: [ADMIN] Raw vs Filesystem Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 6+ messages in thread
From: Richard Huxton @ 2004-03-30 08:22 UTC (permalink / raw)
To: Jaime Casanova <el_vigia_ec@hotmail.com>; pgsql-performance
On Monday 29 March 2004 22:56, Jaime Casanova wrote:
> ok. if i don't misunderstand you (english is not my mother tongue, so i can
> be wrong). your point is that speed is not necesarily performance, that's
> right.
>
> so, the real question is what is the best filesystem for optimal speed in
> postgresql?
That's going to depend on a number of things:
1. Size of database
2. Usage patterns (many updates or mostly reads? single user or many?...)
3. What hardware you've got
4. What OS you're running.
5. How you've configured your hardware, OS and PG.
There are some test results people have provided in the archives, but whether
they apply to your setup is open to argument.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] Raw vs Filesystem
2004-03-29 21:56 Re: [ADMIN] Raw vs Filesystem Jaime Casanova <el_vigia_ec@hotmail.com>
2004-03-30 08:22 ` Re: [ADMIN] Raw vs Filesystem Richard Huxton <dev@archonet.com>
@ 2004-03-30 16:43 ` Josh Berkus <josh@agliodbs.com>
2004-03-30 17:28 ` Re: [ADMIN] Raw vs Filesystem Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 6+ messages in thread
From: Josh Berkus @ 2004-03-30 16:43 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; Jaime Casanova <el_vigia_ec@hotmail.com>; pgsql-performance
Jaime, Richard,
> That's going to depend on a number of things:
> There are some test results people have provided in the archives, but
> whether they apply to your setup is open to argument.
True. On Linux overall, XFS, JFS, and Reiser have all looked good at one time
or another. Ext3 has never been a leader for performance, though, so that's
an easy elimination.
--
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] Raw vs Filesystem
2004-03-29 21:56 Re: [ADMIN] Raw vs Filesystem Jaime Casanova <el_vigia_ec@hotmail.com>
2004-03-30 08:22 ` Re: [ADMIN] Raw vs Filesystem Richard Huxton <dev@archonet.com>
2004-03-30 16:43 ` Re: [ADMIN] Raw vs Filesystem Josh Berkus <josh@agliodbs.com>
@ 2004-03-30 17:28 ` Richard Huxton <dev@archonet.com>
2004-03-30 20:59 ` Re: [ADMIN] Raw vs Filesystem Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 6+ messages in thread
From: Richard Huxton @ 2004-03-30 17:28 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; Jaime Casanova <el_vigia_ec@hotmail.com>; pgsql-performance
On Tuesday 30 March 2004 17:43, Josh Berkus wrote:
> Jaime, Richard,
>
> > That's going to depend on a number of things:
> > There are some test results people have provided in the archives, but
> > whether they apply to your setup is open to argument.
>
> True. On Linux overall, XFS, JFS, and Reiser have all looked good at one
> time or another. Ext3 has never been a leader for performance, though, so
> that's an easy elimination.
True, but on the sorts of commodity boxes I use, it doesn't make sense for me
to waste time setting up non-standard filesystems - it's cheaper to spend a
little more for better performance. I think SuSE offer Reiser though, so
maybe we'll see a wider selection available by default.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] Raw vs Filesystem
2004-03-29 21:56 Re: [ADMIN] Raw vs Filesystem Jaime Casanova <el_vigia_ec@hotmail.com>
2004-03-30 08:22 ` Re: [ADMIN] Raw vs Filesystem Richard Huxton <dev@archonet.com>
2004-03-30 16:43 ` Re: [ADMIN] Raw vs Filesystem Josh Berkus <josh@agliodbs.com>
2004-03-30 17:28 ` Re: [ADMIN] Raw vs Filesystem Richard Huxton <dev@archonet.com>
@ 2004-03-30 20:59 ` Joshua D. Drake <jd@commandprompt.com>
2004-03-30 21:52 ` Re: [ADMIN] Raw vs Filesystem Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 6+ messages in thread
From: Joshua D. Drake @ 2004-03-30 20:59 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: Josh Berkus <josh@agliodbs.com>; Jaime Casanova <el_vigia_ec@hotmail.com>; pgsql-performance
>
> True, but on the sorts of commodity boxes I use, it doesn't make sense for me
> to waste time setting up non-standard filesystems - it's cheaper to spend a
> little more for better performance. I think SuSE offer Reiser though, so
> maybe we'll see a wider selection available by default.
SuSE defaults to Reiser but also allows XFS. I would suggest XFS.
Sincerely,
Joshua D. Drake
>
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
Attachments:
jd.vcf (text/x-vcard, 638B) download
begin:vcard
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:jd@commandprompt.com
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0034
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.
x-mozilla-html:FALSE
url:http://www.commandprompt.com/
version:2.1
end:vcard
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [ADMIN] Raw vs Filesystem
2004-03-29 21:56 Re: [ADMIN] Raw vs Filesystem Jaime Casanova <el_vigia_ec@hotmail.com>
2004-03-30 08:22 ` Re: [ADMIN] Raw vs Filesystem Richard Huxton <dev@archonet.com>
2004-03-30 16:43 ` Re: [ADMIN] Raw vs Filesystem Josh Berkus <josh@agliodbs.com>
2004-03-30 17:28 ` Re: [ADMIN] Raw vs Filesystem Richard Huxton <dev@archonet.com>
2004-03-30 20:59 ` Re: [ADMIN] Raw vs Filesystem Joshua D. Drake <jd@commandprompt.com>
@ 2004-03-30 21:52 ` Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 6+ messages in thread
From: Josh Berkus @ 2004-03-30 21:52 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; Richard Huxton <dev@archonet.com>; +Cc: Jaime Casanova <el_vigia_ec@hotmail.com>; pgsql-performance
Josh,
> SuSE defaults to Reiser but also allows XFS. I would suggest XFS.
I've found Reiser to perform very well for databases with many small tables.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2004-03-30 21:52 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-29 21:56 Re: [ADMIN] Raw vs Filesystem Jaime Casanova <el_vigia_ec@hotmail.com>
2004-03-30 08:22 ` Richard Huxton <dev@archonet.com>
2004-03-30 16:43 ` Josh Berkus <josh@agliodbs.com>
2004-03-30 17:28 ` Richard Huxton <dev@archonet.com>
2004-03-30 20:59 ` Joshua D. Drake <jd@commandprompt.com>
2004-03-30 21:52 ` Josh Berkus <josh@agliodbs.com>
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