| From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
|---|---|
| To: | Andreas Åkre Solberg <Andreas(dot)Solberg(at)uninett(dot)no> |
| Cc: | pgsql-performance(at)postgresql(dot)org, vivek singh <sing_vivek(at)yahoo(dot)com> |
| Subject: | Re: Insertion puzzles |
| Date: | 2004-11-13 16:54:56 |
| Message-ID: | 41963C60.8000608@fastcrypt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2004-11-13 17:13:42 | Re: Insertion puzzles |
| Previous Message | Andreas Åkre Solberg | 2004-11-13 13:31:11 | Re: Insertion puzzles |