| From: | PFC <lists(at)boutiquenumerique(dot)com> |
|---|---|
| To: | Mage <mage(at)mage(dot)hu>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ext3 |
| Date: | 2005-01-17 21:05:24 |
| Message-ID: | opskrl7arwth1vuj@musicbox |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Gabor Szima asked us to translate the letter below.
>
> "I read that ext3 writeback mode is recommended for PostgreSQL. I made
> some tests.
>
> data=ordered data=writeback
> ----------------------------------------------------------------------
> restoredb: 2m16.790s 1m42.367s
> UPDATE <tbl1> (17krows): 9.289s 7.147s
> UPDATE <tbl1> (17krows) (2.): 10.480s 3.778s
> VACUUM ANALYZE <tbl1>: 9.364s 0.986s !
> VACUUM FULL <tbl1>: 16.071s 2.575s
> REINDEX TABLE <tbl1>: 3.815s 1.886s
> ----------------------------------------------------------------------
Hum. You might as well run it with fsync disabled for that extra thrill ;)
You could try the same with reiserfs (hint, hint).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John DeSoi | 2005-01-17 21:32:14 | Re: Statically linking against libpq |
| Previous Message | PFC | 2005-01-17 21:01:43 | Re: PostgreSQL 8 on windows very slow |