FAQ

PostgreSQL > pgsql-hackers > November 2011

Search Discussions

172 discussions - 1,764 posts

  • Hello, After some rather extensive rewriting, I submit the patch to improve foreign key locks. To recap, the point of this patch is to introduce a new lock tuple mode, that lets the RI code obtain a ...
    Alvaro HerreraAlvaro Herrera
    Nov 3, 2011 at 6:13 pm
    Apr 5, 2012 at 6:51 pm
  • Hi, As proposed by Jan Wieck on hackers and discussed in Ottawa at the Clusters Hackers Meeting, the most (only?) workable way to ever have DDL triggers is to have "command triggers" instead. Rather ...
    Dimitri FontaineDimitri Fontaine
    Nov 8, 2011 at 5:47 pm
    Mar 21, 2012 at 4:41 pm
  • Hello. This message is a proposal of a pair of patches that enables the memory allocator for PGresult in libpq to be replaced. The comment at the the begging of pqexpbuffer.c says that libpq should ...
    Kyotaro HORIGUCHIKyotaro HORIGUCHI
    Nov 11, 2011 at 9:20 am
    Apr 5, 2012 at 5:05 pm
  • Hi, I know I'm late for the ongoing commitfest, but I thought I might as well be early for the next one. Attached is a patch against master that implements timing of shared buffer fills and per ...
    Ants AasmaAnts Aasma
    Nov 28, 2011 at 12:40 am
    Apr 30, 2012 at 3:13 pm
  • This patch adds basic support of arrays in foreign keys, by allowing to define a referencing column as an array of elements having the same type as the referenced column in the referenced table. ...
    Gabriele BartoliniGabriele Bartolini
    Nov 4, 2011 at 12:48 pm
    Aug 1, 2012 at 5:53 pm
  • Hi pgsql-hackers, I am a long time user and fan of PostgreSQL and have built various projects large and small on every major release since 6.5. Recently I decided to try doing something more with the ...
    Thomas MunroThomas Munro
    Nov 6, 2011 at 3:30 am
    Dec 7, 2011 at 7:49 pm
  • Hello, It was proposed a while ago for libpq to support URI syntax for specifying the connection information: http://archives.postgresql.org/message-id/1302114698.23164.17.camel@jd-desktop ...
    Alexander ShulginAlexander Shulgin
    Nov 21, 2011 at 6:35 pm
    Dec 9, 2011 at 9:25 pm
  • Hackers, WIP patch with index support for regexp search for pg_trgm contrib is attached. In spite of techniques which extracts continuous text parts from regexp, this patch presents technique of ...
    Alexander KorotkovAlexander Korotkov
    Nov 22, 2011 at 7:39 pm
    Dec 18, 2012 at 9:10 am
  • Hi PostgreSQL hackers, support for Mingw-w64 compiler was added to postgres with commit 91812df. Unfortunately only the 64 bit output is working right now. This issue was already highlighted with ...
    Lars KanisLars Kanis
    Nov 24, 2011 at 8:24 am
    Dec 14, 2011 at 8:34 pm
  • I ran into a performance problem described in this thread: http://archives.postgresql.org/pgsql-performance/2011-10/msg00249.php continued here: ...
    Albe LaurenzAlbe Laurenz
    Nov 8, 2011 at 1:59 pm
    Nov 28, 2011 at 12:21 pm
  • Attached patch adds a new function to the pageinspect extension for measuring total free space, in either tables or indexes. It returns the free space as a percentage, so higher numbers mean more ...
    Greg SmithGreg Smith
    Nov 6, 2011 at 3:08 am
    Mar 13, 2012 at 1:53 pm
  • I've been noodling around with various methods of reducing ProcArrayLock contention and (after many false starts) I think I've finally found one that works really well. I apologize in advance if this ...
    Robert HaasRobert Haas
    Nov 15, 2011 at 1:50 pm
    Dec 15, 2011 at 7:03 pm
  • I noticed while playing around this morning that, in read committed mode, the following query - or any other straightforward query - calls GetSnapshotData() twice: SELECT 1; What happens is this: ...
    Robert HaasRobert Haas
    Nov 11, 2011 at 2:07 pm
    Dec 19, 2011 at 7:18 pm
  • We have three patches in the hopper that all have the same goal: reduce ProcArrayLock contention. They are: [1] Pavan's patch (subsequently revised by Heikki) to put the "hot" members of the PGPROC ...
    Robert HaasRobert Haas
    Nov 18, 2011 at 3:11 pm
    Nov 22, 2011 at 7:04 pm
  • Some time ago, I changed GetOldestXmin() to ignore procs in other databases resulting in a potentially later xmin. GetSnapshotData() was not touched when that happened, even though the comments say ...
    Simon RiggsSimon Riggs
    Nov 22, 2011 at 8:23 pm
    Aug 17, 2012 at 5:21 pm
  • Looking for comments ... https://gist.github.com/be937d3a7a5323c73b6e We'd like to get this, or something like it, into 9.2 PS Subscribing to psql-hackers@postgresql.org just spins for me.
    Edward MullerEdward Muller
    Nov 16, 2011 at 7:47 pm
    Jan 15, 2012 at 2:41 pm
  • Hi, Consider the following sequence of events: s1 # CREATE SCHEMA test_schema; s1 # CREATE TABLE test_schema.c1(x int); Now open another session s2 and via gdb issue a breakpoint on ...
    Nikhil SontakkeNikhil Sontakke
    Nov 9, 2011 at 9:56 am
    Jan 16, 2012 at 2:53 pm
  • I've long considered synchronous_commit=off to be one of our best performance features. Certainly, it's not applicable in every situation, but there are many applications where losing a second or so ...
    Robert HaasRobert Haas
    Nov 7, 2011 at 2:32 pm
    Dec 1, 2011 at 4:48 pm
  • On some recent benchmarks and profile data, I saw GetSnapshotData figures at the very top or near top. For lesser number of clients, it can account for 10-20% of time, but more number of clients I ...
    Pavan DeolaseePavan Deolasee
    Nov 26, 2011 at 3:53 pm
    Aug 20, 2012 at 3:39 pm
  • In commit 4240e429d0c2d889d0cda23c618f94e12c13ade7, we modified RangeVarGetRelid() so that it acquires a lock on the target relation "atomically" with respect to the name lookup. Since we lock OIDs, ...
    Robert HaasRobert Haas
    Nov 17, 2011 at 8:51 pm
    Dec 21, 2011 at 11:40 pm
  • Hi, when I insert/update many rows at once using INSERT ... SELECT into a table which has plenty of CHECK constraints, the error message that Postgres returns has no indication of which row failed ...
    Jan KundrátJan Kundrát
    Nov 7, 2011 at 5:14 am
    Nov 29, 2011 at 8:25 pm
  • Given the amount of fixes that went into the branch, and importance of them - when can we expect 9.1.2 to be released officially ? 9.1.1 was stamped on 22nd of September.
    Greg JaskiewiczGreg Jaskiewicz
    Nov 8, 2011 at 7:46 pm
    Nov 12, 2011 at 11:43 pm
  • Two years ago Magnus submitted a patch to parse all the configuration files in a directory. After some discussion I tried to summarize what I thought the most popular ideas were for moving that ...
    Greg SmithGreg Smith
    Nov 16, 2011 at 4:59 am
    Sep 25, 2012 at 7:37 am
  • Hi, As discussed few days ago it would be beneficial if we could change the v3 backend<- client protocol without breaking backwards compatibility. Here is a working patch that exports a ...
    Mikko TiihonenMikko Tiihonen
    Nov 28, 2011 at 3:19 pm
    Jan 23, 2012 at 9:54 pm
  • Hi all, The good news is that psql's backslash commands are becoming quite thorough at displaying all information which could conceivably be of interest about an object. The bad news is, psql's ...
    Josh KupershmidtJosh Kupershmidt
    Nov 5, 2011 at 5:33 pm
    Nov 14, 2011 at 11:43 pm
  • Here is the patch to implement type privileges that I alluded to earlier. To recall, this is mainly so that owners can prevent others from using their types because that would in some cases prevent ...
    Peter EisentrautPeter Eisentraut
    Nov 15, 2011 at 8:32 pm
    May 20, 2012 at 9:15 am
  • Consider the following query: select (x).key as k, (x).value as v from (select each(hstore(q)) as x from (select oid, c.* from pg_class c where oid = 'parent'::regclass) q) t; This gives results like ...
    Andrew DunstanAndrew Dunstan
    Nov 16, 2011 at 8:53 pm
    Feb 15, 2012 at 4:44 am
  • One thing that bothered me while looking at the range types patch is that it seemed you'd been mighty conservative about creating built-in range types. In particular, I don't understand why there's ...
    Tom LaneTom Lane
    Nov 29, 2011 at 5:01 pm
    Dec 3, 2011 at 9:57 pm
  • I noticed that a bulk INSERT into an empty table (which has been TRUNCATEd in the same transaction, for good measure) results in a curious number of open(2) calls for the FSM resource fork: ...
    Florian WeimerFlorian Weimer
    Nov 27, 2011 at 3:24 pm
    Aug 23, 2012 at 7:19 pm
  • I notice that there's some weird info coming out of the system columns on any FDW: test=# select tableoid, ctid, xmin, xmax, cmin, cmax, * from dict limit 12; tableoid | ctid | xmin | xmax | cmin | ...
    Thom BrownThom Brown
    Nov 13, 2011 at 12:24 am
    Feb 29, 2012 at 5:24 am
  • These attached patches were getting rebased to the latest master and cosmetic changes towrad upcoming commit-fest Nov. Please apply these patches in order of Part-1, Part-2, Part-3 then Part-4. We ...
    Kohei KaiGaiKohei KaiGai
    Nov 15, 2011 at 11:04 am
    Dec 16, 2011 at 5:55 pm
  • The series of attached patches try to have refactoring on several ddl statements; that consolidates distributed routines for each object types into a common routine to minimize the number of upcoming ...
    Kohei KaiGaiKohei KaiGai
    Nov 15, 2011 at 9:51 am
    Dec 1, 2011 at 1:25 pm
  • This is the time of year when the Wisconsin Courts formalize their annual plan for where people will be spending the bulk of their time in the coming year. Two years ago at this time, managers ...
    Kevin GrittnerKevin Grittner
    Nov 8, 2011 at 9:23 pm
    Nov 18, 2011 at 10:06 pm
  • We have a need for logging in systems where it isn't feasible to log to disk as it negatively impacts performance. I'd like to be able to creatively solve this problem without modifying the core, but ...
    Theo SchlossnagleTheo Schlossnagle
    Nov 24, 2011 at 2:28 am
    Mar 15, 2012 at 10:18 pm
  • Hi All, While working on some of the performance issues on HP-UX, I noticed a significant data cache misses for accessing PGPROC members. On a close inspection, it was quite evident that for large ...
    Pavan DeolaseePavan Deolasee
    Nov 3, 2011 at 6:13 pm
    Dec 17, 2011 at 2:00 pm
  • G'day list. I've been messing around with the unaccent extension and I've noticed that some of the characters listed in the unaccent.rules file aren't actually being unaccented on my system. Here are ...
    J SmithJ Smith
    Nov 6, 2011 at 5:29 pm
    Nov 10, 2011 at 9:18 pm
  • Occasionally, we get bitten by embedded NUL bytes in TEXT values. We take care of generating proper UTF-8, but this additional restriction sometimes slips by. It would be really helpful if PostgreSQL ...
    Florian WeimerFlorian Weimer
    Nov 24, 2011 at 9:07 am
    Dec 23, 2011 at 10:52 am
  • Hi everyone, I propose a patch that would allow optional "cleaning" of queries tracked in pg_stat_statements, compressing the result and making it more readable. The default behavior is that when the ...
    Tomas VondraTomas Vondra
    Nov 6, 2011 at 1:05 am
    Dec 1, 2011 at 10:56 am
  • When a server fails, we need to promote a standby as quickly as possible. Currently when we promote a standby to a primary we need to run a shutdown checkpoint before users can begin write ...
    Simon RiggsSimon Riggs
    Nov 1, 2011 at 12:11 pm
    Aug 22, 2012 at 3:01 pm
  • Hi, A few months ago, I got an email related to Pyrseas (http://lists.pgfoundry.org/pipermail/pyrseas-general/2011-August/000003.html) where the user reported he had a table named "user" and reported ...
    Joe AbbateJoe Abbate
    Nov 30, 2011 at 12:29 am
    Nov 30, 2011 at 6:34 pm
  • During the closing days of the 9.1 release, we had discussed that we should add privileges on types (and domains), so that owners can prevent others from using their types because that would prevent ...
    Peter EisentrautPeter Eisentraut
    Nov 5, 2011 at 2:35 pm
    Nov 11, 2011 at 2:39 pm
  • The attached patch adds a column for statistics target when viewing tables in psql using \d+. Comments/reivews? --  Magnus Hagander  Me: http://www.hagander.net/  Work: ...
    Magnus HaganderMagnus Hagander
    Nov 4, 2011 at 1:34 pm
    Nov 5, 2011 at 12:03 pm
  • The attached patch makes the \d output for psql on a sequence show which table/column owns the sequence. The table already showed the dependency the other way through the default value, but going ...
    Magnus HaganderMagnus Hagander
    Nov 4, 2011 at 1:01 pm
    Nov 5, 2011 at 11:59 am
  • Reviving a thread that has hit its second birthday: http://archives.postgresql.org/pgsql-hackers/2009-11/msg00024.php In our case not being able to restart Postgres when it has been taken down in the ...
    Daniel FarinaDaniel Farina
    Nov 30, 2011 at 2:11 am
    Jan 2, 2012 at 9:59 pm
  • Hi, We got a very strange nbtree corruption report some time ago. This was a btree index on a vey high churn table -- entries are updated and deleted very quickly, so the index grows very large and ...
    Alvaro HerreraAlvaro Herrera
    Nov 21, 2011 at 11:00 pm
    Nov 29, 2011 at 1:14 pm
  • While thinking about range_cmp_bounds, I started to think that the way range_adjacent works is wrong. range_adjacent() depends on the bounds of two ranges to match up, such that the boundary values ...
    Jeff DavisJeff Davis
    Nov 18, 2011 at 8:25 am
    Nov 23, 2011 at 9:39 pm
  • The singleton range constructors don't work terribly well. regression=# select int4range(42); -- ok int4range ----------- [42,43) (1 row) regression=# select int4range(null); -- not so ok int4range ...
    Tom LaneTom Lane
    Nov 19, 2011 at 5:27 pm
    Nov 22, 2011 at 6:01 pm
  • Hello, there is a request on enhancing of pg_backup to produce a conditional DROPs. A reason for this request is more simple usage in very dynamic production - cloud BI solution. pg_backup can have a ...
    Pavel StehulePavel Stehule
    Nov 15, 2011 at 8:06 am
    Nov 21, 2011 at 2:06 pm
  • Currently, the Startup process is responsible for running restore_command. So when the Startup process is busy or waiting, then no new WAL files arrive. That has these effects * Recovery must wait ...
    Simon RiggsSimon Riggs
    Nov 2, 2011 at 3:57 pm
    Nov 4, 2011 at 1:24 pm
  • It would be helpful if variable length catalog fields (except the first one) would not be visible on the C level in the Form_pg_* structs. We keep them listed in the include/catalog/pg_*.h files so ...
    Peter EisentrautPeter Eisentraut
    Nov 27, 2011 at 10:50 pm
    Jan 27, 2012 at 2:11 am
Nov 2011
1234
Group Navigation
period‹ prev | Nov 2011 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions172
posts1,764
users146
websitepostgresql.org...
irc#postgresql

146 users for November 2011

Robert Haas: 278 posts Tom Lane: 252 posts Simon Riggs: 87 posts Bruce Momjian: 75 posts Kevin Grittner: 71 posts Greg Smith: 51 posts Pavel Stehule: 42 posts Peter Eisentraut: 42 posts Alvaro Herrera: 41 posts Andrew Dunstan: 39 posts Joshua Berkus: 37 posts Dimitri Fontaine: 36 posts Thom Brown: 31 posts Magnus Hagander: 27 posts Andres Freund: 26 posts Jeff Davis: 23 posts Heikki Linnakangas: 22 posts Alexander Shulgin: 21 posts Peter Geoghegan: 21 posts Florian Pflug: 20 posts
show more
Archives