Self vacuuming
Hi guys (and girls),
Firstly, I must say that everyone has been quite helpful to me while I've
been migrating my database to PostgreSQL 7.1.
One feature I would like to see would be the ability to set a "usage" and
"idle" threshold, so that tables automatically get vacuumed once they have
had more than X insert/deletes and there is less than Y load (however load
may be defined) on the database.
Would this be a particularly hard feature to implement?
Cheers,
--
Alastair D'Silva (mob: 0413 485 733)
Networking Consultant
New Millennium Networking (web: http://www.newmillennium.net.au)
Alastair D'Silva wrote:
Hi guys (and girls),
Firstly, I must say that everyone has been quite helpful to me while I've
been migrating my database to PostgreSQL 7.1.One feature I would like to see would be the ability to set a "usage" and
"idle" threshold, so that tables automatically get vacuumed once they have
had more than X insert/deletes and there is less than Y load (however load
may be defined) on the database.Would this be a particularly hard feature to implement?
I would like not to see vacuuming required at all. I like the feature as a way
to force compaction, but I would like to see dynamic block space reuse. This is
a far more complex thing to implement with variable length fields, but it is
realy the only way to do it.
--
I'm not offering myself as an example; every life evolves by its own laws.
------------------------
http://www.mohawksoft.com