Hi, Andrzej, Andrzej Zawadzki wrote: > After upgrade PostgreSQL from 8.0 to 8.1.4 a VACUUM FULL ANALYZE > process is much slower, from logs: > > 8.0 > [13666][postgres][2006-10-06 01:13:38 CEST][1340121452] LOG: statement: VACUUM FULL ANALYZE; > [13666][postgres][2006-10-06 01:39:15 CEST][0] LOG: duration: 1536862.425 ms > > > 8.1 > [4535][postgres][2006-10-10 01:08:51 CEST][6144112] LOG: statement: VACUUM FULL ANALYZE; > [4535][postgres][2006-10-10 02:04:23 CEST][0] LOG: duration: 3332128.332 ms > > Databases are equal. Are they on equal disks? And in the same areas of those disks? Some current disks tend to drop down their speed at the "end" of the LBA address space drastically. HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org
