pgsql-server/ oc/src/sgml/runtime.sgml rc/back

pgsql-server/ oc/src/sgml/runtime.sgml rc/back

Post by Bruce Momji » Fri, 22 Nov 2002 12:34:03





> > Tom, do we really want to add a GUC that is used just for comparison of
> > performance?  I know we have the seqscan on/off, but there are valid
> > reasons to do that.  Do you think there will be cases where it will
> > faster to have this hash setting off?

> Sure --- that's why the planner code is going to great lengths to try to
> choose the faster one.  Even if I didn't think that, it'll be at least
> as useful as, say, enable_indexscan.

Oh, OK.  Just checking.  I was confused about your commit message
because you seemed to be saying it was mostly for testing, and I thought
you meant testing to see if the hash code is an improvement over what we
had, rather than to see if the hash code is an improvement over the
sequential scan GROUP BY path, which is still in the code.

--
  Bruce Momjian                        |  http://candle.pha.pa.us

  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

 
 
 

1. pgsql/doc/src/sgml (environ.sgml libpq++.sgml libpq.sgml runtime.sgml start.sgml)


Author: tgl

Update of /home/projects/pgsql/cvsroot/pgsql/doc/src/sgml
     from hub.org:/home/projects/pgsql/tmp/cvs-serv79643/doc/src/sgml

Modified Files:
        environ.sgml libpq++.sgml libpq.sgml runtime.sgml start.sgml

-----------------------------  Log Message  -----------------------------

Repair residual sillinesses from UUNET virtual host/socket path patch.
I hope all the dust has settled out now ...

2. Merging contents of fields into an other text field.

3. pgsql-server/ oc/src/sgml/installation.sgml rc ...

4. Trigger

5. pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm

6. Moving an output row to the top.

7. pgsql/ oc/src/sgml/pltcl.sgml rc/pl/tcl/pltcl.c

8. Field type that stores a 'file'

9. pgsql/ oc/src/sgml/libpgeasy.sgml rc/interface ...

10. pgsql/ oc/src/sgml/monitoring.sgml rc/backend/ ...

11. pgsql/ oc/src/sgml/libpq++.sgml rc/interfaces/ ...

12. pgsql/ oc/src/sgml/typeconv.sgml rc/interfaces ...

13. pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...