Search Discussions
-
241
Last gasp
These patches aren't marked with a committer FK arrays ECPG fetch foreign stats command triggers check function parallel pg_dump Does that mean myself or others should be claiming them for ...Simon Riggs
Apr 5, 2012 at 5:35 pm
Jul 9, 2012 at 9:56 pm -
Hi, attached is a patch to implement a framework to simplify and correctly nest multiplexing more than two timeout sources into the same SIGALRM signal handler. The framework is using a new internal ...
Boszormenyi Zoltan
Apr 4, 2012 at 10:31 am
Dec 8, 2012 at 6:32 pm -
I tried to implement a patch according to the idea. It allows extensions to register an entry point of the self-managed daemon processes, then postmaster start and stop them according to the normal ...
Kohei KaiGai
Apr 25, 2012 at 9:40 am
Nov 24, 2012 at 7:29 pm -
A key barrier to migrations from trigger-based replication to WAL-based replication is the lack of temporary tables under hot standby. I'd like to close that gap; the changes needed will also reduce ...
Noah Misch
Apr 25, 2012 at 3:55 am
Jun 10, 2012 at 8:48 pm -
I'm beginning to work on advanced additions to in-core replication for PostgreSQL. There are a number of additional features for existing single-master replication still to achieve, but the key ...
Simon Riggs
Apr 26, 2012 at 12:41 pm
May 4, 2012 at 5:26 pm -
Hackers, attached patch adds conversion from pg_wchar string to multibyte string. This functionality is needed for my patch on index support for regular expression search ...
Alexander Korotkov
Apr 23, 2012 at 8:48 am
Jul 11, 2012 at 5:23 am -
This idea appeared to have some support. I'd like to suggest that we take this a step further. Instead of adding a fourth mode, I'd like to suggest that we redefine "smart" to have the behavior ...
Robert Haas
Apr 27, 2012 at 5:43 pm
May 8, 2012 at 5:59 pm -
Hello, this is bug report and a patch for it. The first patch in the attachments is for 9.2dev and next one is for 9.1.3. On the current 9.2dev, IsCheckpointOnSchedule@checkpointer.c does not check ...
Kyotaro HORIGUCHI
Apr 16, 2012 at 12:06 pm
Jul 2, 2012 at 5:03 pm -
<sigh Yes, it appears very similar. I didn't know about this. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Simon Riggs
Apr 26, 2012 at 3:03 pm
May 4, 2012 at 10:18 pm -
I just talked to Tom about the 9.2 release notes. Do people want me to write the 9.2 release notes? When do you think we will be ready for 9.2 beta? -- Bruce Momjian <bruce@momjian.us ...
Bruce Momjian
Apr 13, 2012 at 3:23 pm
Apr 30, 2012 at 8:18 am -
Hi All, I submitted a GSoc application yesterday. Please review it and let me know if anyone needs any clarifications. Atri
Atri Sharma
Apr 7, 2012 at 11:08 am
Apr 17, 2012 at 2:10 pm -
I propose that we remove support for the following OS ports from our source tree. They are totally dead, definitely don't work, and/or probably no one remembers what they even were. The code just bit ...
Peter Eisentraut
Apr 24, 2012 at 6:29 pm
Sep 13, 2012 at 4:06 pm -
Having performed this investigation, I've discovered a couple of interesting things. First, SlruRecentlyUsed() is an ineffective way of keeping a page from getting reused, because it's called ...
Robert Haas
Apr 4, 2012 at 12:00 pm
Apr 9, 2012 at 3:06 am -
The following patch truncates trailing null attributes from heap rows to reduce the size of the row bitmap. Applications often have wide rows in which many of the trailing column values are null. On ...
Jameison Martin
Apr 17, 2012 at 4:23 pm
Aug 10, 2012 at 12:06 am -
The Mac installation docs currently recommend the EDB one-click installer as the first choice. While this does install pgadmin and some other refinements, it also is fairly confusing to ...
Jay Levitt
Apr 1, 2012 at 8:14 pm
Apr 4, 2012 at 8:19 pm -
If you use ALTER ROLE/DATABASE SET to configure an invalid search_path, PostgreSQL 9.1 issues a complaint about the invalid setting on each new connection. This is a behavior change relatively to ...
Robert Haas
Apr 3, 2012 at 3:33 pm
Apr 11, 2012 at 3:26 am -
I hope this is not an inappropriate time for 9.3 discussions. The flip side of asking for submissions in the first couple commitfests means that I need to submit proposals now. What is a Range Join? ...
Jeff Davis
Apr 16, 2012 at 5:41 am
Apr 19, 2012 at 8:11 am -
Hi all, I've written a pg_upgrade wrapper for upgrading our users (heroku) to postgres 9.1. In the process I encountered a specific issue that could easily be improved. We've had this process work ...
Harold Giménez
Apr 5, 2012 at 2:27 am
Apr 12, 2012 at 12:48 am -
When I do this: rhaas=# set default_transaction_isolation = 'serializable'; SET rhaas=# begin; BEGIN rhaas=# select 1; Then I get this: TRAP: FailedAssertion("!(!RecoveryInProgress())", File ...
Robert Haas
Apr 27, 2012 at 1:15 pm
Apr 30, 2012 at 2:56 pm -
I am again requesting the addition of options to tools/git_changelog so I can more easily produce the release notes. I asked for this during 9.1 development and it was rejected. I am currently using ...
Bruce Momjian
Apr 25, 2012 at 8:05 pm
May 2, 2012 at 4:39 pm -
I looked into the behavior complained of here: http://archives.postgresql.org/pgsql-performance/2012-04/msg00093.php The problem query can be abstracted to select * from a, b, c, d where a.x = b.y ...
Tom Lane
Apr 13, 2012 at 2:32 pm
Apr 19, 2012 at 5:33 am -
I haven't finished reviewing this yet - but there are some things that need to be fixed. First, either the creation of the destination directory needs to be delayed until all the sanity checks have ...
Andrew Dunstan
Apr 3, 2012 at 1:27 pm
Dec 9, 2012 at 4:16 am -
The new pg_tablespace_location() function added in PG 9.2 to remove the director location from pg_tablespace returns an odd error for '0', which is InvalidOID: test= select ...
Bruce Momjian
Apr 10, 2012 at 8:32 pm
Apr 11, 2012 at 2:10 am -
So after committing the latest round of parameterized-plan hacking, I was dismayed to see the buildfarm breaking out in pink, thanks to some of the members producing a different plan than expected ...
Tom Lane
Apr 19, 2012 at 10:39 pm
Apr 21, 2012 at 8:35 am -
Hmm ... that did work as described, until we broke it :-(. This is an oversight in the 9.0 changes that added separate ModifyTuple nodes to plan trees. ModifyTuple doesn't return after each updated ...
Tom Lane
Apr 4, 2012 at 3:00 pm
Apr 18, 2012 at 3:11 pm -
During ANALYZE, in analyze.c, functions compute_minimal_stats and compute_scalar_stats, values whose length exceed WIDTH_THRESHOLD (= 1024) are not used for calculating statistics other than that ...
Albe Laurenz
Apr 30, 2012 at 10:28 am
May 15, 2012 at 1:08 pm -
Currently, we have a problem with index-only scans in Hot Standby mode: the xmin horizon on the standby might lag the master, and thus an index-only scan might mistakenly conclude that no heap fetch ...
Robert Haas
Apr 13, 2012 at 4:33 pm
May 4, 2012 at 8:57 am -
Yes, that sure looks like a bug. It seems that if the top-level transaction is aborting, then LockReleaseAll() is called and everything gets cleaned up properly; or if a subtransaction is aborting ...
Robert Haas
Apr 9, 2012 at 1:37 am
Apr 10, 2012 at 5:20 pm -
Some of my PostgreSQL Experts colleagues have been complaining to me that servers under load with very large queries cause CSV log files that are corrupted, because lines are apparently multiplexed ...
Andrew Dunstan
Apr 1, 2012 at 10:35 pm
Apr 4, 2012 at 9:08 pm -
Hackers, Per bug #6593, REASSIGN OWNED fails when the affected role owns an extension. This would be trivial to fix if extensions had support code for ALTER EXTENSION / OWNER, but they don't. So the ...
Alvaro Herrera
Apr 18, 2012 at 3:42 pm
Jul 4, 2012 at 8:51 am -
I admit to not having followed the discussion around the new mode for synchronous_commit very closely, so my apologies if this has been discussed and dismiseed - I blame failing to find it int he ...
Magnus Hagander
Apr 19, 2012 at 9:05 am
Apr 24, 2012 at 8:51 pm -
... would be really nice to have. Especially pgbench and pg_upgrade for me, but it would be useful to have man pages for everything. Unfortunately, we can't just replace the sect1's in in Appendix F ...
Peter Eisentraut
Apr 4, 2012 at 6:53 pm
Apr 16, 2012 at 8:59 am -
Hi, When I committed Alex Shulgin's patch to add URI support to libpq, I included the test harness as well. However, due to it being in a separate subdirectory that did not previously had tests, it's ...
Alvaro Herrera
Apr 17, 2012 at 1:47 pm
Jul 6, 2012 at 9:03 pm -
Don't know if anybody noticed bug #6559 http://archives.postgresql.org/pgsql-bugs/2012-03/msg00180.php I've confirmed that the given test case works in 9.0 but fails in 9.1 and HEAD. It's not ...
Tom Lane
Apr 10, 2012 at 2:20 am
Apr 26, 2012 at 6:13 pm -
A lot of discussion took place regarding corruption detection, and I am attempting to summarize it in a useful way. Please excuse the lack of references; I'm hoping to agree on the basic problem ...
Jeff Davis
Apr 21, 2012 at 9:41 pm
Apr 26, 2012 at 1:41 pm -
I think it might be useful to disguard the stability property if it's not a real requirement, as I think doing so gives us additional leeway to compose descending runs (pre-sorted subsets) that are ...
Peter Geoghegan
Apr 19, 2012 at 1:32 am
Apr 25, 2012 at 12:23 am -
Hello hackers, It turns out that in a PL/PgSQL function, you can DECLARE a variable using the same name as one of the function parameters. This has the effect of clobbering the parameter, for ...
Brendan Jurd
Apr 15, 2012 at 7:49 am
Apr 17, 2012 at 9:51 am -
Hi, I recently wrote a plpgsql plugin. I wanted to enable the use of pgxs, to make it easier to compile the plugin, but I eventually found that I can't do that because the plpgsql.h file is not ...
Guillaume Lelarge
Apr 8, 2012 at 9:00 am
Apr 17, 2012 at 7:13 am -
Hi, While looking into SSL code in secure_read() of be-secure.c and pqsecure_read() of fe-secure.c, I noticed subtle difference between them. In secure_read ...
Tatsuo Ishii
Apr 4, 2012 at 1:17 pm
Apr 6, 2012 at 4:47 pm -
Uh, isn't it kind of a bad idea to back-patch something like this? It seems like a behavior change. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Robert Haas
Apr 17, 2012 at 11:08 pm
Apr 18, 2012 at 2:27 pm -
A long time ago, we had this bug report: http://archives.postgresql.org/pgsql-bugs/2003-02/msg00069.php in consequence of which, I changed timestamp_part() so that it would rotate a ...
Tom Lane
Apr 9, 2012 at 5:31 pm
Apr 9, 2012 at 7:56 pm -
Hoping to demonstrate the wonders of our new group commit code, I ran some benchmarks on the IBM POWER7 machine with synchronous_commit = on. But, it didn't come out much better than 9.1. pgbench, ...
Robert Haas
Apr 1, 2012 at 12:10 am
Apr 2, 2012 at 11:20 pm -
Hi, I've tried out pg_receivexlog and have noticed that when restarting the cluster, pg_receivexlog gets cut off... it doesn't keep waiting. This is surprising as the DBA would have to remember to ...
Thom Brown
Apr 6, 2012 at 12:07 am
May 27, 2012 at 9:07 am -
I notice that there isn't a parameter called enable_indexonly (or similar). ISTM that such a major new feature should be controlled by a planner method parameter, just as all the existing planner ...
Simon Riggs
Apr 27, 2012 at 3:39 pm
Apr 30, 2012 at 10:28 am -
Hi, I'm debugging initdb using gdb. I found that I could not step in the function getopt_long in line 2572 in initdb.c. I also found that the value of VAR optind never be changed. VAR optind is ...
Clover White
Apr 9, 2012 at 11:39 am
Apr 9, 2012 at 6:28 pm -
When GIN changes a metapage, we WAL-log its ex-header content and never use a backup block. This reduces WAL volume since the vast majority of the metapage is unused. However, ginRedoUpdateMetapage() ...
Noah Misch
Apr 30, 2012 at 5:34 pm
May 3, 2012 at 3:34 pm -
Hi, This is the version I used to run the following commands select version(); version ---------------------------------------------------------------------------------------------------------------- ...
Abbas Butt
Apr 27, 2012 at 12:25 pm
Apr 27, 2012 at 10:42 pm -
Since we are wacking around pg_stat_activity for 9.2, what do people think about these column names? backend_start | timestamp with time zone | xact_start | timestamp with time zone | query_start | ...
Bruce Momjian
Apr 11, 2012 at 8:46 pm
Apr 11, 2012 at 9:30 pm -
Then you may need WAL space larger than 1GB as well. For replication to work, it seems likely that you may need to have sufficient WAL space to handle a row, possibly the entire transaction.. But ...
Michael Nolan
Apr 11, 2012 at 2:38 pm
Apr 11, 2012 at 6:14 pm -
I updated the patch added to CF 2012-Next [1]. Attached is the updated version of the patch. For the discussion in [2], I've introduced a new generic option, validate for file_fdw foreign tables, ...
Etsuro Fujita
Apr 13, 2012 at 7:56 am
Jun 21, 2012 at 11:16 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 112 |
posts | 1,459 |
users | 118 |
website | postgresql.org... |
irc | #postgresql |
118 users for April 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)