Re: Time to put theory to the test? - Mailing list pgsql-performance

From Rob Wultsch
Subject Re: Time to put theory to the test?
Date
Msg-id BANLkTikzg0JMtXPB0E=v_=GTPh2AoAf3oQ@mail.gmail.com
Whole thread Raw
In response to Time to put theory to the test?  (J Sisson <sisson.j@gmail.com>)
Responses Re: Time to put theory to the test?
Re: Time to put theory to the test?
List pgsql-performance
On Mon, Apr 25, 2011 at 12:30 PM, J Sisson <sisson.j@gmail.com> wrote:
> machines, and virtually every MySQL machine has required data cleanup
> and table scans and tweaks to get it back to "production" status.

Tip from someone that manages thousands of MySQL servers: Use InnoDB
when using MySQL. Using a crash unsafe product will yield undesirable
results when a server crashes. It is also faster for many use cases.

InnoDB is crash safe. It is just that simple.

--
Rob Wultsch
wultsch@gmail.com

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Slow deleting tables with foreign keys
Next
From: Robert Haas
Date:
Subject: Re: Performance