Postgres Pro
Downloads
Home   >   mailing lists

Postgres INSERT performance and scalability - Mailing list pgsql-performance

From Igor Chudov
Subject Postgres INSERT performance and scalability
Date
Msg-id CAMhtkAb1F1SOyz1mzeeWaQehoqtzk29oLVVG=NzKEoGS9bPDNg@mail.gmail.com
Whole thread Raw
Responses Re: Postgres INSERT performance and scalability  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Postgres INSERT performance and scalability  (Stephen Frost <sfrost@snowman.net>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Next
From: Scott Marlowe
Date:
Subject: Re: Postgres INSERT performance and scalability