From sneaker@powergrid.electriciti.com Thu May 11 03:42:58 1995
Received: from hofmann.CS.Berkeley.EDU (hofmann.CS.Berkeley.EDU [128.32.34.35]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id DAA13123 for <andrew@postgres.Berkeley.EDU>; Thu, 11 May 1995 03:42:57 -0700
From: sneaker@powergrid.electriciti.com
Received: from powergrid.electriciti.com (powergrid.electriciti.com [198.5.212.8]) by hofmann.CS.Berkeley.EDU (8.6.10/8.6.6.Beta11) with SMTP id DAA25313 for <andrew@cs.berkeley.edu>; Thu, 11 May 1995 03:42:55 -0700
Received: from slip01.cs1.electriciti.com by powergrid.electriciti.com with smtp
	(Smail3.1.29.1 #3) id m0s9Vk8-000HFgC; Thu, 11 May 95 03:45 PDT
Message-Id: <m0s9Vk8-000HFgC@powergrid.electriciti.com>
X-Sender: sneaker@powergrid.electriciti.com (Unverified)
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Date: Fri, 29 Jul 1994 11:22:04 -0100
To: andrew@cs.berkeley.edu
Subject: linux port of postgres95-beta
X-Mailer: <PC Eudora Version 1.4>
Status: RO


I have successfully tested the port of postgres95 to linux.

---------------------------------------------------------------------

The regression testing is majorly broken, I have not had time to look into 
it further to see just where the prooblem lies. However, it seems that the 
test  mechanism itself is broken, and not postgres itself.

The "runwisc.sh" benchmark produces timed results all "0.000" for all 
queries, I don't know if this is due to a test bug (the raw output of 
runwisc.sh looks fine), a clock resolution problem, or if it's true.

----------------------------------------------------------------------

I would recommend that a README.linux file be placed at ...postgres95/ to 
relate the linux port specific comilation info.

Here is what i had to do to successfully compile the port.

1. To compile the linux port, the dld librsry MUST be obtained and installed 
on the system. It enables dynamic link loading capability to the postgres 
port. The dld library can be obtained from the sunsite linux distributions. 
The current name is dld-3.2.5.

2. In the file, .../postgres95/src/mk/postgres.mk, the INSTALL variable 
needs to be changed from "bsdinstall" to "install".

3. In the file, .../postgres95/src/mk/port/postgres.mk.linux, the CFLAGS_OPT 
variable should contain "-m486 -O2", instead of "-O2". This allows for 486 
specific optimization to be performed by the compiler, greatly increasing 
the speed and minimizing system load for a 486 system. The 486 optimized 
executables will work on a 386 with no drawbacks (the 486 code is simply 
ignored) except for the slight increase of executable file size.

---------------------------------------------------------------------

This port was compiled with the linux kernel 1.2.8 and gcc 2.6.3.

The hardware consists of a 486dx2/66, 256k cache, 8 megs ram, 1 gig HD, 
clocked at 33.22 bogomips.

----------------------------------------------------------------------

I am incorporating this version into the development of an application which 
was previously under postgres v4.2, so that should give more insight as to 
the real-world workings under linux.
Jalon Q. Zimmerman
The Zimmerman Group
sneaker@powergrid.electriciti.com


