It is easy enough to drop a PostgreSQL index, then rebuild it after the append. I do not know how long it would take to perform an index build on the table with 157,000,000+ records in it, but the time differential ought to be easy to measure.
Thanks! Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of John Weller > Sent: Wednesday, April 02, 2008 12:08 PM > To: [EMAIL PROTECTED] > Subject: RE: [NF] RE: Microsoft New SQL OS >>> PostgreSQL info > > > I did some work on a data conversion job where timing was critical so we > investigated various ways to save time by running the same task written in > different ways on identical machines. It involved importing > anything from 1 > million to 22 million records at a time into an empty table from > a CSV. We > found it significantly quicker to delete the indexes and import the data > then add the indexes again. I can't remember the actual differences as it > was some time ago. > > John Weller > 01380 723235 > 07976 393631 > > > > >I have no recorded time comparisons, just my gut feel based on years > > of watching VFP import records from large csv files (millions of > > records at a crack). And, for the record, when I do my imports into a > > VFP table I leave any index/order set off, as having a table with an > > active index/order will slow down an import process horribly with > > large tables as VFP tries to rearrange imported records into the > > active sort order... > > > > > > > I don't think that's 100% accurate. If you have SET ORDER TO 0, but > > still have a CDX, the cdx tags must be updated. If you have SET ORDER > > TO something, I don't believe that slows down the APPEND FROM. - Can't > > test it right now though. > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
