Stephen Harris <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
