Search Discussions
-
done. * Procedure 1. Call pg_start_backup('x') on the standby. 2. Take a backup of the data dir. 3. Call pg_stop_backup() on the standby. 4. Copy the control file on the standby to the backup. 5. ...
Jun Ishiduka
Aug 5, 2011 at 6:47 am
Jan 26, 2012 at 6:09 am -
Hi, The attached patches try to tackle our long-standing leaky view problem, and were revised according to the discussion we had in the commit-fest 1st. We already knew two scenarios to leak contents ...
Kohei Kaigai
Aug 24, 2011 at 12:40 pm
Jan 24, 2012 at 5:27 pm -
78
Range Types
Attached is the latest version of the Range Types patch. I will get it into better shape before the commitfest, but wanted to put up a draft in case anyone had comments on the TODO items. Changes: * ...Jeff Davis
Aug 23, 2011 at 5:32 pm
Nov 4, 2011 at 6:08 pm -
Please find attached a patch implementing a basic version of index-only scans. This patch is the work of my colleague Ibrar Ahmed and myself, and also incorporates some code from previous patches ...
Robert Haas
Aug 11, 2011 at 8:06 pm
Oct 15, 2011 at 10:01 pm -
I was able to obtain access to a 32-core HP-UX server. I repeated the pgbench -S testing that I have previously done on Linux, and found that the results were not too good. Here are the results at ...
Robert Haas
Aug 28, 2011 at 12:09 am
Aug 27, 2012 at 5:28 pm -
Hello list, At Heroku we use CREATE INDEX CONCURRENTLY with great success, but recently when frobbing around some indexes I realized that there is no equivalent for DROP INDEX, and this is a similar ...
Daniel Farina
Aug 24, 2011 at 6:25 pm
Jun 14, 2012 at 3:04 pm -
Hi I have been helping some people to debug a SIGALARM related crash induced by using pl/perlu http get functionality I have been so far able to repeat the crash only on Debian 64 bit computers. DB ...
Hannu Krosing
Aug 4, 2011 at 1:08 pm
Sep 5, 2012 at 8:45 pm -
The problem appears to be that the Postgres catalogs think there is a toast table for 'actions', while the file system doesn't seem to have such a file. I can you look in pg_class and verify that? ...
Bruce Momjian
Aug 25, 2011 at 8:34 pm
Sep 7, 2011 at 6:43 pm -
This is a patch to implement synchronized snapshots. It is based on Alvaro's specifications in: http://archives.postgresql.org/pgsql-hackers/2011-02/msg02074.php In short, this is how it works: ...
Joachim Wieland
Aug 15, 2011 at 1:49 am
Oct 23, 2011 at 9:01 am -
I would like to see whether there is support for adding sha1 and sha2 functions into the core. These are obviously well-known and widely used functions, but currently the only way to get them is ...
Peter Eisentraut
Aug 10, 2011 at 6:07 pm
Aug 23, 2012 at 6:02 pm -
Hello, I'd like to propose a small patch that allows better checkpoint progress monitoring. The patch is quite simple - it adds a new integer GUC "checkpoint_update_limit" and every time checkpoint ...
Tomas Vondra
Aug 25, 2011 at 8:57 pm
Sep 19, 2011 at 6:43 pm -
Attached is a patch that tracks and displays the accumulated cost when autovacuum is running. Code by Noah Misch and myself. I hope this idea will bring a formal process to vacuum tuning, which is ...
Greg Smith
Aug 17, 2011 at 9:04 pm
Feb 23, 2012 at 1:36 am -
While I was poking around at the index-only scans patch, I couldn't help noticing that our buffer replacement algorithm leaves something to be desired. Here's the query again: select sum(aid) from ...
Robert Haas
Aug 12, 2011 at 4:05 am
Jan 20, 2012 at 2:59 pm -
Attached is an undocumented patch that allows pg_restore to omit post-data items or omit all but post-data items. This has been discussed before, and Simon sent in a patch back on 2008, which has ...
Andrew Dunstan
Aug 23, 2011 at 8:30 pm
Dec 16, 2011 at 7:53 pm -
I'm happy to report that thanks to some persistent complaining on my part, the one outstanding issue when building Postgres with Clang - the spurious warnings that occured as a result of it being ...
Peter Geoghegan
Aug 2, 2011 at 11:52 pm
Aug 13, 2011 at 9:49 pm -
The attached three patches try to consolidate code path of DROP statement on various kind of object classes. The first part provides a set of internal api to reference properties of object types; as ...
Kohei KaiGai
Aug 15, 2011 at 8:54 pm
Oct 21, 2011 at 1:02 pm -
I've been giving this quite a bit more thought, and have decided to abandon the scheme described above, at least for now. It has the advantage of avoiding virtually all locking, but it's extremely ...
Robert Haas
Aug 22, 2011 at 9:25 pm
Sep 13, 2011 at 12:44 pm -
Here's an updated version of pg_receivexlog, that should now actually work (it previously failed miserably when a replication record crossed a WAL file boundary - something which I at the time could ...
Magnus Hagander
Aug 16, 2011 at 2:33 pm
Jun 4, 2012 at 4:07 pm -
I think it would be useful to add the following explanation and sample to the postgresql.conf sample file: diff --git i/src/backend/utils/misc/postgresql.conf.sample ...
Peter Eisentraut
Aug 30, 2011 at 6:39 pm
Sep 10, 2011 at 8:33 am -
COPY is slow. Let's make it faster. One obvious optimization is to insert heap tuples in bigger chunks, instead of calling heap_insert() separately for every tuple. That saves the overhead of pinning ...
Heikki Linnakangas
Aug 12, 2011 at 7:17 pm
Aug 9, 2012 at 2:11 pm -
I've been thinking about how to redesign the plancache infrastructure to better support use of transient (one-shot) plans, as we've talked about various times such as in this thread: ...
Tom Lane
Aug 2, 2011 at 8:47 pm
Aug 19, 2011 at 9:23 pm -
About nine months ago, we had a discussion of some benchmarking that was done by the mosbench folks at MIT: http://archives.postgresql.org/pgsql-hackers/2010-10/msg00160.php Although the authors used ...
Robert Haas
Aug 3, 2011 at 6:21 pm
Aug 16, 2011 at 2:40 am -
Hi there, attached is WIP-patch for 9.2 development source tree, which provides implementation of SP-GiST (prototype was presented at PGCon-2011, see ...
Oleg Bartunov
Aug 31, 2011 at 6:39 pm
Dec 17, 2011 at 10:27 pm -
This seems to be bug month for my client. Now there are seeing periods where all new connections fail immediately with the error: FATAL: lock AccessShareLock on object 0/1260/0 is already held This ...
Daveg
Aug 12, 2011 at 11:19 pm
Sep 8, 2011 at 3:32 pm -
Hi, I looked at b4fbe392f8ff6ff1a66b488eb7197eef9e1770a4 and I noticed that it's using TRUE, FALSE, true and false inconsistently: @@ -248,6 +249,7 @@ CreateSharedInvalidationState(void) ...
Boszormenyi Zoltan
Aug 4, 2011 at 10:08 am
Aug 29, 2012 at 2:19 pm -
I'm trying to make my streaming log receiver work properly with 9.1, and have come across a couple of things. The first one that's causing trouble is that the definition of the protocol is currently ...
Magnus Hagander
Aug 15, 2011 at 11:22 am
Aug 16, 2011 at 12:58 pm -
We currently have reduced WAL logging for wal_level = minimum for these commands: CREATE TABLE AS CREATE INDEX CLUSTER COPY into tables that were created or truncated in the same transaction One ...
Bruce Momjian
Aug 4, 2011 at 7:50 pm
Aug 11, 2011 at 8:49 pm -
As background, I have an app that accepts user text input and casts it to a timestamp in order to produce reports. I use PostgreSQL's timestamp input conversion for this, since it gives a lot of ...
Dean Rasheed
Aug 25, 2011 at 9:39 am
Aug 31, 2011 at 7:02 am -
I've been thinking some more about the long-standing problem of the AFTER TRIGGER queue using too much memory, and I think that the situation can be improved by using some basic compression. ...
Dean Rasheed
Aug 1, 2011 at 4:05 pm
Aug 15, 2011 at 8:07 pm -
The attached patch is a draft to support arguments in addition to OAT_* enum and object identifiers. The existing object_access_hook enables loadable modules to acquire control when objects are ...
Kohei KaiGai
Aug 28, 2011 at 6:32 pm
Nov 12, 2011 at 8:29 pm -
Currently, if you take a backup with "pg_basebackup -x" (which means it will include all the WAL to required restore within the backup dump), and hit Ctrl-C while the WAL is being streamed, you end ...
Heikki Linnakangas
Aug 9, 2011 at 9:00 am
Aug 17, 2011 at 9:38 am -
Hi, Previously, we had some discussion to introduce a new type of tuple lock to let foreign keys be lighter weight, allowing for more concurrency. During the course of that discussion, it became ...
Alvaro Herrera
Aug 9, 2011 at 5:01 pm
Sep 14, 2011 at 12:07 pm -
Folks, I noticed that src/tools/copyright looks like it can only be run on Bruce's machine, so this translation to Perl is intended: 1. To make the script idempotent, which allows its safe use in ...
David Fetter
Aug 12, 2011 at 8:30 pm
Aug 20, 2011 at 2:14 am -
Attached is an undocumented patch that allows a user to have pg_dump exclude data but not DDL for a table. One use case for this is a very large table that changes infrequently, and for which dumping ...
Andrew Dunstan
Aug 23, 2011 at 8:08 pm
Dec 14, 2011 at 4:36 pm -
The current plan (or, the last one I recall) is to push another 9.1 release tomorrow, for Monday release. Are we going with beta4 or rc1? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: ...
Dave Page
Aug 17, 2011 at 1:00 pm
Aug 17, 2011 at 10:20 pm -
In response to my blog post on lseek contention, someone posted a comment wherein they proposed using fstat() rather than lseek() to get file sizes. ...
Robert Haas
Aug 8, 2011 at 2:30 pm
Oct 28, 2011 at 8:22 pm -
Hi, In order to compare the schema of two presumably identical databases, I've been diffing the output of pg_dump -Osx. However, I've found that the order of the output is not very reliable. For ...
Joe Abbate
Aug 30, 2011 at 7:08 pm
Aug 31, 2011 at 2:43 pm -
Hi there, plpython crashes on me on various 64-bit Ubuntu hosts, see the gdb backtrace at: https://gist.github.com/1140005 Do you believe there was recent bugfixes regarding PLyMapping_ToTuple() ? ...
Jean-Baptiste Quenot
Aug 11, 2011 at 4:02 pm
Aug 18, 2011 at 11:09 am -
I've been testing the problem reported by Dave Gould by running "make installcheck-parallel" together with a tight loop of "vacuum full pg_class": while true; do psql -c "vacuum full pg_class" ...
Tom Lane
Aug 12, 2011 at 6:15 pm
Aug 13, 2011 at 7:27 pm -
It has been years since I ran src/tools/pginclude/pgrminclude to remove unnecessary include files. (I have already fixed things so include files can be compiled on their own.) The attached patch ...
Bruce Momjian
Aug 26, 2011 at 4:36 am
Sep 1, 2011 at 2:53 pm -
Should we have an optional, disabled-by-default limit on the recursion/iteration depth of recursive CTEs to guard against stupid queries that loop ad infinitum? I've looked at other database systems ...
Peter Geoghegan
Aug 15, 2011 at 7:49 pm
Aug 20, 2011 at 3:56 pm -
Our docs suggest an optimization to reduce WAL logging when you are creating and populating a table: http://www.postgresql.org/docs/9.0/static/runtime-config-wal.html#RUNTIME-CONFIG-WAL-SETTINGS In ...
Bruce Momjian
Aug 2, 2011 at 1:35 pm
Aug 4, 2011 at 4:07 pm -
On my way to do something else entirely, I came across a couple of things that are not very nice about psql's lexer: 1. Somebody broke the no-backtracking property back in 9.0 while adding quoted ...
Tom Lane
Aug 25, 2011 at 4:47 pm
Aug 26, 2011 at 3:13 am -
String-formatted relopts was never used before, but I've used it in buffering GiST index build patch and encountered with following compiler warnings: reloptions.c:259: warning: initializer-string ...
Alexander Korotkov
Aug 8, 2011 at 10:27 am
Aug 9, 2011 at 4:16 pm -
The pg_stat_replication view exposes all the fields in StandbyReplyMessage *except* for the timestamp when the message was generated. On an active system this is not all that interesting, but on a ...
Magnus Hagander
Aug 15, 2011 at 11:03 am
Aug 25, 2012 at 8:46 pm -
Given a document and a query, the goal of headline generation is to produce text excerpts in which the query appears. Currently the headline generation in postgres follows the following steps: 1. ...
Sushant Sinha
Aug 23, 2011 at 5:19 pm
Aug 15, 2012 at 5:39 pm -
The attached patch adds an option to the COPY command to skip writing WAL when the following conditions are all met: 1) The table is empty (zero size on disk) 2) The copy command can obtain an access ...
Steve Singer
Aug 23, 2011 at 6:01 pm
Aug 25, 2011 at 2:45 am -
Why do we parse this as a correct timestamptz literal: 2011-08-29T09:11:14.123 CDT but not this: 2011-08-29T09:11:14.123 America/Chicago Replace the ISO-8601 style T between the date and time parts ...
Andrew Dunstan
Aug 29, 2011 at 2:41 pm
Aug 25, 2012 at 9:45 pm -
Hi, I propose to support force_not_null option for file_fdw too. In 9.1 development cycle, file_fdw had been implemented with exported COPY FROM routines, but only force_not_null option has not been ...
Shigeru Hanada
Aug 8, 2011 at 7:13 am
Sep 16, 2011 at 8:40 pm -
This is an artificial test case shrunk down from a much larger real query. CREATE TABLE test1 ( sha1 bytea PRIMARY KEY, something text ); CREATE TABLE test2 ( sha1 bytea PRIMARY KEY, blah text ); ...
Peter Eisentraut
Aug 27, 2011 at 11:33 am
Sep 6, 2011 at 2:25 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 149 |
posts | 1,433 |
users | 134 |
website | postgresql.org... |
irc | #postgresql |
134 users for August 2011
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)