[pgrouting-dev] SSL SYSCALL error: EOF detected

Luís de Sousa luis.a.de.sousa at gmail.com
Wed Feb 25 01:28:58 PST 2015


Just as an addendum, the network tables in this schema sum up to less
than 34 Mb:

# SELECT sum(c.relpages) * 8
  FROM pg_class c,
       pg_namespace n
 WHERE c.relnamespace = n.oid
   AND n.nspname LIKE 'lux_2po_2169'
   AND c.relname LIKE 'ways%';
 ?column?
----------
    33952
(1 row)

Thank you,

Luís

On 25 February 2015 at 10:06, Luís de Sousa <luis.a.de.sousa at gmail.com> wrote:
> Hi again Steve,
>
> I have ran valgrind with 4 and 10 queries, and as you expected, the
> report is essentially the same (logs attached).
>
> I have postgres crashing twice a day. The way psycopg2 opens and
> maintains the connection is the only alternative suspect, but the
> memory swell only takes place with the pgr_dijkstra function. Would
> you have other suggestions? Or would you advise a different forum to
> pose this issue?
>
> Thank you,
>
> Luís
>
>
>


More information about the pgrouting-dev mailing list