FAQ

PostgreSQL > pgsql-hackers > August 2011

Search Discussions

149 discussions - 1,433 posts

  • 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 IshidukaJun 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 KaigaiKohei Kaigai
    Aug 24, 2011 at 12:40 pm
    Jan 24, 2012 at 5:27 pm
  • 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 DavisJeff 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 HaasRobert 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 HaasRobert 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 FarinaDaniel 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 KrosingHannu 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 MomjianBruce 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 WielandJoachim 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 EisentrautPeter 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 VondraTomas 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 SmithGreg 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 HaasRobert 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 DunstanAndrew 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 GeogheganPeter 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 KaiGaiKohei 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 HaasRobert 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 HaganderMagnus 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 EisentrautPeter 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 LinnakangasHeikki 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 LaneTom 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 HaasRobert 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 BartunovOleg 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 ...
    DavegDaveg
    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 ZoltanBoszormenyi 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 HaganderMagnus 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 MomjianBruce 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 RasheedDean 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 RasheedDean 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 KaiGaiKohei 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 LinnakangasHeikki 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 HerreraAlvaro 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 FetterDavid 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 DunstanAndrew 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 PageDave 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 HaasRobert 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 AbbateJoe 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 QuenotJean-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 LaneTom 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 MomjianBruce 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 GeogheganPeter 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 MomjianBruce 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 LaneTom 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 KorotkovAlexander 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 HaganderMagnus 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 SinhaSushant 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 SingerSteve 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 DunstanAndrew 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 HanadaShigeru 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 EisentrautPeter Eisentraut
    Aug 27, 2011 at 11:33 am
    Sep 6, 2011 at 2:25 am
Aug 2011
123
Group Navigation
period‹ prev | Aug 2011 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions149
posts1,433
users134
websitepostgresql.org...
irc#postgresql

134 users for August 2011

Robert Haas: 229 posts Tom Lane: 219 posts Heikki Linnakangas: 77 posts Peter Eisentraut: 56 posts Simon Riggs: 54 posts Andrew Dunstan: 50 posts Alvaro Herrera: 46 posts Bruce Momjian: 41 posts Magnus Hagander: 37 posts Alexander Korotkov: 28 posts Dean Rasheed: 26 posts Peter Geoghegan: 26 posts Jeff Davis: 25 posts Kevin Grittner: 22 posts Jim Nasby: 20 posts Dimitri Fontaine: 18 posts Florian Pflug: 17 posts Gokulakannan Somasundaram: 17 posts Daveg: 16 posts David E. Wheeler: 15 posts
show more
Archives