[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: 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?