Re: [HACKERS] How good is FreeBSD for postgres ?

On Mon, 17 May 1999, The Hermit Hacker wrote:

> Date: Mon, 17 May 1999 00:35:00 -0300 (ADT)
> From: The Hermit Hacker <scrappy@hub.org>
> To: Oleg Bartunov <oleg@sai.msu.su>
> Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgreSQL.org
> Subject: Re: [HACKERS] How good is FreeBSD for postgres ? 
> 
> 
> Will look at them right now...

I see you did a job ! Postgres 6.5 cvs works now under FreeBSD 3.1 release 
(elf) as on my lovely Linux box ! Almost all regression tests passed
except float8, horology and geometry and rules (could somebody correct
pgsql <-> postgres in .out). 

I think it would be useful to apply these fixes to 6.4.2 too.
Regards,    Oleg

PS.

10:05:47[nature]:/usr/home/postgres/cvs/pgsql/src/test/regress$ diff results/flo
at8.out expected/float8.out 
190,191d189
< ERROR:  floating point exception! The last floating point operation either exc
eeded legal ranges or was a divide by zero
< QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
192a191,192
> QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
> ERROR:  pow() result is out of range
198,206c198
< bad|            ?column?
< ---+--------------------
<    |                   1
<    |7.39912306090513e-16
<    |                   0
<    |                   0
<    |                   1
< (5 rows)
< 
---
> ERROR:  exp() result is out of range
223a216
> ERROR:  Input '10e-400' is out of range for float8
224a218
> ERROR:  Input '-10e-400' is out of range for float8
1

> 
> On Mon, 17 May 1999, Oleg Bartunov wrote:
> 
> > I read across /usr/ports/databases/postgresql on my FreeBSD 3.1 release
> > elf machine and found a lot of patches to postgres 6.4.2
> > It seems they are didn't applied - I checked 6.5 cvs.
> > What is the status of this port ? Is there is a chance to apply them
> > into 6.5 release ?
> > 
> > 
> >     Regards,
> >         
> >         Oleg
> > 
> > On Sun, 16 May 1999, Tom Lane wrote:
> > 
> > > Date: Sun, 16 May 1999 10:03:32 -0400
> > > From: Tom Lane <tgl@sss.pgh.pa.us>
> > > To: The Hermit Hacker <scrappy@hub.org>
> > > Cc: Oleg Bartunov <oleg@sai.msu.su>, pgsql-hackers@postgreSQL.org
> > > Subject: Re: [HACKERS] How good is FreeBSD for postgres ? 
> > > 
> > > The Hermit Hacker <scrappy@hub.org> writes:
> > > > All known problems...I've always run PostgreSQL under FreeBSD, and have
> > > > yet to notice a problem with a -release version of it...
> > > > The regression tests are "base Linux", and some of the generated error
> > > > messages are different between the systems and/or rounding is slighty
> > > > different...
> > > 
> > > The backend crashes that he's showing in some of the tests are not
> > > known problems (to me anyway).  Any ideas?  Oleg, can you provide
> > > debugger backtraces from the corefiles those crashes generate?
> > > 
> > >             regards, tom lane
> > > 
> > 
> > _____________________________________________________________
> > Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> > Sternberg Astronomical Institute, Moscow University (Russia)
> > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> > phone: +007(095)939-16-83, +007(095)939-23-83
> > 
> 
> Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
> Systems Administrator @ hub.org 
> primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 
> 
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83