> Hi, I have performance issues on very large database(100GB). Reading from > the database is no problem, but writing(or heavy writing) is a nightmare. > I have tried tuning postgresql, but that does not seem to improving the > writing performance. > To improve the write performance, what are my options? Hard to tell with this little info. We need to know more about your hardware (CPU, RAM, disk setup, ...), PostgreSQL configuration (number of checkpoint segments, ...) and output from tools like vmstat and iostat. regards Tomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
