FAQ

PostgreSQL > pgsql-hackers > July 2012

Search Discussions

97 discussions - 1,125 posts

  • Hey everyone, Upon doing some usability tests with PostgreSQL 9.1 recently, I ran across this discussion: http://archives.postgresql.org/pgsql-hackers/2011-12/msg01224.php And after reading the ...
    Shaun ThomasShaun Thomas
    Jul 9, 2012 at 8:30 pm
    Jul 25, 2012 at 9:43 pm
  • I occasionally get questions about how to run pg_upgrade on log-shipping standby servers. The attached documentation patch outlines how to do it. I don't think we can assume that because pg_upgrade ...
    Bruce MomjianBruce Momjian
    Jul 10, 2012 at 3:50 pm
    Aug 31, 2012 at 4:10 am
  • I've moved this thread from performance to hackers. The topic was poor performance when truncating lots of small tables repeatedly on test environments with fsync=off. My attached Proof of Concept ...
    Jeff JanesJeff Janes
    Jul 13, 2012 at 4:55 am
    Jul 24, 2012 at 5:09 pm
  • Hello we cannot actually store result of query to psql variable I propose a new slash statement "\eset for this purpose Syntax: \eset variable [, variable [..]] query -- it raise exception when more ...
    Pavel StehulePavel Stehule
    Jul 26, 2012 at 5:13 am
    Dec 19, 2012 at 8:04 am
  • The attached patch is my homework at the last commit fest of v9.2. It consolidates some similar routines into a single generic routines that handles ALTER RENAME TO, OWNER TO and SET SCHEMA according ...
    Kohei KaiGaiKohei KaiGai
    Jul 24, 2012 at 5:24 am
    Jan 9, 2013 at 11:46 am
  • Hi all, I've created new patch to get/reset statistics of WAL buffer writes (flushes) caused by WAL buffer full. This patch provides two new functions, pg_stat_get_xlog_dirty_write() and ...
    Satoshi NagayasuSatoshi Nagayasu
    Jul 7, 2012 at 12:01 pm
    Dec 9, 2012 at 6:06 pm
  • CompactCheckpointerRequestQueue supposes that it can use an entry of the checkpointer request queue directly as a hash table key. This will work reliably only if there are no pad bytes in the ...
    Tom LaneTom Lane
    Jul 15, 2012 at 9:36 pm
    Jul 18, 2012 at 12:41 pm
  • Why does the isolation check take such a long time? On some of my slower buildfarm members I am thinking of disabling it because it takes so long. This single test typically takes longer than a full ...
    Andrew DunstanAndrew Dunstan
    Jul 13, 2012 at 8:06 pm
    Jul 27, 2012 at 12:13 am
  • Hmm, I ran the regressions tests, but not with C encoding. With the patch, you no longer get the errdetail you used to, when an encoding conversion fails: We could just update the expected output, ...
    Heikki LinnakangasHeikki Linnakangas
    Jul 5, 2012 at 8:37 pm
    Aug 9, 2012 at 9:55 am
  • Hi all, I am trying to install my FDW project on windows.I did some research and I believe I shall be requiring pre compiled binaries(dll files).I tried cross compiling using MinGW on my Ubuntu.I am ...
    Atri SharmaAtri Sharma
    Jul 13, 2012 at 8:31 am
    Jul 13, 2012 at 1:43 pm
  • I am running into a lot of customer situations where the customer reports that "canceling autovacuum task" shows up in the logs, and it's unclear whether this is happening often enough to matter, and ...
    Robert HaasRobert Haas
    Jul 24, 2012 at 5:48 pm
    Aug 30, 2012 at 5:28 pm
  • So, considering that there is required setup, it seems that the obvious thing to do here is add a GUC: huge_tlb_pages (boolean). The other alternative is to try with MAP_HUGETLB and, if it fails, try ...
    Robert HaasRobert Haas
    Jul 3, 2012 at 2:49 am
    Aug 21, 2012 at 8:13 pm
  • I converted Skytools modules to extensions and found 2 problems: 1) Dumpable sequences are not supported - if sequence is tagged with pg_catalog.pg_extension_config_dump(), the pg_dump tries to run ...
    Marko KreenMarko Kreen
    Jul 18, 2012 at 10:13 am
    Nov 2, 2012 at 2:50 pm
  • Hi, Attached is v2 of the patch. Changes are: * more comments * significantly cleaned/simpliefied coded * crc validation * addition of XLogReaderReadOne Definitely needed are: * better validation of ...
    Andres FreundAndres Freund
    Jul 19, 2012 at 10:29 am
    Sep 9, 2012 at 8:14 pm
  • Hello, I've noticed recently that I can't seem to use the convenient xlog filename formatting functions while I'm in a standby. I don't see an incredibly obvious reason why that is the case, so ...
    Daniel FarinaDaniel Farina
    Jul 3, 2012 at 8:25 am
    Oct 18, 2012 at 4:56 pm
  • I have received positive feedback on the pg_dump --split option I suggested, but it depends on pg_dump dumping objects in a deterministic order. I'm committed to fixing this. The first problem I've ...
    Joel JacobsonJoel Jacobson
    Jul 4, 2012 at 3:17 pm
    Oct 18, 2012 at 3:26 pm
  • Yes. Attached patch removes that sentence. Yes, .done file should be created even if archive mode is not enabled. Attached patch changes the startup process so that it creates .done file whenever WAL ...
    Fujii MasaoFujii Masao
    Jul 29, 2012 at 3:01 pm
    Dec 29, 2012 at 9:07 pm
  • Hi, attached is a patch that does $SUBJECT. It's a usability enhancement, to take a backup, write a minimalistic recovery.conf and start the streaming standby in one go. Comments? Best regards, ...
    Boszormenyi ZoltanBoszormenyi Zoltan
    Jul 1, 2012 at 11:03 am
    Oct 3, 2012 at 12:39 pm
  • I noticed today that has_language_privilege() returns incorrect answer for non-superuser, e.g.: 8<--------------------------------------------------- select has_language_privilege('nobody', ...
    Joe ConwayJoe Conway
    Jul 10, 2012 at 1:24 am
    Aug 31, 2012 at 3:22 am
  • I'm chasing up an issue from a client who has this problem (in 9.1): with q as ( some query here ) select q.* from q yields: job_scope | checked_col ...
    Andrew DunstanAndrew Dunstan
    Jul 18, 2012 at 6:58 pm
    Jul 20, 2012 at 5:13 pm
  • Hi, I wonder if we just should add a format code like %R or something similar as a replacement for the %X/%X notion. Having to type something like "(uint32) (state- curptr 32), (uint32)state- curptr" ...
    Andres FreundAndres Freund
    Jul 3, 2012 at 5:36 pm
    Jul 14, 2012 at 5:29 pm
  • Hello When I worked on parametrised DO statement, I had to solve following issue: Syntax is: DO (param list) $$ ... $$ LANGUAGE ... USING expr_list What is correct way for evaluation of expr_list ...
    Pavel StehulePavel Stehule
    Jul 8, 2012 at 7:14 am
    Jul 10, 2012 at 3:50 pm
  • Hi, I've been playing around with the idea of supporting automatically updatable views, and I have a working proof of concept. I've taken a different approach than the previous attempts to implement ...
    Dean RasheedDean Rasheed
    Jul 1, 2012 at 10:36 pm
    Sep 2, 2012 at 8:37 pm
  • Hi, I found several problems in pg_receivexlog, e.g., memory leaks, file-descripter leaks, ..etc. The attached patch fixes these problems. ISTM there are still some other problems in pg_receivexlog, ...
    Fujii MasaoFujii Masao
    Jul 9, 2012 at 6:24 pm
    Aug 6, 2012 at 11:56 am
  • Hello I seen nice trick based on window function http://stackoverflow.com/questions/11700930/how-can-i-trim-a-text-array-in-postgresql but isn't it example of wrong evaluation? Result of row_number ...
    Pavel StehulePavel Stehule
    Jul 30, 2012 at 4:20 pm
    Jul 30, 2012 at 7:25 pm
  • After fixing the assorted breakage discussed yesterday, I still wasn't seeing any ForwardFsyncRequest requests coming from the bgwriter during a regression test run, which made me wonder if there was ...
    Tom LaneTom Lane
    Jul 18, 2012 at 8:00 pm
    Jul 22, 2012 at 9:31 pm
  • Hello I did a backport of temp_file_limit feature to 9.1, but when we tested this patch, we found very restristrictive limit to 2GB. 2GB is nonsense, because this is session limit of temp files, and ...
    Pavel StehulePavel Stehule
    Jul 19, 2012 at 8:05 pm
    Jul 20, 2012 at 5:46 am
  • Hi, Attached please find a trivial patch for psql which adds a \n meta command as a shortcut for typing set search_path =. This allows you to use psql as follows: \dn \n my_schema \d \d my_table ...
    Colin 't HartColin 't Hart
    Jul 10, 2012 at 9:09 am
    Jul 10, 2012 at 6:10 pm
  • The attached patch is delivered from the discussion around row-level access control feature. A problem Florian pointed out is refcursor declared in security definer function. Even though all the ...
    Kohei KaiGaiKohei KaiGai
    Jul 2, 2012 at 2:55 pm
    Jul 5, 2012 at 5:05 pm
  • Attached are two patches, one of which I'd like to apply. Open for discussion on which one. The smaller one, pgfoundry_1.diff, removes the suggestion to apply for new projects on pgfoundry. The ...
    Magnus HaganderMagnus Hagander
    Jul 3, 2012 at 7:20 pm
    Jul 4, 2012 at 3:17 pm
  • Hello, I'm currently on a university research project if performance could be increased by substituting different inter-node search algorithms instead of the currently used binary search. But I'm ...
    Samuel VogelSamuel Vogel
    Jul 16, 2012 at 11:51 pm
    Jul 22, 2012 at 10:41 pm
  • In bug #6734 we have a complaint about a longstanding misfeature of CREATE TABLE LIKE. Ordinarily, this command doesn't select names for copied indexes, but leaves that to be done at runtime by ...
    Tom LaneTom Lane
    Jul 14, 2012 at 8:02 pm
    Jul 16, 2012 at 5:40 pm
  • Sorry to raise this once again, but I still find this CHECK NO INHERIT syntax to a bit funny. We are currently using something like CHECK NO INHERIT (foo 0) But we already have a different syntax for ...
    Peter EisentrautPeter Eisentraut
    Jul 18, 2012 at 9:49 pm
    Jul 24, 2012 at 8:32 pm
  • What are our plans for a 9.2 final release date? If we wait until September 1 to release our first release candidate, we will probably not release final until mid/late September. Is that what we ...
    Bruce MomjianBruce Momjian
    Jul 21, 2012 at 7:08 am
    Jul 24, 2012 at 5:55 pm
  • Rsync is popular with Postgres users, but I don't understand how they are using the default check mode (file size, modification time) to synchronize shut-down data directories? It seems they would ...
    Bruce MomjianBruce Momjian
    Jul 10, 2012 at 2:48 am
    Jul 24, 2012 at 5:16 pm
  • We yesterday encountered a program that in a degenerate case issued in a single transaction a huge number of selects (in a single transaction but each select in a separate call to PGExec) (huge = ~ ...
    Benedikt GrundmannBenedikt Grundmann
    Jul 20, 2012 at 7:19 am
    Jul 20, 2012 at 10:46 am
  • Today I learnt [1,2,3] that the feature ALTER TABLE .. ADD CONSTRAINT ... USING INDEX we added back in the day is not so useful in the field. Having to drop foreign key constraints before this ...
    Gurjeet SinghGurjeet Singh
    Jul 7, 2012 at 3:53 am
    Jul 12, 2012 at 11:18 pm
  • Attached is a Patch to change the parsing of pg_ident.conf to make it similar to pg_hba.conf. This is based on Todo Item: http://archives.postgresql.org/pgsql-hackers/2011-06/msg02204.php Purpose - ...
    Amit KapilaAmit Kapila
    Jul 2, 2012 at 12:10 pm
    Sep 22, 2012 at 3:59 am
  • Hi, I notice that pg_basebackup has lots of messages where file names are not in quotes. Is this okay? There's also this one which is probably against our conventions: #: pg_receivexlog.c:181 #, ...
    Alvaro HerreraAlvaro Herrera
    Jul 25, 2012 at 7:37 pm
    Jul 26, 2012 at 2:20 pm
  • We are now at the end of the originally scheduled one-month window for the June commitfest. While the numbers look fairly bad: Needs Review: 17, Waiting on Author: 10, Ready for Committer: 3, ...
    Tom LaneTom Lane
    Jul 16, 2012 at 12:17 am
    Jul 17, 2012 at 3:06 pm
  • This bug report was fixed mostly via private email because a private schema dump was sent to Tom and me. Tom fixed the problem by changing the way we interact with struct dirent, but neither of us is ...
    Bruce MomjianBruce Momjian
    Jul 25, 2012 at 5:01 pm
    Jul 26, 2012 at 10:22 am
  • Hello I tested Peter's patch and it works well. I don't see any performance problem on my notebook last discussion ...
    Pavel StehulePavel Stehule
    Jul 2, 2012 at 8:14 am
    Jul 19, 2012 at 8:14 pm
  • A web site doc comment from user skong today points out a small issue around the sample INSTR function given in plpgsql-porting.html that I can't confirm (none of those dirty Oracle instances here ...
    Greg SmithGreg Smith
    Jul 3, 2012 at 12:51 am
    Jul 6, 2012 at 11:05 am
  • It seems strange that the external_pid_file is never removed. There is even a C comment about it: /* Should we remove the pid file on postmaster exit? */ I think it should be removed with proc_exit ...
    Peter EisentrautPeter Eisentraut
    Jul 27, 2012 at 5:09 am
    Aug 17, 2012 at 5:43 am
  • Folks, I just noticed that there's yet another change to time zones: http://www.iana.org/time-zones Can we slide this into the upcoming point release? When would that be? Cheers, David. -- David ...
    David FetterDavid Fetter
    Jul 30, 2012 at 9:28 pm
    Aug 6, 2012 at 3:19 pm
  • Hi, I'm thinking of adding new probes to trace smgr activities. In this implementation, I just found that md.c has its own probes within it, but I'm wondering why we do not have those probes within ...
    Satoshi NagayasuSatoshi Nagayasu
    Jul 28, 2012 at 7:34 am
    Jul 29, 2012 at 8:07 am
  • (Moved to hackers.) I have emailed the author asking for a copy. Does anyone have a recently downloaded copy of diskchecker.pl? -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB ...
    Bruce MomjianBruce Momjian
    Jul 27, 2012 at 12:35 am
    Jul 27, 2012 at 1:26 am
  • Is there a reason to vacuum the pgbench_* tables after the indexes on them are built, rather than before? Since the indexes are on fresh tables, they can't have anything that needs to be cleaned. I ...
    Jeff JanesJeff Janes
    Jul 20, 2012 at 12:05 am
    Jul 23, 2012 at 6:45 pm
  • Hackers, I stumbled across an initialization of a BlockNumber with InvalidBuffer, which seems strange to me, as the values for "invalid" of the two types are different, see attached patch. In case ...
    Markus WannerMarkus Wanner
    Jul 10, 2012 at 1:12 pm
    Jul 13, 2012 at 3:38 pm
  • Hi, waitpid() is used with "#ifdef HAVE_WAITPID" in reaper(), but NOT in BaseBackup(). Why not? We can ensure that all platforms which PostgreSQL supports have waitpid()? If so, can we get rid of ...
    Fujii MasaoFujii Masao
    Jul 4, 2012 at 4:59 pm
    Jul 5, 2012 at 6:12 pm
Jul 2012
12
Group Navigation
period‹ prev | Jul 2012 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions97
posts1,125
users114
websitepostgresql.org...
irc#postgresql

114 users for July 2012

Tom Lane: 181 posts Robert Haas: 134 posts Bruce Momjian: 55 posts Alvaro Herrera: 45 posts Peter Eisentraut: 40 posts Magnus Hagander: 34 posts Pavel Stehule: 33 posts Andrew Dunstan: 31 posts Dimitri Fontaine: 26 posts Amit Kapila: 23 posts Joel Jacobson: 23 posts Merlin Moncure: 23 posts Heikki Linnakangas: 22 posts Peter Geoghegan: 20 posts Andres Freund: 19 posts Fujii Masao: 17 posts Kohei KaiGai: 16 posts Marko Kreen: 16 posts Alexander Korotkov: 15 posts Daniel Farina: 15 posts
show more
Archives