Re: [GENERAL] Invalid memory alloc

Chris Mair [mailto:ch...@1006.org] Envoyé : 24 avril 2015 15:41 À : Marc-André Goderre; pgsql-general@postgresql.org Objet : Re: [GENERAL] Invalid memory alloc > I use Postgis and PGrouting extension. > The error come when I use a pgrouting function pgr_createtopology() It appears pgrouting

Re: [GENERAL] Invalid memory alloc

| 1GB shared_buffers | 10GB work_mem| 256MB I use Postgis and PGrouting extension. The error come when I use a pgrouting function pgr_createtopology() Marc Marc-André Goderre Analyste en informatique Courriel: magode

Re: [GENERAL] Invalid memory alloc

De la part de Edson Richter Envoyé : 23 avril 2015 16:16 À : pgsql-general@postgresql.org Objet : Re: [GENERAL] Invalid memory alloc On 23-04-2015 16:55, Marc-André Goderre wrote: > Hello, I'm processing a 100Million row table. > I get error message about memory and I'ld like t

[GENERAL] Invalid memory alloc

Hello, I'm processing a 100Million row table. I get error message about memory and I'ld like to know what can cause this issue. ... psql:/home/ubuntu/create_topo.sql:12: NOTICE:  104855000 edges processed psql:/home/ubuntu/create_topo.sql:12: NOTICE:  104856000 edges processed psql:/home/ubuntu/

Re: [GENERAL] function returning a merge of the same query executed X time

cm_get_loop_route_4(2, 10, -73.597070, 45.544083))r)q CROSS JOIN generate_series(1, 3) the quey is executed only 1 time. Thanks Marc De : gwinkl...@gmail.com [mailto:gwinkl...@gmail.com] De la part de Geoff Winkless Envoyé : 22 avril 2015 11:22 À : Marc-André Goderre Cc : 'pgsql-general@postgresql.org&#x

[GENERAL] function returning a merge of the same query executed X time

Hi all, I'm having difficulties to create a function that should execute X time the same query and return their results as a single table. I tried this way but it don't work : Thanks to help. create function cm_get_json_loop_info( IN profile integer, IN distance double precision DEFAULT

[GENERAL] Using array_agg in pgr_kdisjkstrpath() error

Hello all, I hope someone will can help me. When I use pgr_kdijkstrapath function as this: select * FROM pgr_kdijkstrapath('     SELECT d.id,      source::integer, target::integer, c.cost::double precision as cost  

[GENERAL] Using array_agg in pgr_kdisjkstrpath()

::integer[] as id from n2) AND '{28411,25582}' Thanks Marc-André Marc-André Goderre Analyste en informatique [LOGO-FINAL-1_Mini.png] Courriel: magode...@cgq.qc.ca<mailto:magode...@cgq.qc.ca> Tel.: (418) 698-5995 poste 1628 Téléc.: (418) 698-4108 Cégep de Chicoutimi, 534 rue Jacques-C

[GENERAL] Trigger vs web service

I receive a long string (about 1 per second) than content many information. For the moment it is directly inserted in the database (1 column). I have to treat the hole string every time i need information in it. Now, I want split the sting and save the informations in differents fields. I have 2

Re: [GENERAL] Trigger vs web service

I receive a long string (about 1 per second) than content many information. For the moment it is directly inserted in the database (1 column). I have to treat the hole string every time i need information in it. Now, I want split the sting and save the informations in differents fields. I have 2

[GENERAL] Trigger vs web service

I receive a long string (about 1 per second) than content many information and for the moment it is directly inserted in the database (1 column). I have to treat the hole string every time i need information in it. Now, I want split the sting and save the informations in differents fields. I have