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

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Counting the occurences of a substring within a very large text
Date: 2015-06-24 14:03:13
Message-ID: CAEzk6feHaZL4Vt_hamwFwv1mDDYB9f3whitpk6tJy7AJDtiVHg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 24 June 2015 at 14:51, Marc Mamin <M(dot)Mamin(at)intershop(dot)de> 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@sss.pgh.pa.us

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-06-24 14:03:50 Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows)
Previous Message John Bleichert 2015-06-24 13:54:57 mirroring a server and/or hot standby