pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Vivek Khera <vivek@khera.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to improve db performance with $7K?
Date: Fri, 15 Apr 2005 08:58:47 -0700
Message-ID: <425FE4B7.6080406@commandprompt.com> (raw)
In-Reply-To: <9fde2d603a18b53b5b3f22ad47f3a064@khera.org>
References: <d31f71$2epm$1@news.hub.org>
	<33c6269f050406151241b01148@mail.gmail.com>
	<20050406224102.GM93835@decibel.org>
	<33c6269f0504061732195f6ae4@mail.gmail.com>
	<87wtrfmgt5.fsf@stark.xeocode.com>
	<13449.1112847297@sss.pgh.pa.us>
	<20050414055655.GB19518@filer>
	<878y3lj23o.fsf@stark.xeocode.com>
	<20050414083608.GC19518@filer>
	<446.1113489854@sss.pgh.pa.us>
	<20050415020337.GD19518@filer>
	<9fde2d603a18b53b5b3f22ad47f3a064@khera.org>

Vivek Khera wrote:
> 
> On Apr 14, 2005, at 10:03 PM, Kevin Brown wrote:
> 
>> Now, bad block remapping destroys that guarantee, but unless you've
>> got a LOT of bad blocks, it shouldn't destroy your performance, right?
>>
> 
> ALL disks have bad blocks, even when you receive them.  you honestly 
> think that these large disks made today (18+ GB is the smallest now) 
> that there are no defects on the surfaces?

That is correct. It is just that the HD makers will mark the bad blocks
so that the OS knows not to use them. You can also run the bad blocks
command to try and find new bad blocks.

Over time hard drives get bad blocks. It doesn't always mean you have to 
replace the drive but it does mean you need to maintain it and usually
at least backup, low level (if scsi) and mark bad blocks. Then restore.

Sincerely,

Joshua D. Drake


> 
> /me remembers trying to cram an old donated 5MB (yes M) disk into an old 
> 8088 Zenith PC in college...
> 
> Vivek Khera, Ph.D.
> +1-301-869-4449 x806
> 


-- 
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org



view thread (119+ messages)  latest in thread

Message-ID: <425FE4B7.6080406@commandprompt.com>
Permalink:  ../425FE4B7.6080406@commandprompt.com/
Also on:    postgresql.org/message-id/425FE4B7.6080406@commandprompt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jd@commandprompt.com, vivek@khera.org
  Subject: Re: How to improve db performance with $7K?
  In-Reply-To: <425FE4B7.6080406@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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