Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9BD309FA103 for ; Fri, 8 Dec 2006 00:04:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 01752-10 for ; Fri, 8 Dec 2006 00:04:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 8CAC99F9357 for ; Fri, 8 Dec 2006 00:04:04 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id A382B30E02; Fri, 8 Dec 2006 05:04:03 +0100 (MET) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: One table is very slow, but replicated table (same data) is fine Date: Thu, 07 Dec 2006 22:33:07 -0500 Organization: cbbrowne Computing Inc Lines: 18 Message-ID: <60lklj6ozw.fsf@dba2.int.libertyrms.com> References: <1165505252.399576.88120@j72g2000cwa.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:i9CUHEgfT2kFOc0XaTkGsPU9jVQ= To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/186 X-Sequence-Number: 22242 arthurbellis@gmail.com writes: > If anyone knows what may cause this problem, or has any other ideas, I > would be grateful. Submit the command "VACUUM ANALYZE VERBOSE locations;" on both servers, and post the output of that. That might help us tell for sure whether the table is bloated (and needs VACUUM FULL/CLUSTER). The query plans are suggestive; on the 'master', the cost is 113921.40, whereas on the 'slave' it's 2185.09; I'll bet that those numbers are proportional to the number of pages assigned to the table on the respective servers... -- (reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc")) http://cbbrowne.com/info/lsf.html "We use Linux for all our mission-critical applications. Having the source code means that we are not held hostage by anyone's support department." -- Russell Nelson, President of Crynwr Software