1. 02 Sep, 2005 1 commit
    • Bruce Momjian's avatar
      Duplicate: · 55af2a43
      Bruce Momjian authored
      < * Maintain a map of recently-expired rows
      <
      <   This allows vacuum to target specific pages for possible free space
      <   without requiring a sequential scan.
      <
      Update entry:
      
      >   One complexity is that index entries still have to be vacuumed, and
      >   doing this without an index scan (by using the heap values to find the
      >   index entry) might be slow and unreliable, especially for user-defined
      >   index functions.
      55af2a43
  2. 01 Sep, 2005 6 commits
  3. 30 Aug, 2005 9 commits
  4. 29 Aug, 2005 5 commits
  5. 28 Aug, 2005 8 commits
  6. 27 Aug, 2005 8 commits
    • Tom Lane's avatar
      cost_agg really ought to charge something per output tuple; else there · 974e3cf3
      Tom Lane authored
      are cases where it appears to have zero run cost.
      974e3cf3
    • Tom Lane's avatar
      Change the division of labor between grouping_planner and query_planner · 4e5fbb34
      Tom Lane authored
      so that the latter estimates the number of groups that grouping will
      produce.  This is needed because it is primarily query_planner that
      makes the decision between fast-start and fast-finish plans, and in the
      original coding it was unable to make more than a crude rule-of-thumb
      choice when the query involved grouping.  This revision helps us make
      saner choices for queries like SELECT ... GROUP BY ... LIMIT, as in a
      recent example from Mark Kirkwood.  Also move the responsibility for
      canonicalizing sort_pathkeys and group_pathkeys into query_planner;
      this information has to be available anyway to support the first change,
      and doing it this way lets us get rid of compare_noncanonical_pathkeys
      entirely.
      4e5fbb34
    • Tom Lane's avatar
    • Tom Lane's avatar
      Fix two separate bugs in setrefs.c. set_subqueryscan_references needs · 5a7d3697
      Tom Lane authored
      to copy the whole plan tree before invoking adjust_plan_varnos(); else
      if there is any multiply-linked substructure, the latter might increment
      some Var's varno twice.  Previously there were some retail copyObject
      calls inside adjust_plan_varnos, but it seems a lot safer to just dup the
      whole tree first.  Also, set_inner_join_references was trying to avoid
      work by not recursing if a BitmapHeapScan's bitmapqualorig contained no
      outer references; which was OK at the time the code was written, I think,
      but now that create_bitmap_scan_plan removes duplicate clauses from
      bitmapqualorig it is possible for that field to be NULL while outer
      references still remain in the qpqual and/or contained indexscan nodes.
      For safety, always recurse even if the BitmapHeapScan looks to be outer
      reference free.  Per reports from Michael Fuhr and Oleg Bartunov.
      5a7d3697
    • Tom Lane's avatar
      Get the MIPS assembler syntax right. Also add a separate sync command; · 5824d021
      Tom Lane authored
      the reference I consulted yesterday said SC does a SYNC, but apparently
      this is not true on newer MIPS processors, so be safe.
      5824d021
    • Bruce Momjian's avatar
      Fix typo: · 338e28e2
      Bruce Momjian authored
      sql_information_info -> sql_implementation_info
      
      Robert Treat
      338e28e2
    • Bruce Momjian's avatar
      Add: · a1a19bb8
      Bruce Momjian authored
      > * Allow user-defined types to specify a type modifier at table creation
      >   time
      a1a19bb8
    • Bruce Momjian's avatar
      Update: · 542faa82
      Bruce Momjian authored
      >
      >   Another issue is whether underlying table changes should be reflected
      >   in the view, e.g. should SELECT * show additional columns if they
      >   are added after the view is created.
      542faa82
  7. 26 Aug, 2005 3 commits
    • Tom Lane's avatar
      Another try at the inlined MIPS spinlock code. Can't test this myself, · 846319db
      Tom Lane authored
      but for sure it's not any more broken than the prior version.
      846319db
    • Bruce Momjian's avatar
      Add: · f9244df7
      Bruce Momjian authored
      > 	o Issue a warning if a change-on-restart-only postgresql.conf value
      > 	  is modified  and the server config files are reloaded
      > 	o Mark change-on-restart-only values in postgresql.conf
      205a209
      > 	o Fix SELECT '0.01 years'::interval, '0.01 months'::interval
      f9244df7
    • Bruce Momjian's avatar
      Add description and item: · acba287a
      Bruce Momjian authored
      >
      > 	  Currently, while \e saves a single query as one entry, interactive
      > 	  queries are saved one line at a time.  Ideally all queries
      > 	  whould be saved like \e does.
      >
      > 	o Allow multi-line column values to align in the proper columns
      >
      > 	  If the second output column value is 'a\nb', the 'b' should appear
      > 	  in the second display column, rather than the first column as it
      > 	  does now.
      acba287a