FAQ

PostgreSQL > pgsql-hackers > September 2012

Search Discussions

137 discussions - 1,195 posts

  • 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 FreundAndres 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 LaneTom 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 LinnakangasHeikki 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 KapilaAmit Kapila
    Sep 20, 2012 at 10:31 am
    Jan 5, 2013 at 4:17 pm
  • 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 DunstanAndrew 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 FujitaEtsuro 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 MomjianBruce 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 PaquierMichael 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 CreagerRobert 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 kapilaAmit 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 EisentrautPeter 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 kapilaAmit 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 WeaverBrian 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 DunstanAndrew 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 VondraTomas 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 DavisJeff 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 HANADAShigeru 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üzDevrim 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 SchoppmannFlorian 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 kapilaAmit 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 DunstanAndrew 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. PincKarl 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 DunstanAndrew 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 DunstanAndrew 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 HORIGUCHIKyotaro 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 HANADAShigeru 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. PincKarl 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 DavisJeff 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 KaiGaiKohei 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. PincKarl 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 KapilaAmit 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 HORIGUCHIKyotaro 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 KapilaAmit 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ísDaymel 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 EisentrautPeter 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 ...
    MdMd
    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. WheelerDavid 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 ScottDan 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 ReykjaVik 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. PincKarl 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 FreundAndres 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 EisentrautPeter 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 LinnakangasHeikki 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 EisentrautPeter 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 KoposovSergey 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 DeolaseePavan 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 EisentrautPeter 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üzDevrim 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 BrowningDaniel 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 DunstanAndrew Dunstan
    Sep 29, 2012 at 3:07 pm
    Oct 1, 2012 at 3:46 am
Sep 2012
123
Group Navigation
period‹ prev | Sep 2012 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions137
posts1,195
users123
websitepostgresql.org...
irc#postgresql

123 users for September 2012

Tom Lane: 207 posts Andrew Dunstan: 96 posts Bruce Momjian: 73 posts Andres Freund: 64 posts Peter Eisentraut: 60 posts Amit Kapila: 58 posts Alvaro Herrera: 50 posts Robert Haas: 31 posts Heikki Linnakangas: 27 posts Kohei KaiGai: 27 posts Kevin Grittner: 25 posts Magnus Hagander: 24 posts Karl O. Pinc: 23 posts Pavel Stehule: 19 posts Simon Riggs: 19 posts Heikki Linnakangas: 18 posts Noah Misch: 17 posts Josh Berkus: 16 posts Daniel Farina: 15 posts Michael Paquier: 15 posts
show more
Archives