[PERFORM] postgresql recommendation memory

2013-11-02 Thread Евгений Селявка
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

Re: [PERFORM] Hot Standby performance issue

2013-11-02 Thread Tomas Vondra
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 Tuples

Re: [PERFORM] Hot Standby performance issue

2013-11-02 Thread Tomas Vondra
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