Re: [ADMIN] Massive table bloat

2013-02-01 Thread Sergey Konoplev
Hi all, For those who are interested in pgcompactor - v1.0rc1 is out. It contains a lot of improvements and has already been tested on a plenty of databases. The list of changes is below: 2013-02-01 v1.0rc1 - Refactored information files, PgToolkit is released under the PostgreSQL License now

[ADMIN] Zabbix Postbix help

2013-02-01 Thread Raju Angani
Hi, I';m exploring zabbix/postbix, I have downloaded the vmware/zabbix appliance and got the zabbix working. I installed postbix as the documentation says, and configured to connect to remote postgres. I can see the connection happening from zabbix to postgres, but I don't see any data for the po

Re: [ADMIN] Avoid casting NULLs in UNION...

2013-02-01 Thread Albe Laurenz
Marko Rihtar wrote: > maybe you can help me with this issue. > Here is an example > > SELECT NULL::integer > UNION ALL > SELECT NULL > UNION ALL > SELECT 123 > > For this sql to work i have to cast NULL to integer. > I was wondering if there exists some configuration parameter at database > leve

[ADMIN] Avoid casting NULLs in UNION...

2013-02-01 Thread Marko Rihtar
Hi, maybe you can help me with this issue. Here is an example SELECT NULL*::integer* UNION ALL SELECT NULL UNION ALL SELECT 123 For this sql to work i have to cast NULL to integer. I was wondering if there exists some configuration parameter at database level that can be used to avoid this n