Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1B8DC9FB270 for ; Wed, 31 Jan 2007 18:25:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 15472-05 for ; Wed, 31 Jan 2007 18:25:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id 3DECD9FB458 for ; Wed, 31 Jan 2007 18:25:17 -0400 (AST) Received: (qmail 26073 invoked from network); 31 Jan 2007 22:25:13 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;83c86319505433ed8ba212492e3abfef; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 31 Jan 2007 22:25:12 -0000 Received: (qmail 7141 invoked by uid 1166); 1 Feb 2007 09:25:12 +1100 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.814472 secs); 31 Jan 2007 22:25:12 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.814472 secs Process 7126) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 1 Feb 2007 09:25:08 +1100 From: "Phillip Smith" To: "'Steve Holdoway'" , Subject: Re: blobs Date: Thu, 1 Feb 2007 09:25:08 +1100 Organization: Weatherbeeta Pty Ptd Message-ID: <007201c74586$aa596cf0$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 In-Reply-To: <20070201104606.5ea9e44e.steve.holdoway@firetrust.com> Importance: Normal X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1170282312.993-26065-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.01/0.10 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/305 X-Sequence-Number: 24461 I don't know about your table question, but may I ask why you're running 32-bit when you have dual Xeon processors? I have dual Xeon's in my DWH, and I used to run 32-bit which I upgraded = to 64-bit over Christmas. We run a nightly import to that database which = used to take around 5 hours which now completes in less than 1 hour. Many of our large queries also run much faster - the only thing I did = was reload the box with RedHat ES 4 64-bit instead of 32-bit. My 2.2 cents (Aust. GST inclusive!) Cheers, -p -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Steve Holdoway Sent: Thursday, 1 February 2007 08:46 To: pgsql-admin@postgresql.org Subject: [ADMIN] blobs I'm got the enviable task of redesigning an MySQL based project from scratch. We need a proper rdbms for this project, and I want to use PG = 8.2. The table I'm concerned with at the moment have (currently) 5 million = rows, with a churn of about 300,000 rows a week. The table has about a million hits a day, which makes it the main potential bottleneck in this = database. We need to store some large ( 0 -> 100kB ) data with each row. Would you recommend adding it as columns in this table, given that blobs will be stored in the pg_largeobject table anyway, or would you recommend a = daughter table for this? Any other suggestions on how to avoid performance problems with this = table ( hardware is dual Xeon, 4GB mem, 2 hardware raid channels for storage + 1 = for logs, all running debian 32 bit ). Cheers, Steve ---------------------------(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 *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments