From: Michael Paesold <mpaesold@gmx.at>
To: mikeb@netnation.com
To: Brent Verner <brent@rcfile.org>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Are we losing momentum?
Date: Tue, 15 Apr 2003 23:51:00 +0200
Message-ID: <039601c30399$1b537600$3201a8c0@beeblebrox> (raw)
References: <200304142237.h3EMbvv13720@candle.pha.pa.us>
<2703.1050364467@sss.pgh.pa.us>
<20030415015217.GA96608@rcfile.org>
<1050433009.1461.100.camel@mikeb.staff.netnation.com>
Mike Benoit writes:
> Shared hosting enviroments. I work for a web hosting company that offers
> MySQL to all of its customers, our MySQL server has several thousand
> databases on it, and I must say it works exceptionally well.
>
> Creating users/databases/changing passwords is as simple as sending it a
> couple queries from our Customer web interface, trouble shooting poor
> queries takes seconds when using "mytop" (mtop), and tracking/billing
> for disk usage is as simple as running "du /var/lib/mysql/*". I would
> like to say the same things for PG, but I'm affrid I can't.
At least in the latest versions, things are quite easy.
User/database administration?
CREATE USER someuser ENCRYPTED PASSWORD '...' NOCREATEDB NOCREATEUSER;
CREATE DATABASE someuser OWNER someuser ENCODING 'UNICODE';
Disk usage account? Use contrib/dbsize (README for easy setup)
SELECT database_size('someuser');
Done.
Poor queries -> query stats?
Of course, some things are easier in MySQL. On the other hand, what about
InnoDB, "du /var/lib/mysql/*" won't help much...
I just wanted to show that PostgreSQL administration is not that hard in a
hosting environment.
Regards,
Michael Paesold
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: mpaesold@gmx.at, mikeb@netnation.com, brent@rcfile.org
Subject: Re: Are we losing momentum?
In-Reply-To: <039601c30399$1b537600$3201a8c0@beeblebrox>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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