RE: Article on MySQL vs. Postgres - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: Article on MySQL vs. Postgres
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018C46@SECTORBASE1
Whole thread Raw
In response to Article on MySQL vs. Postgres  (Tim Perdue <tperdue@valinux.com>)
List pgsql-hackers
> Before I do that I want to confirm the major problem I had w/postgres:
> the 8K tuple limit. When trying to import some tables from MySQL,
> postgres kept choking because MySQL has no such limit on the size of a
> row in the database (text fields on MySQL can be multi-megabyte).

Jan is working on TOAST for 7.1 - there will be no 8K limit any more...

> Long-term stability:
> Postgres is undoubtably the long-run winner in stability, 
> whereas MySQL will freak out or die when left running for more than a
month 
> at a time. But if you ever do have a problem with postgres, you generally
> have to nuke the database and recover from a backup, as there are no 
> known tools to fix index and database corruption. For a long-running
postgres
> database, you will occasionally have to drop indexes and re-create them,
> causing downtime.

I'm implementing WAL for 7.1 - there will be true after crash recovery...

Vadim


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fwd: Re: Fwd: Problem with recv syscall on socket when other side closed connection
Next
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: TOAST on indices