| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Gordan Bobic <gordan(at)freeuk(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: MySQL and PostgreSQL speed compare |
| Date: | 2000-12-29 16:59:14 |
| Message-ID: | Pine.LNX.4.30.0012291753540.822-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Gordan Bobic writes:
> > Actually, if he ran Postgresql with WAL enabled, fsync shouldn't
> > make much of a difference.
>
> What's WAL?
Write Ahead Logging
It's a system that writes anything that it wants to do to the database to
a log file first and if the system crashes before the data is in the
database proper then it will replay the log on restart. (I guess you
could think of it as similar to a journalling file system.) That means
that fsync is never necessary on actual data files, only on the log files,
which are much smaller.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas T. Thai | 2000-12-29 17:05:18 | can't post |
| Previous Message | Frank Joerdens | 2000-12-29 16:45:30 | Re: SV: MySQL and PostgreSQL speed compare |