Re: Insert performance vs Table size

Поиск
Список
Период
Сортировка
От 李江华
Тема Re: Insert performance vs Table size
Дата
Msg-id 20050627113053.6F2E466C097@smtp-hz
обсуждение исходный текст
Ответ на Insert performance vs Table size  ("Praveen Raja" <praveen.raja@netlight.se>)
Список 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@postgresql.org
>

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

       Best regards!
  
        
                               李江华
                               Seamus Dean
                               Alibaba.com
                               TEL:0571-85022088-2287
                        ljh1469@alibaba-inc.com
                        2005-06-27

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Praveen Raja"
Дата:
Сообщение: Insert performance vs Table size
Следующее
От: Jacques Caron
Дата:
Сообщение: Re: Insert performance vs Table size