Re: Moving to postgresql and some ignorant questions

"Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com> writes:

> There are some cases where I would like to bunch queries into a
> transaction purely for speed purposes, but they're not interdependent
> for integrity. E.g.,

How do you know you need to do this for speed if you haven't run it yet? I
would suggest you build your application around the application needs first,
then later look at how to optimize it.

Remember the two rules of optimization:

1) Don't
2) (for experts only) Don't yet

The only case where you should consider batching together transactions like
that is if you're processing a batch data load of some kind. In that case you
have a large volume of updates and they're all single-threaded. But usually in
that case you want to abort the whole load if you have a problem.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com