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

Re: PostgreSQL vs MySQL

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: PostgreSQL vs MySQL
Date: 2004-05-25 03:19:57
Message-ID: m37jv15h2a.fsf@wolfe.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-advocacy
In an attempt to throw the authorities off his trail, threshar(at)torgo(dot)978(dot)org (Jeff) transmitted:
> One area though is fast recovery - Reloading a multi-GB db from a
> pg_dump is painful, especially if you have foreign keys.  Lots of
> sort_mem helps.

A very interesting approach on a multi-cpu system would be to restore
multiple indices concurrently when working on a single table.  The
locality of reference should allow this to be handled quite
efficiently, as data blocks pulled in for one index should shortly be
used for others.

This ought to get decent parallelism.
-- 
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','cbbrowne.com').
http://www3.sympatico.ca/cbbrowne/linuxdistributions.html
"To conquer the enemy without  resorting to war is the most desirable.
The highest form of generalship  is to conquer the enemy by strategy."
-- Sun Tzu, "The Art of War"

In response to

Responses

pgsql-advocacy by date

Next:From: Christopher BrowneDate: 2004-05-25 04:53:36
Subject: Re: Ingres to be released as open source
Previous:From: Christopher Kings-LynneDate: 2004-05-25 02:54:48
Subject: Re: Ingres to be released as open source

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