Search Discussions
-
Hey everyone, Upon doing some usability tests with PostgreSQL 9.1 recently, I ran across this discussion: http://archives.postgresql.org/pgsql-hackers/2011-12/msg01224.php And after reading the ...
Shaun Thomas
Jul 9, 2012 at 8:30 pm
Jul 25, 2012 at 9:43 pm -
I occasionally get questions about how to run pg_upgrade on log-shipping standby servers. The attached documentation patch outlines how to do it. I don't think we can assume that because pg_upgrade ...
Bruce Momjian
Jul 10, 2012 at 3:50 pm
Aug 31, 2012 at 4:10 am -
I've moved this thread from performance to hackers. The topic was poor performance when truncating lots of small tables repeatedly on test environments with fsync=off. My attached Proof of Concept ...
Jeff Janes
Jul 13, 2012 at 4:55 am
Jul 24, 2012 at 5:09 pm -
Hello we cannot actually store result of query to psql variable I propose a new slash statement "\eset for this purpose Syntax: \eset variable [, variable [..]] query -- it raise exception when more ...
Pavel Stehule
Jul 26, 2012 at 5:13 am
Dec 19, 2012 at 8:04 am -
The attached patch is my homework at the last commit fest of v9.2. It consolidates some similar routines into a single generic routines that handles ALTER RENAME TO, OWNER TO and SET SCHEMA according ...
Kohei KaiGai
Jul 24, 2012 at 5:24 am
Jan 9, 2013 at 11:46 am -
Hi all, I've created new patch to get/reset statistics of WAL buffer writes (flushes) caused by WAL buffer full. This patch provides two new functions, pg_stat_get_xlog_dirty_write() and ...
Satoshi Nagayasu
Jul 7, 2012 at 12:01 pm
Dec 9, 2012 at 6:06 pm -
CompactCheckpointerRequestQueue supposes that it can use an entry of the checkpointer request queue directly as a hash table key. This will work reliably only if there are no pad bytes in the ...
Tom Lane
Jul 15, 2012 at 9:36 pm
Jul 18, 2012 at 12:41 pm -
Why does the isolation check take such a long time? On some of my slower buildfarm members I am thinking of disabling it because it takes so long. This single test typically takes longer than a full ...
Andrew Dunstan
Jul 13, 2012 at 8:06 pm
Jul 27, 2012 at 12:13 am -
Hmm, I ran the regressions tests, but not with C encoding. With the patch, you no longer get the errdetail you used to, when an encoding conversion fails: We could just update the expected output, ...
Heikki Linnakangas
Jul 5, 2012 at 8:37 pm
Aug 9, 2012 at 9:55 am -
Hi all, I am trying to install my FDW project on windows.I did some research and I believe I shall be requiring pre compiled binaries(dll files).I tried cross compiling using MinGW on my Ubuntu.I am ...
Atri Sharma
Jul 13, 2012 at 8:31 am
Jul 13, 2012 at 1:43 pm -
I am running into a lot of customer situations where the customer reports that "canceling autovacuum task" shows up in the logs, and it's unclear whether this is happening often enough to matter, and ...
Robert Haas
Jul 24, 2012 at 5:48 pm
Aug 30, 2012 at 5:28 pm -
So, considering that there is required setup, it seems that the obvious thing to do here is add a GUC: huge_tlb_pages (boolean). The other alternative is to try with MAP_HUGETLB and, if it fails, try ...
Robert Haas
Jul 3, 2012 at 2:49 am
Aug 21, 2012 at 8:13 pm -
I converted Skytools modules to extensions and found 2 problems: 1) Dumpable sequences are not supported - if sequence is tagged with pg_catalog.pg_extension_config_dump(), the pg_dump tries to run ...
Marko Kreen
Jul 18, 2012 at 10:13 am
Nov 2, 2012 at 2:50 pm -
Hi, Attached is v2 of the patch. Changes are: * more comments * significantly cleaned/simpliefied coded * crc validation * addition of XLogReaderReadOne Definitely needed are: * better validation of ...
Andres Freund
Jul 19, 2012 at 10:29 am
Sep 9, 2012 at 8:14 pm -
Hello, I've noticed recently that I can't seem to use the convenient xlog filename formatting functions while I'm in a standby. I don't see an incredibly obvious reason why that is the case, so ...
Daniel Farina
Jul 3, 2012 at 8:25 am
Oct 18, 2012 at 4:56 pm -
I have received positive feedback on the pg_dump --split option I suggested, but it depends on pg_dump dumping objects in a deterministic order. I'm committed to fixing this. The first problem I've ...
Joel Jacobson
Jul 4, 2012 at 3:17 pm
Oct 18, 2012 at 3:26 pm -
11
Prevent restored WAL files from being archived again Re: Unnecessary WAL archiving after failover
Yes. Attached patch removes that sentence. Yes, .done file should be created even if archive mode is not enabled. Attached patch changes the startup process so that it creates .done file whenever WAL ...Fujii Masao
Jul 29, 2012 at 3:01 pm
Dec 29, 2012 at 9:07 pm -
Hi, attached is a patch that does $SUBJECT. It's a usability enhancement, to take a backup, write a minimalistic recovery.conf and start the streaming standby in one go. Comments? Best regards, ...
Boszormenyi Zoltan
Jul 1, 2012 at 11:03 am
Oct 3, 2012 at 12:39 pm -
I noticed today that has_language_privilege() returns incorrect answer for non-superuser, e.g.: 8<--------------------------------------------------- select has_language_privilege('nobody', ...
Joe Conway
Jul 10, 2012 at 1:24 am
Aug 31, 2012 at 3:22 am -
I'm chasing up an issue from a client who has this problem (in 9.1): with q as ( some query here ) select q.* from q yields: job_scope | checked_col ...
Andrew Dunstan
Jul 18, 2012 at 6:58 pm
Jul 20, 2012 at 5:13 pm -
Hi, I wonder if we just should add a format code like %R or something similar as a replacement for the %X/%X notion. Having to type something like "(uint32) (state- curptr 32), (uint32)state- curptr" ...
Andres Freund
Jul 3, 2012 at 5:36 pm
Jul 14, 2012 at 5:29 pm -
Hello When I worked on parametrised DO statement, I had to solve following issue: Syntax is: DO (param list) $$ ... $$ LANGUAGE ... USING expr_list What is correct way for evaluation of expr_list ...
Pavel Stehule
Jul 8, 2012 at 7:14 am
Jul 10, 2012 at 3:50 pm -
Hi, I've been playing around with the idea of supporting automatically updatable views, and I have a working proof of concept. I've taken a different approach than the previous attempts to implement ...
Dean Rasheed
Jul 1, 2012 at 10:36 pm
Sep 2, 2012 at 8:37 pm -
Hi, I found several problems in pg_receivexlog, e.g., memory leaks, file-descripter leaks, ..etc. The attached patch fixes these problems. ISTM there are still some other problems in pg_receivexlog, ...
Fujii Masao
Jul 9, 2012 at 6:24 pm
Aug 6, 2012 at 11:56 am -
Hello I seen nice trick based on window function http://stackoverflow.com/questions/11700930/how-can-i-trim-a-text-array-in-postgresql but isn't it example of wrong evaluation? Result of row_number ...
Pavel Stehule
Jul 30, 2012 at 4:20 pm
Jul 30, 2012 at 7:25 pm -
After fixing the assorted breakage discussed yesterday, I still wasn't seeing any ForwardFsyncRequest requests coming from the bgwriter during a regression test run, which made me wonder if there was ...
Tom Lane
Jul 18, 2012 at 8:00 pm
Jul 22, 2012 at 9:31 pm -
Hello I did a backport of temp_file_limit feature to 9.1, but when we tested this patch, we found very restristrictive limit to 2GB. 2GB is nonsense, because this is session limit of temp files, and ...
Pavel Stehule
Jul 19, 2012 at 8:05 pm
Jul 20, 2012 at 5:46 am -
Hi, Attached please find a trivial patch for psql which adds a \n meta command as a shortcut for typing set search_path =. This allows you to use psql as follows: \dn \n my_schema \d \d my_table ...
Colin 't Hart
Jul 10, 2012 at 9:09 am
Jul 10, 2012 at 6:10 pm -
The attached patch is delivered from the discussion around row-level access control feature. A problem Florian pointed out is refcursor declared in security definer function. Even though all the ...
Kohei KaiGai
Jul 2, 2012 at 2:55 pm
Jul 5, 2012 at 5:05 pm -
Attached are two patches, one of which I'd like to apply. Open for discussion on which one. The smaller one, pgfoundry_1.diff, removes the suggestion to apply for new projects on pgfoundry. The ...
Magnus Hagander
Jul 3, 2012 at 7:20 pm
Jul 4, 2012 at 3:17 pm -
Hello, I'm currently on a university research project if performance could be increased by substituting different inter-node search algorithms instead of the currently used binary search. But I'm ...
Samuel Vogel
Jul 16, 2012 at 11:51 pm
Jul 22, 2012 at 10:41 pm -
In bug #6734 we have a complaint about a longstanding misfeature of CREATE TABLE LIKE. Ordinarily, this command doesn't select names for copied indexes, but leaves that to be done at runtime by ...
Tom Lane
Jul 14, 2012 at 8:02 pm
Jul 16, 2012 at 5:40 pm -
Sorry to raise this once again, but I still find this CHECK NO INHERIT syntax to a bit funny. We are currently using something like CHECK NO INHERIT (foo 0) But we already have a different syntax for ...
Peter Eisentraut
Jul 18, 2012 at 9:49 pm
Jul 24, 2012 at 8:32 pm -
What are our plans for a 9.2 final release date? If we wait until September 1 to release our first release candidate, we will probably not release final until mid/late September. Is that what we ...
Bruce Momjian
Jul 21, 2012 at 7:08 am
Jul 24, 2012 at 5:55 pm -
Rsync is popular with Postgres users, but I don't understand how they are using the default check mode (file size, modification time) to synchronize shut-down data directories? It seems they would ...
Bruce Momjian
Jul 10, 2012 at 2:48 am
Jul 24, 2012 at 5:16 pm -
We yesterday encountered a program that in a degenerate case issued in a single transaction a huge number of selects (in a single transaction but each select in a separate call to PGExec) (huge = ~ ...
Benedikt Grundmann
Jul 20, 2012 at 7:19 am
Jul 20, 2012 at 10:46 am -
Today I learnt [1,2,3] that the feature ALTER TABLE .. ADD CONSTRAINT ... USING INDEX we added back in the day is not so useful in the field. Having to drop foreign key constraints before this ...
Gurjeet Singh
Jul 7, 2012 at 3:53 am
Jul 12, 2012 at 11:18 pm -
Attached is a Patch to change the parsing of pg_ident.conf to make it similar to pg_hba.conf. This is based on Todo Item: http://archives.postgresql.org/pgsql-hackers/2011-06/msg02204.php Purpose - ...
Amit Kapila
Jul 2, 2012 at 12:10 pm
Sep 22, 2012 at 3:59 am -
Hi, I notice that pg_basebackup has lots of messages where file names are not in quotes. Is this okay? There's also this one which is probably against our conventions: #: pg_receivexlog.c:181 #, ...
Alvaro Herrera
Jul 25, 2012 at 7:37 pm
Jul 26, 2012 at 2:20 pm -
We are now at the end of the originally scheduled one-month window for the June commitfest. While the numbers look fairly bad: Needs Review: 17, Waiting on Author: 10, Ready for Committer: 3, ...
Tom Lane
Jul 16, 2012 at 12:17 am
Jul 17, 2012 at 3:06 pm -
This bug report was fixed mostly via private email because a private schema dump was sent to Tom and me. Tom fixed the problem by changing the way we interact with struct dirent, but neither of us is ...
Bruce Momjian
Jul 25, 2012 at 5:01 pm
Jul 26, 2012 at 10:22 am -
Hello I tested Peter's patch and it works well. I don't see any performance problem on my notebook last discussion ...
Pavel Stehule
Jul 2, 2012 at 8:14 am
Jul 19, 2012 at 8:14 pm -
A web site doc comment from user skong today points out a small issue around the sample INSTR function given in plpgsql-porting.html that I can't confirm (none of those dirty Oracle instances here ...
Greg Smith
Jul 3, 2012 at 12:51 am
Jul 6, 2012 at 11:05 am -
It seems strange that the external_pid_file is never removed. There is even a C comment about it: /* Should we remove the pid file on postmaster exit? */ I think it should be removed with proc_exit ...
Peter Eisentraut
Jul 27, 2012 at 5:09 am
Aug 17, 2012 at 5:43 am -
Folks, I just noticed that there's yet another change to time zones: http://www.iana.org/time-zones Can we slide this into the upcoming point release? When would that be? Cheers, David. -- David ...
David Fetter
Jul 30, 2012 at 9:28 pm
Aug 6, 2012 at 3:19 pm -
Hi, I'm thinking of adding new probes to trace smgr activities. In this implementation, I just found that md.c has its own probes within it, but I'm wondering why we do not have those probes within ...
Satoshi Nagayasu
Jul 28, 2012 at 7:34 am
Jul 29, 2012 at 8:07 am -
(Moved to hackers.) I have emailed the author asking for a copy. Does anyone have a recently downloaded copy of diskchecker.pl? -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB ...
Bruce Momjian
Jul 27, 2012 at 12:35 am
Jul 27, 2012 at 1:26 am -
Is there a reason to vacuum the pgbench_* tables after the indexes on them are built, rather than before? Since the indexes are on fresh tables, they can't have anything that needs to be cleaned. I ...
Jeff Janes
Jul 20, 2012 at 12:05 am
Jul 23, 2012 at 6:45 pm -
Hackers, I stumbled across an initialization of a BlockNumber with InvalidBuffer, which seems strange to me, as the values for "invalid" of the two types are different, see attached patch. In case ...
Markus Wanner
Jul 10, 2012 at 1:12 pm
Jul 13, 2012 at 3:38 pm -
Hi, waitpid() is used with "#ifdef HAVE_WAITPID" in reaper(), but NOT in BaseBackup(). Why not? We can ensure that all platforms which PostgreSQL supports have waitpid()? If so, can we get rid of ...
Fujii Masao
Jul 4, 2012 at 4:59 pm
Jul 5, 2012 at 6:12 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 97 |
posts | 1,125 |
users | 114 |
website | postgresql.org... |
irc | #postgresql |
114 users for July 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)