Re: High Performance/High Reliability File system on SuSE64

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Christopher Weimann <cweimann(at)k12hq(dot)com>
Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-performance(at)postgresql(dot)org
Subject: Re: High Performance/High Reliability File system on SuSE64
Date: 2004-01-24 01:26:45
Message-ID: 4011C9D5.6050905@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance


>You can do snapshots in FreeBSD 5.x with UFS2 as well but that (
>nor XFS snapshots ) will let you backup with the database server
>running. Just because you will get the file exactly as it was at
>a particular instant does not mean that the postmaster did not
>still have some some data that was not flushed to disk yet.
>
>
Ahh... isn't that what fsync is for?

--
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(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Kirkwood 2004-01-24 03:27:04 Re: High Performance/High Reliability File system on SuSE64
Previous Message Christopher Weimann 2004-01-24 01:22:47 Re: High Performance/High Reliability File system on SuSE64

Browse pgsql-performance by date

  From Date Subject
Next Message Jenny Zhang 2004-01-24 01:34:24 query slows under load
Previous Message Christopher Weimann 2004-01-24 01:22:47 Re: High Performance/High Reliability File system on SuSE64