Re: What's the fastest way to do this?

Поиск
Список
Период
Сортировка
От Orion
Тема Re: What's the fastest way to do this?
Дата
Msg-id 9sf2d4$1jhv$1@news.tht.net
обсуждение исходный текст
Ответ на Re: What's the fastest way to do this?  (Andrew Gould <andrewgould@yahoo.com>)
Список pgsql-general
Andrew Gould wrote:

> Are you updating directly from the flat file?  Or are
> you copying the new data into an indexed table that is
> emptied and vacuumed after daily updates, and
> updating/inserting from there?
>
> Andrew Gould

Well to be honest I'll do it any way I can to make this go faster.

Right now I am updating directly from said file. For each line I read from
the file I need to insert or update the exsisting table depending on
weather or not the record is already there.

        Orion


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

Предыдущее
От: Douglas Bates
Дата:
Сообщение: Hardware performance tuning
Следующее
От: Jason Earl
Дата:
Сообщение: Re: Hardware performance tuning