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
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
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
Hi all;Since we are on the
topic of what prompted us to use PostgreSQL, I figured Iwould share my
experiences as well, and some additional thoughts that I had.I chose
PostgreSQL about 2 years ago when I realized that the application Iwas
building needed something more robust than MySQL. I fo
