On 27/11/2003 08:08 Chris Travers wrote:
Hi;
I am trying to determine if there is anything I can do with MySQL that I
can't do with PostgreSQL. HEAP tables are the last one I can't figure
out.
HEAP tables are MySQL tables which reside in memory and are visible
across
sessions. For obvious reason
Hi All,
I've just been reading an article in PHP Architect magazine
(http://www.phparch.com) which is the cover story for October called
"Migrating from MySQL to PostgreSQL". I must say that this is a highly
compelling article, especially for me, and is aimed at programmers that
aren't neces
Chris Travers wrote:
HEAP tables are MySQL tables which reside in memory and are visible across
sessions. For obvious reasons, this violates the D in ACID.
Postgresql depend upon two level of buffers. One is it's own buffers and others
are OS buffer cache. So when you say update the table, the re
Le Vendredi 21 Novembre 2003 15:04, Markus Seibold a écrit :
> I am looking for an open source / free data modeling tool for PostgreSQL.
Dear Markus,
pgAdmin team was contacted lately by John McCawley <[EMAIL PROTECTED]>
who is the developer of wxpgDesign, a very neat PostgreSQL design tool unde
Jonathan,
Could you tell me what is the real impact of "fsync=false" on the WAL and on the
database in the same catastrophic scenario ?
Thierry Missimilly
Jonathan Bartlett wrote:
> WAL is write-ahead logging. Basically, before the database actually
> performs an operation, it writes in a log
Hi;
I am trying to determine if there is anything I can do with MySQL that I
can't do with PostgreSQL. HEAP tables are the last one I can't figure out.
HEAP tables are MySQL tables which reside in memory and are visible across
sessions. For obvious reasons, this violates the D in ACID.
In many
Chris Travers wrote:
Anyway one additional thought I had was that it should be possible to write
parsers for text files in PL/PERLu and then plug those in as views. In this
way, files such as /etc/passwd or even /var/log/messages could be used as if
they were tables in the database. Information f
