Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 61E22B5D91F for ; Sun, 24 Jul 2011 00:44:38 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 14566-09 for ; Sun, 24 Jul 2011 03:44:31 +0000 (UTC) X-Greylist: delayed 03:09:19.063656 by SQLgrey-1.7.6 Received: from mailgate.caprica.metux.de (caprica.metux.de [82.165.128.25]) by mail.postgresql.org (Postfix) with ESMTP id BD0E6B5D8C5 for ; Sun, 24 Jul 2011 00:44:30 -0300 (ADT) Received: from mailgate.caprica.metux.de (localhost.localdomain [127.0.0.1]) by mailgate.caprica.metux.de (8.14.4/8.14.4) with ESMTP id p6O0M3pf031741 for ; Sun, 24 Jul 2011 02:26:33 +0200 Received: (from uucp@localhost) by mailgate.caprica.metux.de (8.14.4/8.14.4/Submit) with UUCP id p6NN9oS0028983 for pgsql-general@postgresql.org; Sun, 24 Jul 2011 01:09:51 +0200 Received: (from weigelt@localhost) by nibiru.metux.de (8.12.10/8.12.10) id p4U7do9Q029438 for pgsql-general@postgresql.org; Mon, 30 May 2011 09:39:50 +0200 Date: Mon, 30 May 2011 09:39:50 +0200 From: Enrico Weigelt To: pgsql-general@postgresql.org Subject: Re: [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way? Message-ID: <20110530073950.GA27187@nibiru.local> Reply-To: weigelt@metux.de Mail-Followup-To: pgsql-general@postgresql.org References: <482E80323A35A54498B8B70FF2B87980049413B5EB@azsmsx504.amr.corp.intel.com> <482E80323A35A54498B8B70FF2B87980049413B673@azsmsx504.amr.corp.intel.com> <4DDEC3B1.2050008@boscorama.com> <4DDFCD7A.8030902@encs.concordia.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4DDFCD7A.8030902@encs.concordia.ca> User-Agent: Mutt/1.4.1i X-Terror: bin laden, kill bush, Briefbombe, Massenvernichtung, KZ, X-Nazi: Weisse Rasse, Hitlers Wiederauferstehung, 42, X-Antichrist: weg mit schaeuble, ausrotten, heiliger krieg, al quaida, X-Killer: 23, endloesung, Weltuntergang, X-Doof: wer das liest ist doof X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.312 tagged_above=-5 required=5 tests=BAYES_00=-1.9, DATE_IN_PAST_96_XX=3.405, RP_MATCHES_RCVD=-1.193 X-Spam-Level: X-Archive-Number: 201107/649 X-Sequence-Number: 178028 * Emi Lu wrote: > Solution: > ==================== > (1) Save pdfs to file system, only point file name in psql8.3 > > (2) Save oids of pdfs into table > > (3) Save pdf files as bytea column in psql8.3 (4) Put them into an object store, eg. venti. cu -- ---------------------------------------------------------------------- Enrico Weigelt, metux IT service -- http://www.metux.de/ phone: +49 36207 519931 email: weigelt@metux.de mobile: +49 151 27565287 icq: 210169427 skype: nekrad666 ---------------------------------------------------------------------- Embedded-Linux / Portierung / Opensource-QM / Verteilte Systeme ----------------------------------------------------------------------