Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?

Поиск
Список
Период
Сортировка
От Anton de Wet
Тема Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?
Дата
Msg-id Pine.LNX.4.04.9812181046030.9458-100000@ra.obsidian.co.za
обсуждение исходный текст
Ответ на Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-general
> > On Thu, 17 Dec 1998, Bruce Momjian wrote:
> >
> > >     Quick mailing list support
> >
> > except they cant tell me why a Dump/Restore from 6.3>6.4 wont work fore
> > some people. :)
>
> Often quick mailing list support?

:-)

While on the subject I finally found the solution to a problem I (and one
or two other people) posted about without answer. (So sometimes it's slow
mailing list support).

In importing about 5 million records (which I copy in blocks of 10000) the
copy became linearly slower. After a friend RTFM and refered me, I used
the -F switch (passed by the postmaster to the backend processes) and the
time became linear and a LOT shorter. Import time for the 5000000 records
now the same (or maybe even slightly faster, I didn't accurately time
them) as importing the data into oracle on the same machine.

Anton


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

Предыдущее
От: Oleg Broytmann
Дата:
Сообщение: Re: [GENERAL] date_part bug?
Следующее
От: Vadim Mikheev
Дата:
Сообщение: Re: [GENERAL] Why PostgreSQL is better than other commerial softwares?