Re: 15,000 tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Ron <rjpeace@xxxxxxxxxxxxx>
Subject: Re: 15,000 tables
From: Michael Stone <mstone+postgres@xxxxxxxxx>
Date: Fri, 02 Dec 2005 08:02:16 -0500
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <6.2.5.6.0.20051202030859.0360c1a8@xxxxxxxxxxxxx>
Mail-followup-to: Ron <rjpeace@xxxxxxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
References: <dmmujf$2rgd$1@xxxxxxxxxxxx> <Pine.LNX.4.62.0512010609060.2807@xxxxxxxxxxxxx> <dmn2lh$maj$1@xxxxxxxxxxxx> <9A858930-1CA6-4238-92D4-D1E945683653@xxxxxxxx> <1133462407.5734.43.camel@xxxxxxxxxxxxxxxxx> <6.2.5.6.0.20051201134344.035fed60@xxxxxxxxxxxxx> <15739.1133463453@xxxxxxxxxxxxx> <6.2.5.6.0.20051202030859.0360c1a8@xxxxxxxxxxxxx>
User-agent: Mutt/1.5.11

On Fri, Dec 02, 2005 at 03:15:00AM -0500, Ron wrote:

I've seen enough HD failures that I tend to be paranoid and log themetadata of fs dedicated to WAL as well, but that may very well be overkill.


Especially since it wouldn't gain anything. Journalling doesn't give you
any advantage whatsoever in the face of a HD failure.

Mike Stone

References:
- 15,000 tables
  - From: Michael Riess
- Re: 15,000 tables
  - From: David Lang
- Re: 15,000 tables
  - From: Michael Riess
- Re: 15,000 tables
  - From: Gavin M. Roy
- Re: 15,000 tables
  - From: Tino Wildenhain
- Re: 15,000 tables
  - From: Ron
- Re: 15,000 tables
  - From: Tom Lane
- Re: 15,000 tables
  - From: Ron

Prev by Date: Re: 15,000 tables
Next by Date: Re: COPY into table too slow with index: now an I/O
Previous by thread: Re: 15,000 tables
Next by thread: Re: 15,000 tables
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux