Home > Archive > PostgreSQL Administration > November 2006 > Settings for writing!









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Settings for writing!
jose fuenmayor

2006-11-20, 7:23 pm

Hi all, which paramaters can I modify in order to improve performance in
wirting tasks (updates,inserts,cop
y), I have a database where there is a lot
of writing, i have increase the shared_buffers but it seems to improve just
the reading which are really fast (I have a table with like
87 000 000 rows, the problem goes when writing)

I am using Mandiva linux 2006 x86_64 kernel 2.6.17
Postgresql 8.0.8
in a ML350G4
I really apreciate the help!
Thanks in advance!

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com