[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re[3]: readlocals SQL query


Aparently to the postgresql query log it runs that query quite a lot.
It's very time consuming.

Before i enabled the symlink from rcpthosts to "locals" i can count in
the logs: 3771 times.

That's A LOT.

Thursday, January 25, 2007, 8:31:33 PM, Alex Howansky wrote:

>> Yes, i got that, but why GATHER all the list when you just need to
>> check for one domain.

> If I recall correctly, it retains the list in memory, so that it doesn't have
> to do a query for each individual incoming message. Naturally, this list needs
> to be refreshed on occasion to account for new records. I was under the
> impression that this only happened on a HUP signal though. How often are you
> seeing this query get run?

Catalin Constantin
Bounce Software