Re: test_fsync label adjustments

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: test_fsync label adjustments
Date: 2011-01-18 22:41:33
Message-ID: 201101182241.p0IMfX703033@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

A.M. wrote:
> >> Because the fastest option may not be syncing to disk. For example,
> >> the only option that makes sense on OS X is fsync_writethrough- it
> >> would be helpful if the tool pointed that out (on OS X only, obviously).
> >
> > Yes, that would be a serious problem. :-(
> >
> > I am not sure how we would address this --- your point is a good one.
>
> One general idea I had would be to offer some heuristics such as "this
> sync rate is comparable to that of one SATA drive" or "comparable to
> RAID 10 with X drives" or "this rate is likely too fast to be actually
> be syncing". But then you are stuck with making sure that the heuristics
> are kept up-to-date, which would be annoying.

That fails for RAID BBUs.

> Otherwise, the only option I see is to detect the kernel and compare
> against a list of known problematic methods. Perhaps it would be easier
> to compare against a whitelist. Also, the tool would likely need to
> parse "mount" output to account for problems with specific filesystems.
>
> I am just throwing around some ideas...

That sounds pretty complicated. One idea would be the creation of a
wiki where people could post their results, or ideally a tool that could
read the output and load it into a database for analysis with other
results.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-01-18 22:59:56 Re: test_fsync label adjustments
Previous Message Simon Riggs 2011-01-18 22:39:52 Re: ALTER TABLE ... ADD FOREIGN KEY ... NOT ENFORCED