Message-ID: <039601c30399$1b537600$3201a8c0@beeblebrox>
From: "Michael Paesold" <mpaesold@gmx.at>
To: <mikeb@netnation.com>, "Brent Verner" <brent@rcfile.org>
Cc: <pgsql-hackers@postgresql.org>
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>
Subject: Re: Are we losing momentum?
Date: Tue, 15 Apr 2003 23:51:00 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit

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