RE: [ilugd] Postgres vs oracle

2003-10-19 Thread Tarun Upadhyay
Did some research over the weekend. First of all some good news: Heavy duty sites that run Postgres include; A) RubyForge (rubyforge.org). They have 300K records. Not too many but moderately high. B) .org domain. c) sourceforge used to run postgres. AFAIK, they moved out because IBM made that a co

RE: [ilugd] Postgres vs oracle

2003-10-19 Thread Tarun Upadhyay
ubject: RE: [ilugd] Postgres vs oracle Correct! To be more precise: The standard form of VACUUM is best used with the goal of maintaining a fairly level steady-state usage of disk space. The standard form finds old tuples and makes their space available for re-use within the table, but it do

Re: [ilugd] Postgres vs oracle

2003-10-18 Thread Raj Mathur
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > "Ambar" == Ambar Roy <[EMAIL PROTECTED]> writes: Ambar> [snip]. Ambar> So does VACUUM require the database to be taken offline? Or Ambar> was this an issue with older versions of pgSQL? As I don't Ambar> see the Geocrawler under

Re: [ilugd] Postgres vs oracle

2003-10-18 Thread Ambar Roy
> The standard form of VACUUM is best used with the goal of maintaining a fairly level steady-state usage of disk space. The standard form finds old tuples and makes their space available for re-use within the table, but it does not try very hard to shorten the table file and return disk space to t

RE: [ilugd] Postgres vs oracle

2003-10-17 Thread Gurpreet Singh Sachdeva
: Raj Mathur [mailto:[EMAIL PROTECTED] Sent: Thu 10/16/2003 5:38 PM To: The Linux-Delhi mailing list Cc: Subject: Re: [ilugd] Postgres vs oracle -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 >>>>> "Ambar" == Ambar Roy &

Re: [ilugd] Postgres vs oracle

2003-10-17 Thread shantanu
Please check http://formation.espacecourbe.com/choosing/dbc_crashMe20001011.html and some comparision reports http://formation.espacecourbe.com/choosing/ Regards shantanu On 16 Oct 2003 12:15:25 +0530, Tarun Dua <[EMAIL PROTECTED]> wrote: On Thu, 2003-10-16 at 11:35, Ambar Roy wrote: > Geocrawle

Re: [ilugd] Postgres vs oracle

2003-10-17 Thread shantanu
Some more information, some numbers from mysql: http://www.mysql.com/information/features.html http://www.mysql.com/information/benchmarks-old.html regards shantanu On Thu, 16 Oct 2003 17:38:34 +0530, Raj Mathur <[EMAIL PROTECTED]> wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 "Ambar" == A

Re: [ilugd] Postgres vs oracle

2003-10-16 Thread Raj Mathur
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > "Ambar" == Ambar Roy <[EMAIL PROTECTED]> writes: >> > Surely NO...so we would certainly be interested to know some >> of your > Ambar> "Biggest Internet Sites running on open source". >> Geocrawler use Postgres. Ambar> Intres

Re: [ilugd] Postgres vs oracle

2003-10-15 Thread Tarun Dua
On Thu, 2003-10-16 at 11:35, Ambar Roy wrote: > > Geocrawler use Postgres. > Intresting thing about Geocrawler & AudioGalaxy using postgres was that both > of these sites seemed to go offline for daily maintainence during the middle > of the day here in India. Both the sites ran Postgresql, and wer

Re: [ilugd] Postgres vs oracle

2003-10-15 Thread Ambar Roy
> > Surely NO...so we would certainly be interested to know some of your > "Biggest Internet Sites running on open source". > > Geocrawler use Postgres. Intresting thing about Geocrawler & AudioGalaxy using postgres was that both of these sites seemed to go offline for daily maintainence during the

RE: [ilugd] Postgres vs oracle

2003-10-15 Thread supreet
I do'nt know for sure but as far as my memory goes. sf.net started of with postgres and then moved on to use DB2 from IBM because of scaling issues with postgres. -- supreet <[EMAIL PROTECTED]> ___ ilugd mailing list [EMAIL PROTECTED] http://frodo.hse

RE: [ilugd] Postgres vs oracle

2003-10-15 Thread Tarun Dua
On Tue, 2003-10-14 at 19:58, Gurpreet Singh Sachdeva wrote: > Hi Tarun, >Let me make it very cleat that I don't have any hunch in open source > and thats why I am in the list but my dear, facts are facts. > (Is Amazon.com running on open source (database)? Is eBay.com running on op

RE: [ilugd] Postgres vs oracle

2003-10-14 Thread Raj Mathur
Gurpreet> SGkgVGFydW4sDQogICAgICAgICAgICAgICBMZXQgbWUgbWFrZSBpdCB2ZXJ5IGNsZWF0IHRoYXQg Gurpreet> SSBkb24ndCBoYXZlIGFueSBodW5jaCBpbiBvcGVuIHNvdXJjZSBhbmQgdGhhdHMgd2h5IEkgYW0g Gurpreet> aW4gdGhlIGxpc3QgYnV0IG15IGRlYXIsIGZhY3RzIGFyZSBmYWN0cy4NCihJcyBBbWF6b24uY29t Gurpreet> IHJ1bm5

RE: [ilugd] Postgres vs oracle

2003-10-14 Thread Gurpreet Singh Sachdeva
ngh Sachdeva -Original Message- From: Tarun Dua [mailto:[EMAIL PROTECTED] Sent: Tue 10/14/2003 2:16 PM To: The Linux-Delhi mailing list Cc: Subject: RE: [ilugd] Postgres vs oracle On Mon, 2003-10-13 at 22:13, Gurpreet Sing

RE: [ilugd] Postgres vs oracle

2003-10-14 Thread Tarun Dua
On Mon, 2003-10-13 at 22:13, Gurpreet Singh Sachdeva wrote: > The strategy of employing dual servers to divide your data > is a short term arrangement. Lot of performance related issues *will* crop up in the > future and lot of fingers would be raised on you. No such things would happen if the

RE: [ilugd] Postgres vs oracle

2003-10-13 Thread Gurpreet Singh Sachdeva
o:[EMAIL PROTECTED] Sent: Sat 10/11/2003 10:26 AM To: 'The Linux-Delhi mailing list' Cc: Subject: RE: [ilugd] Postgres vs oracle Gupreet, It is a real application. It's an OLTP appliaction for banking and credit card industry. From a concurrency

RE: [ilugd] Postgres vs oracle

2003-10-13 Thread Gurpreet Singh Sachdeva
small web services -Original Message- From: Tarun Upadhyay [mailto:[EMAIL PROTECTED] Sent: Fri 10/10/2003 9:50 PM To: 'The Linux-Delhi mailing list' Cc: Subject: [ilugd] Postgres vs oracle We have a cu

RE: [ilugd] Postgres vs oracle

2003-10-10 Thread Tarun Upadhyay
hdeva Sent: Saturday, October 11, 2003 2:32 AM To: The Linux-Delhi mailing list; The Linux-Delhi mailing list Subject: RE: [ilugd] Postgres vs oracle Hi Tarun, I think you are trying to compare a Apple with a Water Melon. But any case if you are really facing a real time scenario, please

RE: [ilugd] Postgres vs oracle

2003-10-10 Thread Gurpreet Singh Sachdeva
To: 'The Linux-Delhi mailing list' Cc: Subject: [ilugd] Postgres vs oracle We have a customer application on oracle. They want to crate a "small footprint" version of it to be sold at a cheaper price.

[ilugd] Postgres vs oracle

2003-10-10 Thread Tarun Upadhyay
We have a customer application on oracle. They want to crate a "small footprint" version of it to be sold at a cheaper price. I want to suggest that Postgres could be the right choice of database for that as it is close to oracle in its sql syntax and hence porting should be simpler. Can anybody