Return to BSD News archive
Path: euryale.cc.adfa.oz.au!newshost.carno.net.au!harbinger.cc.monash.edu.au!munnari.OZ.AU!news.mel.connect.com.au!news.mel.aone.net.au!grumpy.fl.net.au!news.webspan.net!www.nntp.primenet.com!nntp.primenet.com!cs.utexas.edu!chi-news.cic.net!news.math.psu.edu!not-for-mail From: tenser@spitfire.ecsel.psu.edu (Dan Cross) Newsgroups: comp.unix.bsd.freebsd.misc Subject: Re: Databases that runs on FreeBSD Date: 29 Jan 1997 01:30:44 -0500 Organization: Penn State ECSEL Computer Laboratory Lines: 30 Message-ID: <5cmqqk$dr3@spitfire.ecsel.psu.edu> References: <5bltbc$r8t@kodak.rdcs.kodak.com> <5c150q$7nn@uriah.heep.sax.de> <5c1q01$koh@nova.dimensional.com> <5cm5a2$ssn@news.webspan.net> NNTP-Posting-Host: spitfire.ecsel.psu.edu Xref: euryale.cc.adfa.oz.au comp.unix.bsd.freebsd.misc:34666 In article <5cm5a2$ssn@news.webspan.net>, Gary Palmer <gpalmer@webspan.net> wrote: >> I don't recall having any difficulty building it, but I recommend >> reading INSTALL carefully before starting. You'll need GNU make >> for the build. > >Depending on which FreeBSD revision you are running, you may need a >newer version of flex (from memory). Actually, you need an older version of flex. 2.5.3 had a bug that prevented PostgreSQL from compiling with the code that it generated. 2.5.2 produced correct output, however. >And now a question of my own: > >How well would the different ``free'' databases handle, say, several >hundred thousand records, and being queried more than once a second? >I'm curious for an upcoming development I've heard of ... This is just pure speculation, but I'd guess that mSQL might be a little faster, but PostgreSQL can definately handle the record quantities. You might want to check out some of the stuff on http://www.PostgreSQL.ORG. If you were going to go with PostgreSQL for this application, the only thing I'd be concerned with is the frequency of the queries, not so much the size of the database or number of records... - Dan C. (btw- it's interesting to note that www.PostgreSQL.ORG is running FreeBSD. :-)