Re: Are we losing momentum?
От | Michael Paesold |
---|---|
Тема | Re: Are we losing momentum? |
Дата | |
Msg-id | 039601c30399$1b537600$3201a8c0@beeblebrox обсуждение исходный текст |
Ответ на | Are we losing momentum? (Bruce Momjian <pgman@candle.pha.pa.us>) |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: