Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 18:08, Tom Lane wrote: > Ron Johnson <[EMAIL PROTECTED]> writes: >> We'll be using RHES4, I guess, so if it uses 7.4, then I'll have to >> convince the SysAdmin to install 8.1 or 8.2. > > > Red Hat is now selling an "Application Stack" ad

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Tom Lane
Ron Johnson <[EMAIL PROTECTED]> writes: > We'll be using RHES4, I guess, so if it uses 7.4, then I'll have to > convince the SysAdmin to install 8.1 or 8.2. Red Hat is now selling an "Application Stack" addon for RHEL4 that provides Postgres 8.1.x, as well as more modern versions of some other pa

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 17:56, Jim C. Nasby wrote: > On Wed, Oct 18, 2006 at 05:42:22PM -0500, Ron Johnson wrote: >>> In any case, you'll be much, much happier if you do this project on at >>> least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's >>> s

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Jim C. Nasby
On Wed, Oct 18, 2006 at 05:42:22PM -0500, Ron Johnson wrote: > > In any case, you'll be much, much happier if you do this project on at > > least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's > > support requirements it will probably remain supported for a few more > > years by Tom/th

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 17:22, Jim C. Nasby wrote: > On Wed, Oct 18, 2006 at 04:27:21PM -0500, Ron Johnson wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> On 10/18/06 16:08, Jim C. Nasby wrote: >>> On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Jim C. Nasby
On Wed, Oct 18, 2006 at 04:27:21PM -0500, Ron Johnson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 10/18/06 16:08, Jim C. Nasby wrote: > > On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote: > >> Hi everybody! > >> I ask you for your help on a problem I have. > >> I ha

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 10/18/06 16:08, Jim C. Nasby wrote: > On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote: >> Hi everybody! >> I ask you for your help on a problem I have. >> I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have >> some VE

Re: [GENERAL] Real time query analyzer

2006-10-18 Thread Jim C. Nasby
On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote: > Hi everybody! > I ask you for your help on a problem I have. > I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have > some VERY memory intense queries, that put processor up to 40%. I see Note that you're likely to

Re: [GENERAL] Real time query analyzer

2006-10-16 Thread Andreas Kretschmer
Adrian Suciu <[EMAIL PROTECTED]> schrieb: > Hi everybody! > I ask you for your help on a problem I have. > I have a postgresql 7.4 running on a dual 4 GB RAM server, but I have some > VERY memory intense queries, that put processor up to 40%. I see all this > info in unix "top" command or ps -au