PgSql

8.3 / 8.2.6 restore comparison
Added to TODO: o Impove COPY performance http://archives.postgresql.org/pgsql-hackers/2008-02/msg00954.php --------------------------------------------------------------------------- Heikki Linnakangas wrote: Bruce Momjian wrote: Heikki, are there any TODO items here? H... 24 Apr 2008 13:27

hm, why isn't SGT in the default timezone abbreviations list?
According to the zic database, SGT is the recognized abbreviation for Singapore time, and there are no other conflicting uses. I wonder why it isn't in either the Default or Asia lists ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subs... 24 Apr 2008 11:51

Is this TODO item done?
Is this TODO item done? * Allow index scans to return matching index keys http://archives.postgresql.org/pgsql-hackers/2007-03/msg01079.php -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard dr... 24 Apr 2008 12:39

Avoiding a needless failure of PITR
Hi, PITR always fails in finding the archived log file with wrong size. But, I think that we can continue PITR if .ready file of the same name exists in XLOGDIR/archive_status, ie the complete file might exist in XLOGDIR. I want to modify the implementation of PITR a little as follows. - In PITR, if the arch... 24 Apr 2008 11:03

libpq object hooks -- needs copy result
We are trying to clean up the object hooks patch (on the libpq side) in time for the May commit fest. The last version we posted is here: http://www.nabble.com/libpq-object-hooks-patch-to16707707.html Everything for the most part works ok but there is a problem with the function 'PQmakeResult' which essentially ... 24 Apr 2008 12:39

Batch update of indexes on data loading
On Tue, 2008-02-26 at 09:08 +0000, Simon Riggs wrote: I very much like the idea of index merging, or put another way: batch index inserts. How big do the batch of index inserts have to be for us to gain benefit from this technique? Would it be possible to just buffer the index inserts inside the indexam m... 24 Apr 2008 07:38

I think this is a BUG?
Kaloyan Iliev wrote: Hi, I find something very interesting which I think is a bug and I want to discuss it. --------------------------------------------------------------------------- Here is the example1: 1.I create a table without PK; 2.Insert 1 row; 3.I ADD PK; 4.When I select all ID'... 24 Apr 2008 14:15

Per-table random_page_cost for tables that we knoware always cached
Decibel! wrote: we can just look at the hit rate for the object. But we'd also need stats for how often we find pages for a relation in the OS cache, which no one has come up with a good method for. Makes me wonder if we could (optionally, I guess, since timing stuff is apparently slow on some syste... 24 Apr 2008 00:29

Proposed patch - psql wraps at window width
I have moved this discussion to hackers in hopes of getting more feedback, and moved the patch to a static URL: ftp://momjian.us/pub/postgresql/mypatches/wrap This patch adds a new '\pset format wrapped' mode that wraps long values to fit the table on the user's screen, or in '\pset columns' columns in an out... 6 May 2008 23:28

WIP: psql default banner patch v4
On Wed, 23 Apr 2008 10:48:24 -0700 "Joshua D. Drake" <jd(a)commandprompt.com> wrote: O.k. I *think* this should do it. Added word Some Version shows up no matter what Server version shows up only if: major or minor version doesn't match (same same as previous behavior) Joshua D. Drake -- The PostgreSQL... 23 Apr 2008 18:09