| From: | "Alex Deucher" <alexdeucher(at)gmail(dot)com> |
|---|---|
| To: | "Guido Neitzer" <lists(at)event-s(dot)net> |
| Cc: | "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: strange performance regression between 7.4 and 8.1 |
| Date: | 2007-03-06 02:56:24 |
| Message-ID: | a728f9f90703051856s2562f4a4g2fd0ba59f3b97609@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 3/5/07, Guido Neitzer <lists(at)event-s(dot)net> wrote:
> On 01.03.2007, at 13:40, Alex Deucher wrote:
>
> > I read several places that the SAN might be to blame, but
> > testing with bonnie and dd indicates that the SAN is actually almost
> > twice as fast as the scsi discs in the old sun server. I've tried
> > adjusting just about every option in the postgres config file, but
> > performance remains the same. Any ideas?
>
> As mentioned last week:
>
> Did you actually try to use the local drives for speed testing? It
> might be that the SAN introduces latency especially for random access
> you don't see on local drives.
Yes, I started setting that up this afternoon. I'm going to test that
tomorrow and post the results.
Alex
>
> cug
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guido Neitzer | 2007-03-06 02:58:29 | Re: strange performance regression between 7.4 and 8.1 |
| Previous Message | Bruce Momjian | 2007-03-06 02:22:21 | Re: Estimate the size of the SQL file generated by pg_dump utility |