Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: migrating oracle to postgres Date: Tue, 21 Jun 2011 13:38:10 +0000 (UTC) Organization: solani.org Lines: 17 Message-ID: References: <1308640710.210659@proxy.dienste.wien.at> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1308663490 27944 eJwFwYEBACAEBMCVVP4xjsj+I3SHw8UyJagYzNuxs1ILq9XrdloKTWWCfXIetSJd6BLAnQ8rERFm (21 Jun 2011 13:38:10 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Tue, 21 Jun 2011 13:38:10 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwNysERACEIA8CWFEPg2iFI/yWcs9/1w00F6ITPY02Zil+qCahClju8lwrr3qmAXj/wHOsfIh4ROA== Cancel-Lock: sha1:vac65lcB4EqwG3qWCm0sO26piWQ= X-NNTP-Posting-Host: eJwNxMkRwDAIBLCWYLjscljD9l9CoofCUvOVZ6QHg3X17jHtSuEqN8jq6hVHiBvmxcpgxnghkqtLTJsBD61/dfrYyAIj+QEFIhvk Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:139 On Tue, 21 Jun 2011 09:18:07 +0200, Laurenz Albe wrote: > PS: Don't let people discourage you. PostgreSQL is a good and stable > database system. It is stable, no contest there. Is it good or not is a matter of opinion. I could list several grave faults which make it less than good in my eyes. The first and foremost is, of course, the lack of hints. Postgres is the only major database system which lacks hints. The second is ludicrous need to "vacuum" database. The third is the fact that Postgres doesn't do multi-block reads. Fixed size archive logs (16M) would be the next issue. The lack of shared pool makes it impossible to see the plan of the statement being executed. And there is more. -- http://mgogala.byethost5.com