Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 43F3F2E2872 for ; Mon, 26 Nov 2007 23:34:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 38011-02 for ; Mon, 26 Nov 2007 23:34:02 -0400 (AST) Received: from rn-out-0102.google.com (rn-out-0910.google.com [64.233.170.187]) by postgresql.org (Postfix) with ESMTP id 8F5FA2E266B for ; Mon, 26 Nov 2007 23:34:11 -0400 (AST) Received: by rn-out-0102.google.com with SMTP id s46so899896rnb for ; Mon, 26 Nov 2007 19:34:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=Zh8Hw0rh2OyY0o8zYHQbBOoJxlZAZJfel7AHi/Vunu4=; b=U4OKJtcO2vHT3tVUfSXy00/Nlo+BcQ7hCP56s8pT13q++hfuir6s4zpMcc75MKSwkjBwTqoDx+7svtAE17B9AweFQqeBehGP/MzLv1ky7C3o0VoSFw/aja6DOb14QJa/G/kuplGBNGxClInON3jHXZwSD8qp+KbcpRsKozlj0AI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=LaGqrmMuLyLbP8kaBpfHm79cBis3KawrRRsAgB54HSNhkyz7TpvljW5Ru2OqH/i1qP2Vn505WTTYqNJsALDUZ+Xs/V0sD3GdcOcLow6m5eS3bg+s5O3zCKM8Q62eYYizrBgDIRGyX5jYBPJS3kan6NxfNitPPs5i6BiNkKYA0bI= Received: by 10.70.8.2 with SMTP id 2mr244463wxh.1196134449703; Mon, 26 Nov 2007 19:34:09 -0800 (PST) Received: by 10.90.82.6 with HTTP; Mon, 26 Nov 2007 19:34:09 -0800 (PST) Message-ID: <493343bd0711261934p43fe15f9q46aaae78c8b6ddd4@mail.gmail.com> Date: Mon, 26 Nov 2007 23:34:09 -0400 From: "=?ISO-8859-1?Q?Elvis_Henr=EDquez?=" To: pgsql-admin@postgresql.org Subject: Case studies MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/227 X-Sequence-Number: 27470 Hello everybody. Rather than asking for a technical detail or writing about a problem, I'm asking for up-to-date case studies involving PostgreSQL. The company where I'm actually working is migrating some apps; one requires a Data Warehouse, and I'm proposing PostgreSQL, but they're thinking of Oracle, as the system has one table (among others) with 20 fields and more then 19 millions of records, and this exists for 2 subcompanies, which are actually in different databases, but the migration project implies joining the two subcompanies data. This amount of data is the result of 8 years of usage, and the data growing rate has increased in the last two years. They asked me for case studies that shows this, so they can go ahead with the migration to PostgreSQL. The ones shown in "http://www.postgresql.org/about/casestudies/" are out-dated and don't show amount of records or database/table size or growth. I hope you could help me with this.