1. 19 Nov, 2001 1 commit
  2. 12 Oct, 2001 1 commit
  3. 13 Sep, 2001 1 commit
  4. 10 Sep, 2001 1 commit
  5. 09 May, 2001 2 commits
    • Bruce Momjian's avatar
      b0546a25
    • Bruce Momjian's avatar
      · a79b698a
      Bruce Momjian authored
      Here's a version of my suggested diffs transplanted to 7.1 beta 5.  I'm
      still looking at the best way to integrate Tom Vijlbrief's fixes
      (insofar as they're still needed); would 7.2 be a suitable time for
      incompatible API changes?
      
      
      Jeroen
      
      
      Changes:
      
      (*) Introduced bool, true, false (replacing some int, 1, 0)
      (*) Made some member functions const
      (*) Documented GetIsNull()
      (*) Marked DisplayTuples() and PrintTuples() as obsolescent; fixed possible
          portability problem (assumed that NULL pointer equals all-zero bit pattern)
      (*) PrintTuples(): renamed width parameter to fillAlign to conform with other
          usage; fixed memory leak and compile issue w.r.t. field separator (should
          also slightly improve performance)
      (*) Fixed some minor compilation issues
      (*) Moved "using namespace std;" out of headers, where they didn't belong; used
          new (temporary) preprocessor macro PGSTD to do this
      (*) Made ToString() static, removed unneeded memset(), made buffer size adapt
          to sizeof(int)
      (*) Made some constructors explicit
      (*) Changed some const std::string & parameters to plain std::string
      (*) Marked PgCursor::Cursor(std::string) as obsolescent (setter with same name
          as getter--bad style)
      (*) Renamed some paramaters previously named "string"
      (*) Introduced size_type typedef for number of tuples in result set
      (*) PgTransaction now supports re-opening after closing, and aborts if not
          explicitly committed prior to destruction
      
      J. T. Vermeulen
      a79b698a
  6. 01 May, 2001 1 commit
  7. 30 Apr, 2001 3 commits
  8. 20 Jan, 2001 1 commit
  9. 13 Jan, 2001 1 commit
  10. 26 Dec, 2000 1 commit
  11. 22 Dec, 2000 1 commit
  12. 30 Nov, 2000 1 commit
  13. 22 Nov, 2000 1 commit
  14. 13 Nov, 2000 1 commit
    • Bruce Momjian's avatar
      UUNET is looking into offering PostgreSQL as a part of a managed web · 2150c2ed
      Bruce Momjian authored
      hosting product, on both shared and dedicated machines.  We currently
      offer Oracle and MySQL, and it would be a nice middle-ground.
      However, as shipped, PostgreSQL lacks the following features we need
      that MySQL has:
      
      1. The ability to listen only on a particular IP address.  Each
         hosting customer has their own IP address, on which all of their
         servers (http, ftp, real media, etc.) run.
      2. The ability to place the Unix-domain socket in a mode 700 directory.
         This allows us to automatically create an empty database, with an
         empty DBA password, for new or upgrading customers without having
         to interactively set a DBA password and communicate it to (or from)
         the customer.  This in turn cuts down our install and upgrade times.
      3. The ability to connect to the Unix-domain socket from within a
         change-rooted environment.  We run CGI programs chrooted to the
         user's home directory, which is another reason why we need to be
         able to specify where the Unix-domain socket is, instead of /tmp.
      4. The ability to, if run as root, open a pid file in /var/run as
         root, and then setuid to the desired user.  (mysqld -u can almost
         do this; I had to patch it, too).
      
      The patch below fixes problem 1-3.  I plan to address #4, also, but
      haven't done so yet.  These diffs are big enough that they should give
      the PG development team something to think about in the meantime :-)
      Also, I'm about to leave for 2 weeks' vacation, so I thought I'd get
      out what I have, which works (for the problems it tackles), now.
      
      With these changes, we can set up and run PostgreSQL with scripts the
      same way we can with apache or proftpd or mysql.
      
      In summary, this patch makes the following enhancements:
      
      1. Adds an environment variable PGUNIXSOCKET, analogous to MYSQL_UNIX_PORT,
         and command line options -k --unix-socket to the relevant programs.
      2. Adds a -h option to postmaster to set the hostname or IP address to
         listen on instead of the default INADDR_ANY.
      3. Extends some library interfaces to support the above.
      4. Fixes a few memory leaks in PQconnectdb().
      
      The default behavior is unchanged from stock 7.0.2; if you don't use
      any of these new features, they don't change the operation.
      
      David J. MacKenzie
      2150c2ed
  15. 29 Sep, 2000 1 commit
  16. 02 May, 2000 1 commit
  17. 19 Apr, 2000 1 commit
  18. 14 Apr, 2000 1 commit
  19. 31 Mar, 2000 1 commit
  20. 15 Feb, 2000 1 commit
    • Tom Lane's avatar
      New cost model for planning, incorporating a penalty for random page · b1577a7c
      Tom Lane authored
      accesses versus sequential accesses, a (very crude) estimate of the
      effects of caching on random page accesses, and cost to evaluate WHERE-
      clause expressions.  Export critical parameters for this model as SET
      variables.  Also, create SET variables for the planner's enable flags
      (enable_seqscan, enable_indexscan, etc) so that these can be controlled
      more conveniently than via PGOPTIONS.
      
      Planner now estimates both startup cost (cost before retrieving
      first tuple) and total cost of each path, so it can optimize queries
      with LIMIT on a reasonable basis by interpolating between these costs.
      Same facility is a win for EXISTS(...) subqueries and some other cases.
      
      Redesign pathkey representation to achieve a major speedup in planning
      (I saw as much as 5X on a 10-way join); also minor changes in planner
      to reduce memory consumption by recycling discarded Path nodes and
      not constructing unnecessary lists.
      
      Minor cleanups to display more-plausible costs in some cases in
      EXPLAIN output.
      
      Initdb forced by change in interface to index cost estimation
      functions.
      b1577a7c
  21. 25 Jan, 2000 1 commit
  22. 22 Nov, 1999 1 commit
  23. 08 Aug, 1999 1 commit
  24. 06 Jul, 1999 1 commit
  25. 17 Jun, 1999 1 commit
  26. 03 Jun, 1999 1 commit
  27. 27 May, 1999 1 commit
  28. 06 Apr, 1999 1 commit
  29. 30 Mar, 1999 1 commit
  30. 14 Oct, 1998 1 commit
  31. 10 Oct, 1998 1 commit
    • Thomas G. Lockhart's avatar
      Clean up markup. · d98011d8
      Thomas G. Lockhart authored
      Add new bibliographic references from Paul Aoki.
      Include libpq++ docs from the old man page in the Programmer's Guide.
      Update Unix installation info for ODBC.
      d98011d8