Postgres Pro
Downloads
Home   >   mailing lists

Re: Counting the occurences of a substring within a very large text - Mailing list pgsql-general

From Geoff Winkless
Subject Re: Counting the occurences of a substring within a very large text
Date
Msg-id CAEzk6feHaZL4Vt_hamwFwv1mDDYB9f3whitpk6tJy7AJDtiVHg@mail.gmail.com
Whole thread Raw
In response to Re: Counting the occurences of a substring within a very large text  (Marc Mamin <M.Mamin@intershop.de>)
Responses Re: Counting the occurences of a substring within a very large text  (Marc Mamin <M.Mamin@intershop.de>)
List pgsql-general
Tree view
On 24 June 2015 at 14:51, Marc Mamin <M.Mamin@intershop.de> wrote:
note that the 345MB text only contains 635 lines. This might be the issue...


There's similar issue discussed here:


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

pgsql-general by date:

Previous
From: John Bleichert
Date:
Subject: mirroring a server and/or hot standby
Next
From:
Date:
Subject: Re: mirroring a server and/or hot standby