| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Greg Spiegelberg <gspiegelberg(at)cranel(dot)com> |
| Cc: | "'Christopher Browne '" <cbbrowne(at)libertyrms(dot)info>, "'pgsql-performance(at)postgresql(dot)org '" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: failures on machines using jfs |
| Date: | 2004-01-13 12:46:08 |
| Message-ID: | 1073997967.2528.12.camel@fuji.krosing.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Greg Spiegelberg kirjutas E, 12.01.2004 kell 19:03:
> Hannu Krosing wrote:
> > Spiegelberg, Greg kirjutas P, 11.01.2004 kell 18:21:
> >
> >>It would seem we're experiencing somthing similiar with our scratch
> >>volume (JFS mounted with noatime).
> >
> >
> > Which files/directories do you keep on "scratch" volume ?
> >
> > All postgres files or just some (WAL, tmp) ?
>
> No Postgres files are kept in scratch only the files being loaded
> into the database via COPY or lo_import.
then the speedup does not make any sense !
Is reading from jfs filesystem also 5 times faster than reading from
ext3 ?
The only explanation I can give to filling database from jfs volume to
be so much faster could be some strange filesystem cache interactions.
----------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2004-01-13 12:59:08 | Re: failures on machines using jfs |
| Previous Message | Tom Lane | 2004-01-13 04:59:35 | Re: Ignore Some Updates |