Yes, PostgreSQL has been criticized because of the need to do VACUUM,
but soon the vacuum will be performed performed transparently as a built
in part of the core product. I did a quick search of the web to try and
find out the current status of this feature, but will need to check back
with you about it.
Currently there is an auto-vacuum application that runs as a service,
and automatically vacuums a database based on statistics created on each
database. The name of the auto-vacuum service application is called
pg_auto vacuum, and is distributed with PostgreSQL. You could do a
search on the web to find out more about it.
PostgreSQL is an excellent database for the world wide web, and there
are many ISP that specialize in offering postgreSQL databases of their
customer, just like many ISP offer MySQL databases to their clients. I
love PostgreSQL. It's a great database and is much more open than
MySQL, and with a much better license to the open community.
Regards,
LelandJ
Regards,
LelandJ
Ed Leafe wrote:
> On May 31, 2005, at 4:54 PM, Leland Jackson wrote:
>
>> You probably haven't taken a look at PostgreSQL lately, but it is
>> very easy to administer. You can select from a number of
>> administration tools including phpPgAdmin, pgadmin III, and webmin.
>
>
> I'm familiar with those tools; similar ones exist for MySQL, too.
> My comments were concerned with the regular maintenance that *must* be
> performed (such as VACUUM). There is simply nothing analogous with
> MySQL, making it easier for ISPs to offer.
>
> ___/
> /
> __/
> /
> ____/
> Ed Leafe
> http://leafe.com/
> http://dabodev.com/
>
>
>
[excessive quoting removed by server]
©2005 Leland Jackson |
