Skip site navigation (1) Skip section navigation (2)

Re: mailing list archiver chewing patches

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 12:23:31
Message-ID: 4B4F0CC3.6030501@beccati.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-www
Il 14/01/2010 08:22, Matteo Beccati ha scritto:
> Hi,
>
>>>>> 3) A nice set of SQL queries to return message, parts, threads,
>>>>> folders based on $criteria (search, id, folder, etc)
>>>>
>>>> I guess Matteo's working on that…
>>>
>>> Right, but this is where I want to see the AOX schema "imporove"... In
>>> ways like adding persistant tables for threading, which are updated by
>>> triggers as new messages are delivered, etc. Documented queries that
>>> show how to use CTEs, ltree, etc to get threaded views, good FTS support
>>> (with indexes and triggers managing them), etc.
>>
>> +1.
>>
>> I just didn't understand how much your proposal fit into current work :)
>
> I'm looking into it. The link I've previously sent will most likely
> return a 500 error for the time being.

A quick update:

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/

pgsql-hackers and -general are currently subscribed, while -www only has 
2003 history imported via aoximport (very fast!).

BTW, I've just noticed a bug in the attachment detection giving false 
positives, but have no time to check now.


Cheers
-- 
Matteo Beccati

Development & Consulting - http://www.beccati.com/

In response to

Responses

pgsql-www by date

Next:From: Dimitri FontaineDate: 2010-01-14 13:39:44
Subject: Re: mailing list archiver chewing patches
Previous:From: Matteo BeccatiDate: 2010-01-14 07:22:29
Subject: Re: mailing list archiver chewing patches

pgsql-hackers by date

Next:From: Euler Taveira de OliveiraDate: 2010-01-14 12:29:19
Subject: Re: improving log management
Previous:From: Simon RiggsDate: 2010-01-14 12:21:07
Subject: Re: Hot Standby and query cancel

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group