Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.postgresql Subject: Re: Is PostgreSQL good? Date: Thu, 30 Jun 2011 15:41:32 +0000 (UTC) Organization: solani.org Lines: 26 Message-ID: References: <1308640710.210659@proxy.dienste.wien.at> <1308738638.232318@proxy.dienste.wien.at> <1308911383.819034@proxy.dienste.wien.at> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1309448492 732 eJwFwQkBACAIBLBKghxIHN7+EdxwlbRMFCpYLHdh6HIa+3QkjLYqjjTidM9KegHh9tY59QMzFhHx (30 Jun 2011 15:41:32 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Thu, 30 Jun 2011 15:41:32 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwdyckNACEMA8CWchq2HJKY/ktA2vlOOhS9AonIm1c55JirsrYcmaXfvxbRXu1ImzqWYiD3PBxUEPA= Cancel-Lock: sha1:eV1YuhSuuqBSgJEFgzqQ1FDmLvo= X-NNTP-Posting-Host: eJwNyMEBwCAIA8CVVBLAcSTK/iO09zyaT1fA6WCzb4xsnR4qA4prI/9colhdgRN2U2NbPs58HyuNEW4= Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:167 On Thu, 30 Jun 2011 07:05:54 -0700, Don Y wrote: > Are hints on a par with the 'register' keyword in C? Yes. > I.e., something > you *hope* gives the compiler an insight into your algorithm -- but, > that the compiler is free to *ignore*? C compiler is not free to ignore "register" keyword and neither is the database free to ignore hints. Compiler has to place your variable in a register, if there is one available. Database also must obey hints, if possible. Also, with C there is one more keyword, namely "asm", which may be used to coerce the code to behave precisely as you want. This analogy is not good for several reasons, the main one being the difference between the directly executable vs. interpreted paradigms. If C was the only compiler to disallow "hints", it wouldn't be so popular. Now, if PostgreSQL was the only major database to disallow hints...? -- http://mgogala.byethost5.com