Re: [HACKERS][PATCHES] odd output in restore mode

2008-07-23 Thread Kevin Grittner
Heikki Linnakangas [EMAIL PROTECTED] wrote: We really need a more reliable way of detecting that a file has been fully copied. In our scripts we handle this by copying to a temp directory on the same mount point as the archive directory and doing a mv to the archive location when the

[PATCHES] Re: [HACKERS] OUTER JOIN performance regression remains in 8.3beta4

2008-01-07 Thread Kevin Grittner
On Sun, Jan 6, 2008 at 7:20 PM, in message [EMAIL PROTECTED], Tom Lane [EMAIL PROTECTED] wrote: Kevin Grittner [EMAIL PROTECTED] writes: There was a serious performance regression in OUTER JOIN planning going from 8.2.4 to 8.2.5. I know Tom came up with some patches to mitigate the issues

Re: [PATCHES] Warm standby patch

2007-07-02 Thread Kevin Grittner
On Mon, Jul 2, 2007 at 7:02 AM, in message [EMAIL PROTECTED], Simon Riggs [EMAIL PROTECTED] wrote: On Fri, 2007-06-29 at 17:04 -0500, Kevin Grittner wrote: I'm submitting this patch in attempt to clarify some issues with the warm standby documentation which caused some confusion in our

[PATCHES] Warm standby patch

2007-06-29 Thread Kevin Grittner
I'm submitting this patch in attempt to clarify some issues with the warm standby documentation which caused some confusion in our organization and which have been recently discussed on the admin list. -Kevin Index: backup.sgml ===

[PATCHES] Warm standby patch

2007-06-29 Thread Kevin Grittner
I'm submitting this patch in attempt to clarify some issues with the warm standby documentation which caused some confusion in our organization and which have been recently discussed on the admin list. I apologize for posting twice, but I noticed that my pseudo-code was unnecessarily long and

Re: [PATCHES] Additional current timestamp values

2006-03-30 Thread Kevin Grittner
On Mon, Mar 20, 2006 at 7:58 pm, in message [EMAIL PROTECTED], Bruce Momjian pgman@candle.pha.pa.us wrote: Tom Lane wrote: But not once per statement --- in reality, you get a fairly arbitrary behavior that will advance in some cases and not others when dealing with a multi- statement

[PATCHES] predicate locking knowledge

2006-03-23 Thread Kevin Grittner
Attached is a patch for the documentation. We currently state that we don't know of any production DBMS which uses predicate locking. Current versions of at least two commercial products (Sybase ASE and Microsoft SQL Server) do use it. I believe this has been true since 1990 or earlier. If

Re: [PATCHES] predicate locking knowledge

2006-03-23 Thread Kevin Grittner
On Thu, Mar 23, 2006 at 1:13 pm, in message [EMAIL PROTECTED], Kevin Grittner [EMAIL PROTECTED] wrote: Attachment didn't seem to go through. Embedding below. Index: mvcc.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml

Re: [PATCHES] [HACKERS] Backslashes in string literals

2006-02-13 Thread Kevin Grittner
The attached patch combines work from two patches recently posted by Bruce Momjian, along with a necessary change to guc.c which is missing from those patches. Please ignore all prior patches with this subject line and consider this a rollup. -Kevin standard-conforming-strings4.patch