Re: [GENERAL] PostgreSQL, MySQL, etc., was Re: PostgreSQL is much

2003-12-01 Thread Jan Wieck
Christopher Browne wrote: A long time ago, in a galaxy far, far away, Randolf Richardson <[EMAIL PROTECTED]> wrote: [sNip] the difference is that with mysql, nothing pushes the table out of memory; it always stays in memory. in postgresql, a big query on another tables, or perhaps a vacuum, or ot

Re: [GENERAL] PostgreSQL, MySQL, etc., was Re: PostgreSQL is much faster than MySQL, only when...

2003-11-28 Thread Chris Travers
Randolf Richardson Wrote: > 2. Moving to table spaces (PostgreSQL version 8 maybe?) rather > than just storing a whole bunch of files in a single directory. Oracle's > implementation is nice because tables, indexes, etc., can span multiple > table spaces, and there are great performance op

Re: [GENERAL] PostgreSQL, MySQL, etc., was Re: PostgreSQL is much faster than MySQL, only when...

2003-11-28 Thread Randolf Richardson
> Since we are on the topic of what prompted us to use PostgreSQL, I > figured I would 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 I was building needed something more robust than MySQL.