Search Discussions
-
Hi, It took me far longer than I planned, its not finished, but time is running out. I would like some feedback that I am not going astray at this point... *I* think the general approach is sound and ...
Andres Freund
Sep 15, 2012 at 12:33 am
Nov 29, 2012 at 8:09 pm -
Attached is a proof-of-concept patch for talking to a standalone backend using libpq and a pair of pipes. It works, to the extent that psql and pg_dump can run without any postmaster present: $ psql ...
Tom Lane
Sep 3, 2012 at 12:23 am
Nov 13, 2012 at 10:43 pm -
I've been working on the often-requested feature to handle timeline changes over streaming replication. At the moment, if you kill the master and promote a standby server, and you have another ...
Heikki Linnakangas
Sep 11, 2012 at 5:23 pm
Dec 26, 2012 at 8:31 pm -
[Review of Patch] Basic stuff: ---------------------- - Patch applies OK - Compiles cleanly with no warnings What it does: ------------------------- The pg_basebackup tool does the backup of Cluster ...
Amit Kapila
Sep 20, 2012 at 10:31 am
Jan 5, 2013 at 4:17 pm -
48
Oid registry
This rather overdue mail arises out the developer's meeting back in May, where we discussed an item I raised suggesting an Oid registry. The idea came from some difficulties I encountered when I did ...Andrew Dunstan
Sep 24, 2012 at 10:59 pm
Oct 1, 2012 at 2:12 pm -
I'd like to add the following options to the SQL COPY command and the psql \copy instruction: * PREPROCESSOR: Specifies the user-supplied program for COPY IN. The data from an input file is ...
Etsuro Fujita
Sep 13, 2012 at 9:07 am
Nov 26, 2012 at 12:44 pm -
[ Thread moved to hackers list.] OK, this is exactly what I wanted to see, and it explains why pg_dump didn't show it. Can you find out what table references this toast table? Try this query on the ...
Bruce Momjian
Sep 16, 2012 at 5:17 pm
Oct 2, 2012 at 3:59 pm -
Hi all, During the last PGCon, I heard that some community members would be interested in having pg_reorg directly in core. Just to recall, pg_reorg is a functionality developped by NTT that allows ...
Michael Paquier
Sep 21, 2012 at 2:05 am
Sep 26, 2012 at 7:29 pm -
I change the build-farm.conf file to have the following make line: make = 'make -j 8', # or gmake if required. can include path if necessary. 2 pass, 4 fail. Is this a build configuration you want to ...
Robert Creager
Sep 1, 2012 at 4:12 pm
Sep 10, 2012 at 6:51 pm -
Please find the review of the patch. Basic stuff: ---------------------- - Patch applies OK - Compiles cleanly with no warnings - Regression tests pass. - Documentation changes are mostly fine. What ...
Amit kapila
Sep 18, 2012 at 1:24 pm
Dec 9, 2012 at 10:53 pm -
When initializing a large database, pgbench writes tons of "%d tuples done" lines. I propose to change this to a sort of progress counter that stays on the same line, as in the attached patch.
Peter Eisentraut
Sep 1, 2012 at 4:00 am
Jan 7, 2013 at 2:29 am -
This patch is based on below Todo Item: Consider adding buffers the background writer finds reusable to the free list I have tried implementing it and taken the readings for Select when all the data ...
Amit kapila
Sep 3, 2012 at 2:17 pm
Dec 12, 2012 at 10:48 am -
While researching the way streaming replication works I was examining the construction of the tar file header. By comparing documentation on the tar header format from various sources I certain the ...
Brian Weaver
Sep 24, 2012 at 11:51 pm
Sep 28, 2012 at 7:45 pm -
Drawing together various discussions both here and elsewhere (e.g. the PostgresOpen hallway track) I propose to work on the following: 1. make datum_to_json() honor a type's cast to json if it ...
Andrew Dunstan
Sep 26, 2012 at 4:36 pm
Oct 1, 2012 at 1:52 pm -
Hi, I've been struggling with autovacuum generating a lot of I/O and CPU on some of our systems - after a night spent analyzing this behavior, I believe the current autovacuum accidentally behaves a ...
Tomas Vondra
Sep 26, 2012 at 12:43 pm
Jan 6, 2013 at 4:03 am -
This is just a rebased version of the patch by Simon here: http://archives.postgresql.org/message-id/CA +<span class="m_body_email_addr" title="9b84e76065f1159d3c080edf2303b923" ...
Jeff Davis
Sep 15, 2012 at 12:58 am
Nov 14, 2012 at 10:28 pm -
Hi all, I'd like to propose FDW for PostgreSQL as a contrib module again. Attached patch is updated version of the patch proposed in 9.2 development cycle. For ease of review, I summarized what the ...
Shigeru HANADA
Sep 14, 2012 at 2:25 pm
Nov 28, 2012 at 11:04 am -
Hi, Does this mean we need to wrap new tarballs soon, because of the data loss bug? Regards, Devrim 14 Eylül 2012, Cuma, 4:42 pm tarihinde, Robert Haas yazmış: -- Temporarily using a webmail program.
Devrim Gündüz
Sep 14, 2012 at 2:23 pm
Sep 26, 2012 at 8:59 am -
Hi all, In PostgreSQL 9.1 and 9.2 (possibly also in earlier versions), the query --8<-- WITH source AS ( SELECT i FROM generate_series(1,10) AS i ) SELECT i FROM source, ( SELECT count(*) AS _n FROM ...
Florian Schoppmann
Sep 18, 2012 at 7:30 am
Sep 20, 2012 at 3:49 pm -
From: Heikki Linnakangas [mailto:heikki(dot)linnakangas(at)enterprisedb(dot)com] Sent: Monday, August 27, 2012 5:58 PM To: Amit kapila pointed out by Simon and Robert. In this patch it only goes for ...
Amit kapila
Sep 24, 2012 at 10:57 am
Oct 24, 2012 at 6:08 am -
Here is a patch against 9.2 sources (it applies with offsets to HEAD too) to fix the problem that pg_upgrade can write paths in arguments for Windows builtin commands (specifically DEL and RMDIR) ...
Andrew Dunstan
Sep 3, 2012 at 6:30 pm
Sep 5, 2012 at 12:54 am -
Hi, I've had problems using pg_restore --data-only when restoring individual schemas (which contain data which has had bad things done to it). --clean does not work well because of dependent objects ...
Karl O. Pinc
Sep 20, 2012 at 5:24 pm
Dec 5, 2012 at 4:40 am -
The attached very small patch allows pg_upgrade's "make check" to succeed on REL9_2_STABLE on my Mingw system. However, I consider the issue I mentioned earlier regarding use of forward slashes in ...
Andrew Dunstan
Sep 3, 2012 at 4:44 pm
Sep 6, 2012 at 2:57 am -
I realized this morning that I might have been a bit cavalier in using dos2unix to smooth away differences in the dumpfiles produced by pg_upgrade. Attached is a dump of the diff if this isn't done, ...
Andrew Dunstan
Sep 4, 2012 at 7:09 pm
Sep 5, 2012 at 8:41 pm -
Hello, I will propose reduce palloc's in numeric operations. The numeric operations are slow by nature, but usually it is not a problem for on-disk operations. Altough the slowdown is enhanced on ...
Kyotaro HORIGUCHI
Sep 14, 2012 at 8:25 am
Nov 23, 2012 at 6:00 pm -
I'd like to propose moving postgresql_fdw_validator into contrib/dblink as dblink's own validator. Main purpose of this proposal is to reserve the name "postgresql_fdw" for concrete FDW for ...
Shigeru HANADA
Sep 11, 2012 at 9:30 am
Nov 16, 2012 at 12:08 am -
Hi, The attached patch documents the oid column of those system catalogs having an oid. Distinguish system catalogs with an oid from those without and make the primary key clear to the newbie. Found ...
Karl O. Pinc
Sep 24, 2012 at 1:57 am
Dec 15, 2012 at 5:46 am -
This question comes about after reading the VLDB paper "Serializable Snapshot Isolation in PostgreSQL". We release predicate locks after a transaction abort, but not after a subtransaction abort. The ...
Jeff Davis
Sep 8, 2012 at 6:34 pm
Sep 17, 2012 at 10:16 pm -
This patch fixes a few portions on which sepgsql didn't follow the latest core API changes. 1) Even though the prototype of ProcessUtility_hook was recently changed, sepgsql side didn't follow this ...
Kohei KaiGai
Sep 2, 2012 at 6:53 pm
Oct 10, 2012 at 4:18 pm -
Hi, This patch (psql_remove_include.patch) eliminates the #include of psqlscan.c at the bottom of mainloop.c. The attached patch uses the %top{} flex feature introduced in flex 2.5.30 released ...
Karl O. Pinc
Sep 27, 2012 at 3:00 pm
Sep 27, 2012 at 8:06 pm -
http://www.postgresql.org/docs/devel/static/libpq-connect.html#LIBPQ-PARAMKE YWORDS We have tried by enabling keepalive, but it didn't worked maybe because walreceiver is trying to send reveiver ...
Amit Kapila
Sep 13, 2012 at 4:23 am
Sep 21, 2012 at 11:18 am -
Hello. A very simple query shown below on partitioned tables can run for four times as long as that on non-partitioned tables when the whole data can be loaded onto memory. * QUERY : SELECT * FROM ...
Kyotaro HORIGUCHI
Sep 13, 2012 at 8:47 am
Dec 14, 2012 at 11:41 am -
[Review of Patch] Basic stuff: ------------ - Patch applies OK. but offset difference in line numbers. - Compiles with errors in contrib [pg_stat_statements, sepgsql] modules - Regression failed; one ...
Amit Kapila
Sep 20, 2012 at 1:08 pm
Oct 3, 2012 at 11:39 am -
Hello hackers: I need a list of all triggers created in my database, but the view system_information.triggers does not show truncate triggers, but it does for insert, update and delete triggers. The ...
Daymel Bonne Solís
Sep 26, 2012 at 5:17 am
Sep 27, 2012 at 1:25 pm -
_FORTIFY_SOURCE=2 appears to be the default for package building on many Linux distributions now, as part of harding or security options. But we often hear about problems related to this only when we ...
Peter Eisentraut
Sep 16, 2012 at 12:32 am
Sep 26, 2012 at 2:35 am -
During the execution of ProcessUtility() function in /src/backend/xxx/utility.c, the CreateStmt node type is processed to create a table. Is there a global function in the context of the backend ...
Md
Sep 21, 2012 at 2:58 pm
Sep 24, 2012 at 8:17 pm -
Hackers, I ran into an issue building 9.2 with the OSSP UUID module today. A bit of Googling and I found that the MacPorts guys ran into the same issue a few weeks ago. Their discussion ...
David E. Wheeler
Sep 10, 2012 at 10:14 pm
Sep 12, 2012 at 7:45 pm -
I ran across a minor typo while reviewing the full-text search documentation. Attached is a patch to address the one usage of "lexems" in a sea of "lexemes".
Dan Scott
Sep 11, 2012 at 3:59 am
Sep 12, 2012 at 2:10 pm -
Hello. It took me a while to get a version of this that was independent of my data, but here it is. I don't understand what's going wrong but if you change any part of this query (or at least any ...
Vik Reykja
Sep 4, 2012 at 12:39 pm
Sep 7, 2012 at 2:54 am -
Hi, The attached documentation patch further describes the additive nature of the permission system. This patch makes some sweeping statements. It needs review by someone who knows whats in all the ...
Karl O. Pinc
Sep 29, 2012 at 6:17 am
Dec 16, 2012 at 9:40 pm -
Hi, Problem 1: concurrency: Testcase: Session 1: CREATE TABLE test_drop_concurrently(id serial primary key, data int); INSERT INTO test_drop_concurrently(data) SELECT * FROM generate_series(1, ...
Andres Freund
Sep 24, 2012 at 11:27 am
Oct 18, 2012 at 12:19 pm -
Example: create temporary table foo (a int); insert into foo values (1); alter role peter set temp_buffers = 120; ERROR: 22023: invalid value for parameter "temp_buffers": 120 DETAIL: "temp_buffers" ...
Peter Eisentraut
Sep 28, 2012 at 3:29 am
Oct 6, 2012 at 9:21 pm -
I've been slowly continuing to work that I started last winder to make XLogInsert scale better. I have tried quite a few different approaches since then, and have settled on the attached. This is ...
Heikki Linnakangas
Sep 20, 2012 at 3:29 pm
Sep 28, 2012 at 7:09 pm -
I haven't followed the details of the htup header reorganization, but I have noticed that a number of external extension modules will be broken because of the move of GETSTRUCT() and to a lesser ...
Peter Eisentraut
Sep 26, 2012 at 12:31 am
Sep 26, 2012 at 2:31 pm -
Hi, I'm experiencing the case when bitmap scan is ~ 70 times slower than index scan which seems to be caused by 1) very big table 2) some hash search logic (hash_search_with_hash_value ) Here is the ...
Sergey Koposov
Sep 2, 2012 at 5:21 am
Sep 2, 2012 at 4:10 pm -
I'm looking at the following code in pg_dump.c /* * Start transaction-snapshot mode transaction to dump consistent data. */ ExecuteSqlStatement(fout, "BEGIN"); if (fout- remoteVersion = 90100) { if ...
Pavan Deolasee
Sep 7, 2012 at 4:53 am
Jan 9, 2013 at 1:12 am -
A while ago I wanted to cherry-pick a patch from master to a back-branch that was initially committed by someone else. That was rejected because our git server requires author==committer. I don't ...
Peter Eisentraut
Sep 12, 2012 at 2:21 pm
Jan 5, 2013 at 5:21 pm -
Hi, I just performed a test upgrade from 9.1 to 9.2, and used --new-port variable. However, the analyze_new_cluster.sh does not include the new port, thus when I run it, it fails. Any chance to add ...
Devrim Gündüz
Sep 25, 2012 at 2:37 pm
Oct 3, 2012 at 8:23 pm -
I would like to have the option of disabling the CTE optimization fence for certain CTEs and/or queries. Can that be added to the official todo list? If not, why not? I would find the option ...
Daniel Browning
Sep 19, 2012 at 8:05 pm
Oct 1, 2012 at 4:06 pm -
The recent alter generic tests have broken pg_upgrade testing on Windows and probably other non-collation-supporting platforms. This can be cured by making the pg_upgrade test set up its test ...
Andrew Dunstan
Sep 29, 2012 at 3:07 pm
Oct 1, 2012 at 3:46 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 137 |
posts | 1,195 |
users | 123 |
website | postgresql.org... |
irc | #postgresql |
123 users for September 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)