Luke Lonergan wrote:
> Note that indexes will also slow down loading.
For large loading bunches, it often makes sense to temporarily drop the
indices before the load, and recreate them afterwards, at least, if you
don't have normal users accessing the database concurrently.
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
In response to
pgsql-performance by date
|Next:||From: Carlos Benkendorf||Date: 2005-12-22 14:06:20|
|Subject: Re: ORDER BY costs |
|Previous:||From: Merlin Moncure||Date: 2005-12-22 13:29:53|
|Subject: Re: Speed of different procedural language |