Grzegorz Blinowski <g.blinowski@xxxxxxxxx> wrote: > Some performance params from postgresql.conf: Please paste the result of running the query on this page: http://wiki.postgresql.org/wiki/Server_Configuration For a start, the general advice is usually to start with shared_buffers at the lesser of 25% of system RAM or 8 GB, and adjust from there based on benchmarks. So you might want to try 4GB for that one. Just to confirm, you are using 2 Phase Commit? (People sometimes mistake the max_prepared_transactions setting for something related to prepared statements.) I concur with previous advice that using one regular expression which matches all of the terms is going to be a lot faster than matching each small regular expression separately and then combining them. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
