[ADMIN] Does pg_reset_stats() influence autovacuum?

2012-08-23 Thread Kouber Saparev
Hello, Does resetting of stats through pg_reset_stats() influence the way autovacuum determines whether autovacuum_vacuum_scale_factor and autovacuum_analyze_scale_factor settings are reached? In other words, are the n_live_tup and n_dead_tup values kept somewhere internally, apart

Re: [ADMIN] Does pg_reset_stats() influence autovacuum?

2012-08-23 Thread Bruce Momjian
On Thu, Aug 23, 2012 at 10:59:56AM +0300, Kouber Saparev wrote: Hello, Does resetting of stats through pg_reset_stats() influence the way autovacuum determines whether autovacuum_vacuum_scale_factor and autovacuum_analyze_scale_factor settings are reached? In other words, are the

[ADMIN] Canot access PostgreSQL via psql -h (Vmware Fusion)

2012-08-23 Thread CS DBA
Hi all; I've fired up 2 CentOS 6.2 VM's via vmware fusion 5 (on a mac). I disables selinux on both, and installed postgres 8.4.13 on both VM's I set listen_addresses = '*' and I added a trust entry for each server in the opposite server's pg_hba.conf file. However I cannot access one server

Re: [ADMIN] Canot access PostgreSQL via psql -h (Vmware Fusion)

2012-08-23 Thread Andreas Schmitz
Hi, are there any firewalls up (check iptabled) ? try running telnet 192.168.91.145 5432 what is happening ? regards, Andreas On 08/24/2012 06:15 AM, CS DBA wrote: Hi all; I've fired up 2 CentOS 6.2 VM's via vmware fusion 5 (on a mac). I disables selinux on both, and installed postgres