> -----Original Message----- > From: Chris Mair [mailto:ch...@1006.org] > Sent: Mittwoch, 24. Juni 2015 13:26 > To: Marc Mamin; Postgres General > Subject: Re: [GENERAL] Counting the occurences of a substring within a > very large text > > > Hello, > > > > I'd like to count the number linebreaks within a string, but I get a > > memory allocation error when using regexp_matches or > regexp_split_to_table. > > > > Any idea for an alternative to this problem ? > > > > select count(*)-1 from > > ( select regexp_split_to_table(full_message,'(\n)', 'g') > > from mytable > > where id =-2146999703 > > )foo; > > > > ERROR: invalid memory alloc request size 1447215584 > > > > regards, > > > > Marc Mamin > > > > Hi, > > what's the size of full_message from mytable where id =-2146999703?
345 MB, Postgres 9.3.6 Marc Mamin > > Also: Postgres version? OS? any extensions installed? > > Bye, > Chris. > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
