366 reputation
26
bio website jayadevanm.wordpress.com
location India
age 41
visits member for 1 year
seen Dec 17 at 2:59

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?
Jan
31
comment Migration from SQL Server 2008 to Postgres 9.2
How many tables are there? If it is just a few, you could use an ETL tool like Pentaho. But it does not move data structures/code.
Jan
30
comment Stress-test PostgreSQL 9.2 and pgpool
When you try with a much smaller number, is it working?
Jan
9
comment VACUUM FREEZE vs. VACUUM FULL
True - "difference between this types of Vacuum in PostgreSQL" - I thought question was about differences between types of vacuum.
Jan
9
answered VACUUM FREEZE vs. VACUUM FULL