Skip site navigation (1) Skip section navigation (2)

Re: MySQL is faster than PgSQL but a large margin in

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: MySQL is faster than PgSQL but a large margin in
Date: 2005-12-22 13:34:16
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
Hi, Madison,
Hi, Luke,

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!

In response to


pgsql-performance by date

Next:From: Carlos BenkendorfDate: 2005-12-22 14:06:20
Subject: Re: ORDER BY costs
Previous:From: Merlin MoncureDate: 2005-12-22 13:29:53
Subject: Re: Speed of different procedural language

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group