| From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
|---|---|
| To: | Hannu Krosing <hannu(at)tm(dot)ee> |
| Cc: | Greg Spiegelberg <gspiegelberg(at)cranel(dot)com>, '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:59:08 |
| Message-ID: | 4003EB9C.30406@potentialtech.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hannu Krosing wrote:
> 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.
http://www.potentialtech.com/wmoran/postgresql.php
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Spiegelberg | 2004-01-13 15:04:20 | Re: failures on machines using jfs |
| Previous Message | Hannu Krosing | 2004-01-13 12:46:08 | Re: failures on machines using jfs |