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.


Andreas Åkre Solberg wrote:

On Nov 13, 2004, at 12:26, vivek singh wrote:

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

---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Reply via email to