| From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Vivek Khera <khera(at)kcilink(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: State of Beta 2 |
| Date: | 2003-09-23 16:39:43 |
| Message-ID: | 20030923133838.I27456@ganymede.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 23 Sep 2003, Tom Lane wrote:
> Vivek Khera <khera(at)kcilink(dot)com> writes:
> > Well, for me the create index part of the restore is what takes about
> > 3x the time for the data load. Total about 4 hours. The dump takes 1
> > hour.
>
> What sort_mem do you use for the restore? Have you tried increasing it?
I've tried restoring a >5gig database with sort_mem up to 100Meg in size,
and didn't find that it sped up the index creation enough to make a
difference ... shaved off a couple of minutes over the whole reload, so
seconds off of each index ... and that was with the WAL logs also disabled
:(
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Ayers | 2003-09-23 16:43:28 | Re: About GPL and proprietary software |
| Previous Message | Robert Treat | 2003-09-23 16:26:42 | Re: About GPL and proprietary software |