| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | Vivek Khera <khera(at)kcilink(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_restore takes ages |
| Date: | 2003-10-03 19:28:55 |
| Message-ID: | 20031003192854.GA4666@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Oct 03, 2003 at 01:06:26PM -0600, scott.marlowe wrote:
> also, turning off fsync during the load helps a lot. Be sure to turn it
> back on when you're done of course.
I'm not sure I understand why this is so. If I turn fsync off, it means
that I won't force the kernel to write WAL logs to disk, but they will
have to be written eventually. If you have tons of RAM it may well be
that the kernel will just keep dirty buffers in RAM, but if not there
should not be any difference. Am I missing something?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Investigación es lo que hago cuando no sé lo que estoy haciendo"
(Wernher von Braun)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Network Administrator | 2003-10-03 19:37:47 | Re: online vs. hot backup (was Re: Type of application that use PostgreSQL) |
| Previous Message | scott.marlowe | 2003-10-03 19:13:51 | Re: Postgres low end processing. |