Re: No flamefest please, MySQL vs. PostgreSQL AGAIN

timeless postgres <pvspam-postgres@hacklab.net> writes:
> 1. Replication -- Supposedly Postgres-R was to be merged into 7.2?
>    Did this happen? Is the pgsql.com offering still the only game
>    in town? (pgsql.com was down at the time I wrote this)

Postgres-R hasn't been merged, and I see no prospect that it will appear
in 7.4 either.  Possibly 7.5.  In the meantime, third-party solutions
are still your only option, and PostgreSQL Inc's one is probably the
best.

> 2. Read/write backups -- Supposedly MySQL locks tables into read-only
>    mode while backing them up?

You'd have to ask them.  Ours doesn't though.

> 3. Non-logged bulk inserts -- How much logging does COPY table FROM
>    do? Is it comparable to a MySQL MyISAM table?

I cannot imagine why you'd want non-logged inserts, unless you don't
actually care about your data.  It should be noted though that as of
7.3, operations on TEMP tables don't do WAL logging; perhaps that
would be of use to you.

> 4. Point-in-time recovery -- Was this supposed to go into CVS sometime
>    this month?

It might be there in 7.4 ... it ain't there today ...

            regards, tom lane