FAQ

PostgreSQL > pgsql-hackers > January 2011

Search Discussions

227 discussions - 2,965 posts

  • Greetings, Minor enhancement, but a valuable one imv. Hopefully there aren't any issues with it. :) Thanks! Stephen commit 3cb707aa9f228e629e7127625a76a223751a778b Author: Stephen Frost ...
    Stephen FrostStephen Frost
    Jan 12, 2011 at 2:23 pm
    Mar 11, 2011 at 2:21 pm
  • Attached. Dan and I have spent many, many hours desk-check and testing, including pounding for many hours in DBT-2 at high concurrency factors on a 16 processor box. In doing so, we found and fixed a ...
    Kevin GrittnerKevin Grittner
    Jan 25, 2011 at 3:31 am
    Feb 10, 2011 at 10:29 am
  • Here's the latest patch for sync rep. repository towards commit. My expectation is that commit is at least 2 weeks away, though there are no major unresolved problems. I expect essential follow on ...
    Simon RiggsSimon Riggs
    Jan 15, 2011 at 9:41 pm
    Feb 18, 2011 at 8:40 am
  • This patch creates pg_basebackup in bin/, being a client program for the streaming base backup feature. I think it's more or less done now. I've again split it out of pg_streamrecv, because it had ...
    Magnus HaganderMagnus Hagander
    Jan 15, 2011 at 6:10 pm
    Jan 24, 2011 at 5:38 am
  • Hello, Here's the patch that improves handling of arrays as pl/perl function input arguments, converting postgres arrays of arbitrary dimensions into perl array references. It includes regression ...
    Alexey KlyukinAlexey Klyukin
    Jan 11, 2011 at 10:25 pm
    Feb 18, 2011 at 2:12 am
  • I whipped up the attached patch tonight. It's pretty quick and dirty, so it's possible I've missed something, but the intent is to suppress writing of hint bits by buffers allocating backends, and by ...
    Robert HaasRobert Haas
    Jan 14, 2011 at 3:35 am
    Feb 7, 2011 at 7:04 pm
  • Hi all! I was a bit frustrated there was no function to generate a unique identifier for any oid. Instead of complaining, I decided to automate the process as far as possible. :) The result is a ...
    Joel JacobsonJoel Jacobson
    Jan 7, 2011 at 6:11 pm
    Jan 24, 2011 at 12:20 am
  • While looking at the backend code, I realized that error code for "terminating connection due to conflict with recovery" is ERRCODE_ADMIN_SHUTDOWN. I thought the error code is for somewhat a human ...
    Tatsuo IshiiTatsuo Ishii
    Jan 8, 2011 at 2:52 pm
    Feb 8, 2011 at 2:22 am
  • Attached is an updated streaming base backup patch, based off the work that Heikki started. It includes support for tablespaces, permissions, progress reporting and some actual documentation of the ...
    Magnus HaganderMagnus Hagander
    Jan 5, 2011 at 1:54 pm
    Jan 17, 2011 at 7:31 pm
  • Here's an issue for feedback from the community -- do we want to support truly serializable transactions on hot standby machines? The best way Dan and I have been able to think to do this is to build ...
    Kevin GrittnerKevin Grittner
    Jan 20, 2011 at 1:05 am
    Jan 22, 2011 at 3:50 am
  • One of the things that I ripped out of the SQL/MED syntax patch before committing it was the hack that made LOCK TABLE also work on FOREIGN TABLEs. Since we're treating a foreign table as a different ...
    Robert HaasRobert Haas
    Jan 7, 2011 at 1:16 pm
    Jan 17, 2011 at 1:12 am
  • Now that we have a basic over-the-wire base backup capability in walsender, it would be nice to allow taking multiple base backups at the same time. It might not seem very useful at first, but it ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 11, 2011 at 6:17 pm
    Mar 21, 2011 at 9:35 am
  • Folks, I've noticed over the years that we give people dire warnings never to send a KILL signal to the postmaster, but I'm unsure as to what are potential consequences of this, as in just exactly ...
    David FetterDavid Fetter
    Jan 13, 2011 at 2:38 pm
    May 27, 2011 at 11:05 am
  • This patch removes ALTER TYPE rewrites in cases we can already prove valid. I add a function GetCoerceExemptions() that walks an Expr according to rules discussed in the design thread, simplified ...
    Noah MischNoah Misch
    Jan 9, 2011 at 10:01 pm
    Feb 15, 2011 at 1:24 pm
  • Dear hackers :) Could you look at this thread from General. --- I say the backend if you have one "row type" output result treats it as the full output result, it's really bad if you use STRUCT types ...
    RsmoguraRsmogura
    Jan 12, 2011 at 10:21 am
    Feb 17, 2011 at 5:31 pm
  • Here I add the notion of an "exemptor function", a property of a cast that determines when calls to the cast would be superfluous. Such calls can be removed, reduced to RelabelType expressions, or ...
    Noah MischNoah Misch
    Jan 9, 2011 at 10:04 pm
    Jan 29, 2011 at 11:06 am
  • Hi, Following recent commit of the hstore Makefile cleaning, that I included into my extension patch too, I have a nice occasion to push version 27 of the patch. Please find it enclosed. This time ...
    Dimitri FontaineDimitri Fontaine
    Jan 24, 2011 at 9:22 am
    Feb 8, 2011 at 10:03 pm
  • Patching: patching file doc/src/sgml/func.sgml Hunk #6 succeeded at 10567 (offset 1 line). Hunk #7 succeeded at 10621 (offset 1 line). Hunk #8 succeeded at 10721 (offset 1 line). Hunk #9 succeeded at ...
    Pavel StehulePavel Stehule
    Jan 9, 2011 at 7:14 pm
    Feb 16, 2011 at 3:38 pm
  • I have been updating my work in progress here: http://git.postgresql.org/gitweb?p=users/jdavis/postgres.git;a=log;h=refs/heads/rangetypes Right now, it's not in a reviewable state, but those ...
    Jeff DavisJeff Davis
    Jan 4, 2011 at 7:29 am
    Jan 12, 2011 at 7:59 pm
  • Hi, what follows is a review of the FDW API patch from http://archives.postgresql.org/message-id/20110114212358.82C7.6989961C@metrosystems.co.jp All three patches apply cleanly and compile without ...
    Jan UrbańskiJan Urbański
    Jan 16, 2011 at 12:54 am
    Feb 23, 2011 at 12:28 am
  • Ok, I have made some progress. This is still a proof-of-concept patch, but the important pieces are working together. Synopsis: CREATE TYPE numrange AS RANGE (SUBTYPE=numeric, ...
    Jeff DavisJeff Davis
    Jan 11, 2011 at 9:16 am
    Feb 8, 2011 at 4:21 pm
  • Would anyone like to argue vigorously for or against the above proposal? I'll start: I think this is a good idea. I don't have a strong opinion on whether the exact details of Greg proposes above are ...
    Robert HaasRobert Haas
    Jan 13, 2011 at 10:19 pm
    Jan 23, 2011 at 3:12 am
  • Hello, As previously commented, here's a proposal with patch to turn foreign key checks into something less intrusive. The basic idea, as proposed by Simon Riggs, was discussed in a previous ...
    Alvaro HerreraAlvaro Herrera
    Jan 14, 2011 at 4:08 am
    Aug 3, 2011 at 5:04 pm
  • I've been thinking about how to fix GIN's assorted corner-case problems, as has been discussed several times, most recently here: http://archives.postgresql.org/pgsql-hackers/2010-10/msg00521.php See ...
    Tom LaneTom Lane
    Jan 4, 2011 at 9:09 pm
    Jan 18, 2011 at 11:53 pm
  • Greetings, This patch looked good, in general, to me. I added a few documentation updates and a comment, but it's a very straight-forward patch as far as I can tell. Passes all regressions and my ...
    Stephen FrostStephen Frost
    Jan 20, 2011 at 3:16 am
    Jan 26, 2011 at 4:17 pm
  • PgUS is preparing to fund a grant for PgUS members to learn and participate in the patch review process. We looking for experienced reviewers that can assist a candidate through to process of testing ...
    Richard BroersmaRichard Broersma
    Jan 24, 2011 at 8:17 pm
    Jan 27, 2011 at 12:28 pm
  • The attached patch implements the above-mentioned pg_ctl failover. Comments? Objections? Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
    Fujii MasaoFujii Masao
    Jan 12, 2011 at 3:15 pm
    Feb 16, 2011 at 4:00 am
  • For those of you using git, I wanted to point out that it is fairly easy to remove git branches. For example, I can easily remove a branch on my github repository using: $ git branch -d :branch_name ...
    Bruce MomjianBruce Momjian
    Jan 26, 2011 at 4:26 pm
    Jan 27, 2011 at 8:26 pm
  • Dear all, for the sake academic teaching, a colleague asked me in how far PostgreSQL does support object functionality these days. I am afraid my web research was not very fruitful to him; the ...
    Jörg Roman RudnickJörg Roman Rudnick
    Jan 31, 2011 at 8:56 am
    Feb 12, 2011 at 4:10 am
  • Here's a cutdown version of the idea about including WAL in the base backup. What I initially wanted was to introduce a way to guarantee that the required WAL (with some sort of cutoff of course) ...
    Magnus HaganderMagnus Hagander
    Jan 15, 2011 at 9:08 pm
    Jan 31, 2011 at 2:47 am
  • Is there value in moving test_fsync to /contrib? -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +
    Bruce MomjianBruce Momjian
    Jan 17, 2011 at 4:03 pm
    Jan 21, 2011 at 6:25 pm
  • Here's a new series of patches for the parallel dump/restore. They need to be applied on top of each other. The parallel pg_dump patch does not yet use the synchronized snapshot functionality from my ...
    Joachim WielandJoachim Wieland
    Jan 7, 2011 at 8:26 pm
    Feb 10, 2011 at 3:22 pm
  • Hi, We are using R to work with 64bit PostgreSQL client libraries, and to avoid compiler compatibility issues the R development community suggest using the same compiler for both the main application ...
    XiaoboGuXiaoboGu
    Jan 20, 2011 at 3:18 pm
    Jan 27, 2011 at 3:05 pm
  • Hi, i'v created a patch enables support for building PostgreSQL with Visual Studio 2010 or Microsoft Windows SDK for Windows 7 and .NET Framework 4 (Windows SDK 7.1). You can grab it from ...
    Brar PieningBrar Piening
    Jan 3, 2011 at 7:19 am
    Oct 23, 2011 at 7:30 pm
  • Currently, replication connections *always* logs something like: LOG: replication connection authorized: user=mha host=[local] There's no way to turn that off. I can't find the reasoning behind this ...
    Magnus HaganderMagnus Hagander
    Jan 16, 2011 at 2:19 pm
    Jan 19, 2011 at 5:16 pm
  • Hi, In the case where there are multiple standbys, when a failover happens, we usually calculate most advanced standby by using pg_last_xlog_receive_location or pg_last_xlog_replay_location, and ...
    Fujii MasaoFujii Masao
    Jan 13, 2011 at 7:24 am
    Mar 1, 2011 at 6:58 pm
  • Hi, Here is a patch that implements "named restore points". It allows DBAs to specify an exact point to which they can recover but that point will have a name, so they have a better control of when ...
    Jaime CasanovaJaime Casanova
    Jan 14, 2011 at 8:42 pm
    Feb 25, 2011 at 12:02 am
  • Here's the patch to add ENCODING option to COPY command. The fundamental issue was explained months ago: ...
    Hitoshi HaradaHitoshi Harada
    Jan 14, 2011 at 5:25 pm
    Feb 8, 2011 at 6:47 pm
  • This begins the patch series for the design I recently proposed[1] for avoiding some table rewrites in ALTER TABLE ... ALTER COLUMN ... TYPE. I'm posting these patches today: 0 - new test cases 1 - ...
    Noah MischNoah Misch
    Jan 9, 2011 at 10:00 pm
    Jan 16, 2011 at 10:21 pm
  • There's an issue where we don't seem to have consensus yet, so I figured I'd bounce it off the list. If the SSI patch were to be accepted as is, REPEATABLE READ would continue to provide the exact ...
    Kevin GrittnerKevin Grittner
    Jan 9, 2011 at 6:08 pm
    Jan 12, 2011 at 6:27 pm
  • On Fedora 14 I see these warnings while building ecpg's preproc.y: Use of assignment to $[ is deprecated at ./parse.pl line 21. Use of assignment to $[ is deprecated at ./check_rules.pl line 18. Any ...
    Tom LaneTom Lane
    Jan 22, 2011 at 11:06 pm
    Mar 6, 2011 at 12:01 pm
  • Has anyone written a in-depth description on how to traverse the pg_depend tree? The 'a' and 'i' deptype really makes it hard to figure out the dependency order, a topological sort does not work. My ...
    Joel JacobsonJoel Jacobson
    Jan 11, 2011 at 3:54 pm
    Jan 14, 2011 at 9:16 am
  • Hello list, I wanted to test the waters on how receptive people might be to an extension that would allow Postgres to support two passwords for a given role. I have recently encountered a case where ...
    Daniel FarinaDaniel Farina
    Jan 20, 2011 at 10:28 pm
    Jan 23, 2011 at 10:05 pm
  • Somebody asked about this on Depesz's blog today, and I think it's come up here before too, so I thought it might be worth my writing up a few comments on this. I don't think I'm going to have time ...
    Robert HaasRobert Haas
    Jan 5, 2011 at 2:41 am
    Jan 8, 2011 at 2:44 pm
  • Due to popular request (Hey, David's popular, right?), I'm posting a patch for Serializable Snapshot Isolation (SSI), although I don't yet have everything in it that I was planning on submitting ...
    Kevin GrittnerKevin Grittner
    Jan 10, 2011 at 4:03 pm
    Jan 14, 2011 at 10:27 am
  • With the attached patch I have managed to get Postgres built and running a clean set of regression tests using the Mingw64 toolset on my 64bit Windows7Pro machine. There's lots of work still to do ...
    Andrew DunstanAndrew Dunstan
    Jan 28, 2011 at 12:12 am
    Feb 16, 2011 at 6:14 am
  • I used the patch from CommitFest application and applied the following commit to fix a known issue: ...
    Anssi KääriäinenAnssi Kääriäinen
    Jan 17, 2011 at 3:26 pm
    Jan 18, 2011 at 1:25 pm
  • Functions to control recovery, to aid PITR and Hot Standby. pg_is_xlog_replay_paused() pg_xlog_replay_pause() pg_xlog_replay_resume() recovery.conf parameter: pause_at_recovery_target (bool) -- Simon ...
    Simon RiggsSimon Riggs
    Jan 14, 2011 at 11:09 am
    Jan 17, 2011 at 6:50 am
  • I've been going over this patch with a fine-tooth comb for the last two weeks, fixed some small bugs, added comments, made initdb a little friendlier, but no substantial changes. I'm going to start ...
    Peter EisentrautPeter Eisentraut
    Jan 14, 2011 at 9:42 pm
    Feb 9, 2011 at 4:53 pm
  • Dan found a few low-frequency assertions when he let the patch cook in DBT-2 for extended periods. For the most part they were over-zealous assertions, although he made a couple minor adjustments ...
    Kevin GrittnerKevin Grittner
    Jan 14, 2011 at 11:54 pm
    Jan 20, 2011 at 8:36 pm
Jan 2011
12345
Group Navigation
period‹ prev | Jan 2011 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions227
posts2,965
users140
websitepostgresql.org...
irc#postgresql

140 users for January 2011

Robert Haas: 476 posts Tom Lane: 374 posts Magnus Hagander: 173 posts Kevin Grittner: 145 posts Simon Riggs: 128 posts Bruce Momjian: 96 posts Dimitri Fontaine: 93 posts Heikki Linnakangas: 92 posts Andrew Dunstan: 74 posts Jan Urbański: 73 posts Fujii Masao: 66 posts Stephen Frost: 60 posts Noah Misch: 58 posts Josh Berkus: 57 posts Peter Eisentraut: 57 posts Itagaki Takahiro: 54 posts Jeff Davis: 50 posts David Fetter: 46 posts Alvaro Herrera: 45 posts Greg Smith: 45 posts
show more
Archives