Re: Insertion puzzles

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