Re: [GENERAL] PostgreSQL vs Mongo

2013-10-17 Thread David Kerr
On Wed, Oct 16, 2013 at 09:30:59AM -0600, CS DBA wrote: - All; - - One of our clients is talking about moving to Mongo for their - reporting/data mart. I suspect the real issue is the architecture of - their data mart schema, however I don't want to start pushing back if I - can't back it up.

Re: [GENERAL] PostgreSQL vs Mongo

2013-10-17 Thread Serge Fonville
One of the strengths/weaknesses of Mongo are with the similarity between code and access. This simplifies development from a developer's perspective, but complicates from an administrator perspective. If you want an informed opinion, ask the same question on the Mongo mailing list. Also look into f

Re: [GENERAL] PostgreSQL vs Mongo

2013-10-17 Thread Bill Moran
If they pull out the "Mongo is faster than PostgreSQL" card, I'll state that I investigated this for my current employer and with roughly equivalent configurations (because it's impossible to get exactly equivalent) I was getting roughly the same performance from each. It's difficult to measure e

Re: [GENERAL] PostgreSQL vs Mongo

2013-10-16 Thread Chris Travers
On Wed, Oct 16, 2013 at 8:30 AM, CS DBA wrote: > All; > > One of our clients is talking about moving to Mongo for their > reporting/data mart. I suspect the real issue is the architecture of their > data mart schema, however I don't want to start pushing back if I can't > back it up. > You want

Re: [GENERAL] PostgreSQL vs Mongo

2013-10-16 Thread Nur Hidayat
Hi Kevin, This might help you more http://www.slideshare.net/nurulferdous/nosql-is-it-for-you Cheers, NH . On Wed, Oct 16, 2013 at 10:30 PM, CS DBA wrote: > All; > > One of our clients is talking about moving to Mongo for their > reporting/data mart. I suspect the real issue is the architect

Re: [GENERAL] PostgreSQL vs Mongo

2013-10-16 Thread Ondrej Ivanič
Hi, On 17 October 2013 02:30, CS DBA wrote: > Anyone have any thoughts on why we would / would not use Mongo for a > reporting environment. hm.. I wouldn't use anything which doesn't support rich SQL as a backed for reporting system. In mongo, simple selects are fine but anything complex require

Re: [GENERAL] PostgreSQL vs Mongo

2013-10-16 Thread Merlin Moncure
On Wed, Oct 16, 2013 at 10:30 AM, CS DBA wrote: > All; > > One of our clients is talking about moving to Mongo for their reporting/data > mart. I suspect the real issue is the architecture of their data mart > schema, however I don't want to start pushing back if I can't back it up. > > Anyone ha