pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL and Journaled File Systems
2+ messages / 2 participants
[nested] [flat]
* PostgreSQL and Journaled File Systems
@ 2003-08-06 21:16 Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Roberto Mello @ 2003-08-06 21:16 UTC (permalink / raw)
To: pgsql-sql
Hi All,
What is the word about using PG with journaled file systems? I have heard
that it's best to not have the PG journal in a journaled system to avoid
double journaling.
Can someone that understand the issues involved (performance, reliability)
please shed some light on the issue?
Thanks in advance,
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net/ |------+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
If I only had a nickel for every time Windows crashed ...
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PostgreSQL and Journaled File Systems
@ 2003-08-06 21:50 Tom Lane <tgl@sss.pgh.pa.us>
parent: Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2003-08-06 21:50 UTC (permalink / raw)
To: Roberto Mello <rmello@cc.usu.edu>; +Cc: pgsql-sql
Roberto Mello <rmello@cc.usu.edu> writes:
> What is the word about using PG with journaled file systems? I have heard
> that it's best to not have the PG journal in a journaled system to avoid
> double journaling.
Journaling metadata is good. Journaling file contents is redundant ---
turn that off if you can. (Of course, if there is anything other than
Postgres files on the same device, you may not want to turn off contents
journalling...)
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-08-06 21:50 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-06 21:16 PostgreSQL and Journaled File Systems Roberto Mello <rmello@cc.usu.edu>
2003-08-06 21:50 ` Tom Lane <tgl@sss.pgh.pa.us>
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