Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 968D72E018E for ; Wed, 9 Jan 2008 17:00:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 05363-01 for ; Wed, 9 Jan 2008 17:00:45 -0400 (AST) Received: from outmail136007.authsmtp.co.uk (outmail136007.authsmtp.co.uk [62.13.136.7]) by postgresql.org (Postfix) with ESMTP id 3DF262E00D7 for ; Wed, 9 Jan 2008 17:00:49 -0400 (AST) Received: from outmail128185.authsmtp.co.uk (outmail128185.authsmtp.co.uk [62.13.128.185]) by punt3.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m09L0jcU018070; Wed, 9 Jan 2008 21:00:45 GMT Received: from [192.168.0.3] (81-6-228-215.dyn.gotadsl.co.uk [81.6.228.215]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id m09L0hsP026186; Wed, 9 Jan 2008 21:00:44 GMT Subject: Re: big database performance From: Simon Riggs To: Adrian Moisey Cc: pgsql-performance@postgresql.org In-Reply-To: <4784835A.8070604@careerjunction.co.za> References: <4784835A.8070604@careerjunction.co.za> Content-Type: text/plain Date: Wed, 09 Jan 2008 21:01:18 +0000 Message-Id: <1199912478.4266.530.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: f19d242a-bef5-11dc-9554-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaAxbZ1hf HGQLW1xEUlx7WWN/ bw4fZQRDZFRMXQ10 UklMXVBXCwUmXBwI eh5GEXlydQNHcHg+ bUdgECZaVRB4cUQs XxwBQ2gbZGY0O30W VUVcagNUcQJCe0tG bVcsBT1vNG8XDRoV JSEUBRUEdT9eJ2xZ Sx0EJ1sJTA4TEyQy QAoHFDMkECVf X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:787/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/48 X-Sequence-Number: 28287 On Wed, 2008-01-09 at 10:18 +0200, Adrian Moisey wrote: > We recently converted to postgres (from mssql) and we're having > performance issues. I think you need to say more about what the performance issues actually are, otherwise everybody will just speculate you to death. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com