Re: are there any methods to disable updating index before inserting large number tuples?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: are there any methods to disable updating index before inserting large number tuples?
Date: 2011-11-22 18:01:02
Message-ID: 4ECBE35E.90105@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/22/11 7:52 AM, Andrew Sullivan wrote:
> But I think performance on that table is going to be pretty bad. I
> suspect that COPY is going to be your friend here.

indeed. 20M rows/hour is 5500 rows/second. you'd better have a
seriously fast disk system, say, 20 15k RPM SAS drives in a RAID10 with
a decent SAS raid controller that has 1GB of writeback battery-or-flash
backed cache.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Tilton 2011-11-22 18:51:41 Re: possible race condition in trigger functions on insert operations?
Previous Message Merlin Moncure 2011-11-22 17:53:58 Re: possible race condition in trigger functions on insert operations?