[GENERAL] On-line / off-line trace of SQL statements presented to the Postgres SQL engine

2007-05-30 Thread Gino . Barille
We are using a three-tier application with J2EE, JBoss, Hibernate and a Postgres database. It would be a nice thing to monitor or trace the actual SQL statements processed by the DB. I do not really need the result set as I can get this - if required - using SQL against the DB through the Pgsql in

[GENERAL] Database activity monitoring

2007-05-30 Thread Gino . Barille
The following is an extract of the output from the DB monitoring tool that was delivered with the Progress DB. Sorry for the formatting but I am hopeful you get an idea of what I am talking about. Counters would be updated every x seconds. Is there something - commercial, non- commercial, does not

[GENERAL] Full vacuum may reclaim space

2007-05-30 Thread Gino . Barille
Other than the fact that no space may need to be reclaimed is anyone aware of any circumstance - e.g. use of numeric data types - where a full vacuum will simply not reclaim space? ---(end of broadcast)--- TIP 5: don't forget to increase your free s

Re: [GENERAL] Full vacuum may reclaim space

2007-06-12 Thread Gino . Barille
On May 31, 12:11 am, [EMAIL PROTECTED] (Tom Lane) wrote: > [EMAIL PROTECTED] writes: > > Other than the fact that no space may need to be reclaimed is anyone > > aware of any circumstance - e.g. use of numeric data types - where a > > full vacuum will simply not reclaim space? > > There are several