Re: [PERFORM] Speeding up loops in pl/pgsql function

2011-05-25 Thread Santhakumaran
Dkloskxe Steve Crawford wrote: >On 05/25/2011 11:45 AM, Reuven M. Lerner wrote: >> Hi, Alex. You wrote: >>> Have you tried something like: >>> SELECT encode(regexp_replace('141142143', '(\d{3})', '\\\1', >>> 'g')::bytea, 'escape'); >> Hmm, forgot about regexp_replace. It might do the trick, b

Re: [PERFORM] Performance degradation of inserts when database size grows

2011-05-24 Thread Santhakumaran
Tomas Vondra wrote: >Dne 24.5.2011 07:24, Terry Schmitt napsal(a): >> As near as I can tell from your test configuration description, you have >> JMeter --> J2EE --> Postgres. >> Have you ruled out the J2EE server as the problem? This problem may not >> be the database. >> I would take a look a