Postgres INSERT performance and scalability
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
:
pgsql-performance@xxxxxxxxxxxxxx
Subject
: Postgres INSERT performance and scalability
From
: Igor Chudov <
ichudov@xxxxxxxxx
>
Date
: Mon, 19 Sep 2011 17:11:11 -0500
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
Follow-Ups
:
Re: Postgres INSERT performance and scalability
From:
Stephen Frost
Re: Postgres INSERT performance and scalability
From:
Scott Marlowe
Prev by Date:
Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Next by Date:
Re: Postgres INSERT performance and scalability
Previous by thread:
Constraint exclusion on UNION ALL subqueries with WHERE conditions
Next by thread:
Re: Postgres INSERT performance and scalability
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]