Re: [GENERAL] vacuum and postgresql.conf settings

2007-06-15 Thread Alvaro Herrera
Walter Vaughan wrote: > Francisco Reyes wrote: > > >Walter Vaughan writes: > >>I am not even sure this is a problem. > >>INFO: "data_import_customer2": scanned 3000 of 5033 pages, containing > >>84905 live rows and 0 dead rows; 3000 rows in sample, 142442 estimated > >>total rows > > > >I don't

Re: [GENERAL] vacuum and postgresql.conf settings

2007-06-15 Thread Francisco Reyes
Walter Vaughan writes: Well, why did it only scan 3000 pages out of 5033? It decided it didn't need to? It took a sample and decided it was gonna be okay? I don't know. Hopefully others with more knowledge can answer. I think it could be because the pages did not need to be looked at. Perhap

Re: [GENERAL] vacuum and postgresql.conf settings

2007-06-15 Thread Walter Vaughan
Francisco Reyes wrote: Walter Vaughan writes: I am not even sure this is a problem. INFO: "data_import_customer2": scanned 3000 of 5033 pages, containing 84905 live rows and 0 dead rows; 3000 rows in sample, 142442 estimated total rows I don't believe it is a problem. I think it is just no

Re: [GENERAL] vacuum and postgresql.conf settings

2007-06-15 Thread Francisco Reyes
Walter Vaughan writes: I am not even sure this is a problem. INFO: "data_import_customer2": scanned 3000 of 5033 pages, containing 84905 live rows and 0 dead rows; 3000 rows in sample, 142442 estimated total rows I don't believe it is a problem. I think it is just normal output of the vacuum