Search Discussions
-
I have completed my draft of the 9.2 release notes, and committed it to git. I am waiting for our development docs to build, but after 40 minutes, I am still waiting ...
Bruce Momjian
May 10, 2012 at 3:11 am
Sep 23, 2012 at 8:27 pm -
Hello here is patch with enhancing ErrorData structure. Now constraints errors and RI uses these fields Regards Pavel Stehule
Pavel Stehule
May 9, 2012 at 1:34 pm
Jan 6, 2013 at 8:39 pm -
103
9.2beta1, parallel queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the oprofile
Hi, I've been running some tests on pg 9.2beta1 and in particular a set of queries like create table _tmp0 as select * from ( select *, (select healpixid from idt_match as m where ...Sergey Koposov
May 24, 2012 at 1:25 pm
Jun 7, 2012 at 5:57 pm -
Hi, I just read a very interesting post about "schema version management". Quote: "You could set it up so that every developer gets their own test database, sets up the schema there, takes a dump, ...
Joel Jacobson
May 20, 2012 at 7:42 pm
Jul 15, 2012 at 2:56 am -
Let me have a discussion to get preferable interface for row-level security. My planned feature will perform to append additional conditions to WHERE clause implicitly, to restrict tuples being ...
Kohei KaiGai
May 23, 2012 at 12:00 pm
Jun 10, 2012 at 8:24 am -
So collecting a few requirements from various places: * Ability to have a Role that can only access one Database * Allow user info to be dumped with a database, to make a db completely ...
Simon Riggs
May 22, 2012 at 9:46 am
May 28, 2012 at 7:59 pm -
Hi all, as a part of my master's thesis I have created temporal support patch for PostgreSQL. It enables the creation of special temporal tables with entries versioning. Modifying operations (UPDATE, ...
Miroslav ©imulčík
May 16, 2012 at 9:15 pm
Aug 29, 2012 at 3:45 am -
The attached very simple patch moves the commit_delay + commit_siblings sleep into XLogFlush, where the leader alone sleeps. This appears to be a much more effective site for a delay. Benchmark ...
Peter Geoghegan
May 29, 2012 at 1:19 am
Jul 3, 2012 at 3:28 am -
Hi hackers After playing around with array_to_json() and row_to_json() functions a bit it I have a question - why do we even have 2 variants *_to_json() Collapsing array_to_json() and row_to_json() ...
Hannu Krosing
May 1, 2012 at 12:03 pm
May 5, 2012 at 3:49 pm -
I had a request from a customer asking if we could make a switch to specifically disable the "unexpected EOF" message that fills lots of peoples logs. Along the same way that we have a flag to turn ...
Magnus Hagander
May 3, 2012 at 12:26 pm
May 7, 2012 at 5:28 pm -
Hello I have to goals for 9.3. First goal is plpgsql_check_function, second goal is enhancing ErrorData and error management to support new fields: COLUMN_NAME, CONSTRAINT_NAME, CONSTRAINT_SCHEMA, ...
Pavel Stehule
May 1, 2012 at 12:22 pm
May 2, 2012 at 10:36 pm -
pg_upgrade is a little over-keen about checking for shared libraries that back functions. In particular, it checks for libraries that support functions created in pg_catalog, even if pg_dump doesn't ...
Andrew Dunstan
May 25, 2012 at 2:21 pm
May 29, 2012 at 11:07 pm -
Doing some beta testing, managed to produce this issue using the daily snapshot from Tuesday: 1. Created master server, loaded it with a couple dummy databases. 2. Created standby server. 3. Did ...
Josh Berkus
May 13, 2012 at 7:05 pm
May 18, 2012 at 5:44 pm -
We allow non-superuser database owners to execute CREATE LANGUAGE for a trusted language (one marked as tmpldbacreate in pg_pltemplate). Currently, the C-language support functions for the language ...
Tom Lane
May 30, 2012 at 4:02 pm
Jul 22, 2012 at 11:50 pm -
Shall I commit to master and all supported branches? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
Tatsuo Ishii
May 31, 2012 at 12:21 am
Sep 3, 2012 at 4:37 am -
Is there plan to implement such external functions before 9.2 release? If not, keepalive protocol seems to be almost useless because there is no use of it for a user and the increase in the number of ...
Fujii Masao
May 23, 2012 at 6:28 pm
Aug 9, 2012 at 4:13 pm -
We've previously discussed the possible desirability of extending relations in larger increments, rather than one block at a time, for performance reasons. I attempted to determine how much ...
Robert Haas
May 1, 2012 at 2:08 pm
May 31, 2012 at 7:18 pm -
Attached patch latches up the WAL Writer, reducing wake-ups and thus saving electricity in a way that is more-or-less analogous to my work on the BGWriter ...
Peter Geoghegan
May 2, 2012 at 3:36 pm
May 10, 2012 at 6:38 am -
Hi all, I noticed that when synchronous_commit=off were not waking up the wal sender latch in xact.c:RecordTransactionCommit which leads to ugly delays of approx 7 seconds (1 + ...
Andres Freund
May 10, 2012 at 7:51 pm
Jun 8, 2012 at 8:10 am -
Hello, I was running some tests on PG9.2beta where I'm creating and dropping large number of tables (~ 20000). And I noticed that table dropping was extremely slow -- e.g. like half a second per ...
Sergey Koposov
May 30, 2012 at 12:40 am
Jun 8, 2012 at 12:28 am -
While going through Readme in backend\storage\buffer, I found some point misleading. Normal Buffer Replacement Strategy ---------------------------------- -------------- .. .. Each buffer header ...
Amit Kapila
May 9, 2012 at 1:38 am
May 24, 2012 at 10:39 pm -
So, I set up a test which should have been ideal setup for index-only scan. The index was 1/10 the size of the table, and fit in RAM (1G) which the table does not: bench2=# select ...
Joshua Berkus
May 17, 2012 at 3:08 am
May 23, 2012 at 3:47 pm -
It seems pretty confusing that synchronous_commit = 'remote_write' means write confirmed to the remote socket, not write to the file system. Is there no better term we could some up with? ...
Bruce Momjian
May 9, 2012 at 1:13 am
May 10, 2012 at 11:28 pm -
According to http://archives.postgresql.org/pgsql-general/2012-04/msg00374.php advisory locks now cause problems for prepared transactions, which ought to ignore them. It appears to me that this got ...
Tom Lane
May 3, 2012 at 12:19 am
May 30, 2012 at 8:26 pm -
Yesterday I had a client that experienced a sudden high load on one of their servers (8.3.5 - yes, I know. Those of you with clients will understand). When I checked, almost all connections were in a ...
Greg Sabino Mullane
May 24, 2012 at 5:33 pm
Jun 10, 2012 at 11:19 pm -
Hi all, One of the issues we've been looking at with PostGIS is how to interrupt long-running processing tasks in external libraries, particularly GEOS. After a few tests here, it seems that even the ...
Mark Cave-Ayland
May 16, 2012 at 10:25 am
Jun 7, 2012 at 10:23 am -
I've been testing the crash recovery of REL9_2_BETA1, using the same method I posted in the "Scaling XLog insertion" thread. I have the checkpointer occasionally throw a FATAL error, which causes the ...
Jeff Janes
May 18, 2012 at 4:23 pm
May 25, 2012 at 7:10 pm -
If pg_stat_statements is set to store it's data across restarts, it stores it in global/pg_stat_statements.stat. This causes some interesting things to happen in combination with a base backup - ...
Magnus Hagander
May 24, 2012 at 10:43 am
May 28, 2012 at 11:15 am -
This code is our pre-9.2 group commit implementation, pretty much in its entirety: if (CommitDelay 0 && enableFsync && MinimumActiveBackends(CommitSiblings)) pg_usleep(CommitDelay); This code is ...
Peter Geoghegan
May 13, 2012 at 11:18 pm
May 15, 2012 at 4:39 pm -
Quite apart from the practical difficulties that we have with Flex (the fact that the authors are non-responsive and possibly retired, that annoying compiler warning, and the fact that we are forced ...
Peter Geoghegan
May 2, 2012 at 12:53 am
May 3, 2012 at 9:36 pm -
Hi Hackers How hard would it be to add support for LIKE syntax, similar to table def in field list declaration for generic record functions What I'dd like to be able to do is to have a generic ...
Hannu Krosing
May 2, 2012 at 11:40 am
May 3, 2012 at 4:05 pm -
In 9.1: regression=# select pg_size_pretty(8*1024*1024); pg_size_pretty ---------------- 8192 kB (1 row) In HEAD: regression=# select pg_size_pretty(8*1024*1024); ERROR: function ...
Tom Lane
May 26, 2012 at 12:30 am
Oct 21, 2012 at 10:22 pm -
Hm. This fixes the stability-within-transaction problem, but it's also introduced a change in the definition of age(), no? Previously, in an xact that had an XID, the age was measured relative to ...
Tom Lane
May 11, 2012 at 4:13 pm
May 29, 2012 at 7:00 pm -
Currently, the following can happen: 1. A backend needs a new transaction, so it calls GetNewTransactionId(). It acquires XidGenLock and then calls ExtendCLOG(). 2. ExtendCLOG() decides that a new ...
Robert Haas
May 3, 2012 at 4:38 pm
May 4, 2012 at 2:05 pm -
Now that there are index only scans, there is a use case for having a composite index which has the primary key or a unique key as the prefix column(s) but with extra columns after that. Currently ...
Jeff Janes
May 22, 2012 at 5:24 pm
Jun 3, 2012 at 7:49 pm -
pg 9.2 git master AMD 8120 (8-core) / 6 GB memory / Centos 6.2 I have experimented a bit with dropping a table from master, then querying that table from a sync-rep slave. It is a little worrying ...
Erik Rijkers
May 26, 2012 at 9:21 am
May 31, 2012 at 2:16 pm -
At dinner on Friday night at PGCon, the end of the table that included Tom Lane, Stephen Frost, and myself got to talking about the idea of including some kind of metapage in every relation, ...
Robert Haas
May 21, 2012 at 5:57 pm
May 25, 2012 at 11:42 pm -
In 9.1, the pg_basebackup option --xlog takes no argument. In 9.2, it takes a required argument. I think such compatibility breaks should be avoided, especially in client-side programs. Now you can't ...
Peter Eisentraut
May 28, 2012 at 8:11 pm
Jun 12, 2012 at 5:34 pm -
Hello I proposed new psql's format "shell". This format is optimized for processing returned result in shell: postgres=# select * from foo; a | b | c --------------+----+------------ Hello, World | ...
Pavel Stehule
May 26, 2012 at 3:40 pm
Jun 4, 2012 at 8:32 pm -
Hi, We just came across a situation where a corrupted HFS+ filesystem appears to return ERANGE on a customer machine. Our first reaction was to turn zero_damaged_pages on to allow taking a pg_dump ...
Alvaro Herrera
May 16, 2012 at 1:39 pm
May 21, 2012 at 10:09 pm -
I would like to propose to improve parsing efficiency of contrib/file_fdw by selective parsing proposed by Alagiannis et al.[1], which means that for a CSV/TEXT file foreign table, file_fdw performs ...
Etsuro Fujita
May 8, 2012 at 11:22 am
Jul 13, 2012 at 1:57 am -
I bumped into a bug in the new buffering GiST build code. I did this: create table gisttest (t text); insert into gisttest select a||'fooooooooooooooooooooooooooooooooooooooooooooooo' from ...
Heikki Linnakangas
May 18, 2012 at 4:27 pm
Jun 5, 2012 at 6:48 am -
Hi list, This bug isn't causing me any immediate problems -- the plan works out well regardless -- but PostgreSQL 8.4.7 is somehow overestimating the number of rows coming from a nestloop join, when ...
Marti Raudsepp
May 28, 2012 at 7:46 am
May 29, 2012 at 5:27 pm -
While researching a problem reported on the -general list by a user who lost a disk containing his index tablespace, I ran into something, but I'm not sure is a serious bug or just an inconsistency ...
Michael Nolan
May 8, 2012 at 4:14 am
May 12, 2012 at 4:03 am -
Hackers, Shouldn't a call to elog(NOTICE) invalidate the current tranaction? david=# begin; BEGIN Time: 0.178 ms david=# do language plperl $$ elog(ERROR, 'foo')$$; ERROR: foo at line 1. CONTEXT ...
David E. Wheeler
May 10, 2012 at 11:21 pm
May 11, 2012 at 5:19 pm -
I have been reviewing how our new libpq URL syntax compares against existing implementations of URL syntaxes in other drivers or higher-level access libraries. In the case of SQLAlchemy, there is an ...
Peter Eisentraut
May 9, 2012 at 6:17 pm
May 29, 2012 at 4:27 am -
I've switched servers yesterday night and the previous slave is now the master. This is 9.0.6 (originally) / 9.0.7 (now) on Linux. Now I'm seeing a bunch of ERROR: could not open relation with OID ...
Joachim Wieland
May 16, 2012 at 2:37 am
May 24, 2012 at 6:54 pm -
Do we have a full list of externally defined open standards that we follow? Are there any known incompatibilities from externally defined open standards? (I know about the SQL standard stuff). Are ...
Simon Riggs
May 12, 2012 at 9:38 am
May 24, 2012 at 3:50 am -
Hello, This question may be appropriate for pgsql-general, but let me ask here because the only relevant discussion seems to have been done on pgsql-hackers ...
MauMau
May 9, 2012 at 12:11 pm
May 11, 2012 at 3:54 pm -
As part of a blog, I started looking at how a user could measure the pressure on shared buffers, e.g. how much are they being used, recycled, etc. They way you normally do it on older operating ...
Bruce Momjian
May 30, 2012 at 4:56 pm
May 31, 2012 at 10:15 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 142 |
posts | 1,584 |
users | 121 |
website | postgresql.org... |
irc | #postgresql |
121 users for May 2012
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)