Skip to content

G
Gpdb

Greenplum / Gpdb

通知 7
Star 1
Fork 0
G
Gpdb

体验新版 GitCode，发现更多精彩内容 >>

切换分支/标签
  1. 14 6月, 2006 1 次提交
  3. 13 6月, 2006 2 次提交
  5. 11 6月, 2006 2 次提交
    • B
      Remove pg_dump wording: · 807bfa58
      由 Bruce Momjian 提交于 
      <   pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef(), and
<   make use of them in pg_dump
>   pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
      807bfa58
    • B
      Add: · 0d001c86
      由 Bruce Momjian 提交于 
      <   pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
>   pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef(), and
>   make use of them in pg_dump
      0d001c86
  7. 10 6月, 2006 2 次提交
    • B
      Cleanups: · 91431449
      由 Bruce Momjian 提交于 
      < 	* Allow a database in tablespace t1 with tables created in
> 	o Allow a database in tablespace t1 with tables created in
125c125
< 	* Allow reporting of which objects are in which tablespaces
> 	o Allow reporting of which objects are in which tablespaces
593c593
< 	* Allow GRANT/REVOKE permissions to be inherited by objects based on
> 	o Allow GRANT/REVOKE permissions to be inherited by objects based on
596c596
< 	* Allow SERIAL sequences to inherit permissions from the base table?
> 	o Allow SERIAL sequences to inherit permissions from the base table?
      91431449
    • B
      Cleanup: · c0ba4829
      由 Bruce Momjian 提交于 
      < * -%Allow pooled connections to list all prepared statements
> * -Allow pooled connections to list all prepared statements
      c0ba4829
  9. 09 6月, 2006 5 次提交
  11. 08 6月, 2006 11 次提交
  13. 07 6月, 2006 2 次提交
    • T
      Make the planner estimate costs for nestloop inner indexscans on the basis · 8a30cc21
      由 Tom Lane 提交于 
      that the Mackert-Lohmann formula applies across all the repetitions of the
nestloop, not just each scan independently.  We use the M-L formula to
estimate the number of pages fetched from the index as well as from the table;
that isn't what it was designed for, but it seems reasonably applicable
anyway.  This makes large numbers of repetitions look much cheaper than
before, which accords with many reports we've received of overestimation
of the cost of a nestloop.  Also, change the index access cost model to
charge random_page_cost per index leaf page touched, while explicitly
not counting anything for access to metapage or upper tree pages.  This
may all need tweaking after we get some field experience, but in simple
tests it seems to be giving saner results than before.  The main thing
is to get the infrastructure in place to let cost_index() and amcostestimate
functions take repeated scans into account at all.  Per my recent proposal.

Note: this patch changes pg_proc.h, but I did not force initdb because
the changes are basically cosmetic --- the system does not look into
pg_proc to decide how to call an index amcostestimate function, and
there's no way to call such a function from SQL at all.
      8a30cc21
    • B
      Add URL to RESET CONNECTION: · 05631354
      由 Bruce Momjian 提交于 
      <   notify the protocol when a RESET CONNECTION command is used.
>   notify the protocol when a RESET CONNECTION command is used.  See
>   http://archives.postgresql.org/pgsql-patches/2006-04/msg00192.php
>   for a partial implementation.
      05631354
  15. 06 6月, 2006 1 次提交
    • B
      Done: · 491a8c27
      由 Bruce Momjian 提交于 
      < * %Make postmater and postgres options distinct so the postmaster -o
> * -Make postmater and postgres options distinct so the postmaster -o
      491a8c27
  17. 05 6月, 2006 2 次提交
    • T
      Increase the default value of cpu_index_tuple_cost from 0.001 to 0.005. · e4de635a
      由 Tom Lane 提交于 
      This shouldn't affect simple indexscans much, while for bitmap scans that
are touching a lot of index rows, this seems to bring the estimates more
in line with reality.  Per recent discussion.
      e4de635a
    • T
      Add a GUC parameter seq_page_cost, and use that everywhere we formerly · eed6c9ed
      由 Tom Lane 提交于 
      assumed that a sequential page fetch has cost 1.0.  This patch doesn't
in itself change the system's behavior at all, but it opens the door to
people adopting other units of measurement for EXPLAIN costs.  Also, if
we ever decide it's worth inventing per-tablespace access cost settings,
this change provides a workable intellectual framework for that.
      eed6c9ed
  19. 04 6月, 2006 4 次提交
    • B
      Update: · f6dc20e1
      由 Bruce Momjian 提交于 
      < * %Remove behavior of postmaster -o
> * %Make postmater and postgres options distinct so the postmaster -o
>   option is no longer needed
      f6dc20e1
    • B
      Update: · d7739850
      由 Bruce Momjian 提交于 
      < 	o Allow COPY to output from views
> 	o Allow COPY to output from SELECT
570c570
< 	  Another idea would be to allow actual SELECT statements in a COPY.
> 	  COPY should also be able to output views.
      d7739850
    • B
      Update GUI FAQ. · e5b19806
      由 Bruce Momjian 提交于 
      Robert Treat
      e5b19806
    • B
      Update GUI tools URL. · 1309c6f5
      由 Bruce Momjian 提交于 
      Robert Treat
      1309c6f5
  21. 03 6月, 2006 4 次提交
  23. 01 6月, 2006 2 次提交
  25. 31 5月, 2006 2 次提交