Re: [HACKERS] Re: Interesting Atricle
Thought some people might find this article interesting. http://www.zend.com/zend/art/databases.php The only interesting thing I noticed is how fast it crashes my Netscape-4.76 browser ;) Use Konqueror :-) I can't tell if the results are biased, but it puts PostgreSQL way ahead of MySQL and Interchange in performance (if more than a couple of simultaneous users) and most other features. Only bad words are about lack of LO support. -- Kaare Rasmussen--Linux, spil,--Tlf:3816 2582 Kaki Datatshirts, merchandize Fax:3816 2501 Howitzvej 75 Åben 14.00-18.00Web: www.suse.dk 2000 FrederiksbergLørdag 11.00-17.00 Email: [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [HACKERS] Re: Interesting Atricle
On Fri, 1 Jun 2001, Bruce Momjian wrote: Thought some people might find this article interesting. http://www.zend.com/zend/art/databases.php The only interesting thing I noticed is how fast it crashes my Netscape-4.76 browser ;) Yours too? I turned off Java/Javascript to get it to load and I am on BSD/OS. Strange it so univerally crashes. Really odd. I have Java/Javascript with FreeBSD and Netscape 4.76 and read it just fine. One difference tho probably, I keep style sheets shut off. Netscape crashes about 1% as often as it used to. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Re: Interesting Atricle
On Sat, 2 Jun 2001, Bruce Momjian wrote: Yours too? I turned off Java/Javascript to get it to load and I am on BSD/OS. Strange it so univerally crashes. Really odd. I have Java/Javascript with FreeBSD and Netscape 4.76 and read it just fine. One difference tho probably, I keep style sheets shut off. Netscape crashes about 1% as often as it used to. I can confirm turning off stylesheets fixed the crash on my system too. Vince, what disadvantages are there to keep stylesheets off? Text placement and colors on some sites gets a bit out of whack. Datek's website has text on top of other text, but still works. I trashed the style sheets on the PostgreSQL website long ago and never used them on other sites I write. Vince. -- == Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED]http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] Re: [GENERAL] +/- Inf for float8's
[ continuing a discussion from last August ] Peter Eisentraut [EMAIL PROTECTED] writes: Bruce Momjian writes: My assumption is that we never came up with any solution to this, right? It stopped when we noticed that proper support for non-finite values will break indexing, because the relational trichotomy doesn't hold. I believe that's not a problem anymore. The current form of the float comparison functions will perform sorting and comparisons according to the sequence -infinity normal values infinity NaN NULL with all NaNs treated as equal. This may not be exactly what an IEEE purist would like, but given that we have to define *some* consistent sort order, it seems as reasonable as we can get. Accordingly, I suggest that Ross go back to work on persuading the code to treat infinities and NaNs properly in other respects. IIRC, there are still open issues concerning whether we still need/want CheckFloat8Val/CheckFloat4Val, what the I/O conversion functions should do on non-IEEE machines, etc. They all seemed soluble, though. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Re: [GENERAL] +/- Inf for float8's
Peter Eisentraut [EMAIL PROTECTED] writes: I was thinking about making NaN equivalent to NULL. Mumble ... in the thread last August, someone made the point that SQL's idea of NULL (unknown value) is not really the same as a NaN (I know that this is not a well-defined number). Even though there's a lot of similarity in the behaviors, I'd be inclined to preserve that semantic distinction. If we did want to do this, the implication would be that all float-returning functions would be required to make sure they were not returning NaNs: if (isnan(x)) PG_RETURN_NULL(); else PG_RETURN_FLOAT8(x); Possibly this logic could be folded right into the PG_RETURN_FLOAT macros. if the platform supports it we ought to make the Invalid Operation FP exception (which yields NaN) configurable: either get NULL or get an error. Seems like we could equally well offer the switch as either get NaN or get an error. Something to be kept in mind here is the likelihood of divergence in our behavior between IEEE and non-IEEE platforms. I don't object to that --- it's sort of the point --- but we should be aware of how much difference we're creating, and try to avoid unnecessary differences. Hmm ... I suppose an attraction of a NULL-vs-error, as opposed to NaN- vs-error, option is that it could theoretically be supported on NaN-less hardware. But is that realizable in practice? SIGFPE is messy. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl