Postgres INSERT performance and scalability

From: Igor Chudov <ichudov(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Postgres INSERT performance and scalability
Date: 2011-09-19 22:11:11
Message-ID: CAMhtkAb1F1SOyz1mzeeWaQehoqtzk29oLVVG=NzKEoGS9bPDNg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Let's say that I want to do INSERT SELECT of 1,000 items into a table. The
table has some ints, varchars, TEXT and BLOB fields.

Would the time that it takes, differ a great deal, depending on whether the
table has only 100,000 or 5,000,000 records?

Thanks

i

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2011-09-19 23:32:29 Re: Postgres INSERT performance and scalability
Previous Message Claudio Freire 2011-09-19 18:53:07 Re: Hash index use presently(?) discouraged since 2005: revive or bury it?