Re: [PERFORM] Current query of the PL/pgsql procedure.

2013-12-16 Thread Yuri Levinsky
se of production issue I'll just unable to do it: the issue already happening, I can't stop procedure and start code change. James, I saw your reply: I see the function is running, it's just not clear that exactly and how this function doing. Sincerely yours, Yuri Levinsky, DBA C

[PERFORM] Current query of the PL/pgsql procedure.

2013-12-15 Thread Yuri Levinsky
yours, [Description: Celltick logo_highres] Yuri Levinsky, DBA Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel Mobile: +972 54 6107703, Office: +972 9 9710239; Fax: +972 9 9710222 <>

Re: [PERFORM] How to properly index hstore tags column to faster search for keys

2013-07-08 Thread Yuri Levinsky
Dear Radu-Stefan, It seems to me that you trying hard to solve a problem by SQL that probably can't be solved. Take a look please on Apache HBase. You can access HBase from PostgreSQL as well by utilizing Java or Python for example. Sincerely yours, [Description: Celltick logo_highres]

Re: [PERFORM] Not same plan between static and prepared query

2013-06-09 Thread Yuri Levinsky
date batch", that can run for millions of different values? Is it some way to give some kind of query hint that will eliminate execution path recalculations during heavy updates and instruct regarding correct execution plan? Sincerely yours, Yuri Levinsky, DBA Celltick Technologies Ltd

Re: [PERFORM] Hardware suggestions for maximum read performance

2013-05-05 Thread Yuri Levinsky
solutions on the market that will provide same performance characteristics (935,000 write IOPS, up to 892,000 read IOPS, up to 3 GB/s Bandwidth). Sincerely yours, Yuri Levinsky, DBA Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel Mobile: +972 54 6107703, Office