From: | 李江华 <ljh1469(at)alibaba-inc(dot)com> |
---|---|
To: | "Praveen Raja" <praveen(dot)raja(at)netlight(dot)se>, "pgsql-performance" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Insert performance vs Table size |
Date: | 2005-06-27 11:30:50 |
Message-ID: | 20050627113053.6F2E466C097@smtp-hz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)postgresql(dot)org
>
= = = = = = = = = = = = = = = = = = = =
Best regards!
李江华
Seamus Dean
Alibaba.com
TEL:0571-85022088-2287
ljh1469(at)alibaba-inc(dot)com
2005-06-27
From | Date | Subject | |
---|---|---|---|
Next Message | Jacques Caron | 2005-06-27 11:40:13 | Re: Insert performance vs Table size |
Previous Message | Praveen Raja | 2005-06-27 11:24:06 | Insert performance vs Table size |