Hi,
Yes, you are right. The table is the biggest one . Please find below the
information you requested. I agree the fact that autovacuum ran on this
table would fix the performance issue on standby does not sound very
convincing. But that is the only thing I could correlate when the query on
Table statistics I sent before were from primary. Following are from standby.
Index Tuples Fetched25910277
Tuples Inserted 0
Tuples Updated 0
Tuples Deleted 0
Tuples HOT Updated 0
Live Tuples 0
Dead Tuples 0
Heap Blocks Read
I've been working on trying to normalize a table that's got a bunch of text
fields. Normalizing the first 4 has been a non-issue. But when I try and
normalize 2 additional fields a bunch of query plans go belly-up.
I've seen this on our old 8.4 databases as well as 9.1. I haven't been able to
Jim Nasby jna...@enova.com writes:
I've been working on trying to normalize a table that's got a bunch of text
fields. Normalizing the first 4 has been a non-issue. But when I try and
normalize 2 additional fields a bunch of query plans go belly-up.
Try increasing
On 10/28/13 6:13 PM, Tom Lane wrote:
Jim Nasby jna...@enova.com writes:
I've been working on trying to normalize a table that's got a bunch of text
fields. Normalizing the first 4 has been a non-issue. But when I try and
normalize 2 additional fields a bunch of query plans go belly-up.
Try