Kasia Tuszynska <ktuszynska@xxxxxxxx> writes: > 1. Is there anything I could do to in postgresql.conf file to speed up the time it takes postgres to commit a transaction? If you want the traditional guarantee that "commit" means "your data is safely down on persistent storage", there's not much you can do except buy better storage hardware. A disk controller card with battery-backed cache can be a relatively inexpensive solution. Try the pgsql-performance archives for more information than you need on that topic. If you're willing to live with weaker guarantees, consider disabling synchronous_commit. > 2. Is there anything better than pg_fouine to analyze logs? No idea on that one. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
