From:
Matteo Beccati <php(at)beccati(dot)com>
To:
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
Cc:
David Fetter <david(at)fetter(dot)org>, 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-16 13:21:58
Message-ID:
4B51BD76.9060500@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 16/01/2010 11:48, Dimitri Fontaine ha scritto:
> Matteo Beccati<php(at)beccati(dot)com> writes:
>> 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
>
> I've been clicking around and like the speedy feeling and the Thread
> index appearing under any mail. Also getting the attachments seems to be
> just working™. I've also checked than this "local thread" works on month
> boundaries, so that you're POC is in a way already better than the
> current archives solution.
Thanks for the feedback.
> Only missing is the search, but we have tsearch and pg_trgm masters not
> far away…
I haven't even looked at it as I was under the impression that the old
engine could still be used. If not, adding search support should be
fairly easy.
>> 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).
>
> Tried clicking over there and very far in the past indexes show no
> messages. Here's an example:
>
> http://archives.beccati.org/pgsql-hackers-history/1996-09/by/thread
Yeah, there are a few messages in the archives with a wrong date header.
The list is generated using from min(date) to now(), so there are holes.
At some point I'll run a few queries to fix that.
>> 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.
>
> Sorry, not from me, still a CTE noob.
Actually the live db doesn't suffer from that problem anymore, but I've
able to reproduce the issue with a few days old backup running on a test
8.5alpha3 instance that still has a stock postgresql.conf.
Cheers
--
Matteo Beccati
Development & Consulting - http://www.beccati.com/
In response to
Responses
pgsql-www by date
Next :From: webmasterDate: 2010-01-18 14:00:01Subject : PostgreSQL moderation report: 2010-1-18Previous :From : Dimitri FontaineDate : 2010-01-16 10:48:50Subject : Re: mailing list archiver chewing patches
pgsql-hackers by date
Next :From: Robert HaasDate: 2010-01-16 13:28:48Subject : Re: Archive recovery crashes on win32 in HEAD - hot standby related?Previous :From : Euler Taveira de OliveiraDate : 2010-01-16 13:21:24Subject : Re: Streaming replication and non-blocking I/O
