Re: [PATCHES] Diagnostic functions

2007-05-07 Thread Heikki Linnakangas
Peter Eisentraut wrote: Heikki Linnakangas wrote: Here's an update of Simon's Heap Page Diagnostic Functions. I now consider it ready to commit. How is this better than pg_filedump? It's handy to be able to inspect pages from within a live database. The new functions work through

Re: [PATCHES] [HACKERS] Full page writes improvement, code update

2007-05-07 Thread Koichi Suzuki
Hi, As replied to Patch queue triage by Tom, here's simplified patch to mark WAL record as compressable, with no increase in WAL itself. Compression/decompression commands will be posted separately to PG Foundary for further review. --- As suggested by Tom, I agree

Re: [PATCHES] HOT patches

2007-05-07 Thread Pavan Deolasee
On 5/7/07, Zoltan Boszormenyi [EMAIL PROTECTED] wrote: I tried your patchset on current CVS (some minutes old) and got this single regression below. Thanks for testing the patch. This failure is expected and I had mentioned this when I posted v7. With HOT, CIC is now a three step process

Re: [PATCHES] updated WIP: arrays of composites

2007-05-07 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: I'm still wondering if we can get away without a catalog change on that - e.g. could we look up an array type by looking for a pg_type entry containing the base type's oid in the typelem field? Or would that be too slow? (a) too slow, (b) not

[PATCHES] Implemented current_query

2007-05-07 Thread Tomas Doran
As suggested in the TODO list (and as I need the functionality myself), I have implemented the current_query interface to debug_query_string. I'm not sure the best place to put this, suggestions welcome.. Please review the patch attached. Cheers Tom pgsql-current_query.patch

Re: [PATCHES] Diagnostic functions

2007-05-07 Thread Heikki Linnakangas
Peter Eisentraut wrote: Am Montag, 7. Mai 2007 11:49 schrieb Heikki Linnakangas: It's handy to be able to inspect pages from within a live database. How reliable is it to inspect pages from within a database if you presumably suspect that database to be broken? As long as the page header

[PATCHES] ECPG patch to use prepare for improved performance

2007-05-07 Thread William Lawrance
This patch for ECPG utilizes the PQprepare and PQexecPrepared functions to cause SQL statements from ECPG to be cached. It does this without requiring any changes in the user's source program. It was developed during the preparation for a benchmark for a large customer. This benchmark

Re: [PATCHES] Implemented current_query

2007-05-07 Thread Neil Conway
On Mon, 2007-07-05 at 19:48 +0100, Tomas Doran wrote: As suggested in the TODO list (and as I need the functionality myself), I have implemented the current_query interface to debug_query_string. Comments: * docs need a bit more detail (they should emphasize that it is the current query