On 25 Sep 2002 at 1:10, Matthew T. O'Connor wrote:
> > It doesn't have to make its way into the postgresql daemon itself -- in
> fact since some people like tuning the vacuuming, it makes more sense to
> make this a daemon. No, my suggestion is simple that some sort of
> auto-vacuumer be compiled
> It doesn't have to make its way into the postgresql daemon itself -- in
fact since some people like tuning the vacuuming, it makes more sense to
make this a daemon. No, my suggestion is simple that some sort of
auto-vacuumer be compiled as a stand-alone app and included in the standard
postgresq
> As far as getting into base postgresql distro. I don't mind it rewriting but I
> have some reservations.
> 1) As it is postgresql source code is huge. Adding functions to it which
> directly taps into it's nervous system e.g. cache, would take far more time to
> perfect in all conditions.
It d
On 24 Sep 2002 at 8:42, Mario Weilguni wrote:
> Am Dienstag, 24. September 2002 08:16 schrieb Shridhar Daithankar:
> IMO there are still several problems with that approach, namely:
> * every database will get "polluted" with the autovacuum table, which is undesired
I agree. But that was the be
Am Dienstag, 24. September 2002 08:16 schrieb Shridhar Daithankar:
>
> > I will play with it more and give you some more feedback.
>
> Awaiting that.
>
IMO there are still several problems with that approach, namely:
* every database will get "polluted" with the autovacuum table, which is undesir
On 23 Sep 2002 at 13:28, Matthew T. O'Connor wrote:
> On Monday 23 September 2002 09:43 am, Shridhar Daithankar wrote:
> > Hello All,
> >
> > I have written a small daemon that can automatically vacuum PostgreSQL
> > database, depending upon activity per table.
>
> Hello Shridhar, sorry I didn't
Just an FYI - this kind of thing would be a *great* feature addition to the generic
PostgresSQL release. We at Lyris often hear that "postgressql is very slow, and the
files are getting larger" and then "wow! it's so much faster now that we're regularly
vacuuming!" after we let them know about
On 23 Sep 2002 at 14:50, Lee Kindness wrote:
> Shridhar,
>
> Might be useful to add a .tag.gz to the downloads, so people do not
> have to use CVS to take a look.
There is a development snapshot..
Bye
Shridhar
--
In most countries selling harmful things like drugs is punishable.Then howcome
Hello All,
I have written a small daemon that can automatically vacuum PostgreSQL
database, depending upon activity per table.
It sits on top of postgres statistics collector. The postgres installation
should have per row statistics collection enabled.
Features are,
* Vacuuming based on acti
