Re: [PERFORM] Scalability in postgres

2009-08-16 Thread Jeff Janes
On Fri, Aug 14, 2009 at 4:21 PM, Tom Lane wrote: > Jeff Janes writes: >> I apologize if it is bad form to respond to a message that is two >> months old, but I did not see this question answered elsewhere and >> thought it would be helpful to have it answered. This my rough >> understanding. Ora

Re: [PERFORM] Less expensive proprietary or Open source ETL tools

2009-08-16 Thread Jean-Max Reymond
Rstat a écrit : Hi, As of today, we are still enjoying our Informatica tool but in a few months we will need to change. Basically we do not use our software at its full capacity and don't feel we need it anymore. So we are trying to find a less expensive solution that would have the same featu

Re: [PERFORM] Scalability in postgres

2009-08-16 Thread si...@2ndquadrant.com
On 14 August 2009 at 03:18 Jeff Janes wrote: > This my rough understanding.  Oracle never > "takes" a snapshot, it computes one the fly, if and when it is needed.  It > maintains a > structure of recently committed transactions, with the XID for when they > committed.  If a > process runs into