Re: [GENERAL] Auto-analyse on insert operations

2015-11-06 Thread Adrian Klaver
On 11/06/2015 09:13 AM, Bertrand Roos wrote: Le 04/11/2015 16:57, Adrian Klaver a écrit : On 11/04/2015 07:43 AM, Bertrand Roos wrote: Le 04/11/2015 14:55, Bill Moran a écrit : On Wed, 4 Nov 2015 14:32:37 +0100 Bertrand Roos wrote: I try to configure auto-analyse

Re: [GENERAL] Auto-analyse on insert operations

2015-11-06 Thread Bertrand Roos
Le 04/11/2015 16:57, Adrian Klaver a écrit : On 11/04/2015 07:43 AM, Bertrand Roos wrote: Le 04/11/2015 14:55, Bill Moran a écrit : On Wed, 4 Nov 2015 14:32:37 +0100 Bertrand Roos wrote: I try to configure auto-analyse task with postgresql 9.4. I have the

Re: [GENERAL] Auto-analyse on insert operations

2015-11-04 Thread Bertrand Roos
Le 04/11/2015 14:45, Adrian Klaver a écrit : On 11/04/2015 05:32 AM, Bertrand Roos wrote: Hello, I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration): track_counts = on autovacuum = on log_autovacuum_min_duration = -1

Re: [GENERAL] Auto-analyse on insert operations

2015-11-04 Thread Adrian Klaver
On 11/04/2015 06:35 AM, Bertrand Roos wrote: Le 04/11/2015 14:45, Adrian Klaver a écrit : On 11/04/2015 05:32 AM, Bertrand Roos wrote: Hello, I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration): track_counts = on autovacuum = on

Re: [GENERAL] Auto-analyse on insert operations

2015-11-04 Thread Bill Moran
On Wed, 4 Nov 2015 14:32:37 +0100 Bertrand Roos wrote: > > I try to configure auto-analyse task with postgresql 9.4. > I have the following configuration (default configuration): > track_counts = on > autovacuum = on > log_autovacuum_min_duration = -1 >

[GENERAL] Auto-analyse on insert operations

2015-11-04 Thread Bertrand Roos
Hello, I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration): track_counts = on autovacuum = on log_autovacuum_min_duration = -1 autovacuum_max_workers = 3 autovacuum_naptime = 300s autovacuum_vacuum_threshold = 50

Re: [GENERAL] Auto-analyse on insert operations

2015-11-04 Thread Adrian Klaver
On 11/04/2015 05:32 AM, Bertrand Roos wrote: Hello, I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration): track_counts = on autovacuum = on log_autovacuum_min_duration = -1 autovacuum_max_workers = 3 autovacuum_naptime = 300s

Re: [GENERAL] Auto-analyse on insert operations

2015-11-04 Thread Bertrand Roos
Le 04/11/2015 14:55, Bill Moran a écrit : On Wed, 4 Nov 2015 14:32:37 +0100 Bertrand Roos wrote: I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration): track_counts = on autovacuum = on

Re: [GENERAL] Auto-analyse on insert operations

2015-11-04 Thread Adrian Klaver
On 11/04/2015 07:43 AM, Bertrand Roos wrote: Le 04/11/2015 14:55, Bill Moran a écrit : On Wed, 4 Nov 2015 14:32:37 +0100 Bertrand Roos wrote: I try to configure auto-analyse task with postgresql 9.4. I have the following configuration (default configuration):

Re: [GENERAL] Auto-analyse on insert operations

2015-11-04 Thread Tom Lane
Bertrand Roos writes: > In fact, I was telling the question because I have read on some forums > that the auto vacuum deamon only count dead tuple so only update and > delete operations can cause the scheduling of auto-analyse. That might have been true years ago, don't

Re: [GENERAL] Auto-analyse on insert operations

2015-11-04 Thread Bill Moran
On Wed, 4 Nov 2015 16:43:57 +0100 Bertrand Roos wrote: > > Le 04/11/2015 14:55, Bill Moran a écrit : > > On Wed, 4 Nov 2015 14:32:37 +0100 > > Bertrand Roos wrote: > >> I try to configure auto-analyse task with postgresql 9.4. > >> I have the