Thanks Tom, that worked!
On Mon, Mar 24, 2014 at 8:47 PM, Tom Lane wrote:
> Ilya Ivanov writes:
> > I need to find all active (status=0) items not belonging to any active
> > trigger. The best I could come up with is this:
>
> > select count(itemid) from items where s
I need some help with a query. I've the following tables structure:
# select triggerid,expression,status from triggers
triggerid | expression | status
19298| {23033}=0 | 0
17041| {20211}#0 | {20210} | 1
18875| {22975}
well, it'd be good to have a link to the resource that says about 5x ratio,
but in general I'm satisfied with that explanation. Thank you.
I have a 8.4 database (installed on ubuntu 10.04 x86_64). It holds Zabbix
database. The database on disk takes 10Gb. SQL dump takes only 2Gb. I've
gone through
http://archives.postgresql.org/pgsql-general/2008-08/msg00316.php and got
some hints. Naturally, the biggest table is history (the second b
