Search Discussions
-
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 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 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 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 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 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 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 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 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 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 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 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. 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Wieland
Jan 10, 2012 at 4:06 am
Jan 12, 2012 at 5:51 pm -
16
pgsphere
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 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 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 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 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 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 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 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 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 Fetter
Jan 10, 2012 at 9:44 pm
Jan 18, 2012 at 8:50 pm -
14
LWLOCK_STATS
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 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 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 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 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 ...
Frederico
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 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 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 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 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 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 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 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 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 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 Scales
Jan 27, 2012 at 10:32 pm
Feb 9, 2012 at 3:12 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 159 |
posts | 1,777 |
users | 154 |
website | postgresql.org... |
irc | #postgresql |
154 users for January 2012
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)