From: Juan Casero <caseroj@comcast.net>
To: pgsql-performance@postgresql.org
Subject: Re: MySQL is faster than PgSQL but a large margin in
Date: Thu, 22 Dec 2005 21:44:32 -0500
Message-ID: <200512222144.32665.caseroj@comcast.net> (raw)
In-Reply-To: <43AAAB58.6050109@logix-tt.com>
References: <BFCF9173.194ED%llonergan@greenplum.com>
<43AAAB58.6050109@logix-tt.com>
Agreed. I have a 13 million row table that gets a 100,000 new records every
week. There are six indexes on this table. Right about the time when it
reached the 10 million row mark updating the table with new records started
to take many hours if I left the indexes in place during the update. Indeed
there was even some suspicion that the indexes were starting to get corrupted
during the load. So I decided to fist drop the indexes when I needed to
update the table. Now inserting 100,000 records into the table is nearly
instantaneous although it does take me a couple of hours to build the indexes
anew. This is still big improvement since at one time it was taking almost
12 hours to update the table with the indexes in place.
Juan
On Thursday 22 December 2005 08:34, Markus Schaber wrote:
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: caseroj@comcast.net
Subject: Re: MySQL is faster than PgSQL but a large margin in
In-Reply-To: <200512222144.32665.caseroj@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox