COPY shine umarni na PostgreSQL mai ƙarfi da sauri don ɗorin bayani da fitarwa cikin girma — watsi da adadi mai yawa na bayani tsakanin fili (ko rago) da tebur da sauri fiye da ƙuɗin INSERT na mutum-mutum. Shi ne kayan ma'amala na daidai don shiga/fitarwa bayani masu girma.
users (name, email, age) (FORMAT csv, HEADER );
users (FORMAT csv, HEADER );
\ users (FORMAT csv, HEADER )
COPY yana karatawa/rubutu dajjin cikakke a aiki guda ɗaya — sauri mai mahimmanci fiye da yin sawon INSERT dubu-dubu.
❌ thousands of individual INSERTs:
each is a separate statement → per-statement overhead, possibly per-row transactions,
network round-trips → SLOW for large data (can be 10-100x slower)
✅ COPY:
one bulk operation, minimal overhead, optimized data path → FAST
→ For loading large datasets, COPY is the go-to; INSERTs are for small/individual rows.
COPY (SQL command) → reads/writes files on the SERVER, needs superuser/file privileges
\copy (psql command) → reads/writes files on the CLIENT, no special privileges
→ Use \copy when running from your machine against a remote database.
✓ Use COPY (not INSERTs) for large data
✓ Consider dropping/disabling indexes and constraints during a huge load, then
recreating them after (building an index once is faster than maintaining it per-row)
✓ Load within a single transaction; increase maintenance_work_mem for index rebuilds
✓ For programmatic bulk inserts, use multi-row INSERT or the driver's COPY support
COPY shine kayan ma'amala mai mahimmanci na PostgreSQL don ɗorin bayani cikin girma da fitarwa da karfi, kuma fahimta ta ita yana da daraja don kowane yanayi da shafa bayani masu girma — shigar bayani, ETL, shirye-shirye/fitarwa, shugging, da bincike, waɗanda su ne buƙatun aiki na duniya gaske.
":Muhimmancin maɓalli shine saurin aiki: ɗorin bayani da yawa tare da ƙuɗin INSERT na mutum-mutum shine tarko mai mahimmanci (gondafe-gondafe na bayani, zuwan-zuwa — maiyada 10-100x a karshe), yayin da COPY yana buƙatar ɗorin bayani a matsayin aiki guda ɗaya na haɓakacciyar girma, na watsi da shi don shiga ko fitarwa bayani mai girma (dubu da miliyona layuka).
Fahimta ta me yasa COPY ya fi sauri sosai (aiki na girma da kira per-row overhead) yana ƙara bayani a lokacin da za ka ƙaurin shi (bayani mai girma) da INSERT (bayani kaɗan/na mutum-mutum).
Sanin bambance-bambancen aiki tsakanin COPY (umarni SQL na server-side, buƙatar entrada/musummunin fili) da \copy (psql client-side umarni, babu musummunin musummun — aiki da bayani na na'ura) shine mahimmanci don shirayen amfani a yanayin daban-daban.
Shawarwarin ɗorin girma (yin amfani da COPY fiye da INSERT, rataye/sakawa sakammako kewaye ɗon girman ɗorin tun da kafa sakammako ɗaya ya shawo cikin sanya sa kowane layuka) su ne ilimin haɓakarcin batutuwa don manyan shirye-shirye.
Tun jiya ayyukan bayani mai girma (shigarwa, shirye-shirye, fitarwa, ETL) su ne ruɗi, kuma tun jiya COPY shine daidai, hanya mai karfi don ɗawuwa a ciki a PostgreSQL (sanin sauri fiye da INSERT don bayani mai girma), fahimta ta COPY — fa'idacin sa na saurin aiki, bambance ta COPY da \copy, da ayyukan ɗorin haɓakarcin — yana da daraja, ilimin amfani mai aiki don watsi da bayani mai girma a ciki kuma a waje Postgres, buƙatu na aiki da sau-sau inda amfani da kayan daidai (COPY) yana yin babbar bambanci.