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 046AD14B281F for ; Wed, 11 Aug 2004 11:29:52 -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 10752-05 for ; Wed, 11 Aug 2004 14:29:49 +0000 (GMT) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by svr1.postgresql.org (Postfix) with ESMTP id 7C0DD14B280B for ; Wed, 11 Aug 2004 11:29:48 -0300 (ADT) Received: from list by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1Buu6w-0007AX-00 for ; Wed, 11 Aug 2004 16:29:53 +0200 Received: from linuxnews.dk ([81.7.132.92]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 11 Aug 2004 16:29:50 +0200 Received: from jesper by linuxnews.dk with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 11 Aug 2004 16:29:50 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Jesper Krogh Subject: Storing binary data. Date: Wed, 11 Aug 2004 14:29:46 +0000 (UTC) Lines: 28 Message-ID: X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: linuxnews.dk User-Agent: slrn/0.9.8.0 (Linux) 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/154 X-Sequence-Number: 7790 Hi. Please be a bit patient.. I'm quite new to PostgreSQL. I'd like some advise on storing binary data in the database. Currently I have about 300.000 320.000 Bytes "Bytea" records in the database. It works quite well but I have a feeling that it actually is slowing the database down on queries only related to the surrounding attributes. The "common" solution, I guess would be to store them in the filesystem instead, but I like to have them just in the database it is nice clean database and application design and if I can get PostgreSQL to "not cache" them then it should be excactly as fast i assume. The binary data is not a part of most queries in the database only a few explicitly written to fetch them and they are not accessed very often. What do people normally do? Thanks, Jesper -- ./Jesper Krogh, jesper@krogh.cc Jabber ID: jesper@jabbernet.dk