pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedVery important choice
3+ messages / 3 participants
[nested] [flat]
* Very important choice
@ 2005-02-01 01:59 Lago, Bruno Almeida do <extern.Bruno.Lago@gedas.com.br>
2005-02-01 08:50 ` Re: Very important choice Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 3+ messages in thread
From: Lago, Bruno Almeida do @ 2005-02-01 01:59 UTC (permalink / raw)
To: pgsql-performance
Hello my friends,
I'd like to know (based on your experience and technical details) which OS
is recommended for running PostgreSQL keeping in mind 3 indicators:
1 - Performance (SO, Network and IO)
2 - SO Stability
3 - File System Integrity
Comparisons between Slackware, Gentoo and FreeBSD are welcome.
Which file system has the best performance and integrity: XFS (Linux) or UFS
(FreeBSD)?
*I've read that UFS is not a journaling FS. Is this right? How much this
difference affects performance and integrity?
I don't have experience with FreeBSD so I'd like to know if it is possible
to run XFS on FreeBSD 5.3.
Thank you,
Bruno Almeida do Lago
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Very important choice
2005-02-01 01:59 Very important choice Lago, Bruno Almeida do <extern.Bruno.Lago@gedas.com.br>
@ 2005-02-01 08:50 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 3+ messages in thread
From: Richard Huxton @ 2005-02-01 08:50 UTC (permalink / raw)
To: Lago, Bruno Almeida do <extern.Bruno.Lago@gedas.com.br>; +Cc: pgsql-performance
Lago, Bruno Almeida do wrote:
> Hello my friends,
>
> I'd like to know (based on your experience and technical details) which OS
> is recommended for running PostgreSQL keeping in mind 3 indicators:
>
> 1 - Performance (SO, Network and IO)
> 2 - SO Stability
> 3 - File System Integrity
The short answer is almost certainly whichever OS you are most familiar
with. If you have a problem, you don't want to be learning new details
about your OS while fixing it. That rules out FreeBSD for now.
What hardware you want to use will affect performance and choice of OS.
You'll need to decide what hardware you're looking to use.
As far as file-systems are concerned, ext3 seems to be the slowest, and
the general feeling seems to be that XFS is perhaps the fastest. In
terms of reliability, avoid cutting-edge releases of any file-system -
let others test them for you. One thing to consider is how long it takes
to recover from a crash - you can run PostgreSQL on ext2, but checking a
large disk can take hours after a crash. That's the real benefit of
journalling for PG - speed of recovery.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 3+ messages in thread
* Very important choice
@ 2005-02-01 10:02 Bruno Almeida do Lago <teolupus@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Bruno Almeida do Lago @ 2005-02-01 10:02 UTC (permalink / raw)
To: pgsql-performance
Sorry, I sent this mail message with wrong account and it has been delayed
by the mail system, so I'm resending it.
Hello my friends,
I'd like to know (based on your experience and technical details) which OS
is recommended for running PostgreSQL keeping in mind 3 indicators:
1 - Performance (SO, Network and IO)
2 - SO Stability
3 - File System Integrity
Comparisons between Slackware, Gentoo and FreeBSD are welcome.
Which file system has the best performance and integrity: XFS (Linux) or UFS
(FreeBSD)?
*I've read that UFS is not a journaling FS. Is this right? How much this
difference affects performance and integrity?
I don't have experience with FreeBSD so I'd like to know if it is possible
to run XFS on FreeBSD 5.3.
Thank you,
Bruno Almeida do Lago
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-02-01 10:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-01 01:59 Very important choice Lago, Bruno Almeida do <extern.Bruno.Lago@gedas.com.br>
2005-02-01 08:50 ` Richard Huxton <dev@archonet.com>
2005-02-01 10:02 Very important choice Bruno Almeida do Lago <teolupus@gmail.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