Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

2008/1/16, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> 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