FAQ

PostgreSQL > pgsql-hackers > April 2012

Search Discussions

112 discussions - 1,459 posts

  • These patches aren't marked with a committer FK arrays ECPG fetch foreign stats command triggers check function parallel pg_dump Does that mean myself or others should be claiming them for ...
    Simon RiggsSimon Riggs
    Apr 5, 2012 at 5:35 pm
    Jul 9, 2012 at 9:56 pm
  • Hi, attached is a patch to implement a framework to simplify and correctly nest multiplexing more than two timeout sources into the same SIGALRM signal handler. The framework is using a new internal ...
    Boszormenyi ZoltanBoszormenyi Zoltan
    Apr 4, 2012 at 10:31 am
    Dec 8, 2012 at 6:32 pm
  • I tried to implement a patch according to the idea. It allows extensions to register an entry point of the self-managed daemon processes, then postmaster start and stop them according to the normal ...
    Kohei KaiGaiKohei KaiGai
    Apr 25, 2012 at 9:40 am
    Nov 24, 2012 at 7:29 pm
  • A key barrier to migrations from trigger-based replication to WAL-based replication is the lack of temporary tables under hot standby. I'd like to close that gap; the changes needed will also reduce ...
    Noah MischNoah Misch
    Apr 25, 2012 at 3:55 am
    Jun 10, 2012 at 8:48 pm
  • I'm beginning to work on advanced additions to in-core replication for PostgreSQL. There are a number of additional features for existing single-master replication still to achieve, but the key ...
    Simon RiggsSimon Riggs
    Apr 26, 2012 at 12:41 pm
    May 4, 2012 at 5:26 pm
  • Hackers, attached patch adds conversion from pg_wchar string to multibyte string. This functionality is needed for my patch on index support for regular expression search ...
    Alexander KorotkovAlexander Korotkov
    Apr 23, 2012 at 8:48 am
    Jul 11, 2012 at 5:23 am
  • This idea appeared to have some support. I'd like to suggest that we take this a step further. Instead of adding a fourth mode, I'd like to suggest that we redefine "smart" to have the behavior ...
    Robert HaasRobert Haas
    Apr 27, 2012 at 5:43 pm
    May 8, 2012 at 5:59 pm
  • Hello, this is bug report and a patch for it. The first patch in the attachments is for 9.2dev and next one is for 9.1.3. On the current 9.2dev, IsCheckpointOnSchedule@checkpointer.c does not check ...
    Kyotaro HORIGUCHIKyotaro HORIGUCHI
    Apr 16, 2012 at 12:06 pm
    Jul 2, 2012 at 5:03 pm
  • <sigh Yes, it appears very similar. I didn't know about this. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
    Simon RiggsSimon Riggs
    Apr 26, 2012 at 3:03 pm
    May 4, 2012 at 10:18 pm
  • I just talked to Tom about the 9.2 release notes. Do people want me to write the 9.2 release notes? When do you think we will be ready for 9.2 beta? -- Bruce Momjian <bruce@momjian.us ...
    Bruce MomjianBruce Momjian
    Apr 13, 2012 at 3:23 pm
    Apr 30, 2012 at 8:18 am
  • Hi All, I submitted a GSoc application yesterday. Please review it and let me know if anyone needs any clarifications. Atri
    Atri SharmaAtri Sharma
    Apr 7, 2012 at 11:08 am
    Apr 17, 2012 at 2:10 pm
  • I propose that we remove support for the following OS ports from our source tree. They are totally dead, definitely don't work, and/or probably no one remembers what they even were. The code just bit ...
    Peter EisentrautPeter Eisentraut
    Apr 24, 2012 at 6:29 pm
    Sep 13, 2012 at 4:06 pm
  • Having performed this investigation, I've discovered a couple of interesting things. First, SlruRecentlyUsed() is an ineffective way of keeping a page from getting reused, because it's called ...
    Robert HaasRobert Haas
    Apr 4, 2012 at 12:00 pm
    Apr 9, 2012 at 3:06 am
  • The following patch truncates trailing null attributes from heap rows to reduce the size of the row bitmap. Applications often have wide rows in which many of the trailing column values are null. On ...
    Jameison MartinJameison Martin
    Apr 17, 2012 at 4:23 pm
    Aug 10, 2012 at 12:06 am
  • The Mac installation docs currently recommend the EDB one-click installer as the first choice. While this does install pgadmin and some other refinements, it also is fairly confusing to ...
    Jay LevittJay Levitt
    Apr 1, 2012 at 8:14 pm
    Apr 4, 2012 at 8:19 pm
  • If you use ALTER ROLE/DATABASE SET to configure an invalid search_path, PostgreSQL 9.1 issues a complaint about the invalid setting on each new connection. This is a behavior change relatively to ...
    Robert HaasRobert Haas
    Apr 3, 2012 at 3:33 pm
    Apr 11, 2012 at 3:26 am
  • I hope this is not an inappropriate time for 9.3 discussions. The flip side of asking for submissions in the first couple commitfests means that I need to submit proposals now. What is a Range Join? ...
    Jeff DavisJeff Davis
    Apr 16, 2012 at 5:41 am
    Apr 19, 2012 at 8:11 am
  • Hi all, I've written a pg_upgrade wrapper for upgrading our users (heroku) to postgres 9.1. In the process I encountered a specific issue that could easily be improved. We've had this process work ...
    Harold GiménezHarold Giménez
    Apr 5, 2012 at 2:27 am
    Apr 12, 2012 at 12:48 am
  • When I do this: rhaas=# set default_transaction_isolation = 'serializable'; SET rhaas=# begin; BEGIN rhaas=# select 1; Then I get this: TRAP: FailedAssertion("!(!RecoveryInProgress())", File ...
    Robert HaasRobert Haas
    Apr 27, 2012 at 1:15 pm
    Apr 30, 2012 at 2:56 pm
  • I am again requesting the addition of options to tools/git_changelog so I can more easily produce the release notes. I asked for this during 9.1 development and it was rejected. I am currently using ...
    Bruce MomjianBruce Momjian
    Apr 25, 2012 at 8:05 pm
    May 2, 2012 at 4:39 pm
  • I looked into the behavior complained of here: http://archives.postgresql.org/pgsql-performance/2012-04/msg00093.php The problem query can be abstracted to select * from a, b, c, d where a.x = b.y ...
    Tom LaneTom Lane
    Apr 13, 2012 at 2:32 pm
    Apr 19, 2012 at 5:33 am
  • I haven't finished reviewing this yet - but there are some things that need to be fixed. First, either the creation of the destination directory needs to be delayed until all the sanity checks have ...
    Andrew DunstanAndrew Dunstan
    Apr 3, 2012 at 1:27 pm
    Dec 9, 2012 at 4:16 am
  • The new pg_tablespace_location() function added in PG 9.2 to remove the director location from pg_tablespace returns an odd error for '0', which is InvalidOID: test= select ...
    Bruce MomjianBruce Momjian
    Apr 10, 2012 at 8:32 pm
    Apr 11, 2012 at 2:10 am
  • So after committing the latest round of parameterized-plan hacking, I was dismayed to see the buildfarm breaking out in pink, thanks to some of the members producing a different plan than expected ...
    Tom LaneTom Lane
    Apr 19, 2012 at 10:39 pm
    Apr 21, 2012 at 8:35 am
  • Hmm ... that did work as described, until we broke it :-(. This is an oversight in the 9.0 changes that added separate ModifyTuple nodes to plan trees. ModifyTuple doesn't return after each updated ...
    Tom LaneTom Lane
    Apr 4, 2012 at 3:00 pm
    Apr 18, 2012 at 3:11 pm
  • During ANALYZE, in analyze.c, functions compute_minimal_stats and compute_scalar_stats, values whose length exceed WIDTH_THRESHOLD (= 1024) are not used for calculating statistics other than that ...
    Albe LaurenzAlbe Laurenz
    Apr 30, 2012 at 10:28 am
    May 15, 2012 at 1:08 pm
  • Currently, we have a problem with index-only scans in Hot Standby mode: the xmin horizon on the standby might lag the master, and thus an index-only scan might mistakenly conclude that no heap fetch ...
    Robert HaasRobert Haas
    Apr 13, 2012 at 4:33 pm
    May 4, 2012 at 8:57 am
  • Yes, that sure looks like a bug. It seems that if the top-level transaction is aborting, then LockReleaseAll() is called and everything gets cleaned up properly; or if a subtransaction is aborting ...
    Robert HaasRobert Haas
    Apr 9, 2012 at 1:37 am
    Apr 10, 2012 at 5:20 pm
  • Some of my PostgreSQL Experts colleagues have been complaining to me that servers under load with very large queries cause CSV log files that are corrupted, because lines are apparently multiplexed ...
    Andrew DunstanAndrew Dunstan
    Apr 1, 2012 at 10:35 pm
    Apr 4, 2012 at 9:08 pm
  • Hackers, Per bug #6593, REASSIGN OWNED fails when the affected role owns an extension. This would be trivial to fix if extensions had support code for ALTER EXTENSION / OWNER, but they don't. So the ...
    Alvaro HerreraAlvaro Herrera
    Apr 18, 2012 at 3:42 pm
    Jul 4, 2012 at 8:51 am
  • I admit to not having followed the discussion around the new mode for synchronous_commit very closely, so my apologies if this has been discussed and dismiseed - I blame failing to find it int he ...
    Magnus HaganderMagnus Hagander
    Apr 19, 2012 at 9:05 am
    Apr 24, 2012 at 8:51 pm
  • ... would be really nice to have. Especially pgbench and pg_upgrade for me, but it would be useful to have man pages for everything. Unfortunately, we can't just replace the sect1's in in Appendix F ...
    Peter EisentrautPeter Eisentraut
    Apr 4, 2012 at 6:53 pm
    Apr 16, 2012 at 8:59 am
  • Hi, When I committed Alex Shulgin's patch to add URI support to libpq, I included the test harness as well. However, due to it being in a separate subdirectory that did not previously had tests, it's ...
    Alvaro HerreraAlvaro Herrera
    Apr 17, 2012 at 1:47 pm
    Jul 6, 2012 at 9:03 pm
  • Don't know if anybody noticed bug #6559 http://archives.postgresql.org/pgsql-bugs/2012-03/msg00180.php I've confirmed that the given test case works in 9.0 but fails in 9.1 and HEAD. It's not ...
    Tom LaneTom Lane
    Apr 10, 2012 at 2:20 am
    Apr 26, 2012 at 6:13 pm
  • A lot of discussion took place regarding corruption detection, and I am attempting to summarize it in a useful way. Please excuse the lack of references; I'm hoping to agree on the basic problem ...
    Jeff DavisJeff Davis
    Apr 21, 2012 at 9:41 pm
    Apr 26, 2012 at 1:41 pm
  • I think it might be useful to disguard the stability property if it's not a real requirement, as I think doing so gives us additional leeway to compose descending runs (pre-sorted subsets) that are ...
    Peter GeogheganPeter Geoghegan
    Apr 19, 2012 at 1:32 am
    Apr 25, 2012 at 12:23 am
  • Hello hackers, It turns out that in a PL/PgSQL function, you can DECLARE a variable using the same name as one of the function parameters. This has the effect of clobbering the parameter, for ...
    Brendan JurdBrendan Jurd
    Apr 15, 2012 at 7:49 am
    Apr 17, 2012 at 9:51 am
  • Hi, I recently wrote a plpgsql plugin. I wanted to enable the use of pgxs, to make it easier to compile the plugin, but I eventually found that I can't do that because the plpgsql.h file is not ...
    Guillaume LelargeGuillaume Lelarge
    Apr 8, 2012 at 9:00 am
    Apr 17, 2012 at 7:13 am
  • Hi, While looking into SSL code in secure_read() of be-secure.c and pqsecure_read() of fe-secure.c, I noticed subtle difference between them. In secure_read ...
    Tatsuo IshiiTatsuo Ishii
    Apr 4, 2012 at 1:17 pm
    Apr 6, 2012 at 4:47 pm
  • Uh, isn't it kind of a bad idea to back-patch something like this? It seems like a behavior change. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
    Robert HaasRobert Haas
    Apr 17, 2012 at 11:08 pm
    Apr 18, 2012 at 2:27 pm
  • A long time ago, we had this bug report: http://archives.postgresql.org/pgsql-bugs/2003-02/msg00069.php in consequence of which, I changed timestamp_part() so that it would rotate a ...
    Tom LaneTom Lane
    Apr 9, 2012 at 5:31 pm
    Apr 9, 2012 at 7:56 pm
  • Hoping to demonstrate the wonders of our new group commit code, I ran some benchmarks on the IBM POWER7 machine with synchronous_commit = on. But, it didn't come out much better than 9.1. pgbench, ...
    Robert HaasRobert Haas
    Apr 1, 2012 at 12:10 am
    Apr 2, 2012 at 11:20 pm
  • Hi, I've tried out pg_receivexlog and have noticed that when restarting the cluster, pg_receivexlog gets cut off... it doesn't keep waiting. This is surprising as the DBA would have to remember to ...
    Thom BrownThom Brown
    Apr 6, 2012 at 12:07 am
    May 27, 2012 at 9:07 am
  • I notice that there isn't a parameter called enable_indexonly (or similar). ISTM that such a major new feature should be controlled by a planner method parameter, just as all the existing planner ...
    Simon RiggsSimon Riggs
    Apr 27, 2012 at 3:39 pm
    Apr 30, 2012 at 10:28 am
  • Hi, I'm debugging initdb using gdb. I found that I could not step in the function getopt_long in line 2572 in initdb.c. I also found that the value of VAR optind never be changed. VAR optind is ...
    Clover WhiteClover White
    Apr 9, 2012 at 11:39 am
    Apr 9, 2012 at 6:28 pm
  • When GIN changes a metapage, we WAL-log its ex-header content and never use a backup block. This reduces WAL volume since the vast majority of the metapage is unused. However, ginRedoUpdateMetapage() ...
    Noah MischNoah Misch
    Apr 30, 2012 at 5:34 pm
    May 3, 2012 at 3:34 pm
  • Hi, This is the version I used to run the following commands select version(); version ---------------------------------------------------------------------------------------------------------------- ...
    Abbas ButtAbbas Butt
    Apr 27, 2012 at 12:25 pm
    Apr 27, 2012 at 10:42 pm
  • Since we are wacking around pg_stat_activity for 9.2, what do people think about these column names? backend_start | timestamp with time zone | xact_start | timestamp with time zone | query_start | ...
    Bruce MomjianBruce Momjian
    Apr 11, 2012 at 8:46 pm
    Apr 11, 2012 at 9:30 pm
  • Then you may need WAL space larger than 1GB as well. For replication to work, it seems likely that you may need to have sufficient WAL space to handle a row, possibly the entire transaction.. But ...
    Michael NolanMichael Nolan
    Apr 11, 2012 at 2:38 pm
    Apr 11, 2012 at 6:14 pm
  • I updated the patch added to CF 2012-Next [1]. Attached is the updated version of the patch. For the discussion in [2], I've introduced a new generic option, validate for file_fdw foreign tables, ...
    Etsuro FujitaEtsuro Fujita
    Apr 13, 2012 at 7:56 am
    Jun 21, 2012 at 11:16 am
Apr 2012
123
Group Navigation
period‹ prev | Apr 2012 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions112
posts1,459
users118
websitepostgresql.org...
irc#postgresql

118 users for April 2012

Tom Lane: 219 posts Robert Haas: 216 posts Simon Riggs: 84 posts Peter Eisentraut: 57 posts Andrew Dunstan: 46 posts Bruce Momjian: 37 posts Magnus Hagander: 37 posts Peter Geoghegan: 35 posts Alvaro Herrera: 34 posts Greg Stark: 33 posts Kevin Grittner: 32 posts Joshua Berkus: 27 posts Noah Misch: 27 posts Boszormenyi Zoltan: 26 posts Greg Smith: 26 posts Heikki Linnakangas: 26 posts Thom Brown: 24 posts Merlin Moncure: 20 posts Pavel Stehule: 20 posts Jay Levitt: 19 posts
show more
Archives