X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1191D5E3632 for ; Fri, 27 Aug 2004 03:27:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71267-08 for ; Fri, 27 Aug 2004 06:27:18 +0000 (GMT) Received: from web54106.mail.yahoo.com (web54106.mail.yahoo.com [206.190.37.241]) by svr1.postgresql.org (Postfix) with SMTP id 66FAC5E3631 for ; Fri, 27 Aug 2004 03:27:16 -0300 (ADT) Message-ID: <20040827062716.4092.qmail@web54106.mail.yahoo.com> Received: from [129.94.6.30] by web54106.mail.yahoo.com via HTTP; Thu, 26 Aug 2004 23:27:16 PDT Date: Thu, 26 Aug 2004 23:27:16 -0700 (PDT) From: my ho Subject: Re: postgresql performance with multimedia To: Jan Wieck Cc: pgsql-performance@postgresql.org In-Reply-To: <412C71F1.4030902@Yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/384 X-Sequence-Number: 8020 Hi, > For your "streaming" purposes I strongly recommend > you do it in your > application with the appropriate thread model. A > relational database > management system is not a multimedia cache. That's actually what i plan to do with postgreSQL, maybe tailor it to suit with a multimedia streaming database. Well, i could do it in the application level but i think it's also worth a try with the database itself. > They are only stored in that way on initial load and > if the load is done > with a single process. And don't you rely on this > for the future. Right > now, if you ever update or delete tuples, that order > changes already. does the buffer manager have any idea what table that buf belongs to? (can we add 'rel' variable to sbufdesc in buf_internals.h and update it everytime we add new entry to the buffer cahe?) And then we take in to account which relation the data in the buffer belongs to in the buf replacement algorithm or in the read-ahead policy. > Also keep in mind that large values are not stored > inline, but in an > extra "TOAST" relation. This is how i store my video file: break them in to small chunks and store each part in a row of a table. regards, MThi __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail