[ADMIN] What is VACUUM waiting for?

2008-12-12 Thread Michael Monnerie
Dear list, this is postgres 8.1, and I run a dbmail mailserver where we deleted most e-mails. I then did a VACUUM (see below), and just before the "dbmail_messages" truncated rows there was a very long time where obviously nothing happened. No CPU usage (<8%) and no disk I/O (usage <5%). You can

Re: [ADMIN] [GENERAL] Tool to converter plsql in pgplsql

2008-12-12 Thread Robert Treat
On Friday 12 December 2008 04:16:19 Dave Page wrote: > On Fri, Dec 12, 2008 at 7:12 AM, Albe Laurenz wrote: > > paulo matadr wrote: > >> you knowns a tool for automatic converter plsql in pgplsql? > >> this tool exist? > > > > EnterpriseDB claim that they can do something like this, > > but I don

Re: [ADMIN] [GENERAL] Tool to converter plsql in pgplsql

2008-12-12 Thread Dave Page
On Fri, Dec 12, 2008 at 7:12 AM, Albe Laurenz wrote: > paulo matadr wrote: >> you knowns a tool for automatic converter plsql in pgplsql? >> this tool exist? > > EnterpriseDB claim that they can do something like this, > but I don't believe that there is any tool which can do > more than assist yo