2008/1/16, Tom Lane <tgl@xxxxxxxxxxxxx>: > I went through this thread again, and noticed something that no one > seems to have remarked on at the time: the vmstat numbers near the > bottom of this post > > http://archives.postgresql.org/pgsql-general/2008-01/msg00161.php This post is from january 5. > show close to 100% I/O wait time (either that or 50% idle 50% I/O wait, > which I suspect is an artifact). We subsequently concluded that the > "SELECT" side of the INSERT/SELECT command is not where the problem is, > so all the cycles are going into the actual row insertion part. > > I don't know of any reason to think that insertion is slower in 8.3 > than it was in 8.2, and no one else has reported anything of the sort. > So I'm leaning to the idea that this suggests some kind of > misconfiguration of the disk setup in Clodoaldo's new server. There > was some earlier discussion about not having the RAID configured right: > > http://archives.postgresql.org/pgsql-general/2008-01/msg00169.php This post is from january 6. So the raid problem was presumed fixed after those vmsat numbers I posted. > I'm thinking it's still not right : I will test both 8.2 and 8.3 again in the old box which is now retired and don't have the raid factor. Regards, Clodoaldo Pinto Neto ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster