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
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
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
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
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
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
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.
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
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,
*
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
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
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
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
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
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,
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
16 matches
Mail list logo