Skip site navigation (1) Skip section navigation (2)

Re: Insert performance vs Table size

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Jacques CaronDate: 2005-06-27 11:40:13
Subject: Re: Insert performance vs Table size
Previous:From: Praveen RajaDate: 2005-06-27 11:24:06
Subject: Insert performance vs Table size

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group