X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8D62D9DCB32 for ; Mon, 6 Feb 2006 04:37:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07766-07 for ; Mon, 6 Feb 2006 04:37:13 -0400 (AST) X-Greylist: delayed 00:06:37.769896 by SQLgrey- Received: from correo6.acens.net (correo6.acens.net [217.116.0.39]) by postgresql.org (Postfix) with ESMTP id EC6DA9DCB65 for ; Mon, 6 Feb 2006 04:37:09 -0400 (AST) Received: (qmail 13478 invoked from network); 6 Feb 2006 08:28:07 -0000 Received: from unknown (HELO albert.sedifa.com) ([83.175.220.10]) (envelope-sender ) by correo6.acens.net (qmail-ldap-1.03) with SMTP for ; 6 Feb 2006 08:28:07 -0000 From: Albert Cervera Areny Organization: Sedifa, S.L. To: pgsql-performance@postgresql.org Subject: Re: Storing Digital Video Date: Mon, 6 Feb 2006 09:30:30 +0100 User-Agent: KMail/1.7.2 References: <3cf983d0601311632t4a2f068au1f958746c2b092a7@mail.gmail.com> In-Reply-To: <3cf983d0601311632t4a2f068au1f958746c2b092a7@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200602060930.31144.albert@sedifa.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/46 X-Sequence-Number: 17032 A Dimecres 01 Febrer 2006 01:32, Rodrigo Madera va escriure: > I am concerned with performance issues involving the storage of DV on > a database. > > I though of some options, which would be the most advised for speed? > > 1) Pack N frames inside a "container" and store the container to the db. > 2) Store each frame in a separate record in the table "frames". > 3) (type something here) > > Thanks for the help, What if you store meta data in the database and use some PL/Python/Java/Perl functions to store and retrieve video files from the server. The function would store files to the files system, not a table. This avoids the need for a file server for your application while making your relational queries fast. Any experiences/thoughts on this solution? > > Rodrigo > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match