Search Postgresql Archives

Numerous prepared transactions?

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

 



Hi,

Is it viable to have very many prepared transactions? As in tens of thousands or even more?

The idea is so that a web application can do _persistent_ transactional stuff over multiple pages/accesses/sessions and have it rolled back easily, or committed if desired. I'm thinking that it might be better to do this instead of reinventing transactions at the application layer.

Would it be better to have separate postgresql databases for this? One for the persistent transactions stuff, and one for "normal" stuff, which will manage the persistent transactions.

Regards,
Link.


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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