Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow sequential scans on one DB but not another; fragmentation? - Mailing list pgsql-general

From Tom Lane
Subject Re: Slow sequential scans on one DB but not another; fragmentation?
Date
Msg-id 24968.1175094474@sss.pgh.pa.us
Whole thread Raw
In response to Slow sequential scans on one DB but not another; fragmentation?  (Stephen Harris <lists@spuddy.org>)
Responses Re: Slow sequential scans on one DB but not another; fragmentation?  (Stephen Harris <lists@spuddy.org>)
List pgsql-general
Tree view 
Stephen Harris <lists@spuddy.org> writes:
> I have one specific table ("sweep_users") that has 900,000 rows in prod
> and 630,000 on the standby.  On the standby a "select count(*) from
> sweep_users" takes a couple of seconds.  On production it takes... 240
> seconds!

Lots of dead rows/free space perhaps?  What does VACUUM VERBOSE have to
say about this table on each machine?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: unexpected data beyond EOF and character encoding
Next
From: Jaime Silvela
Date:
Subject: Re: unexpected data beyond EOF and character encoding