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 E6CAD53507 for ; Tue, 26 Apr 2005 06:36:16 -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 37606-04 for ; Tue, 26 Apr 2005 09:36:07 +0000 (GMT) Received: from smtp109.mail.sc5.yahoo.com (smtp109.mail.sc5.yahoo.com [66.163.170.7]) by svr1.postgresql.org (Postfix) with SMTP id A33DD53DE0 for ; Tue, 26 Apr 2005 06:36:05 -0300 (ADT) Received: from unknown (HELO ?192.168.2.161?) (apoc9009@84.56.236.162 with plain) by smtp109.mail.sc5.yahoo.com with SMTP; 26 Apr 2005 09:36:07 -0000 Message-ID: <426E0B35.9080509@yahoo.de> Date: Tue, 26 Apr 2005 11:34:45 +0200 From: "apoc9009@yahoo.de" Reply-To: apoc9009@yahoo.de Organization: apoc9009@yahoo.de User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: BLOB's bypassing the OS Filesystem for better Image References: <426DFA46.8090402@yahoo.de> <426E045C.7010601@archonet.com> In-Reply-To: <426E045C.7010601@archonet.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.894 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200504/694 X-Sequence-Number: 12091 > Which filesystems? I know ext2 used to have issues with many-thousands > of files in one directory, but that was a directory scanning issue > rather than file reading. From my Point of view i think it is better to let one Process do the operation to an Postgres Cluster Filestructure as if i bypass it with a second process. For example: A User loads up some JPEG Images over HTTP. a) (Filesystem) On Filesystem it would be written in a File with a random generated Filename (timestamp or what ever) (the Directory Expands and over a Million Fileobjects with will be archived, written, replaced, e.t.c) b) (Database) The JPEG Image Information will be stored into a BLOB as Part of a special Table, where is linked wit the custid of the primary Usertable. From my Point of view is any outside Process (must be created, forked, Memory allocated, e.t.c) a bad choice. I think it is generall better to Support the Postmaster in all Ways and do some Hardware RAID Configurations. >> My Question: >> Can i speedup my Webapplication if i store my JPEG Images with small >> sizes inside my PostgreSQL Database (on verry large Databasis over 1 >> GByte >> and above without Images at this time!) > > > No. Otherwise the filesystem people would build their filesystems on > top of PostgreSQL not the other way around. Of course, if you want > image updates to be part of a database transaction, then it might be > worth storing them in the database. Hmm, ORACLE is going the other Way. All File Objects can be stored into the Database if the DB has the IFS Option (Database Filesystem and Fileserver insinde the Database). > >> I hope some Peoples can give me a Tip or Hint where in can >> some usefull Information about it! > > Look into having a separate server (process or actual hardware) to > handle requests for static text and images. Keep the Java server for > actually processing Thanks