Re: Autovacuum to-do list

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <mark(at)mark(dot)mielke(dot)cc>, "Jeff MacDonald" <jam(at)zoidtechnologies(dot)com>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, <andrew(at)supernews(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Autovacuum to-do list
Date: 2005-08-02 07:25:00
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4AC96B8@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of
> mark(at)mark(dot)mielke(dot)cc
> Sent: 02 August 2005 05:55
> To: Jeff MacDonald
> Cc: Matthew T. O'Connor; andrew(at)supernews(dot)com;
> pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Autovacuum to-do list
>
> On Mon, Aug 01, 2005 at 10:35:00PM -0400, Jeff MacDonald wrote:
> > On Mon, Aug 01, 2005 at 10:22:14PM -0400, Matthew T. O'Connor wrote:
> > [..snipped..]
> > > Right which is why we would need to enforce some max
> value so that
> > > vacuuming will never be totally squeezed out.
> > I'm a linux guy, so please forgive my ignorance, but is it
> even possible to
> > determine load average on win32?
>
> Oooo... That's a lot of win32 ignorance to ignore... :-)
>
> Push control-alt-delete and look under "Performance". I believe
> Windows may even keep *more* information that Linux. It's all a
> question of figuring out what the Win32 API calls are to get what you
> are looking for. Most concepts found in one system are also found in
> the other. I would assume yes before no.

Yes - Win32 has Performance Counters which are an extensible set of
monitored objects, and a rich API to access them - see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/perfmon
/base/performance_monitoring.asp for details. The perfmon program (Start
-> Run -> perfmon -> OK) gives a GUI interface to play with in which you
can monitor any installed counter.

Regards, Dave.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff MacDonald 2005-08-02 07:31:03 Re: Autovacuum to-do list
Previous Message Jeff Davis 2005-08-02 06:05:13 Re: #escape_string_warning = off