Re: [BUGS] BUG #8117: simple but huge query infinite execution time

2013-04-25 Thread Tom Lane
hadd...@mail.ru writes: > query has the following scheme > SELECT > regexp_matches('...',' (\d+)\:','g'), > regexp_matches('...','\:([\d\.]+)','g') I'm not sure what you're expecting this to do, but what it will actually do is produce a number of rows equal to the least common multip

[BUGS] BUG #8117: simple but huge query infinite execution time

2013-04-25 Thread haddock
The following bug has been logged on the website: Bug reference: 8117 Logged by: Viacheslav Seledkin Email address: hadd...@mail.ru PostgreSQL version: 9.2.3 Operating system: Linux, Windows Description: you can get query here http://yadi.sk/d/uE-KE0b34LV5A query ha