346 reputation
15
bio website jayadevanm.wordpress.com
location India
age 41
visits member for 9 months
seen Sep 16 at 13:37

Long-time Oracle guy, getting to know PostgreSQL and probably falling for it.


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 suggested edit on 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
Dec
26
answered How to efficiently copy millions of rows from one table to another in Postgresql?
Dec
15
awarded  Teacher
Dec
15
awarded  Autobiographer
Dec
15
answered Can a single PostgreSQL query use multiple cores?