PgSql

-DCLOBBER_CACHE_ALWAYS build takes far longer than before
Hi all, While working on our network problems to send the full build result to the buildfarm server, I just saw that a full buildfarm run with -DCLOBBER_CACHE_ALWAYS option takes nearly 2 hours more than before (from ~ 5h40 to 7h30). This phenomenon has started with this run: http://www.pgbuildfarm.org/cgi-bi... 20 Apr 2008 12:25

WAL files format
Hi, iam developing version control system based on content because i havent found anything for postgres and it sounds like great tool to have. Propably i will use Rules and Views with shadow tables, but iam interested in alternative to examine WAL files. So iam interested in WAL file format and information ... 21 Apr 2008 10:06

pgkill on win32
I'm wondering if the mechanism used for sending signals between postmaster processes on Win32 is much more heavyweight that is necessary. Is there a reason not to call OpenThread on the target postmaster's thread id, and then use QueueUserAPC to execute a 'signal handler' method on it? (Or Terminate Thread fo... 23 Apr 2008 05:08

TODO, FAQs to Wiki?
I am impressed at the state of the May wiki patch queue: http://wiki.postgresql.org/wiki/CommitFest:May It is even tracking the psql wrap patch I am working on now. Magnus has started moving the Developer's FAQ to a wiki. I am thinking we should move the main FAQ and the TODO list to a wiki as well if the ... 21 Apr 2008 18:09

TODO.detail removed
Alvaro Herrera wrote: Bruce Momjian wrote: Log Message: ----------- Remove TODO.detail references; instead add TODO URLs pointing to the archives. We have been using URLs for a while for new items. Thanks, this was a good move. I should have done it a long time ago. I started using U... 19 Apr 2008 11:32

Coding standards
Alvaro Herrera wrote: Yes they are useful. As a new patcher, where should I look for coding standards? How about a little FAQ at the top of the CVS source tree? The developer's FAQ is supposed to contain this kind of thing, but I think it's rather thin on actual details. (Some time ag... 18 Apr 2008 15:03

pgsql: Fix a couple of oversights associated with the "physical tlist"
[resending because the first went to -committers which is kind of bogus] "Tom Lane" <tgl(a)postgresql.org> writes: Log Message: ----------- Fix a couple of oversights associated with the "physical tlist" optimization: we had several code paths where a physical tlist could be used for the input to a ... 17 Apr 2008 22:06

RFD: hexstring(n) data type
I am confused how a hex type is any better than using the 'hex' decode() format we already support: test=> select decode('5476', 'hex'); decode -------- Tv (1 row) --------------------------------------------------------------------------- Dawid Kuroczko wrote: Following the discussion on maki... 17 Apr 2008 20:31

Cross-field statistics
"Decibel!" <decibel(a)decibel.org> writes: For each field that isn't already in a set of field groupings * Sort sample rows on that field * Calculate correlation for all other fields * If there are other fields that have a correlation to this sort order over some threshold, save them along with the f... 17 Apr 2008 13:21

Plan targetlists in EXPLAIN output
For debugging the planner work I'm about to do, I'm expecting it will be useful to be able to get EXPLAIN to print the targetlist of each plan node, not just the quals (conditions) as it's historically done. My first instinct is just to stick in the code under a debugging #ifdef, but I wonder if anyone wants to ar... 17 Apr 2008 22:06