CAcert Code Development list.

[Jan Dittberner <jandd AT cacert.org>]

On Sat, Dec 19, 2009 at 01:28:23PM +0100, Christopher Etz wrote:
>    Hello,
> 
>     4. Other candidates for the database system
>        From what I read, I've understood that you want to move from MySQL to
>        another database system such as PostgreSQL. Althought I don't really
>        know MySQL, this seems to be a good idea in my opinion.
>        In my opinion, PostgreSQL requires regular maintenance (the famous
>        vacuumdb at least) and might not be the best option when
>        recoverability is a high requirement.

The vacuumdb is done automatically in the background if the (highly
recommended) autovacuum daemon is used [1].

[1] 
http://www.postgresql.org/docs/current/static/routine-vacuuming.html#AUTOVACUUM

PostgreSQL has improved a lot during the last years and is recommended by some
commercial software vendors if Oracle is not an option (due to company 
policies
or financial reasons). The SQL standard support of PostgreSQL as well as its
documentation is excelent.


Regards
Jan

-- 
Jan Dittberner - CAcert Infrastructure Team
GPG-key: 4096R/558FB8DD 2009-05-10
         B2FF 1D95 CE8F 7A22 DF4C  F09B A73E 0055 558F B8DD
http://www.dittberner.info/

Attachment: signature.asc
Description: Digital signature