FAQ

PostgreSQL > pgsql-hackers > January 2012

Search Discussions

159 discussions - 1,777 posts

  • So this is the parallel pg_dump patch, generalizing the existing parallel restore and allowing parallel dumps for the directory archive format, the patch works on Windows and Unix. In the first phase ...
    Joachim WielandJoachim Wieland
    Jan 15, 2012 at 6:02 pm
    Apr 4, 2012 at 10:17 am
  • It looks like initdb doesn't fsync all the files it creates, e.g. the PG_VERSION file. While it's unlikely that it would cause any real data loss, it can be inconvenient in some testing scenarios ...
    Jeff DavisJeff Davis
    Jan 28, 2012 at 12:19 am
    Jul 13, 2012 at 11:43 pm
  • In tuplesort.c, it initially reads tuples into memory until availMem is exhausted. It then switches to the tape sort algorithm, and allocates buffer space for each tape it will use. This ...
    Jeff JanesJeff Janes
    Jan 16, 2012 at 12:59 am
    May 1, 2012 at 8:05 pm
  • This patch adds a new GUC "sepgsql.client_label" that allows client process to switch its privileges into another one, as long as the system security policy admits this transition. Because of this ...
    Kohei KaiGaiKohei KaiGai
    Jan 10, 2012 at 11:28 am
    Mar 21, 2012 at 5:02 pm
  • Hi, The extension mechanism we added in 9.1 is aimed at allowing a fully integrated contrib management, which was big enough a goal to preclude doing anything else in its first release. Now we have ...
    Dimitri FontaineDimitri Fontaine
    Jan 8, 2012 at 9:05 pm
    Mar 8, 2012 at 4:07 pm
  • Going back through the patches we had to make to 9.0 to move to PostgreSQL triggers, I noticed that I let the issues raised as bug #6123 lie untouched during the 9.2 development cycle. In my view, ...
    Kevin GrittnerKevin Grittner
    Jan 11, 2012 at 11:33 pm
    Jun 5, 2012 at 5:14 pm
  • Attached is a patch that myself and Simon Riggs collaborated on. I took the group commit patch that Simon posted to the list back in November, and partially rewrote it. Here is that original thread: ...
    Peter GeogheganPeter Geoghegan
    Jan 15, 2012 at 10:42 pm
    Feb 7, 2012 at 8:15 am
  • So far the reaction I've gotten from my recent submission to make autovacuum log its read/write in MB/s has been rather positive. I've been surprised at the unprecedented (to me at least) amount of ...
    Greg SmithGreg Smith
    Jan 15, 2012 at 8:24 am
    Feb 9, 2012 at 2:42 pm
  • Recent results from Robert show clog contention is still an issue. In various discussions Tom noted that pages prior to RecentXmin are readonly and we might find a way to make use of that fact in ...
    Simon RiggsSimon Riggs
    Jan 8, 2012 at 2:26 pm
    Feb 28, 2012 at 7:22 pm
  • If this variable changes protocol-level layout and is user-settable, shouldn't it be GUC_REPORT? Now that I think about it, same applies to bytea_output? You could say the problem does not appear if ...
    Marko KreenMarko Kreen
    Jan 23, 2012 at 3:00 pm
    Jan 26, 2012 at 7:48 am
  • Right now we have a single table on http://www.postgresql.org/docs/devel/static/monitoring-stats.html#MONITORING-STATS-VIEWS that lists all our statistics views. It makes for difficult to parse ...
    Magnus HaganderMagnus Hagander
    Jan 15, 2012 at 8:51 am
    Feb 27, 2012 at 9:42 pm
  • Is this perhaps by design? Oy, this doesn’t look good: $ do LANGUAGE plperl $$ elog(NOTICE, $^V) $$; ERROR: server conn crashed? ERROR: server conn crashed? The connection to the server was lost. ...
    David E. WheelerDavid E. Wheeler
    Jan 4, 2012 at 5:48 am
    Jan 5, 2012 at 9:48 pm
  • Hello, Yesterday I was facing a little issue with a backup software (NetBackup) that do not report error when a post backup script is run. The problem is that this script execute pg_stop_backup() and ...
    Gilles DaroldGilles Darold
    Jan 30, 2012 at 6:34 pm
    Jun 14, 2012 at 7:36 pm
  • My laptop ran out of battery and turned itself off while I was just starting up postmaster. After plugging in the charger and rebooting, I got the following error when I tried to restart PostgreSQL: ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 5, 2012 at 1:19 pm
    Aug 29, 2012 at 9:06 pm
  • In order to simulate real-world clog contention, we need to use benchmarks that deal with real world situations. Currently, pgbench pre-loads data using COPY and executes a VACUUM so that all hint ...
    Simon RiggsSimon Riggs
    Jan 12, 2012 at 12:31 pm
    Feb 17, 2012 at 7:10 pm
  • The open items list for 9.2 says "Index-only scans need to be disabled when running under Hot Standby" There is no explanation, so please explain here so we can change it, if possible. Not sure its ...
    Simon RiggsSimon Riggs
    Jan 13, 2012 at 1:28 pm
    Jan 14, 2012 at 2:55 pm
  • It appears that the only way to create a non-inherited CHECK constraint is using ALTER TABLE. Is there no support in CREATE TABLE planned? That looks a bit odd.
    Peter EisentrautPeter Eisentraut
    Jan 17, 2012 at 5:00 pm
    Apr 19, 2012 at 3:26 pm
  • One of the most useful bits of feedback on how well checkpoint I/O is going is the amount of time taken to sync files to disk. Right now the only way to get that is to parse the logs. The attached ...
    Greg SmithGreg Smith
    Jan 16, 2012 at 6:28 am
    Apr 5, 2012 at 6:07 pm
  • Hi, Here's my review for the "logging hooks" patch queued for the 2012-01 CommitFest by Martin Pihlak. Submission review ---- The patch is in context diff format and applies fine. Tests are not ...
    Marti RaudseppMarti Raudsepp
    Jan 17, 2012 at 5:36 pm
    Mar 8, 2012 at 12:34 pm
  • I think I would like to have a set of GUC parameters to control the location of the server-side SSL files. In a setup that has all the other configuration files under /etc, the SSL files ought to go ...
    Peter EisentrautPeter Eisentraut
    Jan 2, 2012 at 4:32 am
    Feb 29, 2012 at 8:59 pm
  • Well, since I see other committers sending in patches the day after the nominal commitfest deadline, I don't feel too bad about being a bit late as well. Attached is a WIP patch for parameterized ...
    Tom LaneTom Lane
    Jan 17, 2012 at 5:07 am
    Jan 26, 2012 at 11:03 pm
  • In builds without --enable-cassert (I guess not many developers use those a lot), there are quite a few unused variable warnings. These usually hold some intermediate result that the assert checks ...
    Peter EisentrautPeter Eisentraut
    Jan 14, 2012 at 9:53 pm
    Mar 21, 2012 at 9:35 pm
  • The attached patch adds OAT_DROP object-access-hook around permission checks of object deletion. Due to the previous drop statement reworks, the number of places to put this hook is limited to these ...
    Kohei KaiGaiKohei KaiGai
    Jan 10, 2012 at 12:51 pm
    Mar 9, 2012 at 8:19 pm
  • Hello list, I have a question of how to benchmark hardware to determine the appropriate ratio of seq_page_cost vs random_page_cost. Emails in this mailing lists archive seem to indicate that 1.0 vs ...
    Benedikt GrundmannBenedikt Grundmann
    Jan 5, 2012 at 10:04 am
    Feb 14, 2012 at 9:52 pm
  • [ Note: please follow-up to pgsql-hackers not pgsql-general; I think this discussion needs to move there ] hubert depesz lubaczewski <depesz@depesz.com writes: [ traces through that with gdb... ] As ...
    Tom LaneTom Lane
    Jan 31, 2012 at 4:18 am
    Feb 10, 2012 at 7:54 pm
  • People have always expressed interest in $subject, so I wondered how hard it could possibly be and came up with the attached patch. Notifications that are generated on the master and are forwarded to ...
    Joachim WielandJoachim Wieland
    Jan 10, 2012 at 4:06 am
    Jan 12, 2012 at 5:51 pm
  • I've been asked by someone to support pgshpere. It would appear that the two project owners are MIA. If anyone knows different can they let me know ? Does anyone have any objection to me taking over ...
    Dave CramerDave Cramer
    Jan 6, 2012 at 5:18 pm
    Jan 10, 2012 at 9:53 pm
  • Hi list, Here's v6 of my expression caching patch. The only change in v6 is added expression cost estimation in costsize.c. I'm setting per-tuple cost of CacheExpr to 0 and moving sub-expression ...
    Marti RaudseppMarti Raudsepp
    Jan 16, 2012 at 5:07 pm
    Oct 31, 2012 at 12:22 am
  • Hi, After running regression, I ran EXPLAIN on one of the queries in regression (test create_misc) and got following output regression=# explain verbose select * into table ramp from road where name ...
    Ashutosh BapatAshutosh Bapat
    Jan 11, 2012 at 11:43 am
    Sep 21, 2012 at 5:12 pm
  • Also we should add "async" as an alias for "off"? Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
    Fujii MasaoFujii Masao
    Jan 25, 2012 at 6:23 am
    Apr 18, 2012 at 2:12 pm
  • I have a need to send banner messages to a psql client that I can set on the server and will be displayed on any psql client that connects to the database. This would be mostly used as an additional ...
    Jim MlodgenskiJim Mlodgenski
    Jan 5, 2012 at 4:38 pm
    Mar 15, 2012 at 1:30 am
  • When attempting to connect to a non-existent host with psql, the connection will hang and ^C will not break the attempt. This affects two places: startup and in interactive mode with \c. During ...
    Ryan KellyRyan Kelly
    Jan 8, 2012 at 9:05 pm
    Jul 14, 2012 at 11:02 am
  • Early yesterday morning, I was able to use Nate Boley's test machine do a single 30-minute pgbench run at scale factor 300 using a variety of trees built with various patches, and with the -l option ...
    Robert HaasRobert Haas
    Jan 24, 2012 at 8:54 pm
    Feb 12, 2012 at 1:02 am
  • Hi, http://archives.postgresql.org/message-id/AANLkTilgyL3Y1jkDVHX02433COq7JLmqicsqmOsbuyA1%40mail.gmail.com Previously I proposed the replication mode "recv" on the above thread, but it's not ...
    Fujii MasaoFujii Masao
    Jan 13, 2012 at 7:41 am
    Jan 25, 2012 at 6:34 am
  • Folks, Please find attached a new revision of the double-write patch. While this one still uses the checksums from VMware, it's been forward-ported to 9.2. I'd like to hold off on merging Simon's ...
    David FetterDavid Fetter
    Jan 10, 2012 at 9:44 pm
    Jan 18, 2012 at 8:50 pm
  • It's been a while since I did any testing with LWLOCK_STATS defined, so I thought it might be about time to do that again and see how things look. Here's how they looked back in July: ...
    Robert HaasRobert Haas
    Jan 6, 2012 at 10:24 pm
    Jan 11, 2012 at 11:29 pm
  • I have been working with xlogdump and noticed that unfortunately it cannot be installed without access to a postgres build directory, which makes the exported functionality in ...
    Daniel FarinaDaniel Farina
    Jan 17, 2012 at 12:57 am
    Feb 29, 2012 at 12:55 am
  • The attached patch adds LEAKPROOF attribute to pg_proc; that enables DBA to set up obviously safe functions to be pushed down into sub-query even if it has security-barrier attribute. We assume this ...
    Kohei KaiGaiKohei KaiGai
    Jan 8, 2012 at 3:52 pm
    Feb 15, 2012 at 3:59 pm
  • Eric's review follows: Compiling on Ubuntu 10.04 LTS AMD64 on a GoGrid virtual machine from 2012-01-12 git checkout. Patch applied fine. 'make check' results in failures when this patch is put into ...
    Josh BerkusJosh Berkus
    Jan 13, 2012 at 5:07 pm
    Feb 7, 2012 at 4:30 pm
  • Hi folks. Is there any restriction in create and start threads inside Postgres? I'm trying to develop a multithread planner, and some times is raised a exception of access memory. I'm debugging the ...
    FredericoFrederico
    Jan 13, 2012 at 8:14 pm
    Jan 30, 2012 at 3:03 pm
  • Hello this is relative simple patch that add possibility to skip noexisting tables. It is necessary for silent cleaning when dump is loaded. Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Jan 2, 2012 at 1:12 pm
    Jan 27, 2012 at 10:50 am
  • WALRestore process asynchronously executes restore_command while recovery continues working. Overlaps downloading of next WAL file to reduce time delays in file based archive recovery. Handles cases ...
    Simon RiggsSimon Riggs
    Jan 15, 2012 at 5:06 pm
    Jan 26, 2012 at 4:22 am
  • Greg Smith muttered a while ago about wanting to do something with sync_file_range to improve checkpoint behavior on Linux. I thought he was talking about trying to sync only the range of blocks ...
    Robert HaasRobert Haas
    Jan 11, 2012 at 2:14 am
    Jan 13, 2012 at 5:09 pm
  • New -x option for pgbench executes the given command once after connection of each session. e.g. pgbench -x "SET synchronous_commit = off" pgbench -x "SET foo_extension.enabled = on" Allows easier ...
    Simon RiggsSimon Riggs
    Jan 12, 2012 at 3:05 pm
    Jan 13, 2012 at 1:10 pm
  • Hi, Attached is a patch thats implements a pg_stat_recovery view that keeps counters about processed wal records. I just notice that it still lacks documentation but i will add it during the week. ...
    Jaime CasanovaJaime Casanova
    Jan 15, 2012 at 7:50 am
    Mar 15, 2012 at 10:17 pm
  • There was finally some time available on Nate Boley's server, which he has been kind enough to make highly available for performance testing throughout this cycle, and I got a chance to run some ...
    Robert HaasRobert Haas
    Jan 23, 2012 at 1:53 pm
    Feb 5, 2012 at 2:32 pm
  • Hackers, It occurs to me that I would find it quite personally useful if the vacuumdb utility was multiprocess capable. For example, just today I needed to manually analyze a database with over 500 ...
    Josh BerkusJosh Berkus
    Jan 13, 2012 at 9:50 pm
    Jan 18, 2012 at 1:25 am
  • Shouldn't it have been closed weeks ago? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com
    Josh BerkusJosh Berkus
    Jan 9, 2012 at 6:37 pm
    Jan 17, 2012 at 10:16 pm
  • I know im a little late to the party... I can't help but think this seems a bit inefficient for the common case. Would it be worth only copying the sv when its a glob or readonly? Something like the ...
    Alex HunsakerAlex Hunsaker
    Jan 5, 2012 at 11:32 pm
    Jan 15, 2012 at 9:22 pm
  • I've been prototyping the double-write buffer idea that Heikki and Simon had proposed (as an alternative to a previous patch that only batched up writes by the checkpointer). I think it is a good ...
    Dan ScalesDan Scales
    Jan 27, 2012 at 10:32 pm
    Feb 9, 2012 at 3:12 am
Jan 2012
1234
Group Navigation
period‹ prev | Jan 2012 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions159
posts1,777
users154
websitepostgresql.org...
irc#postgresql

154 users for January 2012

Robert Haas: 275 posts Simon Riggs: 168 posts Tom Lane: 163 posts Andrew Dunstan: 79 posts Heikki Linnakangas: 62 posts Peter Eisentraut: 57 posts Alvaro Herrera: 56 posts Greg Smith: 52 posts Fujii Masao: 46 posts Noah Misch: 45 posts Peter Geoghegan: 45 posts Dimitri Fontaine: 43 posts Kevin Grittner: 43 posts Magnus Hagander: 38 posts Jeff Janes: 36 posts Pavel Stehule: 28 posts Jim Nasby: 27 posts Joshua Berkus: 23 posts Kohei KaiGai: 23 posts Merlin Moncure: 23 posts
show more
Archives