Re: mailing list archiver chewing patches

Matteo Beccati <php@beccati.com>

From: Matteo Beccati <php@beccati.com>

To: David Fetter <david@fetter.org>

Cc: Dimitri Fontaine <dfontaine@hi-media.com>, Aidan Van Dyk <aidan@highrise.ca>, Magnus Hagander <magnus@hagander.net>, Dave Page <dpage@pgadmin.org>, Abhijit Menon-Sen <ams@toroid.org>, Alvaro Herrera <alvherre@commandprompt.com>, Andrew Dunstan <andrew@dunslane.net>, Tim Bunce <Tim.Bunce@pobox.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2010-01-15T19:38:50Z

Lists: pgsql-hackers

Attachments

cte-mergejoin.txt (text/plain)
cte-index.txt (text/plain)

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@beccati.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/