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-21 02:29:24
Message-ID: m3u0yacy2j.fsf@wolfe.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-advocacy
Clinging to sanity, dan(at)langille(dot)org (Dan Langille) mumbled into her beard:
> On Thu, 20 May 2004, Josh Berkus wrote:
>> Dan, Robert
>> > This is an issue frequently raised with Bacula (http://www.bacula.org/).
>> > How do I backup my 20GB database if I have only 1GB free diskspace?
>> > Bacula can use a FIFO, although I've never used it myself.
>>
>> My answer to this would be "stop being such a cheapskate and spend $150 on
>> another HDD, darn it!"
>
> Umm, I was using small numbers to prove a point.  Change GB to TB if
> you want.  For some places, it's a realy issue.  There is no disk
> space to dump.

The principle still fits.

Dumps, particularly if compressed, are WAY smaller than the database.
If there's a fair bit of text being stored, I'd find a 10:1
compression ratio quite easy to believe.

If your filesystems are consistently more than 90% full, therefore
meaning dumping isn't possible, then you're aiming to suffer from all
the sorts of pathologies that take place when filesystems get very
nearly full.  Some filesystems may play a little better than others
(doubtless ext2, BFFS, MS-FAT, and HPFS all behave a bit differently),
but when they're doing a lot of work looking for the little bit of
free space that's left, performance is certain to suffer.
-- 
select 'cbbrowne' || '@' || 'acm.org';
http://www.ntlug.org/~cbbrowne/advocacy.html
Strong language gets results.  "The  reloader is completely broken  in
242" will open  a lot more eyes than  "The reloader doesn't load files
with intermixed spaces, asterisks,  and <'s in   their names that  are
bigger than 64K".  You can always say the latter in a later paragraph.
-- from the Symbolics Guidelines for Sending Mail

In response to

pgsql-advocacy by date

Next:From: Joe ConwayDate: 2004-05-21 05:35:07
Subject: Re: pgSQL deployment
Previous:From: Dan LangilleDate: 2004-05-20 21:48:16
Subject: Re: PostgreSQL vs MySQL

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