Thought that this info may be useful to some of you who
might be using postgres.
Guru had posted this on ilug-goa.
----- Forwarded message from "Gurunandan R. Bhat" <[EMAIL PROTECTED]> -----
>From: "Gurunandan R. Bhat" <[EMAIL PROTECTED]>
>Date: Tue, 6 Mar 2001 10:35:27 +0530 (IST)
>To: <[EMAIL PROTECTED]>
>Subject: Re: [ilug-goa] POSTGRES 7.03
>Reply-To: [EMAIL PROTECTED]
>
>On Mon, 5 Mar 2001, ANIL SETH wrote:
>
>> Our move at PHIL to Postgres 7.03 was painless.
>
>Betas of 7.1 (beta-5) are now available at
>ftp://ftp.postgresql.org/pub/dev/test-rpms. I have been using it now for
>the last three months without any major problems (admittedly on uncritical
>systems).
>
>Some interesting features are
>
>1. Increase in oracle like built-in functions
>2. Support for left and right outer joins.
>3. WAL
>
>> One thing which surprises us is that it seems to use indexes less
>> often
>
>The query planner in Postgres is highly intelligent in the sense that for
>small number of records, a sequential scan actually turns out to be
>faster. Check the third column in the explain output to see the number of
>affected rows. In any case, building correct indices is a black art ;) For
>further tricks on getting the backend to use the right index, see Tim
>Perdue's excellent set of tutorials on www.phpbuilder.com. Sorry I dont
>have the URL handy.
>
>> but is faster!
>
>Yes. I just installed Oracle 8.1.6 (Enterprise Edition) on my machine here
>and was amazed at how much tweaking I had to do (took me over 6 hours) to
>get Oracle to run on RH 7.0. It is apparently a problem with RH's choice
>of glibc that causes the problem, but I do have Oracle up and humming. I
>did some intensive benchmarks too (Oracle is faster marginally) but the
>interesting thing is that it takes upwards of 400 MB to store the
>database templates and about 1. 3 GB for the entire engine and tools. I
>wonder if so much hoo haa is worth the few microseconds that oracle
>shaves off the job.
>
>> We are keen to move to 7.1, especially for write ahead logs (WAL)
>
>We would be keen to hear your experiences here, especially on production
>level databases.
>
>Thanks and regards,
>Gurunandan
>
>
>
>------------------------ Yahoo! Groups Sponsor ---------------------~-~>
>Find software faster. Search more than 20,000
>software solutions on KnowledgeStorm. Register
>now and get started.
>http://us.click.yahoo.com/nHk3aB/wMSCAA/Di4EAA/0qAVlB/TM
>---------------------------------------------------------------------_->
>
>To Post a message, send it to: [EMAIL PROTECTED]
>To Unsubscribe, send a blank message to: [EMAIL PROTECTED]
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
----- End forwarded message -----
--
Rajesh Fowkar
(Computer Programmer)
V. S. DEMPO & CO. LTD., PANAJI-GOA
Email ID : [EMAIL PROTECTED], [EMAIL PROTECTED]
Web Site : http://www.dempos.com
----------------------------------------------
An alpha version of a web based tool to manage
your subscription with this mailing list is at
http://lists.linux-india.org/cgi-bin/mj_wwwusr
