From: Chris Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: One table is very slow, but replicated table (same data) is fine
Date: Thu, 07 Dec 2006 22:33:07 -0500
Message-ID: <60lklj6ozw.fsf@dba2.int.libertyrms.com> (raw)
References: <1165505252.399576.88120@j72g2000cwa.googlegroups.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: One table is very slow, but replicated table (same data) is fine
In-Reply-To: <60lklj6ozw.fsf@dba2.int.libertyrms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox