Re: [HACKERS] Checkpointer split has broken things dramatically (was Re: DELETE vs TRUNCATE explanation)

2012-07-22 Thread David Fetter
On Tue, Jul 17, 2012 at 06:56:50PM -0400, Tom Lane wrote: > Robert Haas writes: > > On Mon, Jul 16, 2012 at 3:18 PM, Tom Lane wrote: > >> BTW, while we are on the subject: hasn't this split completely > >> broken the statistics about backend-initiated writes? > > > Yes, it seems to have done jus

[HACKERS] FW: Patch for option in pg_resetxlog for restore from WAL files

2012-07-22 Thread Amit kapila
I have uploaded the patch for new option in pg_resetxlog at below location: https://commitfest.postgresql.org/action/patch_view?id=897 This completes the implementation of Option-2 discussed in below mail. Now I will work on Option-1 (1. To compute the value of max LSN in data pages based o

Re: [HACKERS] Restrict ALTER FUNCTION CALLED ON NULL INPUT (was Re: Not quite a security hole: CREATE LANGUAGE for non-superusers)

2012-07-22 Thread Noah Misch
On Fri, Jul 20, 2012 at 03:39:33PM -0400, Robert Haas wrote: > On Fri, Jul 20, 2012 at 1:52 PM, Tom Lane wrote: > > And with that too. The STRICT option is a fairly obvious security > > hazard, but who's to say there are not others? I think it'd be easier > > to make a case for forbidding a non-

Re: [HACKERS] b-tree index search algorithms

2012-07-22 Thread Samuel Vogel
Am 20.07.12 01:40, schrieb Tom Lane: RelationGetDescr(rel)->attrs[n]->attbyval Thanks! Now does 'Relation' refer to the whole table or only the columns that are supposed to be scanned? So will RelationGetDescr(rel)->attrs[0] give me the description of the first column relevant to the current

Re: [HACKERS] bgwriter, regression tests, and default shared_buffers settings

2012-07-22 Thread Andrew Dunstan
On 07/19/2012 10:32 AM, Andrew Dunstan wrote: On 07/19/2012 10:12 AM, Tom Lane wrote: Robert Haas writes: On Wed, Jul 18, 2012 at 5:30 PM, Andrew Dunstan wrote: Or we could provide an initdb flag which would set an upper bound on shared_buffers, and have make check (at least) use it. How

Re: [HACKERS] isolation check takes a long time

2012-07-22 Thread Noah Misch
On Fri, Jul 20, 2012 at 01:39:34PM -0400, Alvaro Herrera wrote: > Excerpts from Noah Misch's message of mar jul 17 16:28:32 -0400 2012: > > The foreign key tests, however, would benefit > > from running under all three isolation levels. Let's control it per-spec > > instead of repeating the entire

Re: [HACKERS] [PATCH] lock_timeout and common SIGALRM framework

2012-07-22 Thread Boszormenyi Zoltan
2012-07-17 06:32 keltezéssel, Alvaro Herrera írta: Excerpts from Tom Lane's message of vie jul 13 18:23:31 -0400 2012: Boszormenyi Zoltan writes: Try SET deadlock_timeout = 0; Actually, when I try that I get ERROR: 0 is outside the valid range for parameter "deadlock_timeout" (1 .. 2147483