From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
---|---|
To: | சிவகுமார் மா <masivakumar(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: MySQL versus Postgres |
Date: | 2010-08-11 02:01:52 |
Message-ID: | 4C620490.1090102@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
சிவகுமார் மா wrote:
> 1. Almost all webhosting providers have MySQL support, but PostgreSQL
> support is available from only a few who also have MySQL support.
> Hence MySQL is universal and PostgreSQL is present as also available.
>
http://www.postgresql.org/support/professional_hosting lists far more
than "a few". I think the only real area to complain about here is that
there are definitely multiple sources for free small-scale MySQL
hosting, but none I'm aware of for PostgreSQL. I'm not sure what anyone
here can do about that though.
> a. Documentation is already available (PostgreSQL User Manual,
> PostgreSQL Technical Documentation). Re-package them and publish as
> books targeting different user levels.
>
Fultus already sells printed copies of the documentation. They're not
very popular. Given that the trend everywhere is toward e-books, and
you can get a free PostgreSQL manual in PDF form already, I'm not sure
who exactly would be served by repackaging them in any way. What's
needed here is completely new content.
> b. Cook Books can be created from the discussions in this mailing list.
>
We've already been doing that on the -performance list successfully; a
good portion of things people used to get individual responses to now
can be directed toward an article from
http://wiki.postgresql.org/wiki/Performance_Optimization instead.
The problem is that few discussions happen on these lists for things
like "how do I get used to PostgreSQL after growing up on MySQL?" And
that material will never be appropriate for the PostgreSQL
documentation. I would highly encourage people to migrate their own
personal notes on such things to the very under-maintained section at
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL
> 3. The default configuration settings for PostgreSQL are not optimal
> for performance. Can there be a recommended configuration file in the
> installation (assuming certain amount of RAM and processor type) ?
>
This doesn't work because there are many different types of database
applications, and what's optimal even as a starting configuration for
each type is very different. Also, hardware changes pretty fast; you'd
be hard pressed to write down useful generic recommendations (or insert
them into the core database code) that are still relevant at all after a
release has been out a few years.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2010-08-11 02:32:53 | Re: InitDB: Bad system call |
Previous Message | Tom Lane | 2010-08-10 23:49:18 | Re: fork() and dynamically loaded c functions.... |