Search Discussions
-
I have gotten two reports via IRC that months after using 9.0 pg_upgrade, some of the clog files have been removed while there is still data in the table needing those clog files. These reports came ...
Bruce Momjian
Mar 29, 2011 at 8:17 pm
Apr 25, 2011 at 4:05 pm -
Or else we should close the CommitFest and cut alpha4. Anyone have an opinion on which way to go? I think it's fair to say that Simon is working pretty actively on Sync Rep and that the bug count is ...
Robert Haas
Mar 1, 2011 at 6:43 pm
Apr 27, 2011 at 7:55 pm -
90
Sync Rep v19
Latest version of Sync Rep, which includes substantial internal changes and simplifications from previous version. (25-30 changes). Includes all outstanding technical comments, typos and docs. I will ...Simon Riggs
Mar 3, 2011 at 10:53 am
Apr 30, 2011 at 2:29 am -
Attached is a WIP patch that allows SQL-language functions to reference their parameters by name. It uses p_post_columnref_hook, so potentially ambiguous references prefer the column... that seems to ...
Matthew Draper
Mar 25, 2011 at 7:41 pm
Apr 26, 2011 at 3:19 pm -
The discussion on the thread was that its not sync rep unless we have the strictest guarantees. We have the strictest guarantees, so it qualifies as sync rep. Relaxations are possible and, to some ...
Simon Riggs
Mar 6, 2011 at 11:28 pm
Mar 25, 2011 at 12:12 pm -
Hi, I'd like to add an ability to validate the corectness of PostgreSQL configuration files, i.e. postgresql.conf, pg_hba.conf, pg_ident.conf without actually applying them. The idea is that it would ...
Alexey Klyukin
Mar 30, 2011 at 4:14 pm
Oct 2, 2011 at 8:58 pm -
It's about dependences. If my extension requires a procedural language, will adding that language to the `requires` control key do what I think it should do? If not, how should one require a PL? Come ...
David E. Wheeler
Mar 2, 2011 at 9:15 pm
Mar 5, 2011 at 6:13 pm -
Hi, I have implemented initial concept of 2nd level cache. Idea is to keep some segments of shared memory for special buffers (e.g. indices) to prevent overwrite those by other operations. I added ...
Radosław Smogura
Mar 17, 2011 at 7:47 pm
Apr 26, 2011 at 7:49 pm -
Agreed. I think that user who wants to request smart shutdown expects all the existing connections to basically be closed normally by the client. So it doesn't seem to be good idea to forcibly close ...
Fujii Masao
Mar 9, 2011 at 7:38 am
Mar 22, 2011 at 7:51 pm -
Attached is a patch that adds a 'json' contrib module. Although we may want a built-in JSON data type in the near future, making it a module (for the time being) has a couple advantages: * ...
Joseph Adams
Mar 28, 2011 at 5:22 pm
Jun 18, 2011 at 10:29 am -
Proposed changes: Make synchronous_replication into an enum, so we can now also say synchronous_replication = recv, flush or apply as well as on or off. synchronous_replication = on is the same as ...
Simon Riggs
Mar 27, 2011 at 9:45 pm
Mar 30, 2011 at 7:59 am -
I was trying to build the Windows msvc build for the first time and ran into some issues. The documentation talks about obtaining and using the "Platform SDK". I understand that this is nowadays ...
Peter Eisentraut
Mar 31, 2011 at 7:38 pm
May 11, 2011 at 4:19 am -
In a previous thread (http://postgresql.1045698.n5.nabble.com/Set-hint-bits-upon-eviction-from-BufMgr-td4264323.html) I was playing with the idea of granting the bgwriter the ability to due last ...
Merlin Moncure
Mar 29, 2011 at 9:35 pm
Jun 29, 2011 at 3:11 pm -
People are confused about what template0 is for, so I created the attached one-line patch to add a database comment to template0. No initdb, I assume, becuase it is just a comment. I plan to work on ...
Bruce Momjian
Mar 11, 2011 at 10:25 pm
Mar 15, 2011 at 6:37 pm -
Looking over the autovacuum.c code, I see: /* * Determine the oldest datfrozenxid/relfrozenxid that we will allow to * pass without forcing a vacuum. (This limit can be tightened for * particular ...
Bruce Momjian
Mar 31, 2011 at 4:17 pm
May 7, 2011 at 7:29 pm -
Hi, I am currently looking at a physical file belonging to a corrupt index. This is with PG 8.3.13 on an ext3 filesystem on suse linux with a RAID1 setup. The sequence of operation seems nothing ...
Nikhil Sontakke
Mar 22, 2011 at 8:02 pm
Mar 22, 2011 at 8:02 pm -
Was this cluster upgraded to 8.4.4 from 8.4.0? It sounds to me like a known bug in 8.4.0 which was fixed by this commit: commit 7fc7a7c4d082bfbd579f49e92b046dd51f1faf5f Author: Tom Lane ...
David Christensen
Mar 1, 2011 at 1:43 am
Mar 8, 2011 at 7:00 pm -
It has bothered me that many of our time routines use special magic constants for time values, e.g. 24, 12, 60, etc. The attached patch changes these magic constants to macros to clarify the code. I ...
Bruce Momjian
Mar 11, 2011 at 5:51 pm
Sep 5, 2011 at 7:39 pm -
Hello, i have an old system where used implicit casting float<- integer numeric<- float numeric<- integer I want define implicit casts, but postgresql don`t know cast priority now postgresql have ...
Zotov
Mar 10, 2011 at 1:20 pm
May 11, 2011 at 10:05 pm -
Hi, I was randomly testing some date related stuff on PG & observed that the outputs were wrong. e.g. postgres=# SELECT TO_DATE('01-jan-2010', 'DD-MON-YY'); to_date ------------ 3910-01-01 <--------- ...
Piyush Newe
Mar 16, 2011 at 12:22 pm
Sep 7, 2011 at 1:51 pm -
Here's a quick enumeration of some things I think need discussion about the collations patch: * Are we happy yet with the collation assignment behavior (see parse_collate.c)? A couple of specific ...
Tom Lane
Mar 26, 2011 at 4:36 am
Apr 18, 2011 at 7:53 pm -
hi, So, I hit a strange problem with Streaming Replication, that I cannot explain. Executive summary: when using hot backup made on straming replication slave, sometimes (depending on load) generated ...
Hubert depesz lubaczewski
Mar 25, 2011 at 8:31 pm
Mar 30, 2011 at 8:12 am -
Hi, I've noticed some weirdness when trying to grant various types of permissions on a foreign table and thought I'd report it here: postgres=# \d stuff Foreign table "public.stuff" Column | Type | ...
Thom Brown
Mar 31, 2011 at 11:55 pm
May 13, 2011 at 7:52 pm -
Greetings, In a discussion which came up at PgEast, I questioned if it'd be possible to set the 'all visible' hint bit and give the tuples the frozen XID when loading data into a table which was ...
Stephen Frost
Mar 24, 2011 at 9:08 pm
Mar 25, 2011 at 8:26 pm -
I took a look at the open item concerning typed tables and pg_upgrade: http://archives.postgresql.org/pgsql-hackers/2011-03/msg00767.php "pg_dump --binary-upgrade" emits commands to recreate the ...
Noah Misch
Mar 29, 2011 at 9:50 pm
Apr 21, 2011 at 5:30 am -
For historical reasons, what we now think of as VACUUM is referred to in some portions of the code as "lazy vacuum", to distinguish it from pre-9.0 VACUUM FULL. As I understand it, VACUUM works like ...
Robert Haas
Mar 14, 2011 at 7:36 pm
Apr 9, 2011 at 12:14 pm -
Hello, Most database connectors/frameworks nowadays support a URI style connection string. Something like: pgsql://user:pass@host/database Do we think psql should support this style of connection ...
Joshua D. Drake
Mar 31, 2011 at 11:26 pm
Apr 6, 2011 at 8:06 pm -
We have run across a problem with autovacuum that occurs when it can truncate off a large amount of empty blocks. It behaves different in version 9.0 than previous versions. Both behaviors are bad. ...
Jan Wieck
Mar 26, 2011 at 2:31 pm
Apr 1, 2011 at 10:16 pm -
I got a report from someone using pg_upgrade coming from PG 8.3 --- turns out we didn't rename toast tables to match the new relfilenode in pre-8.4, so the attached applied patch avoids the check for ...
Bruce Momjian
Mar 6, 2011 at 2:15 am
Dec 8, 2011 at 7:06 pm -
Is there any documentation of $SUBJECT? Because the more I look at this patch the more I think it's misdesigned; either that or I fundamentally misunderstand what it's trying to do. I complained ...
Tom Lane
Mar 7, 2011 at 4:43 pm
Mar 10, 2011 at 8:22 pm -
Specifically, if we're not going to remove write location, then I think we need to apply something like the attached. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise ...
Robert Haas
Mar 23, 2011 at 3:35 pm
Mar 26, 2011 at 12:25 am -
I've attached a small patch with a bit of clarification and a typo fix in the synchronous_standby_names parameter info. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux ...
Thom Brown
Mar 7, 2011 at 9:58 am
Mar 10, 2011 at 3:52 pm -
16
alpha5
Per previous discussion, I'm going to wrap alpha5 Monday morning Eastern time, barring objections. This time, I'm going to try to make sure that announcements actually go out; I dropped the ball on ...Robert Haas
Mar 27, 2011 at 1:41 am
May 5, 2011 at 4:54 pm -
I took a crack at implementing the first approach described above, which seems to be by far the simplest idea we've come up with to date. Patch attached. It doesn't seem to be that complicated, which ...
Robert Haas
Mar 22, 2011 at 8:43 pm
Mar 31, 2011 at 10:31 am -
Hi, I try to known how a database is implemented and I have been reading PG source codes for a month. Now, I only know a little about how PG work. :( I just know PG work like this but I don't know ...
Hom
Mar 17, 2011 at 2:57 pm
Mar 20, 2011 at 3:44 pm -
I am not sure the following pg_ctl behaviour is really a bug, but I find it unexpected enough to report. I was testing synchronous replication in a test setup on a single machine. (After all, one ...
Erik Rijkers
Mar 18, 2011 at 5:19 pm
Oct 19, 2011 at 4:20 am -
It stroke me today again, that \dt+ isn't displaying the acurate table size for tables, since it uses pg_relation_size() till now. With having pg_table_size() since PostgreSQL 9.0 available, i ...
Bernd Helmle
Mar 21, 2011 at 6:56 pm
Apr 8, 2011 at 7:56 pm -
This might be nitpicking (or i'm currently missing something), but i recognized that setting wal_buffers = -1 always triggers the following on reload, even if nothing to wal_buffers had changed: $ ...
Bernd Helmle
Mar 31, 2011 at 12:38 pm
Apr 6, 2011 at 4:14 pm -
Hackers, I would like to ask you about currency of the work above. I propose to develop functionality of GIN and GiST q-gram indexes with following features: 1) Handle edit distance (e.g. levenshtein ...
Alexander Korotkov
Mar 25, 2011 at 5:33 pm
Apr 5, 2011 at 3:03 pm -
On the open items list, we have: conversion from integer literals to money type http://archives.postgresql.org/pgsql-testers/2011-01/msg00000.php What this is really complaining about is that we ...
Robert Haas
Mar 31, 2011 at 8:28 pm
Apr 5, 2011 at 1:38 pm -
Hi! PostgreSQL is applying for GSoC again this year. We're looking for: * Mentors * Project ideas Would you like to mentor? Please let me know! Our application closes on Friday, so please contact me ...
Selena Deckelmann
Mar 8, 2011 at 6:44 am
Mar 28, 2011 at 6:25 am -
Currently, we don't measure any statistics about the ordering correlation of multi-column indexes, which means that btcostestimate has to pick a number out of the air if there's more than one column. ...
Tom Lane
Mar 13, 2011 at 11:40 pm
Mar 16, 2011 at 12:58 am -
Heyho! I'm poking around a bit in PostgreSQL's source for curiosity's sake. Is there a short howto on how to start / debug postgres from within the unpacked/compiled tar? Are there scripts that set ...
Adrian von Bidder
Mar 8, 2011 at 9:11 am
Mar 9, 2011 at 12:55 pm -
I believe I've figured out why synchronous replication has such terrible performance with fsync=off: it has a nasty race condition. It may happen - if the standby responds very quickly - that the ...
Robert Haas
Mar 26, 2011 at 1:11 am
Mar 28, 2011 at 1:27 am -
I'm seeing this failure on a build machine with an old (and therefore unusable) version of flex: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels ...
Dave Page
Mar 11, 2011 at 3:41 pm
Mar 22, 2011 at 9:44 pm -
So I was moving some error checks around and all of a sudden the regression tests blew up on me, with lots of errors about how type X didn't support collations (which indeed it didn't). After some ...
Tom Lane
Mar 9, 2011 at 9:49 pm
Mar 15, 2011 at 8:22 pm -
I've thought of another area that AFAICT the current patch fails to address at all: what should happen in user-defined functions? Consider create function my_lt(x text, y text) returns bool as $$ ...
Tom Lane
Mar 12, 2011 at 5:17 pm
Mar 15, 2011 at 7:44 pm -
I am unsure on that one. We have many 'char' mentions in catalog.sgml, and I don't see any of them shown as '"char"'. (Wow, we should have just called this type char1, but I think that name came from ...
Bruce Momjian
Mar 11, 2011 at 11:13 am
Sep 6, 2011 at 3:20 pm -
Hi, maybe we should change the "1000 digits" here: http://developer.postgresql.org/pgdocs/postgres/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL because ISTM that up to 2^17 digits are supported ...
Gianni Ciolli
Mar 11, 2011 at 11:44 am
Apr 27, 2011 at 12:20 pm -
Maybe I'm being overly simplistic or incorrect here, but I was thinking that there might be a route to reducing hint bit impact to the main sufferers of the feature without adding too much pain in ...
Merlin Moncure
Mar 25, 2011 at 2:52 pm
Apr 5, 2011 at 3:59 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 175 |
posts | 1,956 |
users | 140 |
website | postgresql.org... |
irc | #postgresql |
140 users for March 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)