gistfile1.txt

WITH trip AS (
 SELECT ST_MakeLine(the_geom_webmercator ORDER BY cartodb_id ASC) as g
 FROM jackerouak
),
params AS (
 SELECT 
   greatest(st_xmax(g)-st_xmin(g), st_ymax(g)-st_ymin(g))/20 as maxlen_old, 
   CDB_XYZ_Resolution(4)*10 as maxlen
 FROM trip
),
dump AS (
 SELECT (ST_DumpPoints(ST_Segmentize(t.g,  p.maxlen))).*
 FROM trip t, params p
  )
SELECT path as cartodb_id, geom as the_geom_webmercator
FROM dump