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

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: cte-index.txt
Description: text/plain (2.2 KB)
Attachment: cte-mergejoin.txt
Description: text/plain (2.4 KB)

In response to

Responses

pgsql-www by date

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

pgsql-hackers by date

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

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