> On Jul 14, 2025, at 15:15, Arnt Gulbrandsen <[email protected]> wrote:
>
> FWIW If I hadn't fallen ill a few months ago, I expect that Abhijit and I
> would have made a new release on the anniversary of the two previous ones. I
> had booked tickets to visit him, and the visit spanned that day. Oh well. A
> release might still happen, when I feel that the code I have is nice, but not
> on any anniversary.
>
No worries, take care of yourself! I've had a few people hesitate to try Aox
because the last "release" was so long ago that they felt it was insecure or
abandonware, but honestly it's amazing how resilient this software has been
over the years. I think it's a testament to good engineering principals and
avoiding needless complexity. A new release would be very welcomed though :)
I have encountered the long query again
select mm.uid, mm.modseq, mm.message from mailbox_messages mm join part_numbers
pn on (pn.message=mm.message) join bodyparts bp on (bp.id=pn.bodypart) left
join address_fields af1 on (af1.message=mm.message) left join addresses a1 on
(a1.id=af1.address and ((af1.field=1 or af1.field=7 or af1.field=8) and
(lower(a1.name) like '%'||$2||'%' or lower(a1.localpart) like '%'||$2||'%' or
lower(a1.domain) like '%'||$2||'%'))) left join header_fields hf2 on
(mm.message=hf2.message and hf2.part='' and (octet_length(hf2.value)<640000 and
to_tsvector('simple'::regconfig, hf2.value) @@ plainto_tsquery($2) and
hf2.value ilike '%'||$2||'%') and hf2.field=20) left join address_fields af3 on
(af3.message=mm.message) left join addresses a3 on (a3.id=af3.address and
((af3.field=1 or af3.field=7 or af3.field=8) and (lower(a3.name) like
'%'||$3||'%' or lower(a3.localpart) like '%'||$3||'%' or lower(a3.domain) like
'%'||$3||'%'))) left join header_fields hf4 on (mm.message=hf4.message and
hf4.part='' and (octet_length(hf4.value)<
According to pg_stat_activity, the backend_start is "2025-07-17 15:32:34.018624
+00:00" but the curent date is "2025-07-17 17:34:14" so it has been running for
a few hours now.
Mark
