Re: mailing list archiver chewing patches

From: Matteo Beccati <php(at)beccati(dot)com>
To: David Fetter <david(at)fetter(dot)org>
Cc: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, 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-15 19:38:50
Message-ID: 4B50C44A.101@beccati.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-www

Hi everyone,

Il 14/01/2010 19:36, David Fetter ha scritto:
> On Thu, Jan 14, 2010 at 03:08:22PM +0100, Matteo Beccati wrote:
>> Il 14/01/2010 14:39, Dimitri Fontaine ha scritto:
>>> Matteo Beccati<php(at)beccati(dot)com> writes:>
>> Any improvements to sorting are welcome :)
>
> ...
> ARRAY[uid]
> ...

Thanks David, using an array rather than text concatenation is slightly
slower and uses a bit more memory, but you've been able to convince me
that it's The Right Way(TM) ;)

Anyway, I've made further changes and I would say that at this point the
PoC is feature complete. There surely are still some rough edges and a
few things to clean up, but I'd like to get your feedback once again:

http://archives.beccati.org

You will find that pgsql-general and -hackers are subscribed and getting
messages live, wihle -hackers-history and -www have been imported from
the archives (about 200k and 1.5k messages respectively at 50 messages/s).

Also, I'd need some help with the CTE query that was picking a wrong
plan and led me to forcibly disable merge joins inside the application
when executing it. Plans are attached.

Cheers
--
Matteo Beccati

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

Attachment Content-Type Size
cte-mergejoin.txt text/plain 2.4 KB
cte-index.txt text/plain 2.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2010-01-15 19:48:20 Re: Streaming replication and non-blocking I/O
Previous Message Andrew Dunstan 2010-01-15 19:18:14 Re: Testing with concurrent sessions

Browse pgsql-www by date

  From Date Subject
Next Message Dimitri Fontaine 2010-01-16 10:48:50 Re: mailing list archiver chewing patches
Previous Message David Fetter 2010-01-14 18:36:09 Re: mailing list archiver chewing patches