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] A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?

2012-03-12 Thread Nur Hidayat
ubject: Re: [GENERAL] A 154 GB table swelled to 527 GB on the Slony slave. How to compact it? On 12 March 2012 09:20, Nur Hidayat wrote: > FYI, after I changed text field into character varying, I vaccuum the whole > database, resulting in much smaller database size What I think that happened

Re: [GENERAL] A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?

2012-03-12 Thread Nur Hidayat
FYI, after I changed text field into character varying, I vaccuum the whole database, resulting in much smaller database size Cheers, NH .::. Sent from my BlackBerry® powered by The ESQ Way 165 -Original Message- From: "Nur Hidayat" Date: Mon, 12 Mar 2012 08:18:09 To: Joh

Re: [GENERAL] A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?

2012-03-12 Thread Nur Hidayat
Yes, I am aware of that, but that's the fact I'm facing Right now I'am happy enough my system runs well without eating up my drive :) I'll investigate more later when time available :) Cheers, Nur Hidayat .::. Sent from my BlackBerry® powered by The ESQ Way 165 -

Re: [GENERAL] A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?

2012-03-12 Thread Nur Hidayat
a Regards, Nur Hidayat On Mon, Mar 12, 2012 at 1:32 PM, Aleksey Tsalolikhin < atsaloli.t...@gmail.com> wrote: > Dear Scott, > > When I pg_dump -t bigtablename on the Slony slave, the dump file is > 212G in size. > > I am unable to perform the same test on the master