Re: Populating huge tables each day

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Populating huge tables each day
Дата
Msg-id 20050628015506.GA39875@decibel.org
обсуждение исходный текст
Ответ на Re: Populating huge tables each day  ("Dann Corbit" <DCorbit@connx.com>)
Список pgsql-general
On Mon, Jun 27, 2005 at 01:05:42PM -0700, Dann Corbit wrote:
>
> > -----Original Message-----
> > From: Jim C. Nasby [mailto:decibel@decibel.org]
> > Sent: Monday, June 27, 2005 12:58 PM
> > To: Dann Corbit
> > Cc: Ben-Nes Yonatan; pgsql-general@postgresql.org
> > Subject: Re: [GENERAL] 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.

Don't ass-u-me; he said he'd be deleting from the main table, not
truncating.

> Is there an alternative I do not know of that is equally fast?

Nope, truncate is undoubtedly faster. But it also means you would have
downtime as you mentioned. If it were me, I'd probably make the
trade-off of using a delete inside a transaction.
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Finding points within 50 miles
Следующее
От: Jeff Gold
Дата:
Сообщение: Re: Postmaster Out of Memory