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: 43AAAB58.6050109@logix-tt.com (view raw or flat)
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

-- 
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

Responses

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-2014 The PostgreSQL Global Development Group