> -----Original Message----- > From: Jim C. Nasby [mailto:decibel@xxxxxxxxxxx] > Sent: Monday, June 27, 2005 12:58 PM > To: Dann Corbit > Cc: Ben-Nes Yonatan; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: Populating huge tables each day > > On Mon, Jun 27, 2005 at 12:43:57PM -0700, Dann Corbit wrote: > > I see a lot of problems with this idea. > > > > You mention that the database is supposed to be available 24x7. > > While you are loading, the database table receiving data will not be > > available. Therefore, you will have to have one server online (with > > Why do you think that's the case? He's doing a bulk load. I assume he will have to truncate the table and load it with the copy command. Is there an alternative I do not know of that is equally fast? ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
