alvherre

Hi,

It seems the greylisting setup stopped quarantining emails?  I'm getting
a lot more spam in pgsql-hackers and the other lists I moderate, and
nothing in the headers suggest that they were greylisted at all.

Did something happen?

Hello!  This is just a test, please ignore.

If you don't ignore it, I'll ignore you.

Thanks,

Huh, you know you can de-duplicate them at your end, right?  Actually I
prefer to get the private copy, so that I get the email immediately even
if the list server is down or slow.

peter pilsl wrote:

> But there is a problem now: There are also entries in fn_kat which dont
> have corresponding entries in fn_dokumente and this entries should be
> listed too. With the proper count=0 !!

Your problem is not on the GROUP BY, but rather that you need an outer
join.  Try something like

select k.kategorie,count(d.oid) from fn_kat k left join fn_dokumente d
on k.id=d.kategorie group by k.kategorie;

Actually, if you are modifying the same blocks over and over it will
help *less*, because applying each record needs to occur only after the
previous records that modify the same block have been applied.

So you have two possibilities: you skip that record and try to apply the
next one, hoping that that record applies to a block that's not locked,
(which means you have to remember the skipped record and apply it
sometime in the future), or you put the process to sleep until the lock
has been released.