Skip site navigation (1) Skip section navigation (2)

Re: Time to put theory to the test?

From: Rob Wultsch <wultsch(at)gmail(dot)com>
To: J Sisson <sisson(dot)j(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Time to put theory to the test?
Date: 2011-04-26 03:04:57
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
On Mon, Apr 25, 2011 at 12:30 PM, J Sisson <sisson(dot)j(at)gmail(dot)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

In response to


pgsql-performance by date

Next:From: Robert HaasDate: 2011-04-26 05:30:58
Subject: Re: Performance
Previous:From: Robert HaasDate: 2011-04-25 23:54:34
Subject: Re: Slow deleting tables with foreign keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group