[PATCHES] monitoring sort activities

2005-09-23 Thread Satoshi Nagayasu
Hi folks, I've created a patch to get following TODO item. > * %Add ability to monitor the use of temporary sort files This patch provides one system view (pg_stat_sorts) and one utility function (pg_stat_get_prev_sort_size). > snaga=# SELECT * from pg_stat_sorts; > heap_all | index_all | datu

Re: [PATCHES] PL/Python error checking

2005-09-23 Thread Michael Fuhr
On Fri, Sep 23, 2005 at 05:03:02PM -0400, Bruce Momjian wrote: > Michael Fuhr wrote: > > http://archives.postgresql.org/pgsql-patches/2005-06/msg00519.php > > I have backpatched this to 8.0.X. It did not apply cleanly to 7.4.X so > if you would like that version patched please submit a matching p

Re: [PATCHES] PL/Python error checking

2005-09-23 Thread Bruce Momjian
Michael Fuhr wrote: > On Mon, Jul 11, 2005 at 08:13:24PM -0600, Michael Fuhr wrote: > > On Sun, Jul 10, 2005 at 12:58:24AM -0400, Bruce Momjian wrote: > > > I am unclear about backpatching this. We have to weigh the risks of > > > applying or not applying to 8.0.X. Comments? > > > > Since 7.4, P

Re: [PATCHES] Improve psql's handling of multi-line queries

2005-09-23 Thread Bruce Momjian
This has been saved for the 8.2 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Steve Woodcock wrote: > Hi all, > > Attached is a patch for the following TODO item: > > o Improve psql's handling

Re: [PATCHES] [HACKERS] Improved \df(+) in psql + backward-compatibility

2005-09-23 Thread Bruce Momjian
Seems this item will have to remain for 8.2. I have added this to TODO: o Display IN, INOUT, and OUT parameters in \df+ It probably requires psql to output newlines in the proper column, which is already on the TODO list. ---

Re: [PATCHES] be-secure.c patch

2005-09-23 Thread Bruce Momjian
This has been saved for the 8.2 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Libor Hoho? wrote: > Hello PG folks, > the attachement contains a simple patch to adding of verification of clien

Re: [PATCHES] Free WAL caches on switching segments

2005-09-23 Thread Bruce Momjian
ITAGAKI Takahiro wrote: > Tom Lane <[EMAIL PROTECTED]> wrote: > > > > Here is a small patch to prevent undesired WAL file caching by kernel. > > > posix_fadvise(POSIX_FADV_DONTNEED) attempts to free cached pages and > > > the kernel will discard them in preference to other data caches. > > > > On

Re: [PATCHES] Multiple -t options for pg_dump

2005-09-23 Thread Neil Conway
On Fri, 2005-23-09 at 00:14 -0700, David Fetter wrote: > Yes. Please find enclosed round 2 of the patch. It implements > multiple -n's and multiple -t's, although I think it's broken for > multiple -n's with no -t's. BTW, have you read the (extensive) prior discussion of this topic? For example