Postgres Pro
Downloads
Home   >   mailing lists

Re: are there any methods to disable updating index before inserting large number tuples? - Mailing list pgsql-general

From John R Pierce
Subject Re: are there any methods to disable updating index before inserting large number tuples?
Date
Msg-id 4ECBE35E.90105@hogranch.com
Whole thread Raw
In response to Re: are there any methods to disable updating index before inserting large number tuples?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: are there any methods to disable updating index before inserting large number tuples?  (Andres Freund <andres@anarazel.de>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: possible race condition in trigger functions on insert operations?
Next
From: Kenneth Tilton
Date:
Subject: Re: possible race condition in trigger functions on insert operations?