On 28.10.2013 21:23, sparikh wrote:
> 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
On 28.10.2013 21:57, sparikh wrote:
> Table statistics I sent before were from primary. Following are from standby.
>
> Index Tuples Fetched 25910277
> Tuples Inserted 0
> Tuples Updated0
> Tuples Deleted0
> Tuples HOT Updated0
> Live
Please help with advice!
Server
HP ProLiant BL460c G1
Architecture: x86_64
CPU op-mode(s):32-bit, 64-bit
Byte Order:Little Endian
CPU(s):8
On-line CPU(s) list: 0-7
Thread(s) per core:1
Core(s) per socket:4
CPU socket(s): 2
NUMA node(s