Search Postgresql Archives

Re: transaction limits?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



jeff sacksteder wrote:
Are there known limits to how many rows can be inserted by one transaction,
or does that just reflect the already documented row, table and database
limits?

Well, the system will need to be able to roll back the transaction, so at some point your system will grind to a halt. I shouldn't be surprised if there was some counter that couldn't cope beyond 2^31 rows too but no-one's found it yet.

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux