From mboxrd@z Thu Jan 1 00:00:00 1970 X-Msuck: nntp://news.gmane.io/gmane.emacs.gnus.general/25857 Path: main.gmane.org!not-for-mail From: Eric Marsden Newsgroups: gmane.emacs.gnus.general Subject: Re: storing messages in DBMSes (Was: Attaching notes to messages) Date: 12 Oct 1999 13:16:00 +0200 Organization: LAAS-CNRS http://www.laas.fr/ Sender: owner-ding@hpc.uh.edu Message-ID: References: <87iu4ffek7.fsf@senstation.vvf.fi> NNTP-Posting-Host: coloc-standby.netfonds.no Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Trace: main.gmane.org 1035163170 16291 80.91.224.250 (21 Oct 2002 01:19:30 GMT) X-Complaints-To: usenet@main.gmane.org NNTP-Posting-Date: Mon, 21 Oct 2002 01:19:30 +0000 (UTC) Return-Path: Original-Received: from spinoza.math.uh.edu (spinoza.math.uh.edu [129.7.128.18]) by sclp3.sclp.com (8.8.5/8.8.5) with ESMTP id HAA26007 for ; Tue, 12 Oct 1999 07:18:12 -0400 (EDT) Original-Received: from sina.hpc.uh.edu (lists@Sina.HPC.UH.EDU [129.7.3.5]) by spinoza.math.uh.edu (8.9.1/8.9.1) with ESMTP id GAB12054; Tue, 12 Oct 1999 06:17:51 -0500 (CDT) Original-Received: by sina.hpc.uh.edu (TLB v0.09a (1.20 tibbs 1996/10/09 22:03:07)); Tue, 12 Oct 1999 06:18:14 -0500 (CDT) Original-Received: from sclp3.sclp.com (root@sclp3.sclp.com [204.252.123.139]) by sina.hpc.uh.edu (8.9.3/8.9.3) with ESMTP id GAA05632 for ; Tue, 12 Oct 1999 06:18:03 -0500 (CDT) Original-Received: from laas.laas.fr (root@laas.laas.fr [140.93.0.15]) by sclp3.sclp.com (8.8.5/8.8.5) with ESMTP id HAA25998 for ; Tue, 12 Oct 1999 07:16:07 -0400 (EDT) Original-Received: from dukas.laas.fr (dukas [140.93.21.58]) by laas.laas.fr (8.9.3/8.9.3) with ESMTP id NAA09629 for ; Tue, 12 Oct 1999 13:16:02 +0200 (MET DST) Original-Received: (from emarsden@localhost) by dukas.laas.fr (8.9.3/8.9.3) id NAA12821; Tue, 12 Oct 1999 13:16:01 +0200 (MET DST) Original-To: ding@gnus.org X-Eric-Conspiracy: there is no conspiracy X-Attribution: ecm X-URL: http://www.chez.com/emarsden/ In-Reply-To: Steinar Bang's message of "12 Oct 1999 10:18:49 +0200" Original-Lines: 24 X-Mailer: Gnus v5.7/Emacs 20.4 Precedence: list X-Majordomo: 1.94.jlt7 Xref: main.gmane.org gmane.emacs.gnus.general:25857 X-Report-Spam: http://spam.gmane.org/gmane.emacs.gnus.general:25857 >>>>> "sb" == Steinar Bang writes: sb> Ah! This is only the elisp interface to Postgres. Presumable the sb> nnpg backend doesn't exist yet. indeed. Just hoping to inspire someone to write it :-) sb> But that makes me wonder: with the scaling problems all folders sb> seem to have, has anyone ever thought about using database sb> systems to store the messages themselves? I'm not very familiar with how Gnus backends work, but I doubt that it would be worth trying to store messages directly in a DBMS. PostgreSQL at least can only store 8k-long text fields; anything longer needs to go in a BLOB. Standard filesystems are probably good enough for this (for example, qmail gets very high performance for its message queue from standard filesystems), but maybe SQL would be useful for overview files. -- Eric Marsden It's elephants all the way down