Re: [PATCHES] pgstattuple extension for indexes

2006-07-28 Thread satoshi nagayasu
Hi folks, As I said on -PATCHES, I've been working on an utility to get a b-tree index information. I'm happy to introduce my new functions to you. pgstattuple module provides a `pgstatindex()`, and other small functions, which allow you to get b-tree internal information. I believe this module

Re: [PATCHES] extension for sql update

2006-07-28 Thread Susanne Ebrecht
Am Donnerstag, den 27.07.2006, 08:30 -0400 schrieb Tom Lane: Susanne Ebrecht [EMAIL PROTECTED] writes: ... We could provide the mixed update syntax and leave the typed row value expression for the next release. Do you agree? I don't really see the point --- the patch won't provide any new

Re: [HACKERS] [PATCHES] putting CHECK_FOR_INTERRUPTS in qsort_comparetup()

2006-07-28 Thread Charles Duffy
On 7/15/06, Tom Lane [EMAIL PROTECTED] wrote: Anyway, Qingqing's question still needs to be answered: how can a sort of under 30k items take so long? It happens because (as previously suggested by Tom) the dataset for the 'short' (~10k rows, .3 sec) sort has no rows whose leftmost fields

[PATCHES] selecting large result sets in psql using cursors

2006-07-28 Thread Chris Mair
Hi there, attached is the new and fixed version of the patch for selecting large result sets from psql using cursors. It was previously discussed on hackers: http://archives.postgresql.org/pgsql-hackers/2006-07/msg00231.php Thanks again to Neil Conway for helping with this (the first sketch of

Re: [HACKERS] [PATCHES] putting CHECK_FOR_INTERRUPTS in qsort_comparetup()

2006-07-28 Thread Tom Lane
Charles Duffy [EMAIL PROTECTED] writes: ... For the 'long' data, the compare moves on rightward until it encounters 'flato', which is a TEXT column with an average length of 7.5k characters (with some rows up to 400k). The first 6 columns are mostly INTEGER, so compares on them are relatively

Re: [PATCHES] pgstattuple extension for indexes

2006-07-28 Thread Bruce Momjian
I thought these new functions were going to be merged into /contrib/pgstattuple. --- satoshi nagayasu wrote: Hi folks, As I said on -PATCHES, I've been working on an utility to get a b-tree index information. I'm happy

Re: [HACKERS] [PATCHES] pgstattuple extension for indexes

2006-07-28 Thread Alvaro Herrera
Bruce Momjian wrote: I thought these new functions were going to be merged into /contrib/pgstattuple. Well, that's exactly what this patch seems to do ... -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.

Re: [HACKERS] [PATCHES] Resurrecting per-page cleaner for btree

2006-07-28 Thread Jim C. Nasby
On Thu, Jul 27, 2006 at 05:24:35PM -0400, Greg Stark wrote: Jim Nasby [EMAIL PROTECTED] writes: Even if we stopped right there it would still be a huge win in many (most?) cases. How often do the indexes on a table comprise even 50% of the table's size? I would say they're usually

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: *** src/test/regress/pg_regress.c 27 Jul 2006 15:37:19 - 1.16 --- src/test/regress/pg_regress.c 28 Jul 2006 19:01:12 - *** *** 813,823 * work for inspecting the results of system(). For the moment, *

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: *** src/test/regress/pg_regress.c 27 Jul 2006 15:37:19 - 1.16 --- src/test/regress/pg_regress.c 28 Jul 2006 19:01:12 - *** *** 813,823 * work for inspecting the results of system(). For the

Re: [PATCHES] [HACKERS] 8.2 features?

2006-07-28 Thread Bruce Momjian
Are you going to apply this? Seems it is ready. --- Joe Conway wrote: Tom Lane wrote: Christopher Kings-Lynne [EMAIL PROTECTED] writes: Strange. Last time I checked I thought MySQL dump used 'multivalue lists in

Re: [PATCHES] [HACKERS] 8.2 features?

2006-07-28 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Are you going to apply this? Seems it is ready. I thought Joe was off in a corner doing a whole new version. (I'm willing to help if he needs help...) regards, tom lane ---(end of

Re: [PATCHES] [HACKERS] 8.2 features?

2006-07-28 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Are you going to apply this? Seems it is ready. I thought Joe was off in a corner doing a whole new version. (I'm willing to help if he needs help...) OK, just checking. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: I checked on MinGW and system() just returns the value returned by the application. There isn't any special two-values-in-one layering like is done on Unix for wait() and the return value from system(). It seems if the child dies from a signal, the

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: The cases that I think we most need to defend against are (A) diff program not found In summary, on MinGW, files differ or 'diff' not found, returns 1. If one of the files to be compared does not exist, it returns 2. And of course,

Re: [PATCHES] [HACKERS] pg_regress breaks on msys

2006-07-28 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: The cases that I think we most need to defend against are (A) diff program not found In summary, on MinGW, files differ or 'diff' not found, returns 1. If one of the files to be compared does not exist, it