I haven't used PgRouting much so I'm a little in the dark here. However, I am attempting a driving distance calculation like the one described by Underdark here.
My SQL is identical, I have a routable network etc etc. I have also successfully run this in the past on another database. However, when I run the simple piece of sql below, it completely crashes the Postgresql server with no error other than connection to server has been lost:
SELECT * FROM driving_distance(' SELECT gid AS id, start_id::int4 AS source, end_id::int4 AS target, shape_leng::float8 AS cost FROM network', 494902005, 50000, false, false)
I first spotted the crash when trying to run this from Python. I restarted the computer and tried to run the stripped down version above from PGAdmin. It still crashes. BTW the '494902005' value is my node id and I want to limit the search to 50km. Because I am not getting any feed back, I don't know where to start diagnosing the issue. I am using PostGIS 2/PostGreSQL 9.1 on 32bit Windows 7.
Any ideas gratefully received!