pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [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