FAQ

PostgreSQL > pgsql-hackers > July 2013

Search Discussions

157 discussions - 1,772 posts

  • There seems to be a consensus that we should try to get rid of SnapshotNow entirely now that we have MVCC catalog scans, so I'm attaching two patches that together come close to achieving that goal ...
    Robert HaasRobert Haas
    Jul 18, 2013 at 12:46 pm
    Jul 26, 2013 at 5:45 pm
  • Hi, guys! I made a quick patch to support floating number in connect_timeout param for libpq. This will treat floating number as seconds so this is backwards-compatible. I don't usually write in C, ...
    Ivan babrouIvan babrou
    Jul 5, 2013 at 5:29 pm
    Jul 15, 2013 at 12:41 pm
  • Buildfarm member anchovy has been failing for the last couple of days, evidently because its owner just couldn't wait to adopt bison 3.0, which is all of 3 days old. The failures look like ...
    Tom LaneTom Lane
    Jul 29, 2013 at 5:05 am
    Jul 30, 2013 at 1:45 am
  • Hi, I reviewed Dimitri's work on extension templates [2]. There's some discussion still ongoing and the patch has gone through several revisions since its addition to the current CF. The patch has ...
    Markus WannerMarkus Wanner
    Jul 5, 2013 at 7:07 pm
    Jul 13, 2013 at 10:10 am
  • Hi, let me elaborate on an idea I had to streamline extension templates. As I wrote in my recent review [1], I didn't have the mental model of a template in mind for extensions, so far. However, ...
    Markus WannerMarkus Wanner
    Jul 5, 2013 at 8:28 pm
    Jul 23, 2013 at 11:02 am
  • Hello all I very often use a little bit adjusted psql system queries to detection TOP N sized tables. I am thinking so it can be useful for all users I propose a few new commands \dts [N|size] .. ...
    Pavel StehulePavel Stehule
    Jul 21, 2013 at 4:48 am
    Jul 23, 2013 at 12:43 pm
  • Recently I've been dismissing a lot of suggested changes to checkpoint fsync timing without suggesting an alternative. I have a simple one in mind that captures the biggest problem I see: that the ...
    Greg SmithGreg Smith
    Jul 23, 2013 at 3:48 am
    Jul 29, 2013 at 6:00 am
  • The spec defines two types of aggregate function classed as "ordered set function", as follows: 1. An "inverse distribution function" taking one argument (which must be a grouped column or otherwise ...
    Andrew GierthAndrew Gierth
    Jul 18, 2013 at 3:15 am
    Jul 27, 2013 at 11:03 pm
  • Hello, I happened to find a trivial bug of ECPG while experimenting with 9.3 beta 2. Please find attached the patch to fix this. This is not specific to 9.3. Could you commit and backport this? [Bug ...
    MauMauMauMau
    Jul 3, 2013 at 10:22 am
    Jul 6, 2013 at 8:15 pm
  • Hi all, I was reading about the plans to add functionality to the planner to remove redundant inner joins where there is no member of the inner relation present in the target list and the inner ...
    Atri SharmaAtri Sharma
    Jul 9, 2013 at 6:20 am
    Jul 14, 2013 at 4:58 pm
  • Bug #8279 exhibits an intra-transaction memory leak in a plpgsql function that repeatedly traps an error. The cause of the leak is that the SPITupleTable created during exec_stmt_execsql is never ...
    Tom LaneTom Lane
    Jul 5, 2013 at 6:47 pm
    Jul 25, 2013 at 8:48 pm
  • Hi, I am a newbie to PostgreSQL and was wondering about the following behaviour. SELECT true WHERE 1 = '1'; <-- Returns true SELECT true WHERE 1 BETWEEN '0' and '2'; <-- Returns true SELECT true ...
    Prabakaran, VaishnaviPrabakaran, Vaishnavi
    Jul 9, 2013 at 10:53 pm
    Jul 19, 2013 at 2:35 am
  • I note that git.postgresql.org's robot.txt refuses permission to crawl the git repository: http://git.postgresql.org/robots.txt User-agent: * Disallow: / I'm curious what motivates this. It's ...
    Greg StarkGreg Stark
    Jul 9, 2013 at 3:25 pm
    Jul 11, 2013 at 2:06 pm
  • Hi, I'm having a look at the SSL support code, because one of our customers reported it behaves unstably when the network is unreliable. I have yet to reproduce the exact problem they're having, but ...
    Alvaro HerreraAlvaro Herrera
    Jul 10, 2013 at 9:20 pm
    Jul 16, 2013 at 11:19 pm
  • When rebasing a patch that I'm working on, I occasionally forget to update the oid of any pg_proc.h entries I may have created. Of course this isn't a real problem; when I go to initdb, I immediately ...
    Peter GeogheganPeter Geoghegan
    Jul 9, 2013 at 1:25 am
    Jul 9, 2013 at 6:22 pm
  • Hi hackers, I tried to improve performance when database is Chinese. Under openSUSE, create index on table with 54996 rows locale=C, 140ms locale=zh_CN, 985ms I think the function strcoll() of Linux ...
    Quan ZongliangQuan Zongliang
    Jul 22, 2013 at 4:17 am
    Jul 28, 2013 at 9:40 am
  • Hackers, We've seen this before: http://www.postgresql.org/message-id/b42b73150906271019k6212ba71u6263bc43a8ec8e94@mail.gmail.com I've run across this again, and am posting it here just in case ...
    Josh BerkusJosh Berkus
    Jul 17, 2013 at 6:50 pm
    Jul 18, 2013 at 2:13 pm
  • The buildfarm members that use -DCLOBBER_CACHE_ALWAYS say this patch is broken. regards, tom lane
    Tom LaneTom Lane
    Jul 17, 2013 at 2:11 pm
    Jul 31, 2013 at 1:39 am
  • So I went off to implement the SPITupleTable tracking discussed in <<span class="m_body_email_addr" title="5476ad28089af6b4d53e2a47f395f09e" 6553.1374424838@sss.pgh.pa.us</span , and thought it would ...
    Tom LaneTom Lane
    Jul 24, 2013 at 3:26 pm
    Jul 24, 2013 at 9:50 pm
  • Hello, I've encountered a bug of PITR that corrupts the database. I'm willing to submit the patch to fix it, but I'm wondering what approach is appropriate. Could you give me your opinions? [Problem] ...
    MauMauMauMau
    Jul 24, 2013 at 10:28 am
    Jul 24, 2013 at 3:11 pm
  • Jeff Janes asked me about this, and Bruce just tripped up on it. Usually on Windows it's necessary to have libpq.dll/cygpq.dll either in the PATH or in the same directory as client .exe files. The ...
    Andrew DunstanAndrew Dunstan
    Jul 25, 2013 at 8:53 pm
    Jul 30, 2013 at 10:32 pm
  • Hello, While understanding the effect of maintenance_work_mem on time taken by CREATE INDEX, I observed that for the values of maintenance_work_mem less than the value for which an internal sort is ...
    Amit LangoteAmit Langote
    Jul 23, 2013 at 4:11 am
    Jul 30, 2013 at 12:29 am
  • The dynamic background workers patch that I submitted for CF1 was generally well-received, but several people commented on a significant limitation: there's currently no way for a backend that ...
    Robert HaasRobert Haas
    Jul 24, 2013 at 4:46 pm
    Jul 26, 2013 at 12:50 pm
  • Hello, While doing some tests, I observed that expression indexes can malfunction if the underlying expression changes. For example, say I define a function foo() as: CREATE OR REPLACE FUNCTION foo(a ...
    Pavan DeolaseePavan Deolasee
    Jul 22, 2013 at 6:29 pm
    Jul 26, 2013 at 3:12 am
  • ... well, 11 actually. We are down to 3 patches needing review, 2 waiting on author, and 6 waiting on commit. Whatever folks can do to close out this commitfest is very welcome! -- Josh Berkus ...
    Josh BerkusJosh Berkus
    Jul 21, 2013 at 6:04 am
    Jul 23, 2013 at 2:35 pm
  • Assorted buildfarm members don't like this patch. regards, tom lane
    Tom LaneTom Lane
    Jul 6, 2013 at 5:39 am
    Jul 7, 2013 at 10:17 pm
  • Hi, I was going through the archives and there was a discussion about using ini file to setup replication.(http://www.postgresql.org/message-id/4C9876B4.9020803@enterprisedb.com). I think if we work ...
    Samrat RevagadeSamrat Revagade
    Jul 19, 2013 at 9:24 am
    Jul 23, 2013 at 7:54 am
  • A third party application we use generates SQL queries. Here is query it generated that broke today and for which I have a hard time arguing that the postgres behavior is correct (minimally the error ...
    Benedikt GrundmannBenedikt Grundmann
    Jul 12, 2013 at 1:49 pm
    Jul 13, 2013 at 1:18 am
  • Hey All, This patch request grew from this post (of mine) to pgsql-general: http://www.postgresql.org/message-id/CABUevEzouAe-g1_OejaGujjMem675DNYStwyBp4d_Wz6Om+fxA@mail.gmail.com The patch adds ...
    James SewellJames Sewell
    Jul 2, 2013 at 4:20 am
    Jul 9, 2013 at 8:11 am
  • Hello In 9.3 super user can cancel all queries or user can cancel own sessions. Is possible enhance this possibility to database owners? So owner can cancel or can terminate sessions related to owned ...
    Pavel StehulePavel Stehule
    Jul 29, 2013 at 9:26 am
    Jul 30, 2013 at 1:59 pm
  • depesz, moved to -hackers.. * hubert depesz lubaczewski (<span class="m_body_email_addr" title="d5ecebb85919589a7cbf7f90eb34eacf" depesz@depesz.com</span ) wrote: I think you're half-right, the check ...
    Stephen FrostStephen Frost
    Jul 29, 2013 at 11:43 pm
    Jul 30, 2013 at 10:47 am
  • Hi, Now I'm seeing xlog.c in 93_stable for studying "fast promote", and I have a question. I think it has an extra unlink command for "promote" file. (on 9937 line) ------- 9934 if ...
    Tomonari KatsumataTomonari Katsumata
    Jul 25, 2013 at 8:34 am
    Jul 29, 2013 at 6:14 pm
  • Historically, REINDEX would always revalidate any uniqueness enforced by the index. An EDB customer reported that this is not happening, and indeed I broke it way back in commit ...
    Noah MischNoah Misch
    Jul 21, 2013 at 5:28 pm
    Jul 23, 2013 at 3:25 am
  • Hi masters of PostgreSQL, I recently got asked about possibility of listening to notifications on warm standby. So question, how hard would that be to implement ? Is it even possible without major ...
    Greg JaskiewiczGreg Jaskiewicz
    Jul 10, 2013 at 8:03 am
    Jul 17, 2013 at 6:48 pm
  • Hello, I'm sorry I've been touching several things recently before fixing any of them. I've noticed undesirable disk space increase while performing archive recovery with PostgreSQL 9.3. This happens ...
    MauMauMauMau
    Jul 27, 2013 at 10:57 pm
    Jul 31, 2013 at 10:36 pm
  • Hi, Yesterday an interesting scenario was diagnosed on IRC. If you're running a synchronous slave and the connection to the slave is lost momentarily, your backends start naturally waiting for the ...
    Marko TiikkajaMarko Tiikkaja
    Jul 28, 2013 at 12:24 am
    Jul 28, 2013 at 6:50 pm
  • Hi, I've been trying to diagnose a severe performance regression we've been having in one of our plpgsql procedures. The example below is of course extremely simplified, and obviously not what we are ...
    Marc CousinMarc Cousin
    Jul 23, 2013 at 10:01 am
    Jul 24, 2013 at 9:04 am
  • I have noticed that some people post examples using make --silent (-s). I found this actually kind of neat to use from time to time, because then you only see output if you have warnings or errors ...
    Peter EisentrautPeter Eisentraut
    Jul 23, 2013 at 12:38 pm
    Jul 23, 2013 at 1:43 pm
  • hi, list, again. the next proposal into auto explain. one would be happy if could set list of target tables and indexes. sometimes it is very hard to detect who is using your indexes. but turn total ...
    Миша ТюринМиша Тюрин
    Jul 21, 2013 at 2:42 pm
    Jul 23, 2013 at 5:19 am
  • Yeah, sorry, I probably should have mentioned that. The structure needs to be fixed size for us to store it in shared memory. I think that would be a good idea. And I'd also propose getting rid of ...
    Robert HaasRobert Haas
    Jul 19, 2013 at 12:23 pm
    Jul 22, 2013 at 7:50 pm
  • Hi Fabien, I have looked into this: https://commitfest.postgresql.org/action/patch_view?id=1105 because it's marked as "Ready for committer". However I noticed that you worried about other pgbench ...
    Tatsuo IshiiTatsuo Ishii
    Jul 10, 2013 at 1:20 am
    Jul 18, 2013 at 1:46 am
  • Commit 9a20a9b2 breaks the build for me, using gcc on HPPA: xlog.c:2182: macro `pg_memory_barrier' used without args xlog.c:2546: macro `pg_memory_barrier' used without args make[4]: *** [xlog.o] ...
    Tom LaneTom Lane
    Jul 15, 2013 at 12:41 am
    Jul 17, 2013 at 10:33 pm
  • Hi I want to know how an index is created and used. actually if you can show to me a simple start point, it would be great. Regards, Soroosh Sardari
    Soroosh SardariSoroosh Sardari
    Jul 16, 2013 at 11:35 am
    Jul 17, 2013 at 5:27 am
  • Consider this sequence of commands: create type rowtype as (c int, d int); create temp table t of rowtype; \c - drop type rowtype cascade; Since the switch to MVCC catalog scans, it exhibits the ...
    Noah MischNoah Misch
    Jul 16, 2013 at 1:50 pm
    Jul 17, 2013 at 12:30 am
  • Reviewer, Testers: As part of an ongoing effort to encourage patch review for the PostgreSQL project, we will be funding cloud servers for patch reviewers and testers who need them for CommitFests ...
    Josh BerkusJosh Berkus
    Jul 9, 2013 at 12:35 am
    Jul 9, 2013 at 5:16 pm
  • Hello, the purpose of this patch is to limit impact of pg_backup on running server. Feedback is appreciated. // Antonin Houska (Tony)
    Antonin HouskaAntonin Houska
    Jul 24, 2013 at 7:21 am
    Jul 31, 2013 at 8:50 pm
  • Hi All, When the slave server starts, the slave server perform the following steps in StartupXLOG(): 1. Read latest CheckPoint record LSN from pg_control file. 2. Try to fetch CheckPoint record from ...
    Sawada MasahikoSawada Masahiko
    Jul 26, 2013 at 4:19 am
    Jul 26, 2013 at 3:51 pm
  • Attached is a small patch that should fix the problem. Vik
    Vik FearingVik Fearing
    Jul 24, 2013 at 2:04 pm
    Jul 24, 2013 at 6:42 pm
  • Hi all, I haven't given this a lot of thought, but it struck me that when rebuilding tables (be it for a restore process, or some other operational activity) - there is more often than not a need to ...
    Tim KaneTim Kane
    Jul 23, 2013 at 12:06 pm
    Jul 24, 2013 at 1:22 pm
  • hi, list. there are my proposal. i would like to tell about odirect in wal sync in wal_level is higher than minimal. i think in my case when wal traffic is up to 1gb per 2-3 minutes but discs ...
    Миша ТюринМиша Тюрин
    Jul 21, 2013 at 2:01 pm
    Jul 22, 2013 at 2:40 pm
Jul 2013
1234
Group Navigation
period‹ prev | Jul 2013 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions157
posts1,772
users159
websitepostgresql.org...
irc#postgresql

159 users for July 2013

Robert Haas: 146 posts Tom Lane: 134 posts Andres Freund: 108 posts Joshua Berkus: 104 posts Alvaro Herrera: 64 posts Greg Smith: 53 posts Pavel Stehule: 52 posts Peter Eisentraut: 49 posts Amit Kapila: 48 posts Andrew Dunstan: 45 posts Fabien COELHO: 37 posts Noah Misch: 36 posts David Fetter: 31 posts Michael Paquier: 28 posts Greg Stark: 27 posts Bruce Momjian: 26 posts Markus Wanner: 26 posts Tatsuo Ishii: 26 posts Dimitri Fontaine: 25 posts Stephen Frost: 25 posts
show more
Archives