Search Discussions
-
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 Herrera
Nov 3, 2011 at 6:13 pm
Apr 5, 2012 at 6:51 pm -
134
Command Triggers
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 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 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 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 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 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 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 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 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 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 Smith
Nov 6, 2011 at 3:08 am
Mar 13, 2012 at 1:53 pm -
34
FlexLocks
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 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 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 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 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 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 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 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 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 Haas
Nov 17, 2011 at 8:51 pm
Dec 21, 2011 at 11:40 pm -
23
[patch] Include detailed information about a row failing a CHECK constraint into the error message
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át
Nov 7, 2011 at 5:14 am
Nov 29, 2011 at 8:25 pm -
22
9.1.2 ?
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Eisentraut
Nov 27, 2011 at 10:50 pm
Jan 27, 2012 at 2:11 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 172 |
posts | 1,764 |
users | 146 |
website | postgresql.org... |
irc | #postgresql |
146 users for November 2011
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)