diff options
-rw-r--r-- | doc/FAQ_japanese | 43 | ||||
-rw-r--r-- | doc/FAQ_russian | 79 | ||||
-rw-r--r-- | doc/src/FAQ/FAQ_japanese.html | 53 | ||||
-rw-r--r-- | doc/src/FAQ/FAQ_russian.html | 90 |
4 files changed, 124 insertions, 141 deletions
diff --git a/doc/FAQ_japanese b/doc/FAQ_japanese index 5436d5bfcde..21c124e2824 100644 --- a/doc/FAQ_japanese +++ b/doc/FAQ_japanese @@ -18,7 +18,7 @@ Maintainer of Japanese Translation: Jun Kuwamura (juk at PostgreSQL.jp) ÆüËܸìÈǤΤ³¤Îʸ½ñ¤Ï ËÜ²È "Docs" ¤Î "Frequently Asked Questions" ¤Î ¤È¤³¤í¤Ë "Japanese FAQ" ¤È¤¤¤¦¸«½Ð¤Ç¤¢¤ê¤Þ¤¹¡£¤Þ¤¿¡¢°Ê²¼¤Î¥µ¥¤¥È¤Ë¤â ¤¢¤ê¤Þ¤¹¡£ - http://www.PostgreSQL.jp/subcommittee/jpugdoc/ + http://www.PostgreSQL.jp/wg/jpugdoc/ http://www.rccm.co.jp/~juk/pgsql/ http://www.linux.or.jp/JF/ @@ -231,25 +231,17 @@ SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. 1.4) Unix°Ê³°¤Î°Ü¿¢ÈǤǻȤ¨¤ë¤â¤Î¤Ï¡© -¥¯¥é¥¤¥¢¥ó¥È +¥Ð¡¼¥¸¥ç¥ó8.0¤Ë¤Ê¤ê¡¢PostgreSQL ¤Ï¡¢Win2000, WinXP, Win2003¤Ê¤É¤Î Microsoft +Windows NT¥Ù¡¼¥¹¤Î¥ª¥Ú¥ì¡¼¥Æ¥£¥ó¥°¥·¥¹¥Æ¥à¤Ç¥Í¥¤¥Æ¥£¥Ö¤ËÁö¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿¡£ +¥Ñ¥Ã¥±¡¼¥¸¤Ë¤Ê¤Ã¤¿¥¤¥ó¥¹¥È¡¼¥é¤¬¡¢http://pgfoundry.org/projects/pginstaller¤«¤é +Æþ¼ê¤Ç¤¤Þ¤¹¡£ -¥Ð¡¼¥¸¥ç¥ó8.0¤Ë¤Ê¤ê¡¢PostgreSQL ¤Ï¡¢Win2000, WinXP, Win2003¤Ê¤É¤ÎMicrosoft -Windows NT¥Ù¡¼¥¹¤Î¥ª¥Ú¥ì¡¼¥Æ¥£¥ó¥°¥·¥¹¥Æ¥à¤Ç¥Í¥¤¥Æ¥£¥Ö¤ËÁö¤ë¤è¤¦¤Ë¤ê¤Þ¤·¤¿¡£¥Ñ -¥Ã¥±¡¼¥¸¤Ë¤Ê¤Ã¤¿¥¤¥ó¥¹¥È¡¼¥é¤¬¡¢http://pgfoundry.org/projects/pginstaller¤«¤éÆþ -¼ê¤Ç¤¤Þ¤¹¡£ - -¥µ¡¼¥Ð - -¸½ºß¡¢Cygnus Unix/NT °Ü¿¢¥é¥¤¥Ö¥é¥ê¤Î Cygwin ¤ò»È¤Ã¤Æ¡¢PostgreSQL ¥Ç¡¼¥¿¥Ù¡¼¥¹ -¥µ¡¼¥Ð¤Ï Windows NT ¤È Win2k ¾å¤Ç²ÔƯ¤·¤Æ¤¤¤Þ¤¹¡£ÇÛÉۤ˴ޤޤì¤ëpgsql/doc/ -FAQ_MSWIN¡¢¤¢¤ë¤¤¤Ï¡¢ http://www.PostgreSQL.org/docs/faqs/text/FAQ_MSWIN¤Ë¤¢¤ë -MS Windows FAQ ¤ò¤´Í÷²¼¤µ¤¤¡£ - -MS Win NT/2000/XP ¥Í¥¤¥Æ¥£¥ÖÈǤؤΰܿ¢¤¬¸½ºß¿Ê¹ÔÃæ¤Ç¤¹¡£¤â¤Ã¤È¾Ü¤·¤¤WindowsÈÇ -PostgreSQL¤Î¶á¶·¤Ï¡¢http://techdocs.postgresql.org/guides/Windows¤È http:// -momjian.postgresql.org/main/writings/pgsql/win32.html ¤ò¸«¤Æ¤¯¤À¤µ¤¤¡£ + [ÌõÃí + pgInstaller ¤ÎÆþ¼ê¤ÏFTP¥ß¥é¡¼¥µ¥¤¥È¤Î win32 ¥Ç¥£¥ì¥¯¥È¥ê¤«¤é¤â²Äǽ¤Ç¤¹¡£ + http://www.postgresql.org/mirrors-ftp.html + ] -Novell Netware 6 ¤Î°Ü¿¢¤â¤¢¤ê¤Þ¤¹¡£ http://forge.novell.com. +¼¡¤Î¥µ¥¤¥È¤Ë Novell Netware 6 ¤Ø¤Î°Ü¿¢¤â¤¢¤ê¤Þ¤¹¡£ http://forge.novell.com 1.5) PostgreSQL ¤Ï¤É¤³¤«¤éÆþ¼ê¤Ç¤¤Þ¤¹¤«¡© @@ -1312,10 +1304,13 @@ PL/PgSQL ¤Ï´Ø¿ô¤ÎÆâÍÆ¤ò¥¥ã¥Ã¥·¥å¤·¡¢¤½¤ÎÉÔ¹¬¤ÊÉûºîÍѤΤ¿¤á¡¢¤â¤· PL/PgSQL ´Ø¿ô ¥ó¤Ï http://gborg.PostgreSQL.org/project/pgreplication/projdisplay.php ¤Ë¤Æºî¶È ¤¬¿Ê¤á¤é¤ì¤Æ¤¤¤Þ¤¹¡£ -[ÌõÃí JPUG ʬ»¶¥È¥é¥ó¥¶¥¯¥·¥ç¥ó³«È¯Ê¬²Ê²ñ¤Ç¤Ï¡¢±Ê°Â¸ç»Ë¤µ¤ó¤òÃæ¿´¤Ë£²Áꥳ¥ß¥Ã¥È -¤Î¼ÂÁõ¤ò¹Ô¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£ http://www.postgresql.jp/subcommittee/dt/index.html -http://www.snaga.org/jpug-dt/ »°Ã«ÆÆ¤µ¤ó¤Ë¤è¤ëÁÐÊý¸þ¥ê¥×¥ê¥±¡¼¥·¥ç¥óPGReplicate -http://www.csra.co.jp/~mitani/jpug/pgreplicate/ ] +[ÌõÃí Jan Wieck¤µ¤ó¤Ë¤è¤ë¥«¥¹¥±¡¼¥É²Äǽ¤Ê¥Þ¥¹¥¿¡¼¡¦¥¹¥ì¡¼¥Ö·¿¤Î¥ì¥×¥ê¥±¡¼¥·¥ç¥ó +Slony-I http://gborg.postgresql.org/project/slony1/projdisplay.php ÀаæÃ£Éפµ¤ó +¤Ë¤è¤ë¥³¥Í¥¯¥·¥ç¥ó¥×¡¼¥ë¥µ¡¼¥Ð PGPool http://www2b.biglobe.ne.jp/~caco/pgpool/ +»°Ã«ÆÆ¤µ¤ó¤Ë¤è¤ë¥Þ¥ë¥Á¥Þ¥¹¥¿Êý¼°¤ÎƱ´ü¥ì¥×¥ê¥±¡¼¥·¥ç¥ó PGCluster http:// +www.csra.co.jp/~mitani/jpug/pgcluster/index.html JPUG ʬ»¶¥È¥é¥ó¥¶¥¯¥·¥ç¥ó³«È¯ +ʬ²Ê²ñ¤Ç¤Ï¡¢±Ê°Â¸ç»Ë¤µ¤ó¤¬£²Áꥳ¥ß¥Ã¥È¤Î¼ÂÁõ¤ò¹Ô¤¤¤Þ¤·¤¿¡£ http:// +www.postgresql.jp/wg/dt/index.html ] 4.28) ¤É¤Î¤è¤¦¤Ê°Å¹æ²½¥ª¥×¥·¥ç¥ó¤òÍøÍѤǤ¤Þ¤¹¤«? @@ -1365,7 +1360,7 @@ http://www.csra.co.jp/~mitani/jpug/pgreplicate/ ] [ÌõÃí¡§ ÆüËܸìÈǤÎÀ½ºî¤Ë¤Ä¤¤¤Æ¤Ï°Ê²¼¤ÎÄ̤ê¤Ç¤¹¡£ - ºÇ½ª¹¹¿·Æü: 2004ǯ10·î18Æü + ºÇ½ª¹¹¿·Æü: 2004ǯ10·î21Æü ËÝÌõ¼Ô: ·¬Â¼ ½á (Jun Kuwamura <juk at PostgreSQL.jp>) ¤³¤ÎFAQ¤ÎÏÂÌõ¤ÎºîÀ®¤Ë¤¢¤¿¤ê¶¨ÎϤò¤·¤Æ¤¯¤À¤µ¤Ã¤¿Êý¡¹(·É¾Î¤Ïά¤µ¤»¤Æ¤¤¤¿¤À¤¤Þ¤¹): @@ -1393,7 +1388,7 @@ http://www.csra.co.jp/~mitani/jpug/pgreplicate/ ] ÆüËܸìÈǤΤ³¤Îʸ½ñ¤Ï¡¢°Ê²¼¤«¤é¤â¤¿¤É¤ì¤Þ¤¹¡£ http://www.rccm.co.jp/~juk/pgsql/(FAQÏÂÌõ PostgreSQL ¤Ë¤Ä¤¤¤Æ¤è¤¯¤¢¤ë¼ÁÌä) - http://www.PostgreSQL.jp/subcommittee/jpugdoc/JPUGʸ½ñ¡¦½ñÀÒ´ØÏ¢Ê¬²Ê²ñ + http://www.PostgreSQL.jp/wg/jpugdoc/JPUGʸ½ñ¡¦½ñÀÒ´ØÏ¢Ê¬²Ê²ñ http://www.linux.or.jp/JF/Linux JF¥×¥í¥¸¥§¥¯¥È ¤Ê¤ª¡¢¤³¤ÎÏÂÌõ¤Ë´Ø¤¹¤ë¤´°Õ¸«¤Ï(juk at PostgreSQL.jp)¤Þ¤Ç¤ª´ó¤»²¼¤µ¤¤¡£ diff --git a/doc/FAQ_russian b/doc/FAQ_russian index 58fec5cab80..57a8b0cc944 100644 --- a/doc/FAQ_russian +++ b/doc/FAQ_russian @@ -1,7 +1,7 @@ Otvety na chasto zadavaemye voprosy po PostgreSQL - Data poslednego obnovleniya: CHetverg 6 maya 23:28:03 EDT 2004 + Data poslednego obnovleniya: Vtornik 31 avgusta 23:28:03 EDT 2004 Anglijskij variant soprovozhdaet: Bryus Mom'yan (Bruce Momjian) (pgman@candle.pha.pa.us) @@ -61,6 +61,7 @@ 3.9) CHto nahoditsya v kataloge pgsql_tmp? 3.10) Pochemu neobhodimo delat' dump i restore pri obnovlenii vypuskov PostgreSQL? + 3.11) Kakoe komp'yuternoe "zhelezo" ya dolzhen ispol'zovat'? Voprosy `ekspluatacii @@ -204,29 +205,10 @@ 1.4) Suschestvuyut li versii perenesennye ne na Unix sistemy? - Klient - - Dlya zapuska na platformah MS Windows vozmozhna kompilyaciya C - biblioteki libpq, psql, drugih interfesov i klientskih prilozhenij. V - `etom sluchae, klient zapuskaetsya na MS Windows i svyazyvaetsya po - TCP/IP s serverom, zapuschennym na odnoj iz podderzhivaemyh Unix - platform. V distributiv vklyuchaetsya fajl win32.mak dlya togo, chtoby - mozhno bylo provesti sborku biblioteki libpq i psql dlya Win32. - PostgreSQL takzhe rabotaet cherez ODBC. - - Server - - Server BD mozhet byt' zapuschen na Windows NT i Win2k, ispol'zuya - biblioteku Cygwin, razrabotannuyu kompaniej Cygnus dlya perenosa - programmnogo obespecheniya Unix v NT. Smotrite pgsql/doc/FAQ_MSWIN v - distributive ili MS Windows FAQ na - http://www.PostgreSQL.org/docs/faqs/text/FAQ_MSWIN. - - PostgreSQL, sportirovannyj special'no dlya MS Win NT/2000/XP v - nastoyaschij moment nachal rabotat'. Podrobnosti tekuschego - sostoyaniya PostgreSQL dlya Windows smotrite na - http://techdocs.postgresql.org/guides/Windows i - http://momjian.postgresql.org/main/writings/pgsql/win32.html. + Nachinaya s versii 8.0, PostgreSQL bez vsyakih uhischrenij rabotaet na + operacionnyh sistemah Microsoft Windows, osnovannyh na NT, takih kak + Win2000, WinXP i Win2003. Paket installyatora dostupen po adresu + http://pgfoundry.org/projects/pginstaller. Takzhe suschestvuet versiya sportirovannaya pod Novell Netware 6 na http://forge.novell.com. @@ -287,7 +269,7 @@ 1.7) Kakaya poslednyaya versiya? - Poslednij vypusk PostgreSQL - `eto versiya 7.4.2 + Poslednij vypusk PostgreSQL - `eto versiya 7.4.5 My planiruem vypuskat' novye versii kazhdye 6-8 mesyacev. @@ -563,11 +545,10 @@ 3.5) Kak mne upravlyat' soedineniyami s drugih komp'yuterov? Po umolchaniyu, PostgreSQL razreshaet tol'ko soedineniya na lokal'noj - mashine cherez sokety domena Unix. Drugie mashiny ne smogut - podklyuchit'sya k baze poka ne budet vklyuchena opciya tcpip_sockets v - postgresql.conf i poka ne budet razreshena host-avtorizaciya v fajle - $PGDATA/pg_hba.conf. `Eti dejstviya delayut vozmozhnymi TCP/IP - soedineniya. + mashine cherez sokety domena Unix ili TCP/IP soedineniya. Drugie + mashiny ne smogut podklyuchit'sya k baze poka vy ne izmenite + listen_addresses v postgresql.conf i poka ne budet razreshena + host-avtorizaciya v fajle $PGDATA/pg_hba.conf. 3.6) Kakie nastrojki mne nuzhno sdelat' dlya uluchsheniya proizvoditel'nosti? @@ -714,6 +695,18 @@ provedeniya obnovleniya mozhet byt' ispol'zovan scenarij pg_upgrade bez ispol'zovaniya dump/restore. Kommentarii k vypusku govorit kogda mozhno ispol'zovat' pg_upgrade dlya `etogo vypuska. + + 3.11) Kakoe komp'yuternoe "zhelezo" ya dolzhen ispol'zovat'? + + Poskol'ku "zhelezo" personal'nyh komp'yuterov yavlyaetsya naibolee + sovmestimym, lyudi sklonny verit', chto takoe "zhelezo" imeet + odinakovoe kachestvo. `Eto ne tak. Pamyat' ECC, SCSI i kachestvennye + materinskie platy yavlyayutsya bolee nadiozhnymi i imeyut bolee + luchshuyu proizvoditel'nost', chem menee dorogoe "zhelezo". PostgreSQL + budet rabotat' na lyubom "zheleze", no esli dlya vas vazhny + nadiozhnost' i proizvoditel'nost', to s vashej storony budet mudro + postavit' sootvetstvuyuschee "zhelezo". Obsudit' raznoe "zhelezo" + mozhno v nashih spiskah rassylki. _________________________________________________________________ Voprosy `ekspluatacii @@ -813,23 +806,23 @@ a srednem, sostavlyaet 20 bajt. Razmer prostogo fajla sostavit 2.8 MB. Razmer bazy PostgreSQL, soderzhaschej `eti zhe dannye sostavit priblizitel'no 6.4 MB iz kotoryh: - 36 bajt: na kazhdyj zagolovok zapisi (priblizitel'no) + 32 bajt: na kazhdyj zagolovok zapisi (priblizitel'no) + 24 bajta: odno pole s celochislennym tipom i odno tekstovoe pole + 4 bajta: ukazatel' na stranice dlya vsej zapisi ---------------------------------------- - 64 bajt na zapis' + 60 bajt na zapis' Razmer stranicy dannyh v PostgreSQL sostavlyaet 8192 bajt (8 KB), tak chto: 8192 bajt na stranicu - --------------------- = 128 zapisej na stranicu BD (s okrugleniem) - 64 bajta na zapis' + --------------------- = 136 zapisej na stranicu BD (okruglionno) + 60 bajt na zapis' 100000 strok dannyh - ----------------------- = 782 stranicy v BD + ----------------------- = 735 stranic v BD (okruglionno) 128 zapisej na stranicu - 782 stranicy BD * 8192 bajt na stranicu = 6,406,144 bajt (6.4 MB) + 735 stranic BD * 8192 bajt na stranicu = 6,021,120 bajt (6 MB) Indeksy ne trebuyut tak mnogo, no poskol'ku oni sozdayutsya dlya bol'shogo kolichestva dannyh, oni takzhe mogut byt' veliki. @@ -902,6 +895,10 @@ a opisyvayutsya v sekcii 4.12. * Vo vremya initdb dolzhna ispol'zovat'sya lokal' po umolchaniyu C. + V vypuskah do versii 8.0, indeksy chasto nel'zya bylo ispol'zovat', + esli tipy dannyh tochno ne sovpadali s indeksnymi tipami kolonok. `Eto + osobenno kasalos' int2, int8 i numeric indeksov kolonok. + 4.9) Kak posmotret' na to, kak optimizator vypolnyaet moj zapros? Smotrite stranicu rukovodstva posvyaschennuyu EXPLAIN. @@ -1085,11 +1082,11 @@ t' null-bajt bez opaski) oblasti, kotorye ispol'zuyutsya vsemi vsemi bazami dannyh. Esli vy hotite izmenit' OID na kakoe-libo drugoe znachenie ili esli vy hotite sozdat' kopiyu tablicy s takimizhe OID, to `eto mozhno sdelat' tak: - CREATE TABLE new_table(old_oid oid, mycol int); - SELECT old_oid, mycol INTO new FROM old; - COPY new TO '/tmp/pgtable'; - DELETE FROM new; - COPY new WITH OIDS FROM '/tmp/pgtable'; + CREATE TABLE new_table(mycol int); + SELECT oid AS old_oid, mycol INTO tmp_table FROM old_table; + COPY tmp_table TO '/tmp/pgtable'; + COPY new_table WITH OIDS FROM '/tmp/pgtable'; + DROP TABLE tmp_table; OID hranitsya kak 4-h bajtnoe celoe i ne mozhet prevyshat' znachenie v 4 milliarda. Odnako, esche nikto ne soobschil o tom, chto takoe diff --git a/doc/src/FAQ/FAQ_japanese.html b/doc/src/FAQ/FAQ_japanese.html index 41b0a1857ad..2acd345f86c 100644 --- a/doc/src/FAQ/FAQ_japanese.html +++ b/doc/src/FAQ/FAQ_japanese.html @@ -36,7 +36,7 @@ http://www.PostgreSQL.org/docs/faqs/FAQ.html</A> ÆüËܸìÈǤΤ³¤Îʸ½ñ¤Ï <a HREF="http://www.PostgreSQL.org/docs/index.html">ËÜ²È "Docs" </a> ¤Î "Frequently Asked Questions" ¤Î ¤È¤³¤í¤Ë "Japanese FAQ" ¤È¤¤¤¦¸«½Ð¤Ç¤¢¤ê¤Þ¤¹¡£¤Þ¤¿¡¢°Ê²¼¤Î¥µ¥¤¥È¤Ë¤â ¤¢¤ê¤Þ¤¹¡£ - <A HREF="http://www.PostgreSQL.jp/subcommittee/jpugdoc/">http://www.PostgreSQL.jp/subcommittee/jpugdoc/</A> + <A HREF="http://www.PostgreSQL.jp/wg/jpugdoc/">http://www.PostgreSQL.jp/wg/jpugdoc/</A> <A HREF="http://www.rccm.co.jp/~juk/pgsql/">http://www.rccm.co.jp/~juk/pgsql/</A> <A HREF="http://www.linux.or.jp/JF/">http://www.linux.or.jp/JF/</A> @@ -230,26 +230,19 @@ MODIFICATIONS.</P> <P> <H4><A NAME="1.4">1.4</A>) Unix°Ê³°¤Î°Ü¿¢ÈǤǻȤ¨¤ë¤â¤Î¤Ï¡©</H4> -<P><STRONG>¥¯¥é¥¤¥¢¥ó¥È</STRONG></P> - -<P>¥Ð¡¼¥¸¥ç¥ó8.0¤Ë¤Ê¤ê¡¢PostgreSQL ¤Ï¡¢Win2000, WinXP, Win2003¤Ê¤É¤ÎMicrosoft Windows NT¥Ù¡¼¥¹¤Î¥ª¥Ú¥ì¡¼¥Æ¥£¥ó¥°¥·¥¹¥Æ¥à¤Ç¥Í¥¤¥Æ¥£¥Ö¤ËÁö¤ë¤è¤¦¤Ë¤ê¤Þ¤·¤¿¡£ +<P>¥Ð¡¼¥¸¥ç¥ó8.0¤Ë¤Ê¤ê¡¢PostgreSQL ¤Ï¡¢Win2000, WinXP, Win2003¤Ê¤É¤Î Microsoft Windows NT¥Ù¡¼¥¹¤Î¥ª¥Ú¥ì¡¼¥Æ¥£¥ó¥°¥·¥¹¥Æ¥à¤Ç¥Í¥¤¥Æ¥£¥Ö¤ËÁö¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿¡£ ¥Ñ¥Ã¥±¡¼¥¸¤Ë¤Ê¤Ã¤¿¥¤¥ó¥¹¥È¡¼¥é¤¬¡¢<a href="http://pgfoundry.org/projects/pginstaller">http://pgfoundry.org/projects/pginstaller</a>¤«¤éÆþ¼ê¤Ç¤¤Þ¤¹¡£ </P> -<P><STRONG>¥µ¡¼¥Ð</STRONG></P> - -<P> ¸½ºß¡¢Cygnus Unix/NT °Ü¿¢¥é¥¤¥Ö¥é¥ê¤Î Cygwin ¤ò»È¤Ã¤Æ¡¢PostgreSQL ¥Ç¡¼¥¿¥Ù¡¼¥¹¥µ¡¼¥Ð¤Ï Windows NT ¤È Win2k ¾å¤Ç²ÔƯ¤·¤Æ¤¤¤Þ¤¹¡£ÇÛÉۤ˴ޤޤì¤ë<I>pgsql/doc/FAQ_MSWIN</I>¡¢¤¢¤ë¤¤¤Ï¡¢ -<A href="http://www.PostgreSQL.org/docs/faqs/text/FAQ_MSWIN">http://www.PostgreSQL.org/docs/faqs/text/FAQ_MSWIN</A>¤Ë¤¢¤ë MS Windows FAQ ¤ò¤´Í÷²¼¤µ¤¤¡£</P> - -<P>MS Win NT/2000/XP ¥Í¥¤¥Æ¥£¥ÖÈǤؤΰܿ¢¤¬¸½ºß¿Ê¹ÔÃæ¤Ç¤¹¡£¤â¤Ã¤È¾Ü¤·¤¤WindowsÈÇPostgreSQL¤Î¶á¶·¤Ï¡¢<a href="http://techdocs.postgresql.org/guides/Windows">http://techdocs.postgresql.org/guides/Windows</a>¤È -<a href="http://momjian.postgresql.org/main/writings/pgsql/win32.html"> -http://momjian.postgresql.org/main/writings/pgsql/win32.html</a> -¤ò¸«¤Æ¤¯¤À¤µ¤¤¡£ -</p> - - <p>Novell Netware 6 ¤Î°Ü¿¢¤â¤¢¤ê¤Þ¤¹¡£ - <a href="http://forge.novell.com">http://forge.novell.com</a>.</p> +<small><pre> + [ÌõÃí + pgInstaller ¤ÎÆþ¼ê¤ÏFTP¥ß¥é¡¼¥µ¥¤¥È¤Î win32 ¥Ç¥£¥ì¥¯¥È¥ê¤«¤é¤â²Äǽ¤Ç¤¹¡£ + http://www.postgresql.org/mirrors-ftp.html + ] +</pre></small> + <p>¼¡¤Î¥µ¥¤¥È¤Ë Novell Netware 6 ¤Ø¤Î°Ü¿¢¤â¤¢¤ê¤Þ¤¹¡£ + <a href="http://forge.novell.com">http://forge.novell.com</a></p> <BR> @@ -374,7 +367,7 @@ PostgreSQL ¤ÎºÇ¿·ÈǤϥС¼¥¸¥ç¥ó 7.4.5 ¤Ç¤¹¡£</P> "http://www.PostgreSQL.org/docs/awbook.html">http://www.PostgreSQL.org/docs/awbook.html</A> <SMALL><PRE> [ÌõÃí: - ÆüËܥݥ¹¥È¥°¥ì¥¹¥æ¡¼¥¶¡¼²ñ¤Î<A HREF="http://www.PostgreSQL.jp/subcommittee/psqltrans/"> ¡ÖPostgreSQL BookËÝÌõʬ²Ê²ñ¡×</A> + ÆüËܥݥ¹¥È¥°¥ì¥¹¥æ¡¼¥¶¡¼²ñ¤Î<A HREF="http://www.PostgreSQL.jp/wg/psqltrans/"> ¡ÖPostgreSQL BookËÝÌõʬ²Ê²ñ¡×</A> ¤Ë¤ÆËÝÌõ¤µ¤ì¤Þ¤·¤¿¡£ ] </PRE></SMALL> @@ -419,7 +412,7 @@ http://www.PostgreSQL.org/docs/awbook.html</A> <SMALL><PRE> [ÌõÃí: - ÆüËܥݥ¹¥È¥°¥ì¥¹¥æ¡¼¥¶¡¼²ñ¤Î<A HREF="http://www.PostgreSQL.jp/subcommittee/psqltrans/"> ¡ÖPostgreSQL BookËÝÌõʬ²Ê²ñ¡×</A> + ÆüËܥݥ¹¥È¥°¥ì¥¹¥æ¡¼¥¶¡¼²ñ¤Î<A HREF="http://www.PostgreSQL.jp/wg/psqltrans/"> ¡ÖPostgreSQL BookËÝÌõʬ²Ê²ñ¡×</A> ¤Ë¤ÆËÝÌõ¤µ¤ì½ÐÈǤµ¤ì¤Æ¤¤¤Þ¤¹¡£ ] </PRE></SMALL> @@ -1333,13 +1326,19 @@ http://gborg.PostgreSQL.org/project/pgreplication/projdisplay.php</a> </P> [ÌõÃí - JPUG ʬ»¶¥È¥é¥ó¥¶¥¯¥·¥ç¥ó³«È¯Ê¬²Ê²ñ¤Ç¤Ï¡¢±Ê°Â¸ç»Ë¤µ¤ó¤òÃæ¿´¤Ë£²Áê - ¥³¥ß¥Ã¥È¤Î¼ÂÁõ¤ò¹Ô¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£ - http://www.postgresql.jp/subcommittee/dt/index.html - http://www.snaga.org/jpug-dt/ - »°Ã«ÆÆ¤µ¤ó¤Ë¤è¤ëÁÐÊý¸þ¥ê¥×¥ê¥±¡¼¥·¥ç¥óPGReplicate - http://www.csra.co.jp/~mitani/jpug/pgreplicate/ + Jan Wieck¤µ¤ó¤Ë¤è¤ë¥«¥¹¥±¡¼¥É²Äǽ¤Ê¥Þ¥¹¥¿¡¼¡¦¥¹¥ì¡¼¥Ö·¿¤Î¥ì¥×¥ê¥±¡¼¥·¥ç¥ó Slony-I + http://gborg.postgresql.org/project/slony1/projdisplay.php + + ÀаæÃ£Éפµ¤ó¤Ë¤è¤ë¥³¥Í¥¯¥·¥ç¥ó¥×¡¼¥ë ¥µ¡¼¥Ð PGPool + http://www2b.biglobe.ne.jp/~caco/pgpool/ + + »°Ã«ÆÆ¤µ¤ó¤Ë¤è¤ë¥Þ¥ë¥Á¥Þ¥¹¥¿Êý¼°¤ÎƱ´ü¥ì¥×¥ê¥±¡¼¥·¥ç¥ó PGCluster + http://www.csra.co.jp/~mitani/jpug/pgcluster/index.html + + JPUG ʬ»¶¥È¥é¥ó¥¶¥¯¥·¥ç¥ó³«È¯Ê¬²Ê²ñ¤Ç¤Ï¡¢±Ê°Â¸ç»Ë¤µ¤ó¤¬£²Áꥳ¥ß¥Ã¥È + ¤Î¼ÂÁõ¤ò¹Ô¤¤¤Þ¤·¤¿¡£ + http://www.postgresql.jp/wg/dt/index.html ] <H4><A name="4.28">4.28</A>) ¤É¤Î¤è¤¦¤Ê°Å¹æ²½¥ª¥×¥·¥ç¥ó¤òÍøÍѤǤ¤Þ¤¹¤«? @@ -1393,7 +1392,7 @@ http://gborg.PostgreSQL.org/project/pgreplication/projdisplay.php</a> [ÌõÃí¡§ ÆüËܸìÈǤÎÀ½ºî¤Ë¤Ä¤¤¤Æ¤Ï°Ê²¼¤ÎÄ̤ê¤Ç¤¹¡£ - ºÇ½ª¹¹¿·Æü: 2004ǯ10·î18Æü + ºÇ½ª¹¹¿·Æü: 2004ǯ10·î21Æü ËÝÌõ¼Ô: ·¬Â¼ ½á (<A HREF="mailto:juk at PostgreSQL.jp">Jun Kuwamura <juk at PostgreSQL.jp></A>) ¤³¤ÎFAQ¤ÎÏÂÌõ¤ÎºîÀ®¤Ë¤¢¤¿¤ê¶¨ÎϤò¤·¤Æ¤¯¤À¤µ¤Ã¤¿Êý¡¹(·É¾Î¤Ïά¤µ¤»¤Æ¤¤¤¿¤À¤¤Þ¤¹): @@ -1421,7 +1420,7 @@ http://gborg.PostgreSQL.org/project/pgreplication/projdisplay.php</a> ÆüËܸìÈǤΤ³¤Îʸ½ñ¤Ï¡¢°Ê²¼¤«¤é¤â¤¿¤É¤ì¤Þ¤¹¡£ <A HREF="http://www.rccm.co.jp/~juk/pgsql/">http://www.rccm.co.jp/~juk/pgsql/</A>(FAQÏÂÌõ PostgreSQL ¤Ë¤Ä¤¤¤Æ¤è¤¯¤¢¤ë¼ÁÌä) - <A HREF="http://www.PostgreSQL.jp/subcommittee/jpugdoc/">http://www.PostgreSQL.jp/subcommittee/jpugdoc/</A>JPUGʸ½ñ¡¦½ñÀÒ´ØÏ¢Ê¬²Ê²ñ + <A HREF="http://www.PostgreSQL.jp/wg/jpugdoc/">http://www.PostgreSQL.jp/wg/jpugdoc/</A>JPUGʸ½ñ¡¦½ñÀÒ´ØÏ¢Ê¬²Ê²ñ <A HREF="http://www.linux.or.jp/JF/">http://www.linux.or.jp/JF/</A>Linux JF¥×¥í¥¸¥§¥¯¥È ¤Ê¤ª¡¢¤³¤ÎÏÂÌõ¤Ë´Ø¤¹¤ë¤´°Õ¸«¤Ï(<A HREF="mailto:juk at PostgreSQL.jp">juk at PostgreSQL.jp</A>)¤Þ¤Ç¤ª´ó¤»²¼¤µ¤¤¡£ diff --git a/doc/src/FAQ/FAQ_russian.html b/doc/src/FAQ/FAQ_russian.html index 4ab12b88a3b..1c5e80145e6 100644 --- a/doc/src/FAQ/FAQ_russian.html +++ b/doc/src/FAQ/FAQ_russian.html @@ -12,7 +12,7 @@ <BODY bgcolor="#ffffff" text="#000000" link="#ff0000" vlink="#a00000" alink="#0000ff"> <H1>ïÔ×ÅÔÙ ÎÁ ÞÁÓÔÏ ÚÁÄÁ×ÁÅÍÙÅ ×ÏÐÒÏÓÙ ÐÏ PostgreSQL</H1> - <P>äÁÔÁ ÐÏÓÌÅÄÎÅÇÏ ÏÂÎÏ×ÌÅÎÉÑ: þÅÔ×ÅÒÇ 6 ÍÁÑ 23:28:03 EDT 2004</P> + <P>äÁÔÁ ÐÏÓÌÅÄÎÅÇÏ ÏÂÎÏ×ÌÅÎÉÑ: ÷ÔÏÒÎÉË 31 Á×ÇÕÓÔÁ 23:28:03 EDT 2004</P> <P>áÎÇÌÉÊÓËÉÊ ×ÁÒÉÁÎÔ ÓÏÐÒÏ×ÏÖÄÁÅÔ: âÒÀÓ íÏÍØÑÎ (Bruce Momjian) (<A href= "mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</A>)<BR> @@ -78,6 +78,8 @@ <A href="#3.9">3.9</A>) þÔÏ ÎÁÈÏÄÉÔÓÑ × ËÁÔÁÌÏÇÅ <I>pgsql_tmp</I>?<BR> <A href="#3.10">3.10</A>) ðÏÞÅÍÕ ÎÅÏÂÈÏÄÉÍÏ ÄÅÌÁÔØ dump É restore ÐÒÉ ÏÂÎÏ×ÌÅÎÉÉ ×ÙÐÕÓËÏ× PostgreSQL?<BR> + <A href="#3.11">3.11</A>) ëÁËÏÅ ËÏÍÐØÀÔÅÒÎÏÅ "ÖÅÌÅÚÏ" Ñ ÄÏÌÖÅÎ + ÉÓÐÏÌØÚÏ×ÁÔØ?<BR> <H2 align="center">÷ÏÐÒÏÓÙ ÜËÓÐÌÕÁÔÁÃÉÉ</H2> @@ -239,32 +241,11 @@ <H4><A name="1.4">1.4</A>) óÕÝÅÓÔ×ÕÀÔ ÌÉ ×ÅÒÓÉÉ ÐÅÒÅÎÅÓÅÎÎÙÅ ÎÅ ÎÁ Unix ÓÉÓÔÅÍÙ?</H4> - <P><STRONG>ëÌÉÅÎÔ</STRONG></P> - - <P>äÌÑ ÚÁÐÕÓËÁ ÎÁ ÐÌÁÔÆÏÒÍÁÈ MS Windows ×ÏÚÍÏÖÎÁ ËÏÍÐÉÌÑÃÉÑ C - ÂÉÂÌÉÏÔÅËÉ <I>libpq</I>, psql, ÄÒÕÇÉÈ ÉÎÔÅÒÆÅÓÏ× É ËÌÉÅÎÔÓËÉÈ ÐÒÉÌÏÖÅÎÉÊ. - ÷ ÜÔÏÍ ÓÌÕÞÁÅ, ËÌÉÅÎÔ ÚÁÐÕÓËÁÅÔÓÑ ÎÁ MS Windows É Ó×ÑÚÙ×ÁÅÔÓÑ ÐÏ - TCP/IP Ó ÓÅÒ×ÅÒÏÍ, ÚÁÐÕÝÅÎÎÙÍ ÎÁ ÏÄÎÏÊ ÉÚ ÐÏÄÄÅÒÖÉ×ÁÅÍÙÈ Unix - ÐÌÁÔÆÏÒÍ. ÷ ÄÉÓÔÒÉÂÕÔÉ× ×ËÌÀÞÁÅÔÓÑ ÆÁÊÌ <I>win32.mak</I> ÄÌÑ ÔÏÇÏ, - ÞÔÏÂÙ ÍÏÖÎÏ ÂÙÌÏ ÐÒÏ×ÅÓÔÉ ÓÂÏÒËÕ ÂÉÂÌÉÏÔÅËÉ <I>libpq</I> É - <I>psql</I> ÄÌÑ Win32. PostgreSQL ÔÁËÖÅ ÒÁÂÏÔÁÅÔ ÞÅÒÅÚ - <SMALL>ODBC</SMALL>.</P> - - <P><STRONG>óÅÒ×ÅÒ</STRONG></P> - - <P>óÅÒ×ÅÒ âä ÍÏÖÅÔ ÂÙÔØ ÚÁÐÕÝÅÎ ÎÁ Windows NT É Win2k, ÉÓÐÏÌØÚÕÑ - ÂÉÂÌÉÏÔÅËÕ Cygwin, ÒÁÚÒÁÂÏÔÁÎÎÕÀ ËÏÍÐÁÎÉÅÊ Cygnus ÄÌÑ ÐÅÒÅÎÏÓÁ ÐÒÏÇÒÁÍÍÎÏÇÏ - ÏÂÅÓÐÅÞÅÎÉÑ Unix × NT. óÍÏÔÒÉÔÅ <I>pgsql/doc/FAQ_MSWIN</I> × ÄÉÓÔÒÉÂÕÔÉ×Å - ÉÌÉ MS Windows FAQ ÎÁ <A href="http://www.postgresql.org/docs/faqs/text/FAQ_MSWIN"> - http://www.PostgreSQL.org/docs/faqs/text/FAQ_MSWIN</A>.</P> - - <P>PostgreSQL, ÓÐÏÒÔÉÒÏ×ÁÎÎÙÊ ÓÐÅÃÉÁÌØÎÏ ÄÌÑ MS Win NT/2000/XP × - ÎÁÓÔÏÑÝÉÊ ÍÏÍÅÎÔ ÎÁÞÁÌ ÒÁÂÏÔÁÔØ. ðÏÄÒÏÂÎÏÓÔÉ ÔÅËÕÝÅÇÏ ÓÏÓÔÏÑÎÉÑ PostgreSQL - ÄÌÑ Windows ÓÍÏÔÒÉÔÅ ÎÁ <a href="http://techdocs.postgresql.org/guides/Windows"> - http://techdocs.postgresql.org/guides/Windows</a> É - <a href="http://momjian.postgresql.org/main/writings/pgsql/win32.html"> - http://momjian.postgresql.org/main/writings/pgsql/win32.html</a>. - </P> + <P>îÁÞÉÎÁÑ Ó ×ÅÒÓÉÉ 8.0, PostgreSQL ÂÅÚ ×ÓÑËÉÈ ÕÈÉÝÒÅÎÉÊ ÒÁÂÏÔÁÅÔ ÎÁ + ÏÐÅÒÁÃÉÏÎÎÙÈ ÓÉÓÔÅÍÁÈ Microsoft Windows, ÏÓÎÏ×ÁÎÎÙÈ ÎÁ NT, ÔÁËÉÈ ËÁË + Win2000, WinXP É Win2003. ðÁËÅÔ ÉÎÓÔÁÌÌÑÔÏÒÁ ÄÏÓÔÕÐÅÎ ÐÏ ÁÄÒÅÓÕ + <A href="http://pgfoundry.org/projects/pginstaller"> + http://pgfoundry.org/projects/pginstaller</A>.</P> <P>ôÁËÖÅ ÓÕÝÅÓÔ×ÕÅÔ ×ÅÒÓÉÑ ÓÐÏÒÔÉÒÏ×ÁÎÎÁÑ ÐÏÄ Novell Netware 6 ÎÁ <a href="http://forge.novell.com/">http://forge.novell.com</a>.</P> @@ -337,7 +318,7 @@ <H4><A name="1.7">1.7</A>) ëÁËÁÑ ÐÏÓÌÅÄÎÑÑ ×ÅÒÓÉÑ?</H4> - <P>ðÏÓÌÅÄÎÉÊ ×ÙÐÕÓË PostgreSQL - ÜÔÏ ×ÅÒÓÉÑ 7.4.2</P> + <P>ðÏÓÌÅÄÎÉÊ ×ÙÐÕÓË PostgreSQL - ÜÔÏ ×ÅÒÓÉÑ 7.4.5</P> <P>íÙ ÐÌÁÎÉÒÕÅÍ ×ÙÐÕÓËÁÔØ ÎÏ×ÙÅ ×ÅÒÓÉÉ ËÁÖÄÙÅ 6-8 ÍÅÓÑÃÅ×.</P> @@ -660,11 +641,10 @@ ËÏÍÐØÀÔÅÒÏ×?</H4> <P>ðÏ ÕÍÏÌÞÁÎÉÀ, PostgreSQL ÒÁÚÒÅÛÁÅÔ ÔÏÌØËÏ ÓÏÅÄÉÎÅÎÉÑ ÎÁ ÌÏËÁÌØÎÏÊ - ÍÁÛÉÎÅ ÞÅÒÅÚ ÓÏËÅÔÙ ÄÏÍÅÎÁ Unix. äÒÕÇÉÅ ÍÁÛÉÎÙ ÎÅ ÓÍÏÇÕÔ ÐÏÄËÌÀÞÉÔØÓÑ Ë - ÂÁÚÅ ÐÏËÁ ÎÅ ÂÕÄÅÔ ×ËÌÀÞÅÎÁ ÏÐÃÉÑ tcpip_sockets × postgresql.conf - <B>É</B> ÐÏËÁ ÎÅ ÂÕÄÅÔ ÒÁÚÒÅÛÅÎÁ host-Á×ÔÏÒÉÚÁÃÉÑ × ÆÁÊÌÅ - <I>$PGDATA/pg_hba.conf</I>. üÔÉ ÄÅÊÓÔ×ÉÑ ÄÅÌÁÀÔ ×ÏÚÍÏÖÎÙÍÉ TCP/IP - ÓÏÅÄÉÎÅÎÉÑ.</P> + ÍÁÛÉÎÅ ÞÅÒÅÚ ÓÏËÅÔÙ ÄÏÍÅÎÁ Unix ÉÌÉ TCP/IP ÓÏÅÄÉÎÅÎÉÑ. äÒÕÇÉÅ ÍÁÛÉÎÙ + ÎÅ ÓÍÏÇÕÔ ÐÏÄËÌÀÞÉÔØÓÑ Ë ÂÁÚÅ ÐÏËÁ ×Ù ÎÅ ÉÚÍÅÎÉÔÅ listen_addresses × + postgresql.conf <B>É</B> ÐÏËÁ ÎÅ ÂÕÄÅÔ ÒÁÚÒÅÛÅÎÁ host-Á×ÔÏÒÉÚÁÃÉÑ × ÆÁÊÌÅ + <I>$PGDATA/pg_hba.conf</I>.</P> <H4><A name="3.6">3.6</A>) ëÁËÉÅ ÎÁÓÔÒÏÊËÉ ÍÎÅ ÎÕÖÎÏ ÓÄÅÌÁÔØ ÄÌÑ ÕÌÕÞÛÅÎÉÑ ÐÒÏÉÚ×ÏÄÉÔÅÌØÎÏÓÔÉ?</H4> @@ -819,6 +799,18 @@ ÏÂÎÏ×ÌÅÎÉÑ ÍÏÖÅÔ ÂÙÔØ ÉÓÐÏÌØÚÏ×ÁÎ ÓÃÅÎÁÒÉÊ <i>pg_upgrade</i> ÂÅÚ ÉÓÐÏÌØÚÏ×ÁÎÉÑ dump/restore. ëÏÍÍÅÎÔÁÒÉÉ Ë ×ÙÐÕÓËÕ ÇÏ×ÏÒÉÔ ËÏÇÄÁ ÍÏÖÎÏ ÉÓÐÏÌØÚÏ×ÁÔØ <i>pg_upgrade</i> ÄÌÑ ÜÔÏÇÏ ×ÙÐÕÓËÁ.</P> + + <H4><A name="3.11">3.11</A>) ëÁËÏÅ ËÏÍÐØÀÔÅÒÎÏÅ "ÖÅÌÅÚÏ" Ñ ÄÏÌÖÅÎ + ÉÓÐÏÌØÚÏ×ÁÔØ?</H4> + <P>ðÏÓËÏÌØËÕ "ÖÅÌÅÚÏ" ÐÅÒÓÏÎÁÌØÎÙÈ ËÏÍÐØÀÔÅÒÏ× Ñ×ÌÑÅÔÓÑ ÎÁÉÂÏÌÅÅ + ÓÏ×ÍÅÓÔÉÍÙÍ, ÌÀÄÉ ÓËÌÏÎÎÙ ×ÅÒÉÔØ, ÞÔÏ ÔÁËÏÅ "ÖÅÌÅÚÏ" ÉÍÅÅÔ ÏÄÉÎÁËÏ×ÏÅ + ËÁÞÅÓÔ×Ï. üÔÏ ÎÅ ÔÁË. ðÁÍÑÔØ ECC, SCSI É ËÁÞÅÓÔ×ÅÎÎÙÅ ÍÁÔÅÒÉÎÓËÉÅ ÐÌÁÔÙ + Ñ×ÌÑÀÔÓÑ ÂÏÌÅÅ ÎÁÄ£ÖÎÙÍÉ É ÉÍÅÀÔ ÂÏÌÅÅ ÌÕÞÛÕÀ ÐÒÏÉÚ×ÏÄÉÔÅÌØÎÏÓÔØ, ÞÅÍ + ÍÅÎÅÅ ÄÏÒÏÇÏÅ "ÖÅÌÅÚÏ". PostgreSQL ÂÕÄÅÔ ÒÁÂÏÔÁÔØ ÎÁ ÌÀÂÏÍ "ÖÅÌÅÚÅ", + ÎÏ ÅÓÌÉ ÄÌÑ ×ÁÓ ×ÁÖÎÙ ÎÁÄ£ÖÎÏÓÔØ É ÐÒÏÉÚ×ÏÄÉÔÅÌØÎÏÓÔØ, ÔÏ Ó ×ÁÛÅÊ ÓÔÏÒÏÎÙ + ÂÕÄÅÔ ÍÕÄÒÏ ÐÏÓÔÁ×ÉÔØ ÓÏÏÔ×ÅÔÓÔ×ÕÀÝÅÅ "ÖÅÌÅÚÏ". ïÂÓÕÄÉÔØ ÒÁÚÎÏÅ "ÖÅÌÅÚÏ" + ÍÏÖÎÏ × ÎÁÛÉÈ ÓÐÉÓËÁÈ ÒÁÓÓÙÌËÉ.</P> + <HR> <H2 align="center">÷ÏÐÒÏÓÙ ÜËÓÐÌÕÁÔÁÃÉÉ</H2> @@ -931,23 +923,23 @@ òÁÚÍÅÒ ÂÁÚÙ PostgreSQL, ÓÏÄÅÒÖÁÝÅÊ ÜÔÉ ÖÅ ÄÁÎÎÙÅ ÓÏÓÔÁ×ÉÔ ÐÒÉÂÌÉÚÉÔÅÌØÎÏ 6.4 MB ÉÚ ËÏÔÏÒÙÈ:</P> <PRE> - 36 ÂÁÊÔ: ÎÁ ËÁÖÄÙÊ ÚÁÇÏÌÏ×ÏË ÚÁÐÉÓÉ (ÐÒÉÂÌÉÚÉÔÅÌØÎÏ) + 32 ÂÁÊÔ: ÎÁ ËÁÖÄÙÊ ÚÁÇÏÌÏ×ÏË ÚÁÐÉÓÉ (ÐÒÉÂÌÉÚÉÔÅÌØÎÏ) + 24 ÂÁÊÔÁ: ÏÄÎÏ ÐÏÌÅ Ó ÃÅÌÏÞÉÓÌÅÎÎÙÍ ÔÉÐÏÍ É ÏÄÎÏ ÔÅËÓÔÏ×ÏÅ ÐÏÌÅ + 4 ÂÁÊÔÁ: ÕËÁÚÁÔÅÌØ ÎÁ ÓÔÒÁÎÉÃÅ ÄÌÑ ×ÓÅÊ ÚÁÐÉÓÉ ---------------------------------------- - 64 ÂÁÊÔ ÎÁ ÚÁÐÉÓØ + 60 ÂÁÊÔ ÎÁ ÚÁÐÉÓØ òÁÚÍÅÒ ÓÔÒÁÎÉÃÙ ÄÁÎÎÙÈ × PostgreSQL ÓÏÓÔÁ×ÌÑÅÔ 8192 ÂÁÊÔ (8 KB), ÔÁË ÞÔÏ: 8192 ÂÁÊÔ ÎÁ ÓÔÒÁÎÉÃÕ - --------------------- = 128 ÚÁÐÉÓÅÊ ÎÁ ÓÔÒÁÎÉÃÕ âä (Ó ÏËÒÕÇÌÅÎÉÅÍ) - 64 ÂÁÊÔÁ ÎÁ ÚÁÐÉÓØ + --------------------- = 136 ÚÁÐÉÓÅÊ ÎÁ ÓÔÒÁÎÉÃÕ âä (ÏËÒÕÇÌ£ÎÎÏ) + 60 ÂÁÊÔ ÎÁ ÚÁÐÉÓØ 100000 ÓÔÒÏË ÄÁÎÎÙÈ - ----------------------- = 782 ÓÔÒÁÎÉÃÙ × âä + ----------------------- = 735 ÓÔÒÁÎÉÃ × âä (ÏËÒÕÇÌ£ÎÎÏ) 128 ÚÁÐÉÓÅÊ ÎÁ ÓÔÒÁÎÉÃÕ - 782 ÓÔÒÁÎÉÃÙ âä * 8192 ÂÁÊÔ ÎÁ ÓÔÒÁÎÉÃÕ = 6,406,144 ÂÁÊÔ (6.4 MB) + 735 ÓÔÒÁÎÉà âä * 8192 ÂÁÊÔ ÎÁ ÓÔÒÁÎÉÃÕ = 6,021,120 ÂÁÊÔ (6 MB) </PRE> <P>éÎÄÅËÓÙ ÎÅ ÔÒÅÂÕÀÔ ÔÁË ÍÎÏÇÏ, ÎÏ ÐÏÓËÏÌØËÕ ÏÎÉ ÓÏÚÄÁÀÔÓÑ ÄÌÑ @@ -1025,7 +1017,11 @@ <LI>÷Ï ×ÒÅÍÑ <i>initdb</i> ÄÏÌÖÎÁ ÉÓÐÏÌØÚÏ×ÁÔØÓÑ ÌÏËÁÌØ ÐÏ ÕÍÏÌÞÁÎÉÀ <i>C</i>. </UL> - <p> + </P> + + <P>÷ ×ÙÐÕÓËÁÈ ÄÏ ×ÅÒÓÉÉ 8.0, ÉÎÄÅËÓÙ ÞÁÓÔÏ ÎÅÌØÚÑ ÂÙÌÏ ÉÓÐÏÌØÚÏ×ÁÔØ, + ÅÓÌÉ ÔÉÐÙ ÄÁÎÎÙÈ ÔÏÞÎÏ ÎÅ ÓÏ×ÐÁÄÁÌÉ Ó ÉÎÄÅËÓÎÙÍÉ ÔÉÐÁÍÉ ËÏÌÏÎÏË. üÔÏ + ÏÓÏÂÅÎÎÏ ËÁÓÁÌÏÓØ int2, int8 É numeric ÉÎÄÅËÓÏ× ËÏÌÏÎÏË.</P> <H4><A name="4.9">4.9</A>) ëÁË ÐÏÓÍÏÔÒÅÔØ ÎÁ ÔÏ, ËÁË ÏÐÔÉÍÉÚÁÔÏÒ ×ÙÐÏÌÎÑÅÔ ÍÏÊ ÚÁÐÒÏÓ?</H4> @@ -1239,16 +1235,12 @@ BYTEA bytea ÍÁÓÓÉ× ÂÁÊÔ ÐÅÒÅÍÅÎÎÏÊ ÄÌÉÎÙ (ÍÏÖÎÏ ÉÓÐÏÌØÚÏ×ÁÔØ ÚÎÁÞÅÎÉÅ ÉÌÉ ÅÓÌÉ ×Ù ÈÏÔÉÔÅ ÓÏÚÄÁÔØ ËÏÐÉÀ ÔÁÂÌÉÃÙ Ó ÔÁËÉÍÉÖÅ <SMALL>OID</SMALL>, ÔÏ ÜÔÏ ÍÏÖÎÏ ÓÄÅÌÁÔØ ÔÁË:</P> <PRE> - CREATE TABLE new_table(old_oid oid, mycol int); - SELECT old_oid, mycol INTO new FROM old; - COPY new TO '/tmp/pgtable'; - DELETE FROM new; - COPY new WITH OIDS FROM '/tmp/pgtable'; + CREATE TABLE new_table(mycol int); + SELECT oid AS old_oid, mycol INTO tmp_table FROM old_table; + COPY tmp_table TO '/tmp/pgtable'; + COPY new_table WITH OIDS FROM '/tmp/pgtable'; + DROP TABLE tmp_table; </PRE> -<!-- - CREATE TABLE new_table (mycol int); - INSERT INTO new_table (oid, mycol) SELECT oid, mycol FROM old_table; ---> <P>O<SMALL>ID</SMALL> ÈÒÁÎÉÔÓÑ ËÁË 4-È ÂÁÊÔÎÏÅ ÃÅÌÏÅ É ÎÅ ÍÏÖÅÔ ÐÒÅ×ÙÛÁÔØ ÚÎÁÞÅÎÉÅ × 4 ÍÉÌÌÉÁÒÄÁ. ïÄÎÁËÏ, ÅÝÅ ÎÉËÔÏ ÎÅ ÓÏÏÂÝÉÌ Ï ÔÏÍ, ÞÔÏ ÔÁËÏÅ ÐÒÏÉÚÏÛÌÏ, ÎÏ ÍÙ ÐÌÁÎÉÒÕÅÍ ÄÏ ÔÏÇÏ ËÁË ÜÔÏ ÓÌÕÞÉÔØÓÑ ÉÚÂÁ×ÉÔÓÑ ÏÔ |