SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-18-2008, 11:57 AM
| ||||
| ||||
 Re: Insert performance vs Table size Praveen Raja: I think the size of a table don't affect the speed of inserts into it.Because PostgreSQL just doing something like "append" on the data files. But the index do speed-down the inserts. Because PostgreSQL should maintain the index when doing inserts. hope this is useful for your question. ======= 2005-06-27 19:24:06 you wrote£º======= >Hi all > >I'm wondering if and how the size of a table affects speed of inserts >into it? What if the table has indexes, does that alter the answer? > >Thanks > > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > = = = = = = = = = = = = = = = = = = = = ¡¡¡¡¡¡¡¡¡¡¡¡¡¡Best regards! ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ Àî½*»ª Seamus Dean Alibaba.com TEL:0571-85022088-2287 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ ljh1469@alibaba-inc.com ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ 2005-06-27 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
Linear Mode
