BUG #8117: simple but huge query infinite execution time

From: haddock(at)mail(dot)ru
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8117: simple but huge query infinite execution time
Date: 2013-04-25 14:38:30
Message-ID: E1UVNJe-0004v7-MU@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8117
Logged by: Viacheslav Seledkin
Email address: haddock(at)mail(dot)ru
PostgreSQL version: 9.2.3
Operating system: Linux, Windows
Description:

you can get query here
http://yadi.sk/d/uE-KE0b34LV5A

query has the following scheme
SELECT
regexp_matches('...',' (\d+)\:','g'),
regexp_matches('...','\:([\d\.]+)','g')

where '...' is approximately 40kb string (the same in both ...)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-04-25 15:12:53 Re: BUG #8117: simple but huge query infinite execution time
Previous Message nitinmn 2013-04-25 13:52:36 BUG #8116: create trigger after insert fails if procedure being executed is having error