Re: Insertion puzzles
От
Dave Cramer
Тема
Re: Insertion puzzles
Дата
Msg-id
41963C60.8000608@fastcrypt.com
Ответ на
Re: Insertion puzzles (Andreas Åkre Solberg)
Список
Дерево обсуждения
Insertion puzzles vivek singh <sing_vivek@yahoo.com>
Re: Insertion puzzles Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: Insertion puzzles Josh Berkus <josh@agliodbs.com>
Re: Insertion puzzles Dave Cramer <pg@fastcrypt.com>
Re: Insertion puzzles Andreas Åkre Solberg <Andreas.Solberg@uninett.no>
Re: Insertion puzzles Dave Cramer <pg@fastcrypt.com>
Well, the default configuration for postgresql 7.1.3 is *very* conservative. ( ie. very slow) You should seriously consider upgrading to 7.4.6 as server performance has increased; in some cases significantly. If that is not an option, certainly tuning the shared buffers, and effective cache settings would be advisable. dave Andreas Åkre Solberg wrote: > > On Nov 13, 2004, at 12:26, vivek singh wrote: > >> But >> still, with large volume of data in database the >> insert operation becomes very slow (ie. to insert 100 >> records in 5 tables, it takes nearly 3minutes). > > > What are the performance when you use COPY FROM instead of INSERT ? > And have you tested the performance with fsync on and off. > -- Dave Cramer http://www.postgresintl.com 519 939 0336 ICQ#14675561
В списке pgsql-performance по дате отправления
