Hi,
I am trying to have synchronous master-master replication in PostgreSQL8.4
using PgPool II. I am not able to configure PgPool on the system, it gives me
an error, libpq is not installed or libpq is old.
I have tried the command , ./configure -with-pgsql = PostgreSQL dir
-with-pgsql-libdi
"Because it's policy" is rarely a good design decision :-) Lose the FK
constraints, and make up for them with integrity checking queries.
I just did a major refactor and shard on our PG schema and the performance
improvement was dramatic ... a big plus for PG, if it is e.g. time-series
data is to
Hello,
I'm about to embark on a partitioning project to improve read performance on
some of our tables:
db=# select relname,n_live_tup,pg_size_pretty(pg_relation_size(relid)) from
pg_stat_all_tables where schemaname = 'public' order by n_live_tup desc limit
10;
relname
