Postgres Pro
Downloads
Home   >   mailing lists

Re: MySQL is faster than PgSQL but a large margin in - Mailing list pgsql-performance

From Markus Schaber
Subject Re: MySQL is faster than PgSQL but a large margin in
Date
Msg-id 43AAAB58.6050109@logix-tt.com
Whole thread Raw
In response to Re: MySQL is faster than PgSQL but a large margin in  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Re: MySQL is faster than PgSQL but a large margin in  (Juan Casero <caseroj@comcast.net>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Speed of different procedural language
Next
From: Carlos Benkendorf
Date:
Subject: Re: ORDER BY costs