Re: Insert performance

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Insert performance
Дата
Msg-id 3F40BDC4.1605.9407ADF@localhost
обсуждение исходный текст
Ответ на Re: Insert performance  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Insert performance
Список pgsql-performance
On 16 Aug 2003 at 11:40, Josh Berkus wrote:

> Shridhar,
>
> > Unfortunately he can not use copy due to some constraints.
>
> Why not use COPY to load the table, and then apply the constraints by query
> afterwords?  It might not be faster, but then again it might.

Lol.. The constraints I mentioned weren't database constraints.. It need to
interface with another database module.. The data import can not be text..
that's a project requirement..

I should have been clearer in first place..

Bye
 Shridhar

--
O'Toole's commentary on Murphy's Law:    Murphy was an optimist.


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

Предыдущее
От: David Emery
Дата:
Сообщение: Re: Benchmark
Следующее
От: pginfo
Дата:
Сообщение: bad join performance