721 reputation
38
bio website
location
age
visits member for 3 years, 2 months
seen Apr 21 at 14:18

Sep
26
awarded  Yearling
Sep
2
awarded  Nice Answer
Jan
26
answered pgpool-II configuring multiple master databases
Jan
26
comment pgpool-II configuring multiple master databases
Well if they are fully siloed then you don't need plproxy per se. But it is a great method to silo things with. I.e. one (set of) pl proxy machine(s) handle all requests and route them to the proper silo without the application having to be silo aware. There are plenty of ways to skin this cat. Basically if you have 2 or more silos and the application is silo-aware then you can run a different plpool / pgbouncer server on a different port for each silo. So silo1 answers on port 65432, silo2 on 65433, and so on. Each pgpool / pgbouncer server you run is itself isolated from the other.s
Jan
26
comment What size of data can PostgreSQL handle?
The more important question is how much data can your SERVER handle. PostgreSQL can handle terabytes pretty well, but single connections are single threaded, and the throughput will be largely determined by the ability of your server to act as a "data pump" for such a connection than anything else. Do you have a pair of 5400RPM SATA drives for storage? OR a RAID array of 32 SSDs? And so on.
Jan
26
comment Group by for UNION not working Postgresql
You are aware that union removes duplicate rows, right? If you don't want the duplicates eliminated, then use UNION ALL.
Jan
26
comment pgpool-II configuring multiple master databases
Are these masters related to each other or are they more like siloed data sets that don't interact or need to be updated across each other? A project worth looking at for massive systems is plproxy, which moves all this logic into a set of postgres servers that simply dispatch all the work to be done onto slaves. But without knowing what you're really trying to do it's hard to recommend a solution.
Jan
14
answered VACUUM FREEZE vs. VACUUM FULL
Dec
18
awarded  Custodian
Dec
18
reviewed Approve PostgreSQL: How to create full copy of database schema in same database?
Sep
26
awarded  Yearling
Apr
26
comment Why PostreSQL 9.2 does not use index scan if it can?
The most important lesson to take from this is that query planning is not as simple as "index good, seq scan bad". If any db proves this point, it's postgresql...
Jan
18
comment PostgreSQL replication
Bucardo++. Otherwise I'd look at using some kind of cross database replication with slony.
Dec
13
comment Postgresql could not find pg_xlog
if you do sudo su - and then cd /var/lib/pgsql/9.2/data, what does "ls -l .fab-pg/wals/.dev.xvdf/pg_xlog" give you? I think this is a simple case of your mv and ln -s resulting in a bad link.
Sep
26
awarded  Yearling
May
31
comment Migrating and normalizing data
I'd just keep the old surrogate keys unless you're gonna re-write django.
May
29
comment tuning postgresql for large amounts of ram
Using your RAM is NOT the problem. Postgresql relies on the OS to do most of the caching. So, it doesn't NEED to use all the RAM. Again, you missed the bulk of my point. You're giving us precious little to help you with. I drive 5000 TPS postgresql clusters for a living. You can take my advice, or keep thinking you know how pgsql works and argue.
May
29
comment PostgreSQL memory spike upgrade from 8.2 to 9.1
What is your work_mem set to? If it's very high that could be the cause of your problems.
May
29
comment Connection to localhost dramatically slower than to network server
A lot of times such issues stem from bad name resolution on your network.
May
29
answered tuning postgresql for large amounts of ram