pgpool2 depends on pcre
add 'limit 1000' to 'SELECT * FROM table' queries automatically to not consume entire memory