Search Postgresql Archives

Re: Out of memory error in 8.1.0 Win32

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I've zipped the results of EXPLAIN INSERT INTO "tblSummary" SELECT *
FROM "qrySummary"; for my case.  It's a zip file that I've renamed to
.txt in order to get around the attachment being blocked by certain mail
servers.
PKyÖ4¨y?ï?ýexplain.txtí]]oÇÕ¾/Ðÿ@(?É`ç{ÖHHvÓº¯å:? ½)i#?H?¢Ú¸ýíïì??ý??%?»3+>Ö?¤¨3g¾Î?ó?3?üø§?½{òî÷¿ûózu{ruµÎ®æ?l6ûâbu·ù?`BQ?¦Ï#LgëÕî¾¥?Íþ³¸Ü|ú?$äËßÿn6ûú»Ùì|µÞx?¤?Hßo?ßÿ¿ìóËÙ?_×?ßÿp?mÞϯ²»èÅÙüâÓb?½yýâ+ûÍ÷ëÅrójuû¹xûöþçëÅz±ùùúÕêzµÎ?Q<俪_<¿¿½½^dÅëæ¹|ë«eñ?ùÏò¥â»áÃïæ7Yùçÿ¾È®/õKð³ó7onV˳l~w¿În²å¦%aþnñZÝê\s?ß}?½Í~ÙÌþºZ,:L¸d??R??"?ôëP|ß«Õòòåì?«{Ý?Fcµ?fßÎ^,?ËîËÖ÷<$E	7²%?°®l8¥ÖwöHX*»#`ýªç»?#.K)?HjI©¤ç?NYó1Ò´|©÷»rYϲõUæ?3AL9)¢Ø?S²ÞïÀ·wÅ-f@G^óÚ_Z?íÖ±HõÈÙ%'H?ë?Br#½H·øC?V¶lÄìäÝëF?ë£ùéúÕîç???5úÊ׿ܺ=ú©?IÊQ¢ûZ?§?q¤?úâ[ÿ9@ôZôéN¦iªWªWD¬¬°@X¸t?ùGÑ  _?J¤©´ÐcBA?´õ?Ú[ËöB?;?ׯAõÎ&óa&S)	C?Ùê?b?¿?Ô?k¢O½?Ð$?(aZ½?0ªônGlõ
µ³?É*Чj"??zsÖ?~??R=¢ªNö$`â
ô©'?i{Næ{<NK1RÜV;ße}õáY(ÐÓ©÷J"AJ?V¹6°Ýl?úixFÝèé?2©²\UÊ9Q?§?ÎØï"dãÙu	 §c$W?èí#¤%O?r?ÓôË??gÚ=??Nâ?¥Do&z)ã?³$EÜa??Ã-e6?uWz:?ê#åH?¸?¦*Ñö?rØ\äÐË??c·?èõgáD?nçî,Lx?¤ÃpÀ»ý??c¶`ŨRúà.tçÑTïl©ÃêÆÃlg>ô?9L?9?[G@ÆlZÞ?.¿Þ×Q$BtP}Ò'?å^&?Ý7r¬?Ô?ê?Ä].Ú4Uk¤4G?þ¯`¡??kýäö6[^Ö¾7EU¹ú&ú?9Cé`?ûº8e?"aÖ!?rj3Ý?Ðh?"T"*ë¦$,ì¶êÉaµÅ´8?ßÜ^[?«ç#í?ä
24·lä=û.»Ûd?³·«ÕmÕÁ?'?%?!¥bë[@1f³_gçóålµ?µ{Ï44AI?ô	?j¡®¦J?B3÷åm>
«u®?²Åüzñ߬Ýúß²óL¿
y ÜVçÕ³ªÝsyCÃn¢c# ©^Û£???j7#?Ï.k¨ÚAIîÉ+ÛAe*âÜ|\×^ð ¯gª?e±Øúà^U¬Nl¯0?!føAL?w?QáÎ`­?Jb¥
+??ÏúQ¢Ô?$	­ö?±¼IÏâØY¼¦ñ#­ç±?¯éñs???"¸ZÂé!???x?mÖ??®3ϼ?gÅ©s¬õ]è<?²¢ò??Mf¹ÍWû?¥þæ;Á´Â³Õ??ù*J?¹~?® ?¬Ýíß|=¿ÉtÏä<m{HMÈ,è-ðûŵnAáÙoµçÅ?/_n²ß6z?ýñÕ?³ó?Âì?ÓÅæf~;ûK¦ÿ±ûæ§ùõ}£sê???Ô¶?2rBSøéCvñ)»ø?Mb7m-×?nÛÛ?öìWöã?åeö[£#jÿÏÅåo?yVv¨£ÃYËm@#'Ò?ÕvkvZ¦ô! ¥ùá? wR"HÞNðJ¥^<?ª)§T5?bªª&??duúà´?ÞÜ̯º?eóZÀméó?,ç×?ïl??äD?Ò7ÂÊy ?RÝÅA?@}ÜÉ}ðP?@Ã8§Çqu»þD9?.NFõN¬n?×?«Åf~],Ýy?ªÉzÚɦ]Ý)È1E\ ?Í@MTlàÛ¸"t*m.W+?ƨDØ8Í?Y²}òch8HBi?Èû´q⹿[,¯JÒÌ]Ù88ôôù¢iðQÊíáVÈÇ÷ï\ÚÐ/ç®??å¥S/¬&Å?)í?ccJøÒÞcAÃõQ¯æïçýßeËõ¿ÿÍþø??ïÕÂôEm¿¿ÊÅ)÷°<?Ëäæ7ö°?'¯OV½Æûºþ[=Ø;ÏG£^ø<.°óN[n°b¨XC$Þh­v?%î­ïìönÞÜöz¸,©¬@E?¥®6áö?-.ì¼ûÞ¸=õ.öÅ??»??ó«fåõÉ+³uÍþöaæüÌ7?ùÕwæS´Ôòß ?S²ô¿åj^xË:Ü??mqw¶º¼·Ù?A·Ð0?ÚméFêÎæëÕ?ËÅ/«õÍbóy,Cɦ¤!8¢%E? ÔD|	6?§ÑÎäíô??Òë?×J?i¼ÑM?i¼5>ï¤PþýÏ¿ÞgëÏ0Z"6ú?)3@	ÎJh8}0??U*®#<N«@nCx?ùSMÝ?ùo_t"z/¾?}óÝ,yùòruÿóu6»]g?»ÅjÒºßâÐF%Ô?Ò@$L­âd/¼úç?°BÿTòjÔKZåø<±Õá0
&`>	­c»Ò?p)Ãqñ »©ð)?èÓâbs??ìXzVT'À?	O?çF{L?ü°)P	e???7Oæ?É86Ä!fÙ»Ç)U7âkÀiQU­¢?
_BÔëuíS¢E?9
Ð]<ô?äÅÚQ>Tc?Æ3&Î)?ª¥ÉZxt)À³"MºS3U¢(õ?ÍÐå2Ρpï?HÊi5Ð?­ÛÍÄ?b¼yÛ© uR6O+?yhlO:??N??QøHí«ª? cçH94?L°¹§2IÊdÖ"ö0)W6çÔ??ª/k1L?jÃ5"­äÓÄÎT <LTnØÚ?ÁÙ??dÏ@?ßw¢ÿ-m§ª?MhA?GsfÂo ÉÈêçμùáuöKv±9?//õtë0µ?Ä»P#6妨?VË*0Õu£Ö?våwÔ¾¨ö"U]í%	¡'ñp$¼ºÕ[{ZUu1·&?SÕ%^þÃ.l?ü|»R±·©ÒòÓéù_VëÅWËÍü:oÅäyc)<NBô?o?W'QÌÔ)1s&¸:%?-¥¨K?ß	¸ø·?Ñ4?b*ë[ .­;o`Ê,Ë??W)ò'à¡]??qN?¢TJ][S?÷O>ºß?Ryi?üúsøiaL%B|?i]ú$Îv<­3õNªÛ£ãâëau¬?^ÄÎÁx|a?r?©ÈaÆ®ê^®z÷?ï"+Øñ¤@+¥QOQÀt?ø=3?/Fr,@èqö<«¢#Ó/4²3£ ?â"S((2?""6"ÈÂ!?&>Y,$?!CAR½i ?ÇnáÑÄF	ܶ«???oæͳ×W­W»õ?ÌëãP
ÅZ?@¦?²?¬?-ð?Ê?%Â.ïaIk|¶FZ9æmK¶C³¸i?ñJ\Ê[!¯? ÑäJæH?0!ÁX??Êþ8__e]ªGõbRûTÎJv?¤?×õ^8¯\¾Aè/Ó¦??Y7zÀó*W??T¦ÁÖÙ??<«ÔÏÇÑÃkyz7½{?$?	6)§?	?©]Ë?Êb¹?ùë4
²´??çÀ9jbÒ×?ñ'¢¸¸Ù<?^#?©	ãðÐV
ï¦?W?Q5à´çªæP??KBÛÆ?rx-vºRS¦.5Ñ]Öç7Aóu»x?j?+/?@pÌÍL?ÜÔÄä?NMt'`ªh???Ëq*"-ìáÞã?cÊ$ÚhÎÉçZ²¤o¿?~±?çs7NËV@¢¨Ø!ʾ¬3â-×à\±pqX?VCNsbÂEI?Ä??^9;ô?×ÞÁ? sÚpuº¯É$p³\ÃláÎd(wy???õ±£¬µ$Qjq
?xN&*
^r@?1ì&¬UµÖdZÝÕ-X¨?¡lËX£ê?£p?w7ÈÓëÕÅ¿N^u£9±4	Poy'ëlþjõïl=¿Êòé??qO?¶Ö&_V9É!?×­ñ±-3¨V¶&b¾Î®7ó?
sZ/Üd^R!Ïéû¨zlÓ."v8?ó?]­W÷ËK?xÙ|Ëb_6ß??YèÖ&_Ö"u??k¥wÓ£?\3|c¢!éPqÆ,ÖW¬¯ØW3g}±¡âöûÉ9J³0]ã?xø¢^Å2Dd©Xmâáö?bE°?­k??i?%?¥¦"$1K:vV¨??I6?Á?µ`è?6Þöh?í¦|?Ü$Y??¾?8Qr"Ië θ??æ?ñò©\µ?"¤]àÛ{U?´ÐÛ¢çHÙ>zIÞ~ôw?¤Ñ4?¦<¾ò¼9©¤µ]ÃG?m?é¾=Ì=ÜP*R*Â^<W~ÕS9U´ºê=2JÕö4*ÛuO¶¿??)pK?
¡ÆA??úî?Ç?b¢¿?çõ?¾f?ô1Ë)JL­B?Ï¡ÌÊh·;?<wϾ??)³?êN}8U'®®uwj3±ÊÕâ «B?nW|¬.k£ã@å92$?ï¶,¢0¥4ÍÞBzËâ­£Õ#?½ÛÒV"-?ø?À?*]:?$	ÖÛ¨B?Lâ+Vr¨¹MNù?]¯æ61¥z¹KJ©Þ??⦢??ÔaÛ4A?zÍ3ÚÉàzxbÊ
áXUo²?Éôr'Ãv"U*ì8q?7¥?<O?SÂks4Oa-UI?/äéóRTƨÄ(-˺?ó1:½?xx^??¬Ð¬^BM¹??fG¶j㡼?M?b«bT¥?RÏRRÜÝK®AÂÓ$Å?Gqãã
(®ï.QésµÇ[îòÖ?HQªwïò!à¡pN&õv?ãiÀm«Ä\¸Ã?3Ó)ÓÑ?8L
Äs¨øY?8¦Âq?!i?;$HQL4Âv¶? ¾ùáäû¯?¾§I4QÄF7>å?¼[»ÝKl¸}õ?¿c¿û¶Ñ±º_/>éß?þØìßóõçÅòêËÙÉ»×}Cã?ú°ó±'í=??Ç<H§(`®Q@??|>Xc$Oköd7ãqÙÛ?TÝþ©?&Ò{8ôÐ(Ye"aAÇ6{Ü+¡?cs¬GK?±?Â"{.?dû?GzKi,ÝØO?O¦hTEæ±³KÐ?Ö?ú?­6?ëì?ïξ·"?­·ºÑ?Ö?CD?ܱ??]å&µrÙ`Ê?Yl_ûbËFÚ²
t??ÏSÊyá*-?KÄ(ÂÂö?{Hó{ä@?s?¯q®?p?H1¯6ÄË|}I?0w=㤺g,S/?ü?fY??Íê!k´?ÉdlÍâ?L¼ñI¦-bÐ3?\g??{£Ó3É èF¡]mìàîÚÆøÖ¶Û1?|È[óé?@>
,?ã? Î ý:*íFúu@WÒø(3Eâh-ô¶?°TÖôª*ë:ÐÛú»D?¸?¤)·qÙ??Á5M?óy$%÷q¤&??<ÉDdÛ7{
²5"§?|ì?nóY?ù¬ñví1?5.FN`çô0/bÊh
I~Û´ñ>?¹Ñ=0îû[èà?u;;¸Ë\ýÉu¡\X`Oè6¥±ÊOÞcoõî¶ÆelMX<PHÁ¢ñHJ?D~ç
<ïqu4:Ä?kxNÎ7óf?ù«Ö«]Ú?yý°?7WþvGyLVÊxåüK*?¡f¤:8Æéìã?	?¯Ä¢l`±¡?r¼JK?T¥Ò8RæúQñG??¾?Íið©?á"¥I«s?DÉWã¼JA?Ó,_áav??1_!©LGg'DÎEØ?y ?Åòänü¼?§R
$?	Õ`Ä?ú Ѳ83~?¦/_^®î¾Îf·ëìbq·X-G??O?õ%Ç¡{øã	Îé ym+?©q??ÆðnNJïû2H?N{¥???T?½??wZ/??ùè^ÇXàÃrÂa}N9Õ?8çÀO?Ð¢Ç >À9"-çaÍ?)òèN?TÑ¢?ü,Ç??¡?/?{?(Ìç¨ÚxN?©¾ý¦?,?yjfTl©íyR*??Ø<??²oHU,.¢ë
Ú?ËDÄÚ @,ik??+d9Ék4qð?Èù????0>Åc¢\¬Ð?WÖ?N?3?Vø?c1?{×cI«4	aÇØ?°V»yjÁQ?®?$`|?ma¸k²
æ³úõ±Å×FJ?Ze­PX?±D?`X"?;ÈÍc;l»gÒM?«túa¾Y¬l¶RõºÅWªÞ9c©P?ÍU*ÿnGq´¡8qPÅráþ¼^ÝßZD%?@?ûyÈá²\¬³LïV-kÀ!R2?HÊr?Õ£ªÅ
©^-?¶ýÐåX³¼ÐåëÝßé=D¸ÙÝi>1Ñ??ª¸
)±ý?QäP;_ÐäEf³?ÎhÃy??àh#TÊ£
¯bC"AÚ?çÈð©9D¢¤?¸¨?6¼|??É?6ìøÖ3(õáÒFÞ?£`Ú?dµ§Èh?6?ïX®*ÆrUA?;mx·ÏÐé?6Ü!? 6b¤?Úè#íÄ{\V$Ú¨
ç??HjcJÔRÖ?έqMt'Z?ôS?0z¤?TÏ?¢j£oÿ?iÕÆ´h¬6lÚC¼ÄVÎ5)~ª«?©?_m¸0¦ÃÚ°é+S ÈÚpuô?)³6B$ÑÚÈ»éXâðM4%?¢ÞÚð?"?#ãÚ?-ÖÛ?µÖF@صaÛ²ARxm¸¶º¨H½6B©VØ?m9@üµa??¨À6?¼?¹PmølÂS?ðÔË&<
?Mxzdî^ÒÛ?M¸¼?=²	÷	???lÂ!à¥CÙ?£b[6áé?M8?lÂ#?pLÙ?!À»}Ù?câÈ&,	OG6áppN #?ðá¿0&¬9vdÙ?ÁàÈ&<²	?l¸à\??lÂ#?ðÈ&®?>²	?lÂ1qd?SÄ?MxPXkí?M8$\[Ý?M¸wØ?Ó?Mx0?Ä&,?7_°Í|ë¼
ù­?'øÖÁÜ?T?B,ÎßÛq9f&?ÂêóÒËÆâí?ÄÌó*glî]x?OU¡ðçÂgÈy?ø¡qàl?xð,·myloGà±5ÈBq3Õ"å¢EÀ6k?èùdÑ0ƺg¦à8aÞ
#DÖ?Û»*¯+æV_l:n?å»
?}åÈ1ð«bgPYc=V?TwÀGÃ?òD("â9M?ÉÔ·ÄÍU???dÇhââ9g??¢)q?\´?±?ìèU¬¼WgM?Ù
w'Wõ?Ø9!òo¬y9:ÃÆc¡Á¡	?%c­L?ò`l+*¦?kq?Ë2[ÅÞÑGâ£X}(ãdpNI¡??$ ,õØe?!¢ÊáK	3?}²û2Ðæ?ü}?]_Z<ójÍ#Ùõ¯Mµx"ðwj?D?èÀ«Õ{n=ÀL
? R?@9F?8Dد
_ÍÑ·Ù/?ö¡/?(¡	Bµ4Â?­O%¥
é¢?º&ÇáÎWnfÃCWíre?ë?,®>µ?ÄôÎ?ym?Ñr¥?
¶?¶n%_S÷1åÕY%@}V)Î?77«eÏ¡Eé?Uª5ñ?CÝÍ¢ìh¦?(çS?ª?é fc+É"ÙÝæÍò?Õú&¿N|¹×íc8Ï%¬`Ø??II`(ë®­õ«cMj?RTjtj&Á ?½®?ËrwÊÿ-'§?jøêq?32U?Èpïj«Ë캻R?¯?$§kp?³Ä><д£Ý`bîÅð$U÷c2r÷|!?e8?í÷ó?Åõçθ­^@ê?A\L/{$cÒQ~??u=RXáJ/-"Ð@¸_??Ãõ0\3º?äz?Õ'ÏâGÙïJUvû¡]âΠÉ|½Y/.¯²Üèhj@1·q?ó?>&¢´¡º¶>&?O8'?±1ãHjrºÚ??Þ¶ãÏæËûùu'ÖQû?nï¾^\ ÏI©?{ôÐg÷??äÜÁ$Ekk+Mª(ßÞôð8KºÍ´<'?ì,?k?:ú±ã!×ÿ¤Ê¡?½?Ó?²BÃR??öÁy_yîiúÀa~O2Y3VI¬??+F?J¤*S?²Ý?Ëzº¶æW±¹fj??ä? ??ì:/?3RHÌ	äti??X²/?ÜÇ?CeµyÛX&c)?HY9?xÊö?ìèié@?VyËû?¨?y?A(%xkÀ?ë?Ì?Ú¯±°MêÓO§ç?eëÍâb~½_î\®?§æ6	©×?e??Ìm
0o©¡· ~?Hæ±wt?ä#'ß@á	´?QÓ÷¥
Ï??¥î?àö?1(¦¥Õ6Oz*rngÏØ?pX?1ÖÉQê#-2î??ª§è!{
à:Ä?QäøÃãç«X£+Ä\Ë??Ôµ??M?&j¨øL?[6?GBèL?Ù6×F Nó´fnÉ`ϵèlGÁR¨NhÛá´¢ÁРݴæ!ô?#áAº?¥£Y@ØY<þÓ?+?ª\±Xªõ?­k?4ªÎ9f»ü¶?w%?4·?ÐyGFÇ!¨è«K?¨xl¯¸×ëGäK°ár±VÄØ8!]??Q¯f_¼¸¹»ù8¿j1qO^?%lö·3çg¾Ù̯¾3?ÚAB;ÕæSãýù?¬
h[ÆôelÍ?>?_¬W?.9]h±ùüØ?Åò?SÊ$Ó?~N4?GÒÞ_m®?ì6w;(Ï£W
$;ª0??Ü×(?׺+E7???½ìä³q¶í`	@¾
k?n!Ó?3r1Ù#?ý?,?ݯ³åÝVÇ~OÃ1ðXÖf8)êJ?§rrI^ùt÷?¯ãZm
BíÐ+Áz¥¯6èªÒÇÁQ~up.!?pî? L*iÝ3é¸ní=wn;Q?W?QH?ÎXÂw´ì?¦?â)ÕÓvê+ÀC+sPÇÑöþ8,uÈÙZRhÇ-\ò$çëð"Ûʳ^?KiÖ<ÚÁïö·½~Ó?cÖ?·¾£ÞÇ?z Ð¢Çì³?³m©Òºµúþü¤¤Ô
}?0¤ZÝ
mr&\ò?A±³+x¸Ò9C»?­¥Õ_òf?®V?ñê«f³¯ÕrX?UÖV1B?n{Ììÿ÷äâ1?Ø'÷_æ¡ ÙCk??ØÇl?X<1,a$P¢
óÉä<?w{ëe»Ä¶ßö??=Jf?i+?¯)ò?{?$	??ÿX-]©wÛ~½-M?+ó÷4?hÛ§;¾ÜL¯¢y"gU¿Åü®¯?K¤óûÛÛë?K&÷÷þ?PKyÖ4¨y?ï?ý ¶?explain.txtPK9

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux