Reputation
406
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 8
Newest
 Tumbleweed
Impact
~15k people reached

Apr
14
comment MySQL: “CREATE DATABASE mydb” command hangs
Try executing SHOW FULL PROCESSLIST from another session and see what it is doing? dev.mysql.com/doc/refman/5.1/en/show-processlist.html
Mar
23
awarded  Tumbleweed
Mar
16
asked PostgreSQL analyze only parent table only
Feb
19
awarded  Editor
Dec
15
awarded  Yearling
Nov
7
comment Postgres automatic failover, multiple clients to multiple masters
I haven't tried that. I suggest trying pgpool mailing list.
Nov
7
comment pgpool-II Master Slave mode / Load Balance Mode / Watchdog On result many primary servers
Where is you pgpool conf? It will have entries for backend_host, backend_port etc. See the examples here pgpool.net/docs/latest/tutorial-en.html
Nov
4
awarded  Commentator
Nov
4
comment Postgres automatic failover, multiple clients to multiple masters
pgpool has pgpool-ha. So it need not be a single point of failure. Are you planning to have pgpool replicate writes, or use in-built replication? Having multiple masters at the same time needs quite a bit of thought. What if 2 sessions try to change the same record in 2 masters? Which one should be given precedence?
Jul
4
awarded  Enlightened
Jul
4
awarded  Nice Answer
Jun
23
awarded  Supporter
May
22
comment INSERT from a SELECT combined with a single value
Please note that if you have 100 item_ids and 200 tag_ids, you will be inserting 100*200 records.
Apr
15
awarded  Custodian
Apr
15
reviewed Approve How slow is slow in postgres?
Apr
14
answered How slow is slow in postgres?
Feb
18
comment Optimizing Postgres query
Please provide the plan for the query. Preferably here - explain.depesz.com
Feb
11
comment pgpool replication not allowing md5 authentication
You are executing createdb. Please try a simple psql connection first. I went through some issues while trying to set up pgpool with replication and made a note of the debugging process I used - sraoss.jp/pipermail/pgpool-general/2013-May/001773.html
Feb
10
comment Query hangs forever at first but works after one day
Is this one table big compared to others?
Feb
9
answered How to create several builds of PostgreSQL?