FAQ

Search Discussions

143 discussions - 1,555 posts

  • Pertinent to another thread titled [HACKERS] corrupt pages detected by enabling checksums I hope to explore the possibility of using fallocate (or posix_fallocate) for new WAL file creation. Most ...
    Jon NelsonJon Nelson
    May 14, 2013 at 1:55 am
    Jul 5, 2013 at 6:27 pm
  • Minor changes wrt to the previous submission, so as to avoid running some stuff twice under some conditions. This is for reference to the next commit fest. -- Fabien.
    Fabien COELHOFabien COELHO
    May 2, 2013 at 12:09 pm
    Jul 22, 2013 at 11:52 pm
  • Hi, I am studying your levenshtein edit distance contribution in Postgresql. Can we add Levenshtein-Damerau edit distance since it is used in spelling checker instead of levenshtein edit distance? ...
    Liming HuLiming Hu
    May 17, 2013 at 12:41 am
    Jul 4, 2013 at 3:51 pm
  • There are a number of changes we'd probably like to make to the way things work in Postgres. This thread is not about discussing what those are, just to say that requirements exist and have been ...
    Simon RiggsSimon Riggs
    May 25, 2013 at 9:39 am
    May 29, 2013 at 6:04 am
  • Hello, I'm student who want to participate in Google Summer of Code. I want to implement feature which allows to get old values directly from update statement. I mean there should be possibility to ...
    Karol TrzcionkaKarol Trzcionka
    May 2, 2013 at 9:04 am
    Jul 31, 2013 at 7:43 pm
  • Hi list, While testing out PostgreSQL 9.3beta1, I stumbled upon a problem installing some extensions (pgTAP and semver among others): % make [...] % make DESTDIR=/tmp/foo install [...] ...
    Marti RaudseppMarti Raudsepp
    May 14, 2013 at 1:13 am
    Jun 2, 2013 at 1:53 pm
  • Folks, There's currently some great ideas bouncing around about eliminating the overhead associated with FREEZE. However, I wanted to take a step back and take a look at the big picture for VACUUM, ...
    Josh BerkusJosh Berkus
    May 30, 2013 at 6:48 pm
    Jun 19, 2013 at 3:21 am
  • We've had a number of discussions about the evils of SnapshotNow. As far as I can tell, nobody likes it and everybody wants it gone, but there is concern about the performance impact. I decided to do ...
    Robert HaasRobert Haas
    May 22, 2013 at 2:18 am
    Jul 6, 2013 at 1:07 pm
  • Hi, I have a question regarding the memory consumption per process in PostgreSQL 9.2 Does each PostgreSQL process allocating in its own memory (Not shared memory) a cache of all the database catalog ...
    Ben Zeev, LiorBen Zeev, Lior
    May 27, 2013 at 8:11 am
    Jun 4, 2013 at 1:25 pm
  • Patch to allow pg_dump to use a snapshot exported with an explicit pg_export_snapshot() for when precise timing of the snapshot is important. This overrides the internally generated snapshot in ...
    Simon RiggsSimon Riggs
    May 6, 2013 at 2:56 pm
    May 7, 2013 at 7:03 pm
  • Andres FreundAndres Freund
    May 30, 2013 at 11:42 am
    Jul 2, 2013 at 5:40 pm
  • As discussed and concluded in mail thread (http://www.postgresql.org/message-id/006f01ce34f0$d6fa8220$84ef8660$@kapila @huawei.com), for moving unused buffer's to freelist end, I having implemented ...
    Amit KapilaAmit Kapila
    May 14, 2013 at 1:45 pm
    Jul 3, 2013 at 1:17 pm
  • Since we're bashing around ideas around freezing, let me write down the idea I've been pondering and discussing with various people for years. I don't think I invented this myself, apologies to ...
    Heikki LinnakangasHeikki Linnakangas
    May 30, 2013 at 1:34 pm
    Jun 10, 2013 at 10:10 pm
  • It would be great if one client session could take advantage of multiple CPU cores. EnterpriseDB wishes to start the trek into this problem space for 9.4 by implementing parallel internal (i.e. not ...
    Noah MischNoah Misch
    May 13, 2013 at 2:29 pm
    May 27, 2013 at 12:59 am
  • Hello, When client authentication method is set to "pam" in pg_hba.conf, connecting using psql results in logging of authentication failure even before a password prompt is provided, nonetheless user ...
    Amit LangoteAmit Langote
    May 9, 2013 at 2:40 am
    May 29, 2013 at 12:12 am
  • [ Moved to hackers ] OK, that is odd. We preserve old/new OIDs, (not relfilenode, as someone suggested in this thread); FYI: * FYI, while pg_class.oid and pg_class.relfilenode are initially the same ...
    Bruce MomjianBruce Momjian
    May 8, 2013 at 9:35 pm
    May 13, 2013 at 4:58 pm
  • I'm working on a new project here that I wanted to announce, just to keep from duplicating effort in this area. I've started to add a cost limit delay for regular statements. The idea is that you set ...
    Greg SmithGreg Smith
    May 23, 2013 at 11:28 pm
    Jun 10, 2013 at 9:43 pm
  • Hi, I've been hacking on a tool to allow resynchronizing an old master server after failover. The need to do a full backup/restore has been a common complaint ever since we've had streaming ...
    Heikki LinnakangasHeikki Linnakangas
    May 23, 2013 at 11:10 am
    Jun 5, 2013 at 5:47 pm
  • Hello devs, I've given a try to the PostgreSQL documentation in epub format. I must admit that there is a bit of a disappointement as far as the user experience is concerned: the generated file is ...
    Fabien COELHOFabien COELHO
    May 1, 2013 at 4:28 pm
    May 4, 2013 at 6:59 am
  • Hi all, I working in a patch to include support of "IF NOT EXISTS" into "CREATE" statements that not have it yet. I started with "DefineStmt" section from "src/backend/parser/gram.y": - CREATE ...
    Fabrízio de Royes MelloFabrízio de Royes Mello
    May 24, 2013 at 3:22 pm
    Jul 27, 2013 at 4:00 am
  • Hi, Please find attached a patch to take code-coverage of DBCommands (CREATE DATABASE / ALTER DATABASE / DROP DATABASE) from 36% to 71%. Any and all feedback is obviously welcome. -- Robins Tharakan
    Robins TharakanRobins Tharakan
    May 12, 2013 at 11:35 pm
    Jul 15, 2013 at 3:01 pm
  • Hi, after having discussed $subject shortly over dinner yesterday, while I should have been preparing the slides for my talk I noticed that there might be a rather easy way to get rid of freezing. I ...
    Andres FreundAndres Freund
    May 23, 2013 at 5:51 pm
    Jun 1, 2013 at 5:56 pm
  • Hi, I've got a patch. This is for a plpython enhancement. There is an item at the TODO list http://wiki.postgresql.org/wiki/Todo#Server-Side_Languages "Fix loss of information during conversion of ...
    Szymon GuzSzymon Guz
    May 28, 2013 at 8:41 pm
    Jul 6, 2013 at 6:10 pm
  • Continuation of: http://www.postgresql.org/message-id/1353551097.11440.128.camel@sussancws0025 Rebased patch attached; no other changes. First of all, I'd like to take a step back and describe the ...
    Jeff DavisJeff Davis
    May 30, 2013 at 3:55 am
    Jul 19, 2013 at 12:29 pm
  • I can check for the presence of $PGDATA/backup_label in order to detect a backup in progress (i.e. pg_start_backup() has been run and pg_stop_backup() has not yet been run). However there is a period ...
    Joe ConwayJoe Conway
    May 31, 2013 at 5:39 pm
    Jun 1, 2013 at 6:11 pm
  • While testing the bug from the "Assertion failure at standby promotion", I bumped into a different bug in fast promotion. When the first checkpoint after fast promotion is performed, there is no ...
    Heikki LinnakangasHeikki Linnakangas
    May 7, 2013 at 9:57 am
    May 21, 2013 at 8:33 pm
  • In surveying the literature on $subject, I find that most of the theoretical work related to how to incrementally update materialized views based on the matview declaration was published between 1988 ...
    Kevin GrittnerKevin Grittner
    May 14, 2013 at 7:52 pm
    May 17, 2013 at 9:53 pm
  • Today we have seen this on our testing database instance: ERROR: could not open file "base/16416/291498116.3" (target block 431006): No such file or directory That database get's created by rsyncing ...
    Benedikt GrundmannBenedikt Grundmann
    May 14, 2013 at 11:59 am
    May 29, 2013 at 9:01 pm
  • All, Starting a new thread to avoid hijacking Heikki's original, but.. * Heikki Linnakangas (<span class="m_body_email_addr" title="1b6a141eeacd80f7f8ee56d3d1a4923e" hlinnakangas@vmware.com</span ) ...
    Stephen FrostStephen Frost
    May 16, 2013 at 12:54 am
    May 28, 2013 at 4:44 pm
  • This is mostly for reference to the next commitfest. This very minor patch adds a corresponding long option to all short (one letter) options of pgbench. In particular for connection options there is ...
    Fabien COELHOFabien COELHO
    May 2, 2013 at 5:59 pm
    Jun 27, 2013 at 6:14 pm
  • Do we want to run pgindent soon? -- Bruce Momjian <<span class="m_body_email_addr" title="ecaa579ddbd27537b4ac50a26f1814a9" bruce@momjian.us</span http://momjian.us EnterpriseDB ...
    Bruce MomjianBruce Momjian
    May 22, 2013 at 5:52 pm
    Jun 3, 2013 at 3:11 pm
  • I don't see how that makes Josh's proposal any simpler. His proposal was to change, in a backward-incompatible fashion, the contents of the visibility map. Getting rid of PD_ALL_VISIBLE will not ...
    Robert HaasRobert Haas
    May 30, 2013 at 2:47 am
    Jun 1, 2013 at 3:30 am
  • Hi all, I was searching for an existing mechanism which ensures that a crashed process releases a content lock held on a page in buffer cache. Also, a similar mechanism for refcount of the page. I ...
    Atri SharmaAtri Sharma
    May 23, 2013 at 10:04 am
    May 23, 2013 at 3:50 pm
  • I've been working on-and-off on the WAL-insert scaling patch. It's in pretty good shape now, and I'll post it shortly, but one thing I noticed is that it benefits a lot from using an atomic ...
    Heikki LinnakangasHeikki Linnakangas
    May 13, 2013 at 12:50 pm
    May 20, 2013 at 9:20 pm
  • Various people, including at least Heikki, Andres, and myself, have proposed various schemes for avoiding freezing that amount to doing it sooner, when we're already writing WAL anyway, or at least ...
    Robert HaasRobert Haas
    May 28, 2013 at 1:21 pm
    Jul 8, 2013 at 8:38 pm
  • Add --throttle to pgbench Each client is throttled to the specified rate, which can be expressed in tps or in time (s, ms, us). Throttling is achieved by scheduling transactions along a ...
    Fabien COELHOFabien COELHO
    May 1, 2013 at 8:57 am
    Jun 19, 2013 at 8:18 pm
  • Truncating a heap at the end of vacuum, to release unused space back to the OS, currently requires taking an AccessExclusiveLock. Although it's only held for a short duration, it can be enough to ...
    Heikki LinnakangasHeikki Linnakangas
    May 15, 2013 at 3:35 pm
    May 23, 2013 at 12:22 pm
  • Please find attached a small patch submission, for reference to the next commit fest. Each thread reports its progress about every the number of seconds specified with the option. May be particularly ...
    Fabien COELHOFabien COELHO
    May 2, 2013 at 12:05 pm
    Jul 1, 2013 at 11:25 am
  • Hi all I know this topic was discussed before, but there doesn't seem to be any conclusion. The lack of unsigned integer types is one of the biggest sources of grief in my daily work with pgsql ...
    Maciej GajewskiMaciej Gajewski
    May 27, 2013 at 1:15 pm
    May 31, 2013 at 8:18 pm
  • In the last two years, the first commit fest started in June, which is about a month from now. If we are going to do that again, we should clarify that as soon as possible. And if we are not, then we ...
    Peter EisentrautPeter Eisentraut
    May 14, 2013 at 2:34 am
    May 29, 2013 at 12:07 am
  • Hi, Please find attached a patch to take code-coverage of CREATE OPERATOR (src/backend/commands/operatorcmds.c) from 56% to 91%. Any and all feedback is welcome. -- Robins Tharakan
    Robins TharakanRobins Tharakan
    May 22, 2013 at 10:35 pm
    Jul 1, 2013 at 9:53 pm
  • A PostgreSQL user recently reported on pgsql-admin about an issue: when he changed wal_level from 'minimal' to 'hot_standby', the WAL segment sequence rewound, that is, it started using old names. A ...
    Amit LangoteAmit Langote
    May 23, 2013 at 1:10 am
    May 24, 2013 at 6:50 pm
  • Hello, as a continuation of my proposal expanding RETURNING syntax by AFTER/BEFORE, there can be enough time to implement RETURNING for COPY. I'd like to hear your opinion on that. My draft idea is ...
    Karol TrzcionkaKarol Trzcionka
    May 8, 2013 at 3:50 pm
    May 8, 2013 at 7:44 pm
  • Not sure if I mentioned this, but having first line of the commit be a subject has save me lots of time in writing the release notes. I know it is helpful to others too who browse our commits on ...
    Bruce MomjianBruce Momjian
    May 3, 2013 at 5:23 pm
    May 6, 2013 at 7:09 pm
  • A memory chunk allocated through the existing palloc.h interfaces is limited to MaxAllocSize (~1 GiB). This is best for most callers; SET_VARSIZE() need not check its own 1 GiB limit, and algorithms ...
    Noah MischNoah Misch
    May 13, 2013 at 2:27 pm
    Jul 6, 2013 at 4:54 pm
  • [ moved to hacker ] Wow, I never realized other tools used -U for user, instead of -u. Should I change pg_upgrade to use -U for 9.4? I can keep supporting -u as an undocumented option. I have applied ...
    Bruce MomjianBruce Momjian
    May 29, 2013 at 2:55 am
    Jun 29, 2013 at 1:34 pm
  • I worked up a small patch to support Terabyte setting for memory. Which is OK, but it only works for 1TB, not for 2TB or above. Which highlights that since we measure things in kB, we have an ...
    Simon RiggsSimon Riggs
    May 21, 2013 at 9:14 pm
    Jun 19, 2013 at 11:18 pm
  • The documentation says of continuous archiving: "While designing your archiving setup, consider what will happen if the archive command fails repeatedly because some aspect requires operator ...
    Peter GeogheganPeter Geoghegan
    May 13, 2013 at 10:02 pm
    May 17, 2013 at 7:12 am
  • Tom has refactored where and how certain parts of the work get done for materialized views, reducing issues with modularity violations. I have been and will continue to review his changes to better ...
    Kevin GrittnerKevin Grittner
    May 2, 2013 at 10:00 pm
    May 6, 2013 at 3:19 pm
  • When Postgres encounters a long list of AND/OR chains, it errors out at check_stack_depth() after a limit of few thousand. At around 10,000 elements, the recursion at assign_expr_collations() causes ...
    Gurjeet SinghGurjeet Singh
    May 25, 2013 at 1:57 pm
    Jun 16, 2013 at 1:36 pm
Group Navigation
period‹ prev | May 2013 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions143
posts1,555
users136
websitepostgresql.org...
irc#postgresql

136 users for May 2013

Tom Lane: 106 posts Robert Haas: 105 posts Bruce Momjian: 102 posts Andres Freund: 93 posts Heikki Linnakangas: 76 posts Simon Riggs: 60 posts Stephen Frost: 59 posts Amit Langote: 44 posts Atri Sharma: 41 posts Josh Berkus: 40 posts Alvaro Herrera: 34 posts Fabien COELHO: 33 posts Peter Eisentraut: 33 posts Amit Kapila: 31 posts Andrew Dunstan: 27 posts Kevin Grittner: 26 posts Craig Ringer: 22 posts Pavel Stehule: 21 posts Dimitri Fontaine: 20 posts Greg Stark: 20 posts
show more
Archives