1

Temat: org.postgresql.util.PSQLException: Ran out of memory retrieving query

Cześć!

Próbuje w javie przez jdbc wykonać poniższe zapytanie:
String sql = "SELECT \"NAZWA\", \"ID_OBIEKTU\", asewkt(\"GEOMETRIA\") FROM go_test";

cały czas dostaje błąd :

org.postgresql.util.PSQLException: Ran out of memory retrieving query results.

Jeśli ogranicze ilosc rekordów poprzez LIMIT 100 zapytanie działa poprawnie. Jednak w tabeli jest tylko 1127 wierszy i problem leży po stronie geometrii trzymanej w bazie jako, że asewkt("GEOMETRIA") zwraca dużego varchara (poniżej):

"SRID=4326;POLYGON((16.0834631508593 51.1813591990452,16.0832541335563 51.1812614014399,16.083703958638 51.180704740026,16.0837641192378 51.1806310505455,16.0839186665039 51.1804131804777,16.0843767079465 51.1804332982922,16.0847310789116 51.1804844416444,16.0859805069968 51.1805304702238,16.0863438535656 51.1805402009805,16.0868398721855 51.1805205819548,16.0877158204409 51.180443519087,16.088089600961 51.1804078119352,16.0890953797448 51.1804357703594,16.0895255472021 51.1804543786815,16.0923444505468 51.1806449991302,16.0927302286075 51.180689811365,16.093001158031 51.1807344004575,16.0937679933155 51.1796879415792,16.0938602525984 51.1795618092705,16.0940661803093 51.1792807199115,16.0960819325057 51.1797411982208,16.0978190200222 51.1801381597156,16.0983318021229 51.1802536993256,16.0986760097579 51.1801344713038,16.0990662229996 51.180042440397,16.0994483476739 51.1799555811423,16.0995894089827 51.1798841712141,16.0996984091947 51.1798152989832,16.1000853975336 51.1792908094461,16.1005173089943 51.1786385205956,16.1008714394072 51.1779718981305,16.1011423988998 51.1773903804085,16.1012697562509 51.1769585693286,16.101442420104 51.1764946082485,16.1016060331808 51.1762418798449,16.101726226587 51.1761098583282,16.1023244723713 51.1757082983508,16.1028454708328 51.1753760481382,16.1031869872902 51.1751457608548,16.1034347485307 51.1749336312335,16.1037387388461 51.1745922190584,16.1040983418213 51.1741823896879,16.1043745182895 51.1738573806635,16.1045112872452 51.1736448791382,16.1045901282261 51.1734091795589,16.1046355023833 51.1729544810741,16.1046854319977 51.1723377987426,16.1047794202495 51.1722426919716,16.1037325371099 51.1711322218654,16.1037576597794 51.1710434287104,16.1047506817798 51.1711623504584,16.1053633080747 51.1712344691917,16.105728842165 51.1713156317534,16.1062567489849 51.171485329325,16.1062843673834 51.1714842004872,16.1063326732705 51.1714752704177,16.1063732288666 51.1714564083259,16.1063933074573 51.1714289005618,16.1064094019024 51.1713877111087,16.1063993137449 51.17132446119,16.1066783167013 51.1704861109954,16.1071219926677 51.1693044015993,16.1071449879538 51.1691428684126,16.1071401393237 51.1690604895064,16.1071447474016 51.1689176608993,16.1068788996432 51.1683936614002,16.1064545881283 51.1677441115128,16.1063581266993 51.1676110399144,16.1058237024185 51.1669282286903,16.105695307686 51.1667641621816,16.1061358188876 51.1666756709251,16.1089400410313 51.1661436295507,16.1093721404234 51.1660644402675,16.1110296803369 51.1657623492753,16.1134673385263 51.1653096196936,16.1150883596102 51.1650090994485,16.1154588175031 51.1649399296945,16.1156072983436 51.1649118706375,16.1165306729671 51.1647390797003,16.1217741469585 51.1637544181277,16.1272641719122 51.1627590807249,16.1308135119879 51.1622793509186,16.1342349083665 51.1620843682557,16.136097970059 51.1620221115392,16.1383631222577 51.1619937593344,16.1434757508912 51.1618394979632,16.1438904177667 51.1617623519639,16.1440314414892 51.1617583179002,16.144632461141 51.1617395520659,16.1457365581159 51.1617143413554,16.1462526628439 51.1617187298217,16.1489502301595 51.161658862041,16.1496911534626 51.1616341413686,16.1503866199187 51.1616076705601,16.1507726234971 51.1615987011126,16.1508328292004 51.1615977079103,16.1517969924549 51.1615680387281,16.1529814188275 51.1615312421166,16.1539388466207 51.1615018792082,16.1560240281935 51.1614405588146,16.158888997283 51.1612783518255,16.1616976095042 51.1611934089699,16.1632351289084 51.1611995913256,16.165005547938 51.1611549016003,16.1655051372545 51.1611398985586,16.1652905195957 51.1607858416502,16.1659246978636 51.1607703310691,16.1659688918117 51.1607694384996,16.1665954325475 51.1607548117372,16.1679546576739 51.1607197915138,16.1680424366722 51.1607208897242,16.1691608089163 51.1606417485698,16.1706271774925 51.1606017710859,16.1727587104658 51.160664421583,16.1728498496775 51.1606591405473,16.1731564484808 51.1606399590556,16.1736264573949 51.1606095110628,16.174109621507 51.1605794787274,16.174934287042 51.1605279809726,16.1749627022697 51.1605976888935,16.1750312972307 51.1608786601183,16.17614773754 51.16084556942,16.1765932777859 51.1608301988497,16.1798977733164 51.1607360502782,16.1802484833779 51.1607237818241,16.1810817937572 51.1607191089608,16.1823576825836 51.1606958890301,16.1835941509195 51.1606812097635,16.1836979792594 51.1606786808168,16.1841011296987 51.1606154615256,16.1840634231426 51.1607330794222,16.1842502194369 51.1614689110194,16.184436451937 51.1620021906151,16.1845931566556 51.1620561604371,16.1846294725194 51.1621245513805,16.184475917531 51.1621506984139,16.1846149491808 51.1625638486676,16.1847909131092 51.1630690385789,16.1855219662552 51.165168379335,16.1862188685072 51.1671495290248,16.1868796879304 51.169033248638,16.1873204772705 51.1699109287661,16.1873425178651 51.1700990115175,16.1874528711831 51.1707157594791,16.1877721816663 51.171451599827,16.1879557079542 51.1714609018004,16.1881004827875 51.1715923107694,16.188104549623 51.171681869609,16.1879866715317 51.171957660431,16.1884431117988 51.1732562395405,16.1887420805871 51.1740799192193,16.1891089978525 51.17508198152,16.189254659722 51.1753077009482,16.1893571875766 51.1753224195928,16.1895589582449 51.1753665011458,16.1900591489419 51.1754314093184,16.1906328884716 51.1755196380545,16.1909063662448 51.1755717396062,16.1911966826716 51.1756428913894,16.1914529910321 51.175669209061,16.1923988497683 51.1755682787121,16.1924382326725 51.1756599595917,16.1924844036589 51.175702938559,16.1924780590948 51.1758317485759,16.1924750296406 51.1759436697795,16.1925097292943 51.1760035988149,16.1925513598581 51.1760718191201,16.1928174632032 51.1763117890315,16.1929813769703 51.1764204418559,16.1932284616578 51.1765645786897,16.1935284603102 51.1767775396257,16.1935954165094 51.1768437078963,16.1937290808383 51.1770015001671,16.1938352996656 51.1771580104632,16.1939220036963 51.1773624482364,16.1940426782069 51.177751240971,16.1940450686943 51.1778932120114,16.1933533533489 51.1779092520088,16.1926710871944 51.1779239706534,16.1902623328543 51.1779915390329,16.1903955085616 51.1785368114362,16.1904093628644 51.1786616617702,16.1905805683698 51.1791672585881,16.190732710114 51.1796100386461,16.1909849892253 51.180324557961,16.1912384635804 51.1810632597814,16.1913811410993 51.1813447998005,16.1917391278645 51.1813896120353,16.1917316481948 51.1814483816055,16.1914249892535 51.1814322803534,16.1916410427082 51.1822084088343,16.1918853911145 51.1830961303683,16.1921057594742 51.1839120219415,16.192332299501 51.1847262202579,16.1925850371649 51.1855255117901,16.1925985832603 51.1855440894848,16.192605183411 51.1855698296115,16.1927501762448 51.1860005206044,16.1927779675402 51.1860660894533,16.1929400470968 51.1865194184566,16.1930773873639 51.1869032408047,16.1931634599451 51.187169712152,16.1932834579027 51.1875297282738,16.1934758169664 51.1880854008609,16.1936042492852 51.1884744911186,16.1937026877525 51.1887623185016,16.1938494997622 51.1891719816092,16.1938730889115 51.1892561412789,16.1939380831069 51.1894593189541,16.1941496788288 51.1899822596208,16.1942243176636 51.1901657001361,16.1943081125162 51.190390618877,16.1944785136753 51.1908717619183,16.1946469528304 51.1913505597772,16.1946800137223 51.1914455396633,16.1949348787698 51.1921989907557,16.1952197902894 51.1929808815598,16.1953212882799 51.1933482788806,16.1954026926451 51.1933498715044,16.1955323427594 51.193457741143,16.1957778788921 51.1933184084327,16.1958284474732 51.1932567598886,16.1959035298262 51.1930944303899,16.1959435968006 51.1930240180393,16.1960402536783 51.1929062820085,16.1962727097856 51.1928129209983,16.1965313785645 51.1926900920714,16.1965845105299 51.1926853579533,16.1968235216845 51.192636257885,16.196906549777 51.1926317512845,16.1969500897237 51.1926419020739,16.1970008763053 51.1927803815928,16.1970702906472 51.1929034686647,16.1971835907296 51.1929601205703,16.1972509227916 51.1929656991291,16.197498210445 51.1929612319067,16.1976118863902 51.192925371618,16.1977601492303 51.1928248306744,16.1978345324784 51.1927991518025,16.1978527392724 51.192739800312,16.1978754864891 51.1926563713241,16.1979881175357 51.192598118044,16.1980787981949 51.192600830755,16.1983833222354 51.1926513309322,16.1985848297998 51.1926735489099,16.1987319725687 51.1926264089941,16.199021777822 51.1923951810126,16.1991562765664 51.1922687818081,16.1991776105389 51.1922267085362,16.199171093078 51.1921921608496,16.1991241478142 51.1920964896597,16.1990495991865 51.1919714905641,16.198982898574 51.1919186189525,16.1989720737254 51.1918450388555,16.1989157168571 51.191773432037,16.1989134391285 51.1916746981089,16.1989513185815 51.1916229815872,16.199071226332 51.1915654808656,16.1991535778715 51.1915156501155,16.1992749289351 51.1914717304501,16.1993720969861 51.1914275307629,16.1994914108734 51.1913586104032,16.1995492035375 51.1913183003935,16.1996840180066 51.1912438714805,16.1997928979425 51.1911603418598,16.1998659280845 51.191070008585,16.1998960497293 51.1910073799647,16.1999400106424 51.1909479497181,16.2001046836524 51.1907668281331,16.2001400523418 51.1907213902246,16.2001539592654 51.1906771292826,16.200444651555 51.1906794700896,16.2006399273141 51.1906800782619,16.2007085598614 51.1906711919459,16.2007562117471 51.1906560095152,16.2008896806274 51.1905599007913,16.2009381293423 51.1905083111544,16.2009972074572 51.1904809521518,16.2011520779654 51.1904327621543,16.2012653103925 51.1903845809075,16.2015368036102 51.190193641059,16.2016123896193 51.1901469299265,16.201758059006 51.1900748680725,16.2019970325743 51.1900138889555,16.2021035520918 51.1899919378734,16.2023012784764 51.1899355616143,16.2024049715056 51.1898964198204,16.2025926097326 51.1898043014068,16.2026842977041 51.1897362517399,16.2028241412174 51.1896318998749,16.2029828680779 51.1894985788822,16.2030887335941 51.1894007418989,16.203158471178 51.189366229215,16.2032694784974 51.1893390802287,16.2034617999749 51.189306588952,16.2036149791004 51.1892689916533,16.2037912136501 51.1892149518258,16.2047283373348 51.1891954290576,16.205920062963 51.1891690895093,16.206520210613 51.1891550402918,16.2065778679665 51.1891545502537,16.2072355226249 51.189141888019,16.2079545707131 51.1891270381142,16.2088511914225 51.1891095717559,16.209293078282 51.1903796017703,16.2093381893352 51.1903752789341,16.2111669573059 51.1901965112822,16.2112922023081 51.1902628195637,16.2123611936976 51.1901635605947,16.2128702697911 51.1901168407116,16.2133604700549 51.1900687819742,16.2135353214295 51.1900518494075,16.2134617575622 51.1898533183436,16.2134152182303 51.1897279910975,16.2133736327701 51.1896381084828,16.2133319871719 51.1895523605645,16.2132657300775 51.189439629923,16.2145845800219 51.1891161216403,16.2148960875933 51.189037960562,16.2160785820311 51.1887429401197,16.2161303608905 51.1887153579747,16.2163002132898 51.188624871563,16.2165350222982 51.1885922490261,16.2167102269838 51.1885527484543,16.2168025764738 51.1885157987059,16.216880868695 51.1884698007539,16.2171633972445 51.1882829212211,16.217319718583 51.1882007304545,16.2174278918969 51.1881704881027,16.2175229927025 51.1881599916614,16.2176527931619 51.1881699280592,16.2177997104131 51.188198910313,16.2182198724027 51.1882877603474,16.2185372133648 51.1883567813399,16.2188530734274 51.1884315515294,16.2194085009215 51.188556331858,16.2196039871637 51.1886074402074,16.2197417183282 51.1886555295721,16.2199145475609 51.1887563592882,16.2200302230962 51.188806610071,16.2202435102007 51.1889395110311,16.2214398664586 51.1896792804345,16.2216378784989 51.1897947587897,16.2217409701477 51.1898895592869,16.2218328084642 51.190050300537,16.2219827025488 51.1902603518718,16.2221168705339 51.1904093015799,16.2223256623193 51.1906523079774,16.2223510781619 51.1907010405171,16.2223581518998 51.1907538421232,16.2223573625879 51.1908057117819,16.2223166416121 51.1908871018612,16.2219301418949 51.191303839894,16.2218349809512 51.1913792620092,16.2217218988692 51.1914276401464,16.2214213289053 51.1914987613021,16.2212922876888 51.1915419590364,16.2212211669298 51.191572070128,16.2211070775355 51.1916369914267,16.220834328936 51.1918319215855,16.2207582918916 51.1919112815069,16.2207164583619 51.191975669014,16.2206770679405 51.1920526487504,16.2205553184623 51.1923150597819,16.2204840097719 51.1924374117966,16.2204720423003 51.1924904102931,16.2204861070863 51.1926464480524,16.220538306912 51.1928816619689,16.2205612270255 51.1931120805125,16.2206231015597 51.1931788394541,16.2207315003912 51.1932575693265,16.2213266415487 51.1936428617889,16.2214543071074 51.1937118609047,16.2215959773139 51.1937827107893,16.2227251217859 51.1942845098119,16.2228455933306 51.1943293789262,16.2229590437581 51.1943593981356,16.2230926329145 51.1943789690326,16.2233486481021 51.194403689705,16.2234838835375 51.1944453910729,16.2236456924729 51.194520721306,16.2238055168527 51.1946368603376,16.2239230265985 51.1947501378967,16.2239688217221 51.1949708519356,16.2239987028147 51.1950167317534,16.2240419120022 51.195061128331,16.2243778732073 51.1953405813127,16.2244843025178 51.195446171399,16.2245201222426 51.1955291103488,16.2245237981808 51.1956215481622,16.2245041931772 51.1957548910317,16.2244945184687 51.1959100187202,16.2245012388956 51.1960286298191,16.2245237681118 51.1960948899718,16.2245903033446 51.1962279309428,16.2246439389662 51.1962840709336,16.2247584192578 51.1963607312701,16.2248280365656 51.1963971384763,16.2249006833276 51.1964166612445,16.2251473094625 51.1964521321279,16.225405436999 51.1964956405114,16.2258471584788 51.1965830116808,16.2261595230174 51.196657571854,16.2262978104588 51.1967089821019,16.226382740417 51.1967606417443,16.2264786681209 51.1968423687248,16.2266032666391 51.1969049710931,16.2267288799868 51.1969368279455,16.2269112486174 51.1969434609613,16.2271056899611 51.1969307112198,16.2272112021663 51.1969404682285,16.2273050400729 51.19695701139,16.2274647291422 51.1970015786058,16.2276525026798 51.1970716103019,16.2278163187225 51.1971620485848,16.2280120680688 51.1973246187272,16.2281952410457 51.1974866900807,16.2284362893766 51.1976998697837,16.228627550921 51.1978691691993,16.2288273219992 51.1980458716907,16.2289422608435 51.1981314402199,16.2291691466641 51.1982405480798,16.2293851399807 51.1983385600767,16.2300303911667 51.1986314803558,16.2301779097985 51.1987223911755,16.2302409269555 51.1987905983546,16.2302633584474 51.1988684487837,16.2302098581365 51.1991348107474,16.2301650177044 51.1992894483979,16.2301191925118 51.1994126317273,16.2299500768036 51.1997517293473,16.229824350697 51.1999697219246,16.2297311216881 51.2001106910121,16.2296245119635 51.2002153010222,16.229474151809 51.2003156013221,16.2293113806648 51.2003970614068,16.2290926886533 51.2004750780988,16.2289923107339 51.200526658985,16.228910680851 51.2005926084886,16.2285466577292 51.2009164011685,16.2282960399314 51.201128880817,16.2280800315803 51.201284489793,16.2278075911883 51.2014593896442,16.2275636863001 51.2016428520362,16.2274974968611 51.2017093090793,16.2274539418798 51.2018485805348,16.2274091315168 51.2021172220508,16.227407492755 51.2021975883005,16.2273302980531 51.2023807881721,16.2272610716426 51.20248112785,16.2271001121571 51.2025818306812,16.2268181699536 51.2026727283749,16.2261173662457 51.2029092811456,16.2252767791626 51.2031871896322,16.2251790698691 51.2032274515132,16.2250879832781 51.2032645106451,16.2250003095214 51.203303459924,16.2249317822157 51.2033595605367,16.2248976764252 51.203408428712,16.2248845663308 51.2035345085166,16.2248792967343 51.2036499299924,16.2249238364761 51.2037642795098,16.2250608234322 51.2040560884525,16.2250947788775 51.204170490474,16.2250866677583 51.2042681786957,16.2250586133589 51.2043574400122,16.2250183734876 51.204463191986,16.2249981821379 51.2045966179869,16.2250578917023 51.2048736601562,16.2251902780978 51.2052558111244,16.2253369322451 51.2054805898544,16.225521338052 51.2057230405836,16.2256261887387 51.2058169397607,16.2259360876173 51.2059448003289,16.226310649932 51.2060603180621,16.226459732153 51.2061240098902,16.2266209697769 51.2062182109657,16.2267190925195 51.2063131602245,16.2268189291964 51.2065263486782,16.2270333063031 51.2071038892159,16.227196483379 51.2075904401777,16.2272611468152 51.207771128604,16.2273366125481 51.2078704006989,16.2274809664151 51.2079351382332,16.2280412726083 51.2080565801772,16.228247929493 51.2081015017956,16.2283689197283 51.2081555503737,16.2284586682477 51.2082436303482,16.2285487174574 51.2083749693119,16.2285666385957 51.2085352380252,16.2283899079071 51.2092288913424,16.228329649583 51.2094078383833,16.2282319402895 51.2095512182833,16.2280905181524 51.2096264697603,16.2279348207461 51.2096531199577,16.2273628327371 51.209703440746,16.2271693836712 51.2097408280284,16.2270367792753 51.2098361579418,16.2268784583467 51.2101485091069,16.226864987424 51.2102395293101,16.2268926885123 51.2103199218118,16.2270026208641 51.2104084393204,16.2271798927951 51.2104896718875,16.2273810395311 51.2105576821764,16.2281224289041 51.2106796316598,16.2284053107646 51.2107486701536,16.2286100808181 51.2108429499853,16.2287316799511 51.2109229793338,16.2288400036101 51.2110456594991,16.2288923462636 51.2111230898955,16.2288659907641 51.2113339900462,16.228799417945 51.211513090224,16.2286584618777 51.2116736608359,16.2284265019093 51.2118746989697,16.2283269133018 51.2120641993313,16.2282624077281 51.2121780413092,16.2281864608907 51.2122904000468,16.2281245036668 51.2123623612679,16.2280368825308 51.212409221162,16.2279756319289 51.2124374902354,16.2276123304637 51.2125577420868,16.2261898776971 51.2130104585425,16.2258617194037 51.2131231104279,16.2257538317456 51.2131783490985,16.2256591819753 51.2132697805837,16.2255939171587 51.2133872978475,16.2255564210858 51.2135630990188,16.2256351868941 51.2137065314228,16.2256882512042 51.2137699301031,16.2259683967836 51.2139887496196,16.2263275111372 51.2141987003215,16.226718197966 51.2144008497918,16.2270794021168 51.214572870669,16.2275189736614 51.2147530909339,16.2275993406453 51.2148195698537,16.227600152509 51.2148843905195,16.2275848624103 51.2150592903706,16.2277747708486 51.2151825480808,16.227958161826 51.2152541811514,16.2282756230641 51.2154513821118,16.2290112091155 51.2159306612581,16.229622940857 51.2163555286731,16.2300457789898 51.216641142134,16.230202649088 51.2167469203598,16.2303449432268 51.2168213580235,16.2308071792982 51.2170151418432,16.2310059731331 51.2171242190756,16.2312346029571 51.2172721712062,16.2317953902547 51.2176690495696,16.232044760188 51.2178336192424,16.2322578969474 51.2179999303006,16.2325249474668 51.2182469182577,16.2328523164483 51.2185797110125,16.2329663908081 51.2187023211723,16.2330857122126 51.2188593783859,16.2331602082196 51.2190332587828,16.233182008262 51.2192696102878,16.2332093109358 51.2196489304107,16.2331187204837 51.219855722117,16.2328705533114 51.220162350337,16.2327892692223 51.2202195797875,16.2325283978873 51.2204021802375,16.2325143481358 51.2205692482296,16.2325214369082 51.2208008699918,16.2325401473584 51.220955131363,16.2324288468661 51.2211563620117,16.231962716856 51.2214985704987,16.2317896771402 51.2216727790461,16.2317353424138 51.2217115883141,16.2316502470759 51.2217468710579,16.2315566797904 51.2217999220584,16.2302858200083 51.2220203210728,16.2299289533143 51.222046118079,16.2297128171697 51.2220260615193,16.2294404068468 51.2219473491482,16.2292107997796 51.2218408402405,16.2289269030895 51.2216480014943,16.2287950203502 51.2215467211182,16.2286015412153 51.2214050082228,16.2284363871009 51.2213241913131,16.2281611127035 51.2212763119647,16.2278742767663 51.2212393403396,16.2273525867171 51.2212096580313,16.2266025073962 51.2211702099636,16.2261147126544 51.2211451480147,16.2256036895915 51.2209303100577,16.2250858333429 51.2207132713046,16.2245332323371 51.2205662292448,16.2237333887814 51.2203739111642,16.2234519427168 51.2203147478133,16.2231006463094 51.2202685398449,16.2226882571625 51.2203059708808,16.2223731713773 51.2203785621508,16.2219604589883 51.2205221695685,16.2218001910904 51.2206023695553,16.2217565985229 51.2206243206373,16.2215462581827 51.2207301294906,16.220230482796 51.2213825014726,16.2200159628616 51.2214901785961,16.2197789212281 51.2218940093752,16.219636589503 51.2220707512446,16.2194417497447 51.2223171310294,16.2189416492548 51.2226668913536,16.2181894124814 51.2231919715617,16.2180992279612 51.2233057085315,16.218128733191 51.2234507379348,16.2184389327598 51.2238477913118,16.2186877915197 51.2240768491245,16.2189234424608 51.2241796214917,16.2191810964102 51.2243456000241,16.2192343336172 51.2244789516442,16.218911437403 51.2250632302058,16.2188539604636 51.2252146782333,16.2190436809705 51.2262748319265,16.2190861083634 51.2264000497891,16.218847630934 51.2263946287425,16.2181169310991 51.2263710194066,16.2176723004412 51.226362010581,16.2173822471184 51.2263872212915,16.2171224582683 51.2264369995375,16.2165417201733 51.2265954787367,16.2160893918453 51.2267422320241,16.215660930805 51.2269072392309,16.2153773498397 51.2270446686681,16.2151913729263 51.2271870684919,16.2150761634608 51.2272538580608,16.2151246422447 51.2272891189279,16.2152658764505 51.2274261414585,16.2154146880502 51.2275951083483,16.2154857637057 51.2277492209579,16.2154357889878 51.2279218981362,16.2154795018315 51.2280473085138,16.2155984699249 51.2281642919861,16.2157128224232 51.228242050533,16.2157851534604 51.2283406006968,16.2158194772513 51.2284888109724,16.2158356017655 51.2286390120279,16.215909233288 51.228794288478,16.2160120016948 51.2289861821507,16.2162184781653 51.2292605684884,16.2163455122744 51.2293297513685,16.2165167177798 51.2294071905156,16.2165730896826 51.2295269917069,16.2165553264067 51.229657989394,16.2166071127832 51.2299232312707,16.2168240382396 51.2301552205614,16.2170009418251 51.2304530412215,16.2171043491986 51.2307253098946,16.2171962777222 51.2309134801528,16.2172591821205 51.2311412691168,16.2173278973575 51.2314029713432,16.2174144134569 51.2316468615594,16.2175287734724 51.2319708598803,16.2177311304866 51.2324035504036,16.2178135722332 51.2326107315152,16.2180131328282 51.2329208687581,16.2181291391228 51.2330935678131,16.2182914968179 51.2333717388202,16.2183954379166 51.2335340508174,16.2184464876021 51.2337592802075,16.2185433925492 51.2339087199537,16.2186742003209 51.2342217317952,16.2187043219657 51.2342897202073,16.2188932982642 51.234716062112,16.219251269995 51.235069060188,16.2194228663977 51.2352685013226,16.2191903125661 51.2356167784065,16.2191982132021 51.2363550120656,16.2192068805983 51.2367402695252,16.2191442017178 51.2369389887287,16.2192920135225 51.2375472091522,16.2194658801365 51.2382597420626,16.2195032484161 51.2383621994052,16.2195941094894 51.2386028606203,16.2198901690997 51.2389210003606,16.2202071793024 51.2393798379173,16.2202428411649 51.2394382312083,16.2204193012322 51.2396707805425,16.2205458392025 51.2398666295228,16.2205578292258 51.2399140494604,16.220478522175 51.2401586397311,16.2195073979414 51.2406599487156,16.2192413396998 51.2409310579235,16.2191062019887 51.2410697912121,16.2188800002384 51.2410599204445,16.2186893400745 51.2410765292361,16.2174465873125 51.241277208592,16.2174100233794 51.2413104305506,16.2174988472762 51.2415100904522,16.2175352007263 51.2415274911804,16.2176174169551 51.2415129781768,16.2176902967521 51.2416891993807,16.2174240430618 51.2417318589481,16.2172711571093 51.2413327185338,16.2172193632154 51.241312828237,16.2170989969124 51.2413323203778,16.2167268326023 51.2415853813072,16.216117867211 51.2418402186247,16.2159575617268 51.241930840672,16.2157567231982 51.2421219117807,16.2155222524664 51.2424966990512,16.2153668106468 51.2428167683165,16.215356068488 51.2428312900708,16.2153465290901 51.242854181851,16.2149922934356 51.2435046811873,16.2146816729004 51.2440320015696,16.2148788730771 51.2441362484264,16.2150390582852 51.24418876126,16.2149904968114 51.2442898009924,16.2145601188709 51.2444437298378,16.2142673818878 51.2446845091871,16.2140664381176 51.2448974219943,16.2139815307111 51.2449661279623,16.2136018867313 51.2450727987576,16.2134859781611 51.2450615497578,16.2134431824227 51.2450875480295,16.213188076823 51.2452580812911,16.2118560566461 51.2461485286621,16.210101536613 51.2457445009927,16.2100478107843 51.2457321494072,16.2099508607337 51.2460572109357,16.2096507793915 51.2460839792674,16.2095691795776 51.245624257892,16.20826644663 51.2453221406477,16.2074904027069 51.2453199486023,16.2064608994632 51.2453385919271,16.2056773608358 51.24536872052,16.2052230629867 51.2453483008071,16.2050763637358 51.2453223594147,16.2029663827355 51.2450061491995,16.2029646688011 51.2450050684905,16.2014965036008 51.2448077493959,16.1994643412345 51.244560932077,16.1993968888964 51.2445455615067,16.1983265218491 51.2442920017886,16.1982434937566 51.2441901701196,16.1968973411384 51.2438731810938,16.1964947018725 51.2435558901696,16.1967456429123 51.2420194806901,16.1957609274798 51.2418402405014,16.1954199973685 51.2417758311176,16.1956569262431 51.24090310825,16.1957309110766 51.2406330797511,16.1955827384436 51.2406539588748,16.1899407972634 51.2413793990389,16.1898155297094 51.2414013588716,16.1898458092166 51.2414774504139,16.1898013596819 51.241482748951,16.1868342386006 51.241850111269,16.1843359913279 51.2421652320245,16.1842530609597 51.2421754178166,16.1841956967791 51.2420777120935,16.1831953830405 51.2422934294938,16.1816238330184 51.2426317920567,16.1790000325359 51.2431870314851,16.178703837615 51.243265791985,16.1793165616343 51.2439624292842,16.1794955625342 51.2441670901998,16.1798773188629 51.2446187478231,16.1799617902685 51.2447163004093,16.1803904392402 51.2452300091081,16.180358220281 51.2455775292581,16.1803180179959 51.2460146520011,16.1802979619569 51.2462293499472,16.1802932711891 51.246265468381,16.1802623903015 51.2465942883268,16.1802293820304 51.2469881083273,16.1802281266486 51.2472522388675,16.1802350425241 51.2475568588064,16.1796474111054 51.2475335207415,16.1786104732955 51.2476514099092,16.1779024906081 51.247735801472,16.1771729409133 51.24784167158,16.1767237096948 51.2478690699606,16.176558307511 51.2478508379178,16.1756629572179 51.2478687899389,16.1750225020412 51.2478816184365,16.1742541182019 51.2480012402389,16.174197859058 51.2480107084752,16.1737259407608 51.248003388531,16.1736113627449 51.2480018221592,16.1728254712163 51.2479907306716,16.1723373607497 51.247983778256,16.1717112409802 51.2479691383675,16.1709459768022 51.2479582218936,16.1708663765784 51.2479541878299,16.1701684219106 51.2479066891361,16.1698304385636 51.2478859894014,16.1692844677775 51.2478518092434,16.1685533770453 51.247807942082,16.1675554387595 51.2477503101002,16.1657833508991 51.2476438318199,16.1657370671539 51.2475022983135,16.1656461534598 51.2472254617852,16.1651955691352 51.2469465119676,16.1652137007566 51.2468870685949,16.1651219300954 51.2468309286042,16.1649397569135 51.2463081585758,16.1649300371015 51.246241228996,16.1649215426022 51.2462203411216,16.1649068162977 51.2461780184554,16.1648544510924 51.2460426716801,16.164770603619 51.2458017216925,16.1647783614272 51.245746999312,16.1647642214686 51.2457045103828,16.1647477812298 51.2457016489103,16.1647490591633 51.2457282684804,16.1645260071433 51.2454846495353,16.1644916006625 51.2453962982896,16.1645235715523 51.2453287517868,16.164161472848 51.2442915686299,16.1641264123661 51.2443659494141,16.1638167690742 51.2434431814047,16.1638267219211 51.2434116702043,16.1637978631753 51.2433270379978,16.1636993194664 51.243119918141,16.1636269583602 51.2428890883155,16.1635455389604 51.2426363817887,16.1634987515591 51.2424894491124,16.1634702837106 51.2424094897693,16.1632938687468 51.2419257696526,16.1632027596041 51.2417202992992,16.1631807866648 51.2416350589204,16.1632678891101 51.2416203402758,16.1632187187386 51.2415851494142,16.1632025716727 51.2415176597908,16.1631943327601 51.2414731188271,16.1631732017535 51.2413632496581,16.1631451172851 51.2412735901856,16.1630089271581 51.2410135287119,16.1629400991622 51.2410205992617,16.1628484111908 51.2407899619511,16.1628336473 51.2407524084058,16.1626103096242 51.2401755110431,16.1624879813173 51.2398408981468,16.1625829768814 51.2397856594762,16.1627219784621 51.2396880893886,16.1626751083709 51.2396789886809,16.1626282307625 51.2396697917156,16.1625621691168 51.2396470311957,16.1624652867215 51.2396528985269,16.1623763425485 51.2396800212612,16.1620117781842 51.2387816413983,16.1619285170568 51.2385669478276,16.1619365229344 51.2384909306661,16.1618799029622 51.2383666097482,16.1618141871103 51.2379257985934,16.1617859823658 51.2378610304316,16.1616927308051 51.2378364410194,16.161598321587 51.2375431182091,16.1614760383836 51.2372565202967,16.1614696411988 51.2371755808774,16.1613768632252 51.2371988095588,16.1611859399573 51.2365949119715,16.1610075103689 51.2361820986189,16.1607910209134 51.2355983100953,16.1605101236084 51.2356433717246,16.160316659508 51.2356802908456,16.1601635781068 51.2357046089867,16.1596670483135 51.2357836101303,16.1588515914171 51.2359137108726,16.1585553213237 51.2359620321303,16.158175121067 51.2360241882139,16.1597092426714 51.2383317514124,16.1598093574868 51.2384336005828,16.159703943006 51.2385120679348,16.1593650200019 51.2388005209915,16.1585432937141 51.2393329998999,16.1579289384502 51.2394541793235,16.1579622098253 51.2394890289086,16.1580625727101 51.2400045314968,16.15797685344 51.2400112520194,16.1575327865763 51.2400424700721,16.1571215400523 51.2400605183507,16.156767251777 51.2401200886082,16.1564608033189 51.2403075281845,16.1563140815163 51.240312909853,16.1560067385047 51.2401576290275,16.155653758232 51.2399350904717,16.154560907072 51.2393296921427,16.1545137889114 51.2393043983007,16.1544842836816 51.2393306109641,16.1537755718204 51.2404909905765,16.153158382551 51.2415206087701,16.1528380873074 51.2420304715448,16.1527324924124 51.2422879296912,16.1525776670078 51.2424636302296,16.1523580804428 51.2426172921791,16.1514774263851 51.2430777092337,16.1503932802075 51.2436476191779,16.1502062583955 51.243769769927,16.1499683898639 51.2439800706561,16.1497369936897 51.2441755608585,16.1495420486899 51.2443513489037,16.14910810757 51.2447358100515,16.1487359507772 51.2450524884281,16.1485796595077 51.2451920399054,16.1483137215422 51.2454012205474,16.147974618124 51.2456687682283,16.1476300421435 51.2459396280419,16.1471150875557 51.2463283988998,16.1464383766534 51.2468439102387,16.1462164822908 51.247020560226,16.1460222814993 51.2471548087909,16.1458001390672 51.2473768616839,16.1456021195096 51.2476436086776,16.14538051832 51.2480932886471,16.1450703262684 51.2488471685229,16.1448384489899 51.2487815690465,16.144784159367 51.2487688280557,16.1441742092152 51.2486180013266,16.144028938243 51.2485819178955,16.1437484092836 51.248511339282,16.1435354379038 51.2484576888598,16.1430348337578 51.2483292813742,16.1428585616218 51.2482858692482,16.1424782636408 51.2481834512836,16.1425380784468 51.248337638274,16.1423408482011 51.2482857686154,16.1416896283138 51.2481129820536,16.1412024424697 51.2479889499082,16.1410333568305 51.2479437701447,16.140299176506 51.2477614278398,16.1401859064926 51.2477331281391,16.1400586393485 51.2477012581607,16.1401812908974 51.2475996015053,16.1397736526563 51.2474974110584,16.1394138016116 51.2474001997488,16.139348183484 51.247375899109,16.1394124485055 51.2472444813893,16.1394700908245 51.2471899909018,16.1396145273813 51.2470744994206,16.1397023289314 51.2470018993998,16.1404793125116 51.2464304187084,16.140645526559 51.2463143015535,16.1407349819054 51.2461971080649,16.1409282129709 51.2460860619293,16.1410562092888 51.245991348939,16.1411159414049 51.2459170906642,16.1412384726777 51.245763638731,16.1415825675539 51.2451030717367,16.1419794110154 51.244625870877,16.1422990522578 51.2442092684798,16.1425852792972 51.2439818601703,16.1431288295268 51.2438100886874,16.1435267930594 51.2435569315006,16.1435733774949 51.2435035611002,16.1437064028571 51.243357980404,16.1439170288529 51.2430524503944,16.1439873903691 51.2429249179768,16.1443116923102 51.2423491188245,16.1445076521396 51.2420230290911,16.1446145400026 51.2418450621264,16.1447110615697 51.2416467192022,16.1446571778787 51.2416363102677,16.1445650088029 51.2416178288305,16.1445722479204 51.2415863001287,16.1447247805619 51.2412874293869,16.1447896394467 51.2411642898109,16.1448372236771 51.2410745078289,16.1449038115308 51.2408636295549,16.1447464678454 51.2404583505382,16.1447367029299 51.240186620032,16.1447268929108 51.2400553204464,16.1447123996413 51.2399576190987,16.1447949616639 51.2396649919674,16.1448770876857 51.2395840919262,16.1449846671363 51.2395204788543,16.1451159109088 51.2394655989615,16.1453405490699 51.2394472881626,16.145734152594 51.2393705796973,16.1459496497718 51.2393121207762,16.1460604090217 51.2392448280432,16.1461102183599 51.2391600120724,16.1460909666673 51.2390776594183,16.1459269702104 51.2389537585331,16.1458137678523 51.2388458101384,16.145785480418 51.2387400494139,16.1458824530204 51.2386638003594,16.1460832013419 51.2386056302107,16.1464466230832 51.2386366688745,16.1465718831199 51.2386411886009,16.1467484935324 51.2385144087419,16.14689051705 51.2383175403073,16.1470600386901 51.237845410467,16.1471454497527 51.2377033781718,16.1473131973204 51.2376612480205,16.1476225925428 51.2375195219991,16.1479822030353 51.2373063597975,16.1481088086609 51.2372056000869,16.148193528136 51.2369721494325,16.1483694695127 51.2367396394762,16.1487171426027 51.2361783095742,16.1488339006229 51.2360365179227,16.1491810399877 51.2354832780248,16.1495950829309 51.2348385497623,16.1499361784219 51.2343110893691,16.1499990677856 51.2342076213229,16.1500293773618 51.2341623496773,16.15045343329 51.2335169519877,16.1505721984176 51.2332850808312,16.1506569178927 51.232872709388,16.150787011525 51.232425930269,16.1509663732532 51.2317623486653,16.1510693070396 51.2313347816654,16.1512600874796 51.2306481420186,16.151293103268 51.230452288663,16.1514197615143 51.2300410985617,16.1514839513633 51.2297974796165,16.1515644837268 51.2294251906654,16.1517084692483 51.2294179188499,16.1517594212094 51.229319521823,16.1517622401804 51.229285367917,16.1514667894679 51.229087620039,16.1511811036708 51.2287992807412,16.1511549135509 51.2287600514405,16.1510583619149 51.2286121780661,16.1508798872229 51.2284530600672,16.1508862693733 51.2281298011789,16.1508893213792 51.2278610896574,16.151249232562 51.227461638594,16.1512799104837 51.2274205103956,16.151340379291 51.2273402316527,16.1513993972678 51.2272245082784,16.1514699467154 51.2269999789428,16.1514855901251 51.2267695385226,16.1514882662683 51.226735030214,16.1514920324135 51.226592731023,16.1514577537262 51.2265352215508,16.1513488888248 51.2262736505846,16.1512229672695 51.22598818151,16.1511161921653 51.2257325610066,16.1510504763133 51.2255045401495,16.1511049613848 51.2252077389436,16.1510685628313 51.2251218116364,16.1507376983257 51.22491823143,16.1507302036214 51.2248218208075,16.1507605507839 51.2244945278555,16.1508918772462 51.224339041389,16.1508910277963 51.2242754808212,16.1508533813783 51.2242115702262,16.1501986509324 51.2236944793894,16.1499022605629 51.2235698084443,16.1497031209342 51.2234559095869,16.1494809033296 51.2232678180849,16.149363107928 51.2231131979358,16.1492954375895 51.2229074694373,16.1492597982788 51.2227683204913,16.149088021462 51.2226782716136,16.1484910085077 51.2223755899505,16.1479440529611 51.2220663802797,16.1478858318134 51.2220369911192,16.147781251748 51.2219680095048,16.1474420130192 51.221723931149,16.1470419822411 51.2213869599443,16.1469063634256 51.2214158415653,16.1467985734919 51.2214399015613,16.1467472231161 51.2213603710016,16.1466860101005 51.2212922207018,16.1462595336159 51.2207779388335,16.1462284196933 51.2207572084714,16.146154119135 51.2207322384046,16.144060300235 51.2209236289132,16.1434239269283 51.2209865506813,16.14199243842 51.221109519619,16.1410039869113 51.2211996910062,16.1404074400269 51.2212599919456,16.1397885518577 51.2213208179257,16.1395676121866 51.2213363591343,16.1375718032704 51.2215037990303,16.1373459999347 51.2215183995407,16.1362320779061 51.2215011607001,16.136144306425 51.2214901392181,16.135591788109 51.2215061179607,16.1355260572225 51.2215073518066,16.1352333427912 51.2215145404906,16.1349229628082 51.2215269620816,16.1341926012497 51.2215571300526,16.1341143015112 51.2215558699546,16.1333433918739 51.2215531178656,16.1332644005479 51.2215377385446,16.1327410266334 51.221741471888,16.1328324515009 51.2214047500777,16.1331513485349 51.2192610389962,16.1332399769831 51.2186617880202,16.1332697002134 51.2184584703342,16.1332881325251 51.2183644311462,16.1333435271845 51.2180097485641,16.1335139734471 51.2169025599632,16.1335776220536 51.2164550414118,16.1335838313071 51.2164138082052,16.133657620692 51.2159917803861,16.1336735121712 51.2158695815082,16.1337285535196 51.2155576897539,16.1337712816027 51.2152339714548,16.1337999674516 51.2150577983796,16.1338404027716 51.214807332027,16.1338842734776 51.2145571500715,16.1339428479364 51.2142487017099,16.1339601301079 51.2141662396722,16.1339896203032 51.213982891039,16.1341721618307 51.2128419510634,16.1341380635575 51.2128079021656,16.1336247778005 51.2126721091056,16.1334621118979 51.2126287494837,16.132882433736 51.2124428500272,16.1326076178912 51.2124414892964,16.1318494199337 51.2124051608463,16.131407848799 51.2124041895207,16.1311353708208 51.2124236116561,16.1304444974081 51.2124186018915,16.1297171577866 51.2124116319745,16.1289958921079 51.212302090956,16.1286741084476 51.2121821891318,16.1283746735893 51.212096909375,16.1273749762657 51.2118930185193,16.1266272498458 51.2117350687363,16.1265032226391 51.2117177686409,16.1262034870906 51.2116815802017,16.1260993806123 51.2115773420956,16.1259433524467 51.2116148212602,16.1257825132374 51.2116591084542,16.1256357613657 51.2116745096519,16.1254706598722 51.2116918097472,16.1252051879766 51.2116877800589,16.1248748872652 51.2116828096723,16.1248037514716 51.2116831115708,16.1246168123494 51.2116840303923,16.1240916117417 51.2116864105774,16.1232491303101 51.2115894005333,16.1228450702828 51.2115164811127,16.1228614278319 51.2114534412104,16.1230047518347 51.2107180690239,16.1230830215042 51.2102882487238,16.1231156012917 51.210089358882,16.1231338080858 51.209978409004,16.1231752883044 51.2097285902017,16.1232695772464 51.2091799881645,16.1233061787658 51.2089671803654,16.1233276931525 51.2088797085631,16.1234518030491 51.2083742298794,16.1235809870934 51.2079109294756,16.1236339987827 51.2077260713501,16.1237027666406 51.207479971587,16.1238365286939 51.2069925980612,16.1239180683697 51.2066841584503,16.123933403572 51.2066221117502,16.1240245878872 51.2062242620613,16.124108563154 51.2058546989471,16.1241810370191 51.2055132298926,16.1242561419238 51.2051319408665,16.1243375688408 51.2046273285002,16.1241328514082 51.2045486992605,16.1236749076899 51.2044632882435,16.123089591586 51.2043662300707,16.1230828711591 51.2043653900054,16.1219230036618 51.2041776091526,16.1219373014827 51.204134420169,16.1220322895296 51.2038256917856,16.1222325116431 51.2030949005803,16.1222928676916 51.2030977095488,16.1233014804808 51.2002926001584,16.123632126986 51.1993728205063,16.1247174984763 51.1995913512505,16.1250009591656 51.1996526497674,16.1261617512853 51.1998832083219,16.1277761421494 51.2001662184552,16.1282359726989 51.2002466809624,16.1284398707506 51.2002719879304,16.1283599623193 51.2001806395767,16.1282420767107 51.2001650721161,16.1272530087871 51.1996186008695,16.1268982469246 51.1994631187784,16.1261650588779 51.1991585994724,16.1261869416102 51.1991234611148,16.1250187825795 51.1986470696931,16.1246205784947 51.1984766283136,16.1243036735335 51.1983401089471,16.1239448373183 51.1981799189899,16.1239018536485 51.1981608381311,16.123621730621 51.1980120809379,16.1233169134074 51.1978231887486,16.1228815665607 51.1975513401082,16.1227515706527 51.1974620919178,16.122348848697 51.1972153796071,16.1218677593475 51.1969177820894,16.1209890672937 51.1963782501324,16.1209238701324 51.19633874081,16.1192789516917 51.1953129685404,16.1176735815349 51.1942886182564,16.1175713318187 51.1942601785448,16.1172481875351 51.1941107519246,16.1169804303936 51.1939614915673,16.1166966013588 51.1938041587072,16.1163748477675 51.1935995284191,16.1163427490844 51.1935799618975,16.1158248326978 51.1932224615963,16.1155757935237 51.1930523396167,16.1154112407899 51.1928633817974,16.1148484163159 51.1925294908322,16.1147763333481 51.1925391209561,16.1146970413318 51.1925055708471,16.1146884791773 51.1924564401514,16.1145101022096 51.1923708978742,16.1142503208768 51.1922491015276,16.1138828774035 51.1920743591887,16.1132743104268 51.1918090210546,16.1130160175106 51.1917066380928,16.1123920702281 51.1914603589408,16.1123080122715 51.1914433301165,16.1116110122952 51.1911571391108,16.1109178085331 51.1909119581692,16.109766841467 51.1905109319832,16.1091737675549 51.1902569609831,16.1090310524497 51.1901822783003,16.1089595783797 51.1901413907457,16.1079408774328 51.1897607580206,16.1070170367394 51.1894039490233,16.1068948512604 51.189357601044,16.1063218033183 51.1891656592426,16.1061581902414 51.1891143408768,16.1054844185862 51.1888301187741,16.1038333810991 51.1881986784199,16.1031214067488 51.1879402401974,16.1024836126808 51.187688001832,16.1024759225279 51.1876850878554,16.1012121364837 51.1872448498701,16.1011278530094 51.187212971141,16.1010004505547 51.1871611014824,16.1009251276496 51.1871319617163,16.1002802523264 51.1868766212347,16.0998859572147 51.1867172582167,16.0995095907585 51.1865779517585,16.0992574695095 51.1864787190416,16.0990156168322 51.186369921831,16.0988181610689 51.1863048386448,16.0987398237441 51.1862774008861,16.0984012390166 51.1861482495926,16.0983580598982 51.1861349091801,16.0978730991618 51.1859623282593,16.0977431032538 51.1859480296474,16.0976038235347 51.1858635505778,16.0963233867684 51.1853667088157,16.0949876004462 51.1848613220141,16.0941950937324 51.184564582063,16.0937224011579 51.1843864707121,16.0928038375782 51.1840365003716,16.0916958090783 51.1836255202866,16.0908452090102 51.1832996011913,16.0902117975024 51.183061521427,16.0899826790567 51.1829790987673,16.0898890065297 51.1829652420648,16.089782802737 51.1830615389283,16.0881457398288 51.1825789213974,16.0863930089026 51.1820841097932,16.0847095870767 51.1816307020338,16.084314968723 51.1815496007269,16.0838173263758 51.1814816385668,16.0834631508593 51.1813591990452))"

Czy jest jakiś sposób na obejście tego ? Tak aby zmusić jdbc aby sam użył limit lub żeby nie cachował całego ResultSet a tylko 10, 100 rekordów?

Mam pomysł aby użyć limit i wtedy zapamiętać ostatni pobrany id i w kolejnej iteracji użyć WHERE id > lastId. Ale nie chciałbym używać tego rozwiązania.

Czy ktoś ma jakiś pomysł?

Pozdrawiam
Patryk S.

Ostatnio edytowany przez smdvq (2009-10-06 08:47:21)

2

Odp: org.postgresql.util.PSQLException: Ran out of memory retrieving query