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?
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

= = = = = = = = = = = = = = = = = = = =

       Best regards!
                               Seamus Dean
                        [EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to