Re: Counting the occurences of a substring within a very large text

[Geoff Winkless <pgsqladmin@xxxxxxxx>]

On 24 June 2015 at 14:51, Marc Mamin <M.Mamin@xxxxxxxxxxxx> wrote:

note that the 345MB text only contains 635 lines. This might be the issue...

There's similar issue discussed here:

http://www.postgresql.org/message-id/6046.1353874252@xxxxxxxxxxxxx

Tom did seem to accept that the attempted alloc is larger than it needs to be, but even if it were fixed you would still run into problems further down the line managing values of that size.

Geoff