From:
Matteo Beccati <php(at)beccati(dot)com>
To:
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
Cc:
Aidan Van Dyk <aidan(at)highrise(dot)ca>,
Magnus Hagander <magnus(at)hagander(dot)net>,
Dave Page <dpage(at)pgadmin(dot)org>, Abhijit Menon-Sen <ams(at)toroid(dot)org>,
Alvaro Herrera <alvherre(at)commandprompt(dot)com>,
Andrew Dunstan <andrew(at)dunslane(dot)net>, Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>,
pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: mailing list archiver chewing patches
Date:
2010-01-14 14:08:22
Message-ID:
4B4F2556.80907@beccati.com (view raw or flat )
Thread:
2010-01-08 23:51:42 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-01-09 04:56:06 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-09 05:17:27 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-09 22:27:48 from Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
2010-01-09 22:42:54 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-01-10 09:27:21 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-11 00:18:22 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-11 09:46:10 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-11 13:23:31 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-11 13:50:36 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-11 14:00:03 from Abhijit Menon-Sen <ams(at)toroid(dot)org>
2010-01-11 22:23:41 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-12 04:54:03 from Dave Page <dpage(at)pgadmin(dot)org>
2010-01-12 09:05:56 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-12 09:30:41 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-12 19:56:29 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-12 20:04:27 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-12 20:37:50 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-12 20:16:47 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-01-12 21:28:03 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-12 21:33:38 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2010-01-12 22:10:57 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-14 07:22:29 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-14 12:23:31 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-14 13:39:44 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-14 13:46:09 from Dave Page <dpage(at)pgadmin(dot)org>
2010-01-14 14:32:13 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-14 14:36:35 from Dave Page <dpage(at)pgadmin(dot)org>
2010-01-14 14:08:22 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-14 14:47:02 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-14 15:06:33 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-14 15:09:43 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-14 18:36:09 from David Fetter <david(at)fetter(dot)org>
2010-01-15 19:38:50 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-16 10:48:50 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-16 13:21:58 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-18 14:48:12 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-18 14:55:00 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-18 15:19:36 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-18 17:35:07 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-18 17:44:28 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-18 15:52:49 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-18 17:31:08 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-18 17:42:48 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-19 08:11:32 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-19 08:44:01 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-30 16:08:08 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-30 16:54:37 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-01-30 21:43:50 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-31 12:45:09 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-31 14:09:17 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-31 17:51:10 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-30 21:14:10 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-30 21:18:48 from Joe Conway <mail(at)joeconway(dot)com>
2010-01-31 12:38:11 from Matteo Beccati <php(at)beccati(dot)com>
2010-02-01 02:27:24 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-02-01 08:06:14 from Matteo Beccati <php(at)beccati(dot)com>
2010-02-01 09:26:04 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-01 13:36:21 from Matteo Beccati <php(at)beccati(dot)com>
2010-02-01 14:03:52 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-01 14:10:14 from Matteo Beccati <php(at)beccati(dot)com>
2010-02-01 14:16:44 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-01 16:28:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-01 16:31:21 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-01 16:41:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-01 16:43:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-02-01 18:50:22 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-02-13 12:34:56 from Matteo Beccati <php(at)beccati(dot)com>
2010-05-01 18:16:13 from Matteo Beccati <php(at)beccati(dot)com>
2010-05-01 18:19:22 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-05-03 16:07:25 from Selena Deckelmann <selenamarie(at)gmail(dot)com>
2010-05-03 16:32:11 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-05-03 16:35:32 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-05-03 16:55:39 from Matteo Beccati <php(at)beccati(dot)com>
2010-11-21 20:06:23 from David Fetter <david(at)fetter(dot)org>
2010-11-22 00:39:38 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-11-22 04:48:14 from Matteo Beccati <php(at)beccati(dot)com>
2010-11-24 13:33:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-11-24 14:51:55 from Matteo Beccati <php(at)beccati(dot)com>
2010-11-22 05:08:59 from Rob Wultsch <wultsch(at)gmail(dot)com>
2010-05-23 16:33:34 from Matteo Beccati <php(at)beccati(dot)com>
2010-06-07 14:35:48 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-06-07 16:21:37 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-12 16:38:00 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-01-12 16:54:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-01-12 17:34:45 from Dave Page <dpage(at)pgadmin(dot)org>
2010-01-12 18:54:27 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-12 19:58:09 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-12 17:38:13 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2010-01-12 09:33:46 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-11 10:18:47 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-11 11:53:08 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-11 11:58:20 from Dave Page <dpage(at)pgadmin(dot)org>
2010-01-11 13:13:47 from Matteo Beccati <php(at)beccati(dot)com>
2010-01-11 13:24:58 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-01-11 13:35:07 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-01-11 14:20:19 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-01-10 01:15:23 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Lists:
pgsql-hackers pgsql-www
Il 14/01/2010 14:39, Dimitri Fontaine ha scritto:
> Matteo Beccati<php(at)beccati(dot)com> writes:
>> I've extended AOX with a trigger that takes care of filling a separate table
>> that's used to display the index pages. The new table also stores threading
>> information (standard headers + Exchange headers support) and whether or not
>> the email has attachments.
>>
>> Please check the updated PoC: http://archives.beccati.org/
>
> Looks pretty good, even if some thread are still separated (this one for
> example), and the ordering looks strange.
This one is separated as the first one is not in the archive yet, thus
to the system there are multiple parent messages. It shouldn't happen
with full archives. About sorting, here's the query I've used (my first
try with CTEs incidentally):
WITH RECURSIVE t (mailbox, uid, date, subject, sender, has_attachments,
parent_uid, idx, depth) AS (
SELECT mailbox, uid, date, subject, sender, has_attachments,
parent_uid, uid::text, 1
FROM arc_messages
WHERE parent_uid IS NULL AND mailbox = 15
UNION ALL
SELECT a.mailbox, a.uid, a.date, a.subject, a.sender,
a.has_attachments, a.parent_uid, t.idx || '.' || a.uid::text, t.depth + 1
FROM t JOIN arc_messages a USING (mailbox)
WHERE t.uid = a.parent_uid
) SELECT * FROM t ORDER BY idx
Any improvements to sorting are welcome :)
Cheers
--
Matteo Beccati
Development & Consulting - http://www.beccati.com/
In response to
Responses
pgsql-www by date
Next :From: Matteo BeccatiDate: 2010-01-14 14:32:13Subject : Re: mailing list archiver chewing patchesPrevious :From : webmasterDate : 2010-01-14 14:00:00Subject : PostgreSQL moderation report: 2010-1-14
pgsql-hackers by date
Next :From: Heikki LinnakangasDate: 2010-01-14 14:15:14Subject : Streaming replication, retrying from archivePrevious :From : Dimitri FontaineDate : 2010-01-14 13:51:37Subject : Re: patch to implement ECPG side tracing / tracking ...
