Re: [PERFORM] How do I bulk insert to a table without affecting read performance on that table?

Scott Marlowe-2 wrote: > > On Jan 25, 2008 5:27 PM, growse <[EMAIL PROTECTED]> wrote: >> >> Hi, >> >> I've got a pg database, and a batch process that generates some metadata >> to >> be inserted into one of the tables. Every 15 minutes or s

[PERFORM] How do I bulk insert to a table without affecting read performance on that table?

Hi, I've got a pg database, and a batch process that generates some metadata to be inserted into one of the tables. Every 15 minutes or so, the batch script re-calculates the meta data (600,000 rows), dumps it to file, and then does a TRUNCATE table followed by a COPY to import that file into the