Search Discussions

136 discussions - 1,850 posts

  • Hi everyone, This mail contains the highlevel design description of how our prototype of in-core logical replication works. The individual patches will be posted as replies to this email. I obviously ...
    Andres FreundAndres Freund
    Jun 13, 2012 at 11:27 am
    Jul 3, 2012 at 3:02 pm
  • Hi, There was already some discussion about compressing libpq data [1][2][3]. Recently, I faced a scenario that would become less problematic if we have had compression support. The scenario is ...
    Euler TaveiraEuler Taveira
    Jun 14, 2012 at 4:37 am
    Aug 30, 2012 at 9:42 pm
  • Robert, all: Last I checked, we had a reasonably acceptable patch to use mostly Posix Shared mem with a very small sysv ram partition. Is there anything keeping this from going into 9.3? It would ...
    Josh BerkusJosh Berkus
    Jun 26, 2012 at 7:50 pm
    Jul 4, 2012 at 7:58 pm
  • Hi, This is v12 of the foreign key locks patch. I gave a talk about this patch at PGCon: http://www.pgcon.org/2012/schedule/events/483.en.html There is an article there that explains this patch. I ...
    Alvaro HerreraAlvaro Herrera
    Jun 14, 2012 at 4:42 pm
    Jan 11, 2013 at 4:31 pm
  • Hi, Allow me to open the new season of the DML trigger series, named pg_event_trigger. This first episode is all about setting up the drama, so that next ones make perfect sense. The attached patch ...
    Dimitri FontaineDimitri Fontaine
    Jun 15, 2012 at 8:28 pm
    Aug 30, 2012 at 3:18 pm
  • Hi, before I ask the main question, just a little background for one issue we're currently having in Fedora 17: PrivateTmp is a systemd's feature, which allows to have private /tmp directory for ...
    Honza HorakHonza Horak
    Jun 6, 2012 at 1:51 pm
    Aug 10, 2012 at 10:17 pm
  • I am planning to work on the below Todo list item for this CommitFest Allow WAL information to recover corrupted pg_controldata http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php I ...
    Amit KapilaAmit Kapila
    Jun 14, 2012 at 3:40 pm
    Nov 16, 2012 at 11:23 am
  • The row-processor API is now in 9.2, but it solves only the "different-row-storage" problem, but not the "one-row-at-a-time" problem, as libpq is still in control until all rows are received. This ...
    Marko KreenMarko Kreen
    Jun 15, 2012 at 6:22 pm
    Aug 2, 2012 at 9:44 pm
  • Hi, To recapitulate why I think this sort of embedded list is worthwile: * minimal memory overhead (16 bytes for double linked list heads/nodes on 64bit systems) * no additional memory allocation ...
    Andres FreundAndres Freund
    Jun 26, 2012 at 11:26 pm
    Oct 18, 2012 at 8:56 pm
  • The attached patch provides bare row-level security feature. Table's owner can set its own security policy using the following syntax: ALTER TABLE <table SET ROW LEVEL SECURITY (<condition ); ALTER ...
    Kohei KaiGaiKohei KaiGai
    Jun 14, 2012 at 3:43 pm
    Dec 3, 2012 at 5:03 pm
  • Hi, I am currently trying to understand what looks like really bad scalability of 9.1.3 on a 64core 512GB RAM system: the system runs OK when at 30% usr, but only marginal amounts of additional load ...
    Nils GorollNils Goroll
    Jun 26, 2012 at 5:02 pm
    Aug 6, 2012 at 10:10 pm
  • Hi Robert, Hi all, Robert and I talked quite a bit about different methods of providing enough information to extract tuples from wal. I don't think either of us is yet really convinced of any ...
    Andres FreundAndres Freund
    Jun 21, 2012 at 11:41 am
    Jun 27, 2012 at 2:11 am
  • Hackers, attached patch implements quad-tree on ranges. Some performance results in comparison with current GiST indexing. Index creation is slightly slower. Probably, it need some investigation ...
    Alexander KorotkovAlexander Korotkov
    Jun 13, 2012 at 10:57 pm
    Dec 17, 2012 at 10:42 am
  • Hackers, Very interesting design document for SQLite 4: http://www.sqlite.org/src4/doc/trunk/www/design.wiki I'm particularly intrigued by "covering indexes". For example: CREATE INDEX cover1 ON ...
    David E. WheelerDavid E. Wheeler
    Jun 28, 2012 at 12:17 pm
    Aug 25, 2012 at 7:53 am
  • As I threatened earlier (http://archives.postgresql.org/message-id/4FD0B1AB.3090405@enterprisedb.com), here are three patches that change the WAL format. The goal is to change the format so that when ...
    Heikki LinnakangasHeikki Linnakangas
    Jun 14, 2012 at 9:02 pm
    Jul 6, 2012 at 9:25 pm
  • Hi all, I've been working on a new system view, pg_stat_lwlocks, to observe LWLock, and just completed my 'proof-of-concept' code that can work with version 9.1. Now, I'd like to know the possibility ...
    Satoshi NagayasuSatoshi Nagayasu
    Jun 25, 2012 at 8:29 pm
    Oct 23, 2012 at 2:50 pm
  • In commit 18fb9d8d21a28caddb72c7ffbdd7b96d52ff9724, Simon modified the rule for when to skip checkpoints on the grounds that not enough activity has happened since the last one. However, that commit ...
    Tom LaneTom Lane
    Jun 6, 2012 at 7:09 pm
    Aug 30, 2012 at 7:10 pm
  • I'd like to propose pgsql_fdw, FDW for PostgreSQL, as a contrib module in core, again. This patch is basically rebased version of the patches proposed in 9.2 development cycle, and contains some ...
    Shigeru HANADAShigeru HANADA
    Jun 14, 2012 at 12:30 pm
    Jul 31, 2012 at 12:23 pm
  • Probably the most common issue we see from Windows users of PostgreSQL is confusion over the passwords the installer asks for during installation and upgrade. I'd like to try to reduce that, but am ...
    Dave PageDave Page
    Jun 12, 2012 at 12:09 pm
    Jun 16, 2012 at 4:36 am
  • Folks, Yeah, I can't believe I'm calling for *yet another* configuration variable either. Suggested workaround fixes very welcome. The basic issue is that autovacuum_max_workers is set by most users ...
    Josh BerkusJosh Berkus
    Jun 28, 2012 at 2:00 am
    Jul 1, 2012 at 10:06 pm
  • Introduction: ================================= A lot of progress has been made on the checksums issue, with Simon's excellent work beginning to gain consensus ...
    Jeff DavisJeff Davis
    Jun 5, 2012 at 1:26 am
    Jun 13, 2012 at 2:41 am
  • The attached patch makes postgres build with Visual Studio 2012 RC. As MS finally decided on the name I don't expect any need for changes for the final RTM. I didn't bother to update the docs for now ...
    Brar PieningBrar Piening
    Jun 2, 2012 at 9:26 pm
    Jan 1, 2013 at 2:54 am
  • When I worked on the XLogInsert scaling patch, it became apparent that some changes to the WAL format would make it a lot easier. So for 9.3, I'd like to do some refactoring: 1. Use a 64-bit integer ...
    Heikki LinnakangasHeikki Linnakangas
    Jun 7, 2012 at 1:51 pm
    Jun 13, 2012 at 3:16 am
  • OK, that was one generically bad thing about json.c's error messages. The other thing that was bothering me was the style of the errdetail strings, eg ereport(ERROR, ...
    Tom LaneTom Lane
    Jun 12, 2012 at 6:41 pm
    Jun 13, 2012 at 11:49 pm
  • I am pleased to announce that Kevin Grittner has accepted the core committee's invitation to become our newest committer. As you all know, Kevin's done a good deal of work on the project over the ...
    Tom LaneTom Lane
    Jun 7, 2012 at 10:15 pm
    Jun 12, 2012 at 12:57 pm
  • Hackers, While experimenting with gistchoose I achieve interesting results about relation of gistchoose behaviour and gist index bloat. I've created following testcase for reproducing gist index ...
    Alexander KorotkovAlexander Korotkov
    Jun 18, 2012 at 11:13 am
    Dec 14, 2012 at 6:12 pm
  • About the new --maintenance-db options: Why was this option not added to createuser and dropuser? In the original discussion[0] they were mentioned, but it apparently never made it into the code. I ...
    Peter EisentrautPeter Eisentraut
    Jun 23, 2012 at 10:27 pm
    Aug 23, 2012 at 1:36 pm
  • Hello I worked on simple patch, that enable access from server side to client side data. It add two new hooks to libpq - one for returning of local context, second for setting of local context. A ...
    Pavel StehulePavel Stehule
    Jun 26, 2012 at 5:07 am
    Jul 4, 2012 at 7:05 am
  • It has now happened at least twice that builds on spponbill started to fail after it failed during ECPGcheck: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=spoonbill&dt=2012-06-19%2023%3A00%3A04 ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Jun 22, 2012 at 6:16 pm
    Jun 24, 2012 at 4:14 pm
  • Maybe I am using it wrong but I get no error message when I use it. I have a type called chkpass (a version is in the additional supplied modules) and I create the equality operator like this: CREATE ...
    D'Arcy CainD'Arcy Cain
    Jun 21, 2012 at 3:47 pm
    Jun 23, 2012 at 2:17 pm
  • Hello pgdev, (Second attempt) I've conducted a statistical study about PostgreSQL use in OSS. One of the result is that quite a few projects have errors in their SQL setup scripts which lead to some ...
    Fabien COELHOFabien COELHO
    Jun 16, 2012 at 7:42 am
    Aug 30, 2012 at 9:43 pm
  • Hm, does this touch stuff that would also be modified by perltidy? I wonder if we should refrain from doing entab/detab on perl files and instead have perltidy touch such code. Perhaps the thing to ...
    Alvaro HerreraAlvaro Herrera
    Jun 11, 2012 at 12:55 am
    Jul 5, 2012 at 1:48 am
  • Hello list, I have been playing with the URI connection strings in the bleeding edge 9.2 and noticed an inconsistency with the old connection string behavior: $ psql 'host=/var/run/postgresql ...
    Daniel FarinaDaniel Farina
    Jun 6, 2012 at 1:26 am
    Jun 11, 2012 at 7:07 pm
  • I got this last night in a perfectly standard build of HEAD: *** /home/tgl/pgsql/src/test/regress/expected/sanity_check.out Thu Jan 12 14:06:14 2012 --- ...
    Tom LaneTom Lane
    Jun 5, 2012 at 1:32 pm
    Jun 7, 2012 at 4:50 pm
  • Hello, I have a problem with promoting from hot-standby that exclusive checkpointing retards completion of promotion. This checkpoint is "shutdown checkpoint" as a convention in realtion to TLI ...
    Jun 8, 2012 at 8:22 am
    Jan 6, 2013 at 9:58 pm
  • Right now, pg_receivexlog sets: replymsg- write = InvalidXLogRecPtr; replymsg- flush = InvalidXLogRecPtr; replymsg- apply = InvalidXLogRecPtr; when it sends it's status updates. I'm thinking it ...
    Magnus HaganderMagnus Hagander
    Jun 5, 2012 at 12:54 pm
    Jul 4, 2012 at 1:27 pm
  • As discussed in several different email threads here and on performance , when using pg_dump a on large number of objects, the server has a quadratic behavior in LockReassignCurrentOwner where it has ...
    Jeff JanesJeff Janes
    Jun 10, 2012 at 8:39 pm
    Jun 23, 2012 at 6:43 pm
  • I'm giving 9.2-beta2 a test simulating a production workflow. Everything looks OK except the speed. Most (all?) queries take about five to six times as long as they do with 9.1. The configurations ...
    James CloosJames Cloos
    Jun 17, 2012 at 10:53 pm
    Jun 20, 2012 at 10:12 pm
  • This patch is to provide support for fallback application name for contrib/pgbench, oid2name, and dblink. Currently I have done the implementation for pgbench. The implementation is same as in psql ...
    Amit kapilaAmit kapila
    Jun 8, 2012 at 5:20 pm
    Jul 4, 2012 at 7:41 pm
  • Folks, A co-worker filed a bug against file_fdw where the columns in a FOREIGN TABLE were scrambled on SELECT. It turned out that this comes from the (yes, it's documented, but since it's documented ...
    David FetterDavid Fetter
    Jun 20, 2012 at 3:03 pm
    Jun 20, 2012 at 7:23 pm
  • Hi, This patch splits htup.h in two pieces -- the first one (tupbasics.h; not wedded to the name) does not include many other headers and is just enough to have other parts of the code create tuples ...
    Alvaro HerreraAlvaro Herrera
    Jun 16, 2012 at 12:40 am
    Aug 30, 2012 at 9:03 pm
  • I'm on the fence. I was hoping somebody else would chime in with an opinion as well. I just realized this thread is on -admin. Moving it to -hackers so more of the right people will spot it. -- ...
    Magnus HaganderMagnus Hagander
    Jun 11, 2012 at 3:47 pm
    Jul 4, 2012 at 1:26 pm
  • ... The current TODO list is close to worthless and needs substantial pruning or even complete truncation. Or massive redesign. The above shows a recent attempt to fix one of the items on the TODO ...
    Simon RiggsSimon Riggs
    Jun 21, 2012 at 7:01 am
    Jul 3, 2012 at 3:48 pm
  • Regarding GLOBAL, the three comments so far have been along the same lines. But I assumed this was a 9.3 discussion. Because the current support for temporary tables is relatively similar to the ...
    Kevin GrittnerKevin Grittner
    Jun 9, 2012 at 5:09 pm
    Jun 13, 2012 at 10:37 pm
  • So, when are we thinking we might release 9.2.0? We've done a fall release the last two years, but it's not obvious to me that we have a whole lot of blockers left. In fact, the only blocker for ...
    Robert HaasRobert Haas
    Jun 11, 2012 at 3:09 pm
    Jun 12, 2012 at 10:13 pm
  • It seems that in implementing ginbuildempty(), I falsified the first "note" in the header comment for log_newpage(): * Note: all current callers build pages in private memory and write them * ...
    Robert HaasRobert Haas
    Jun 7, 2012 at 11:24 pm
    Jun 11, 2012 at 3:05 pm
  • Here's my review of this patch. Basic stuff: ------------ * Patch applies OK (some offsets). BTW, I had no problems applying both the original patch and Chetan Suttraway's version. The only ...
    Dean RasheedDean Rasheed
    Jun 16, 2012 at 1:50 pm
    Jun 26, 2012 at 10:03 am
  • Hi list, The recent 9.2 beta releases have used a slightly different numbering scheme than all previous releases. It used to be that tarballs for version $VER were always available at ...
    Marti RaudseppMarti Raudsepp
    Jun 20, 2012 at 8:29 am
    Jun 21, 2012 at 5:17 pm
  • We have a 8.3.18 system (yes, the same one from the previous thread, finally upgraded!) that gave us this error yesterday: ERROR: index "pg_class_oid_index" is not a btree It seems like this happened ...
    Greg Sabino MullaneGreg Sabino Mullane
    Jun 4, 2012 at 4:30 pm
    Jul 10, 2012 at 5:35 pm
  • Every time I make a change to the structure of the catalog files, genbki.pl produces a bunch of warnings (like "Use of uninitialized value in string eq at genbki.pl line ..."), and produces corrupted ...
    Peter EisentrautPeter Eisentraut
    Jun 24, 2012 at 6:41 pm
    Jun 27, 2012 at 3:21 pm
Group Navigation
period‹ prev | Jun 2012 | next ›
Group Overview
grouppgsql-hackers @

127 users for June 2012

Tom Lane: 274 posts Robert Haas: 263 posts Andres Freund: 162 posts Simon Riggs: 89 posts Magnus Hagander: 81 posts Alvaro Herrera: 54 posts Heikki Linnakangas: 50 posts Kevin Grittner: 49 posts Peter Geoghegan: 48 posts Peter Eisentraut: 44 posts Amit Kapila: 43 posts Florian Pflug: 36 posts Merlin Moncure: 32 posts Fujii Masao: 28 posts Joshua Berkus: 28 posts Bruce Momjian: 27 posts Jeff Janes: 27 posts Jeff Davis: 24 posts Kohei KaiGai: 22 posts Daniel Farina: 20 posts
show more