pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL
11+ messages / 8 participants
[nested] [flat]

* Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL
@ 2003-10-09 17:59 Josh Berkus <josh@agliodbs.com>
  2003-10-09 18:14 ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Nick Fankhauser <nickf@ontko.com>
  2003-10-09 19:23 ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL scott.marlowe <scott.marlowe@ihs.com>
  2003-10-09 20:26 ` Re: OFFTOPIC: PostgreSQL vs MySQL David Griffiths <dgriffiths@boats.com>
  0 siblings, 3 replies; 11+ messages in thread

From: Josh Berkus @ 2003-10-09 17:59 UTC (permalink / raw)
  To: David Griffiths <dgriffiths@boats.com>; pgsql-performance; +Cc: pgsql-advocacy@postgresql.org

David,

Thanks for being considerate, thourough, and honest about your opinions.   
Particulary that you didn't simple depart in a huff.

> 1) the MySQL docs are better (sorry - I found them easier to read, and
> more comprehensive; I had an easier time finding the answers I needed)

I can believe that.   MySQL AB has paid documentation writers; we don't.   

> 2) there are more web pages devoted to MySQL (probably because it has a
> bit more market share)

Particularly among web developers.

> 3) there are more books on MySQL at the bookstore (I haven't had a
> chance to pick up Bruce's book yet; it might be all the book I'd ever
> need)

Bruce's book is out of date -- released in 1998.  I recommend Korry Douglas' 
book instead, just because of its up-to-date nature (printed late 2002 or 
early 2003).

> 4) we looked at MySQL first (we needed replication, and eRServer had not
> been open-sourced when we started looking)

I can't do anything about that, now can I?

> With regards to #1, I'd like to specifically mention tuning - the docs
> at http://www.postgresql.org/docs/7.3/static/runtime-config.html
> <http://www.postgresql.org/docs/7.3/static/runtime-config.html;  give a

Have you checked these pages?  They've been posted on this list numerous 
times:
http://techdocs.postgresql.org
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html

Also, the runtime docs are being improved in 7.4:
http://developer.postgresql.org/docs/postgres/runtime-config.html
... and I'm still working on more general "how to" text.

> "I guess my point is simply this: instead of saying: "okay we use
> default settings that will run on _old_ hardware too" we should go for a
> little script that creates a "still save but much better" config file.
> There's just no point in setting SHARED_BUFFERS to something like 16
> (what's the current default?) if the PC has >= 1 GB of RAM. Setting it
> to 8192 would still be save, but 512 times better...  ;-) (IIRC 8192
> would take 64 MB of RAM, which should be save if you leave the default
> MAX_CONNECTIONS.)" 

You'll be interested to know that SHARED_BUFFERS are actually addressed in the 
initdb script in 7.4.  However, may OSes have low limits on per-process 
memory that requires the admin to modify the sysconf before postgresql.conf 
can be adjusted properly.  This makes writing a multi-platform tuning script 
a significant effort, and to date nobody who is complaining about it the 
loudest has volunteered to do the work.

To reiterate my point above, PostgreSQL is a 100% volunteer Open Source 
project.  MySQL is a commercial company which distributes its products via 
Open Source licensing.  That makes some things easier for them than for us 
(and vice-versa, of course).

> I also have to admit a bit of irritation reading this thread; there is a
> fair number of incorrect statements on this thread that, while not
> wrong, definately aren't right:

We've been working on this on the advocacy list .... that is, giving an 
accurate listing of PostgreSQL features not posessed by MySQL (same for 
Oracle and DB2 as well, MySQL is just easier to start becuase we don't have 
to worry about being sued).   I'd appreciate it if you'd take an interest in 
that document and revise anything which is innaccurate or perjorative.

Also, keep in mind that many members of the PostgreSQL community have "an axe 
to grind" about MySQL.  This is not only because of MySQL's eclipsing us in 
the popular press as "THE open source database"; it is also because prominent 
individuals at MySQL AB, particularly Monty and David Axmark, have in the 
past signaled their intent to rub out all other OSS databases, starting with 
PostgreSQL.   While this says little about the MySQL community, it does make 
members of our communty very touchy when the "M" word comes up.

I quote the rest of your debunking for the benefit of the readers on the 
Advocacy list, with a couple of comments:

> "Speed depends on the nature of use and the complexity of queries.  If
> you are doing updates of related tables, ACID is of vital importance and
> MySQL doesn't provide it."
> MySQL has ACID in InnoDB. I've found that MySQL is actually very fast on
> complex queries w/InnoDB (six tables, 1 million rows, two of the joins
> are outer-joins. In fact, I can get InnoDB to be almost as fast as
> MyISAM. Complex updates are also very very fast. We have not tried
> flooding either database with dozens of complex statements from multiple
> clients; that's coming soon, and from what I've read, MySQL won't do too
> well.
>
> "using InnoDB tables (the only way to have foreign keys, transactions,
> and row level locking for MySQL) makes MySQL slower and adds complexity
> to tuning the database"
> Adding this: "innodb_flush_method=O_DSYNC" to the my.cnf made InnoDB as
> fast as MyISAM in our tests. It doesn't turn off disk flushing; it's
> just a flush method that might work better with different kernels and
> drives; it's one of those "play with this and see if it helps"
> parameters; there are lots of those in Postgres, it seems. There are 10
> variables for tuning InnoDB (and you don't have to tune for MyISAM, so
> it's actually a six-of-one, half-dozen-of-the-other). Setup between the
> two seems to be about the same.
>
> "PostgreSQL supports constraints. MySQL doesn't; programmers need to
> take care of that from the client side"
> Again, InnoDB supports constraints.

Really?  This is news.   We did some tests on constraints on InnoDB, and found 
that while they parsed, they were not actually enforced.    Was our test in 
error?

> "Transactions: We've been here before. Suffice to say, MySQL+InnoDB is
> almost there. Plain ol' MySQL doesn't have it, which tells you something
> about their philosophy towards database design."
> InnoDB supports transactions very nicely, has the equivalent of WAL, and
> one thing I really like: a tablespace (comprised of data files that can
> be spread around multiple hard drives), and in a month or so, InnoDB
> will support multiple tablespaces.

We'll have multiple tablespaces soon as well.  They didn't quite make it for 
7.4, but will be in 7.5.

> To be fair, here are a few MySQL "bad-things" that weren't mentioned:
>
> 1) InnoDB can't do a hot-backup with the basic backup tools. To
> hot-backup an InnoDB database, you need to pay $450 US per database per
> year ($1150 per database perpetual) for a proprietary hot-backup tool
> 2) InnoDB can't do full-text searching.
> 3) I see alot more corrupt-database bugs on the MySQL lists (most are
> MyISAM, but a few InnoDB bugs pop up from time to time) - way more than
> I see on the Postgres lists.

This is consistent with MySQL's emphasis on speed and ease-of-use over 
reliability; we have the opposite emphasis (see below).

> 4) There are some really cranky people on the MySQL lists; the Postgres
> lists seem to be much more effective (esp. with people like Tom Lane).
> Maybe it's because they get alot of dumb questions, as people unfamiliar
> with databases turn to MySQL first?

Possibly.  Also I think it's because of the poor organization of their mailing 
lists; ours are clearly divided into particular topics and experienced 
members politiely encourage toplicality.   Further, the participation by 
major contributors on our lists is, from what I've heard, higher; this means 
that complaintants have faith that their complaints will reach the eyes of 
those actually responsible for the code.

> Maybe the Postgres community needs an anti-FUD individual or two; people
> that know both databases, and can provide the proper information for
> answering questions like this. A section in the docs would help as well.
> Yes, I know many of the people advocating Postgres do not want to
> compare themselves to MySQL (but rather to Oracle, Sybase, DB2, etc) ,
> but the volume of responses on a thread like this indicates that the
> comparison is going to happen regardless. Better to nip it in the bud
> quickly than let it go on over 3-4 days.

Would you care to volunteer?   We'd be glad to have you.

> One last observation: someone looking at both databases, reading those
> posts, might get a bad impression of Postgres based on the inconsistency
> and incorrectness of some of the statements made about MySQL. If a
> salesperson provides misinformation about a competitors product and you
> find out about it, that salesperson has most likely lost a customer.

Maybe.  Not that I'm saying that inaccurate propaganda is a good thing, but 
that it seems so pervasive in the industry that I think people expect it.  We 
trash MySQL; MySQL publishes 6-year-old PG vs. MySQL benchmarks; Oracle puts 
down all Open Source databases based on MySQL's limitations; and MS SQL 
Server publishes benchmarks based on MSSQL on a cluster vs. other DBs on 
workstations.

> Anyway, I hope I haven't offended anyone - I'm not trying to troll or
> flame, but rather just give some constructive criticism from someone
> outside both the MySQL and Postgres camps.

Hmmm .... also, come to think about it, MySQL has done us a favor in some ways 
by making our project take advocacy and user-friendliness seriously, 
something we didn't always do.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL
  2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
@ 2003-10-09 18:14 ` Nick Fankhauser <nickf@ontko.com>
  2003-10-09 19:01   ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
  2003-10-09 19:06   ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Robert Treat <xzilla@users.sourceforge.net>
  2 siblings, 2 replies; 11+ messages in thread

From: Nick Fankhauser @ 2003-10-09 18:14 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; pgsql-performance; +Cc: pgsql-advocacy@postgresql.org

> Have you checked these pages?  They've been posted on this list numerous
> times:
> http://techdocs.postgresql.org
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
> http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
>

Josh- It would be great to have a link to those last two excellent resources
from the techdocs area- perhaps from the "optimizing" section in
http://techdocs.postgresql.org/oresources.php. Who should we suggest this
to? (I submitted these using the form in that area, but you may have better
connections.)

-Nick





^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL
  2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
  2003-10-09 18:14 ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Nick Fankhauser <nickf@ontko.com>
@ 2003-10-09 19:01   ` Josh Berkus <josh@agliodbs.com>
  1 sibling, 0 replies; 11+ messages in thread

From: Josh Berkus @ 2003-10-09 19:01 UTC (permalink / raw)
  To: nickf@ontko.com; pgsql-performance; +Cc: pgsql-advocacy@postgresql.org

Nick,

> Josh- It would be great to have a link to those last two excellent resources
> from the techdocs area- perhaps from the "optimizing" section in
> http://techdocs.postgresql.org/oresources.php. Who should we suggest this
> to? (I submitted these using the form in that area, but you may have better
> connections.)

This is my  responsibility;  I'll add it to the list.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL
  2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
  2003-10-09 18:14 ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Nick Fankhauser <nickf@ontko.com>
@ 2003-10-09 19:06   ` Robert Treat <xzilla@users.sourceforge.net>
  2003-10-09 19:30     ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Joshua D. Drake <jd@commandprompt.com>
  1 sibling, 1 reply; 11+ messages in thread

From: Robert Treat @ 2003-10-09 19:06 UTC (permalink / raw)
  To: nickf@ontko.com; +Cc: Josh Berkus <josh@agliodbs.com>; pgsql-advocacy@postgresql.org

On Thu, 2003-10-09 at 14:14, Nick Fankhauser wrote:
> > Have you checked these pages?  They've been posted on this list numerous
> > times:
> > http://techdocs.postgresql.org
> > http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
> > http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
> >
> 
> Josh- It would be great to have a link to those last two excellent resources
> from the techdocs area- perhaps from the "optimizing" section in
> http://techdocs.postgresql.org/oresources.php. Who should we suggest this
> to? (I submitted these using the form in that area, but you may have better
> connections.)
> 

Unfortunately techdocs is becoming more and more a bastard child since
no one can seem to agree on and actually implement a solution to it's
current woes. I've (quietly) complained about new articles getting
written by the community and posted to sites other than techdocs since I
think it makes it harder for folks to find useful information... 

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL
  2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
  2003-10-09 18:14 ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Nick Fankhauser <nickf@ontko.com>
  2003-10-09 19:06   ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Robert Treat <xzilla@users.sourceforge.net>
@ 2003-10-09 19:30     ` Joshua D. Drake <jd@commandprompt.com>
  2003-10-10 00:29       ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 11+ messages in thread

From: Joshua D. Drake @ 2003-10-09 19:30 UTC (permalink / raw)
  To: Robert Treat <xzilla@users.sourceforge.net>; +Cc: nickf@ontko.com, Josh Berkus <josh@agliodbs.com>; pgsql-advocacy@postgresql.org

Hello,

  One of the other problems with techdocs is that it is way to top level 
heavy. There is a ton of information that is on the front page that
really shouldn't be. IMHO:

There shouldn't be a separate box for JDBC... There should be one that 
is a link to an intefaces page. The interfaces page should have
subsequent information about JDBC/Perl/Python/etc...

As much as I personally appreciate the Online Books box, it should be 
one link that say Documentation. That link should open
a page that has resources for the books, and other online docs as well 
as a link to an articles page.

etc...

Sincerely,

Joshua Drake


Robert Treat wrote:

>On Thu, 2003-10-09 at 14:14, Nick Fankhauser wrote:
>  
>
>>>Have you checked these pages?  They've been posted on this list numerous
>>>times:
>>>http://techdocs.postgresql.org
>>>http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
>>>http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
>>>
>>>      
>>>
>>Josh- It would be great to have a link to those last two excellent resources
>>from the techdocs area- perhaps from the "optimizing" section in
>>http://techdocs.postgresql.org/oresources.php. Who should we suggest this
>>to? (I submitted these using the form in that area, but you may have better
>>connections.)
>>
>>    
>>
>
>Unfortunately techdocs is becoming more and more a bastard child since
>no one can seem to agree on and actually implement a solution to it's
>current woes. I've (quietly) complained about new articles getting
>written by the community and posted to sites other than techdocs since I
>think it makes it harder for folks to find useful information... 
>
>Robert Treat
>  
>

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org





^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL
  2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
  2003-10-09 18:14 ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Nick Fankhauser <nickf@ontko.com>
  2003-10-09 19:06   ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Robert Treat <xzilla@users.sourceforge.net>
  2003-10-09 19:30     ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Joshua D. Drake <jd@commandprompt.com>
@ 2003-10-10 00:29       ` Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 11+ messages in thread

From: Josh Berkus @ 2003-10-10 00:29 UTC (permalink / raw)
  To: Joshua D. Drake <jd@commandprompt.com>; Robert Treat <xzilla@users.sourceforge.net>; +Cc: nickf@ontko.com; pgsql-advocacy@postgresql.org

Josh,

The plan is to re-design techdocs based on Bricolage, allowing writers to 
contribute easier.   However, we got as far as installing Bric on David 
Fetter's test server, and haven't worked on setting up templates yet.

Too many things.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL
  2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
@ 2003-10-09 19:23 ` scott.marlowe <scott.marlowe@ihs.com>
  2003-10-09 20:01   ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
  2 siblings, 1 reply; 11+ messages in thread

From: scott.marlowe @ 2003-10-09 19:23 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: David Griffiths <dgriffiths@boats.com>; pgsql-performance; pgsql-advocacy@postgresql.org

On Thu, 9 Oct 2003, Josh Berkus wrote:

> David Griffiths wrote: 
> > With regards to #1, I'd like to specifically mention tuning - the docs
> > at http://www.postgresql.org/docs/7.3/static/runtime-config.html
> > <http://www.postgresql.org/docs/7.3/static/runtime-config.html;  give a
> 
> Have you checked these pages?  They've been posted on this list numerous 
> times:
> http://techdocs.postgresql.org
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
> http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
> 
> Also, the runtime docs are being improved in 7.4:
> http://developer.postgresql.org/docs/postgres/runtime-config.html
> ... and I'm still working on more general "how to" text.

any chance of getting the perf.html file from varlena folded into the main 
documentation tree somewhere?  it's a great document, and it would 
definitely help if the tuning section of the main docs said "For a more 
thorough examination of postgresql tuning see this:" and pointed to it.




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL
  2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
  2003-10-09 19:23 ` Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL scott.marlowe <scott.marlowe@ihs.com>
@ 2003-10-09 20:01   ` Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 11+ messages in thread

From: Josh Berkus @ 2003-10-09 20:01 UTC (permalink / raw)
  To: scott.marlowe <scott.marlowe@ihs.com>; +Cc: David Griffiths <dgriffiths@boats.com>; pgsql-performance; pgsql-advocacy@postgresql.org

Scott,

> any chance of getting the perf.html file from varlena folded into the main 
> documentation tree somewhere?  it's a great document, and it would 
> definitely help if the tuning section of the main docs said "For a more 
> thorough examination of postgresql tuning see this:" and pointed to it.

Actually, I'm working on that this weekend.

-- 
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology 	josh@agliodbs.com
    and data management solutions 	(415) 565-7293
   for law firms, small businesses 	 fax 621-2533
    and non-profit organizations. 	San Francisco




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: OFFTOPIC: PostgreSQL vs MySQL
  2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
@ 2003-10-09 20:26 ` David Griffiths <dgriffiths@boats.com>
  2003-10-10 03:21   ` Re: OFFTOPIC: PostgreSQL vs MySQL Dennis Bjorklund <db@zigo.dhs.org>
  2003-10-10 07:43   ` Re: OFFTOPIC: PostgreSQL vs MySQL Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  2 siblings, 2 replies; 11+ messages in thread

From: David Griffiths @ 2003-10-09 20:26 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance

> Thanks for being considerate, thourough, and honest about your opinions.
> Particulary that you didn't simple depart in a huff.

Why would I depart in a huff? I was just trying to make a few objective
observations.

I really have no biases; I like what I've seen in MySQL, and I like alot of
the more Oracle-like
features in Postgres.

> > 4) we looked at MySQL first (we needed replication, and eRServer had not
> > been open-sourced when we started looking)
>
> I can't do anything about that, now can I?

My point was that it's since been open-sourced; it just means I've looked
longer at
MySQL, as it had replication when we started looking.

> Have you checked these pages?  They've been posted on this list numerous
> times:
> http://techdocs.postgresql.org
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
> http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html

Those are much more instructive; I'm curious - why aren't then in the
administrator's
section of the docs?

> We've been working on this on the advocacy list .... that is, giving an
> accurate listing of PostgreSQL features not posessed by MySQL (same for
> Oracle and DB2 as well, MySQL is just easier to start becuase we don't
have
> to worry about being sued).   I'd appreciate it if you'd take an interest
in
> that document and revise anything which is innaccurate or perjorative.

I might be able to provide some insight, but I've only been working with
MySQL for a month
or so (Oracle for about 8 years).

> > "PostgreSQL supports constraints. MySQL doesn't; programmers need to
> > take care of that from the client side"
> > Again, InnoDB supports constraints.
>
> Really?  This is news.   We did some tests on constraints on InnoDB, and
found
> that while they parsed, they were not actually enforced.    Was our test
in
> error?

You may have turned them off to load data? I've run into constraints when my
data-load script missed some rows in address_type. When it went to do the
address_list table, all rows that had the missing address_type failed, as
they
should. I saw no weakness in the constraints.


> > Maybe the Postgres community needs an anti-FUD individual or two; people
> > that know both databases, and can provide the proper information for
> > answering questions like this. A section in the docs would help as well.
> > Yes, I know many of the people advocating Postgres do not want to
> > compare themselves to MySQL (but rather to Oracle, Sybase, DB2, etc) ,
> > but the volume of responses on a thread like this indicates that the
> > comparison is going to happen regardless. Better to nip it in the bud
> > quickly than let it go on over 3-4 days.
>
> Would you care to volunteer?   We'd be glad to have you.

Maybe once all this database testing is done; it's extra work on top of an
already
heavy load (add a new baby, and free time goes right down the toilet).

I need to figure out my performance issues with Postgres, finish my
benchmark
suite, test a bunch of databases, argue with the CTO, and then start
migrating.

I'll be sure to post my results to the  pgsql-performance@postgresql.org
along with
the tests.

David.



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: OFFTOPIC: PostgreSQL vs MySQL
  2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
  2003-10-09 20:26 ` Re: OFFTOPIC: PostgreSQL vs MySQL David Griffiths <dgriffiths@boats.com>
@ 2003-10-10 03:21   ` Dennis Bjorklund <db@zigo.dhs.org>
  1 sibling, 0 replies; 11+ messages in thread

From: Dennis Bjorklund @ 2003-10-10 03:21 UTC (permalink / raw)
  To: David Griffiths <dgriffiths@boats.com>; +Cc: Josh Berkus <josh@agliodbs.com>; pgsql-performance

On Thu, 9 Oct 2003, David Griffiths wrote:

> > > "PostgreSQL supports constraints. MySQL doesn't; programmers need to
> > > take care of that from the client side"
> > > Again, InnoDB supports constraints.
> >
> > Really?  This is news.   We did some tests on constraints on InnoDB, and
> > found that while they parsed, they were not actually enforced.    Was 
> > our test in error?
> 
> You may have turned them off to load data? I've run into constraints
> when my data-load script missed some rows in address_type. When it went
> to do the address_list table, all rows that had the missing address_type
> failed, as they should. I saw no weakness in the constraints.

It sounds like you talk about foreign keys only, while the previous writer 
talkes about other constraints also. For example, in postgresql you 
can do:

CREATE TABLE foo (
  x int,

  CONSTRAINT bar CHECK (x > 5)
);

and then

# INSERT INTO foo VALUES (4);
ERROR:  ExecInsert: rejected due to CHECK constraint "bar" on "foo"


I don't know MySQL, but I've got the impression from other posts on the
lists that innodb supports foreign keys only. I might be wrong though.

-- 
/Dennis




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: OFFTOPIC: PostgreSQL vs MySQL
  2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
  2003-10-09 20:26 ` Re: OFFTOPIC: PostgreSQL vs MySQL David Griffiths <dgriffiths@boats.com>
@ 2003-10-10 07:43   ` Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  1 sibling, 0 replies; 11+ messages in thread

From: Shridhar Daithankar @ 2003-10-10 07:43 UTC (permalink / raw)
  To: David Griffiths <dgriffiths@boats.com>; +Cc: Josh Berkus <josh@agliodbs.com>; pgsql-performance

David Griffiths wrote:
>>Have you checked these pages?  They've been posted on this list numerous
>>times:
>>http://techdocs.postgresql.org
>>http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
>>http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
> Those are much more instructive; I'm curious - why aren't then in the
> administrator's
> section of the docs?

Because they are much more recent. Not even 6 months old. And lot of people 
differ on how exactly these tips applies. What goes in postgresql documentation 
is fact and nothing but facts. Clearly such tips do not have any place in 
postgresql documentation(At least in my opinion)

A pointer might get added to postgresql documentation. That's about it at the most.

  Shridhar




^ permalink  raw  reply  [nested|flat] 11+ messages in thread


end of thread, other threads:[~2003-10-10 07:43 UTC | newest]

Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-09 17:59 Re: [PERFORM] OFFTOPIC: PostgreSQL vs MySQL Josh Berkus <josh@agliodbs.com>
2003-10-09 18:14 ` Nick Fankhauser <nickf@ontko.com>
2003-10-09 19:01   ` Josh Berkus <josh@agliodbs.com>
2003-10-09 19:06   ` Robert Treat <xzilla@users.sourceforge.net>
2003-10-09 19:30     ` Joshua D. Drake <jd@commandprompt.com>
2003-10-10 00:29       ` Josh Berkus <josh@agliodbs.com>
2003-10-09 19:23 ` scott.marlowe <scott.marlowe@ihs.com>
2003-10-09 20:01   ` Josh Berkus <josh@agliodbs.com>
2003-10-09 20:26 ` David Griffiths <dgriffiths@boats.com>
2003-10-10 03:21   ` Dennis Bjorklund <db@zigo.dhs.org>
2003-10-10 07:43   ` Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox