On Tue, 24 Jul 2007, Jonah H. Harris wrote:
> At this point in time, I don't believe you can use anything but MyISAM
> for the catalog tables. So, I imagine it would be possible to logically
> corrupt a system if DDL was occurring at the exact point of a crash.
They work around this the old-fashioned MySQL way, with lots of locks.
For example, this is their ALTER TABLE internal workflow: "
* open and lock table with TL_WRITE_ALLOW_READ
* create an altered copy of the table with a temporary name
* force and wait until all instances of table are closed (lock
* swap the new and old versions
* drop the old version"
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
In response to
pgsql-advocacy by date
|Next:||From: Greg Smith||Date: 2007-07-24 20:39:11|
|Subject: Re: (wtf) Top 20 Open Source Software Projects in
|Previous:||From: Bruce Momjian||Date: 2007-07-24 20:16:36|
|Subject: Re: (wtf) Top 20 Open Source Software
Projects inthe Enterprise|