RE: [ilugd] Postgres vs oracle

2003-10-19 Thread Tarun Upadhyay
: [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 does not try very

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

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

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-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 ==

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: Geocrawler

RE: [ilugd] Postgres vs oracle

2003-10-17 Thread Gurpreet Singh Sachdeva
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 [EMAIL PROTECTED] writes

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 Intresting thing about

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 open

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]

RE: [ilugd] Postgres vs oracle

2003-10-14 Thread Gurpreet Singh Sachdeva
: 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 Singh Sachdeva wrote: The strategy of employing

RE: [ilugd] Postgres vs oracle

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

RE: [ilugd] Postgres vs oracle

2003-10-13 Thread Gurpreet Singh Sachdeva
- 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 customer application on oracle. They want

[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

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. I want

RE: [ilugd] Postgres vs oracle

2003-10-10 Thread Tarun Upadhyay
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 make