Search Discussions
-
I believe that the consensus was mostly in favor of deprecating = as an operator name, with the intent to abolish it completely in a future release. Attached is a patch to implement == as an ...
Robert Haas
Jun 8, 2010 at 7:08 pm
Jul 2, 2010 at 9:08 pm -
Hi, We don't have any statistic views for walsenders in SR's master server in 9.0, but such views would be useful to monitor and manage standby servers from the master server. I have two ideas for ...
Takahiro Itagaki
Jun 18, 2010 at 2:32 am
Jan 13, 2011 at 5:54 pm -
Hi, When an error is found in the WAL streamed from the master, a warning message is repeated without interval forever in the standby. This consumes CPU load very much, and would interfere with ...
Fujii Masao
Jun 7, 2010 at 1:22 pm
Jul 2, 2010 at 9:47 pm -
Hi, we improved ECPG quite a lot in 9.0 because we worked and still working with an Informix to PostgreSQL migration project. We came across a pretty big performance problem that can be seen in every ...
Boszormenyi Zoltan
Jun 17, 2010 at 12:10 pm
Apr 24, 2012 at 8:17 am -
Hi, In 9.0, walsender reads WAL always from the disk and sends it to the standby. That is, we cannot send WAL until it has been written (and flushed) to the disk. This degrades the performance of ...
Fujii Masao
Jun 11, 2010 at 1:14 pm
Jul 8, 2010 at 7:51 am -
For previous discussion of this topic, see: http://archives.postgresql.org/pgsql-hackers/2010-04/msg01181.php http://archives.postgresql.org/pgsql-hackers/2010-05/msg00352.php ...
Robert Haas
Jun 10, 2010 at 8:40 pm
Sep 15, 2010 at 4:46 pm -
I think adding new moderators who are regualy reading emails and living in different time zones is an idea. If nobody in +0900 tinme zone(Japan), I'd like to be an additional moderator. -- Tatsuo ...
Tatsuo Ishii
Jun 16, 2010 at 10:04 pm
Jun 25, 2010 at 3:16 pm -
A recent discussion with a developer convinced me that enums would be much more useful if new values could be added to the label list easily without changing the stored values. Given the current ...
Andrew Dunstan
Jun 18, 2010 at 3:51 pm
Jun 23, 2010 at 11:30 pm -
The attached patch is a proof of concept. It tries to fix the problem of leaky VIEWs for RLS. * The scenario of leaky VIEWs for RLS ------------------------------------- When a view contains any ...
KaiGai Kohei
Jun 3, 2010 at 8:45 am
Jun 9, 2010 at 6:04 am -
I have developed a patch that partially implements the "functional dependency" feature that allows some columns to be omitted from the GROUP BY clause if it can be shown that the columns are ...
Peter Eisentraut
Jun 7, 2010 at 6:34 pm
Sep 5, 2010 at 6:28 pm -
Hi! I'm looking at adding win32 support for keepalives in libpq (well, also backend, but libpq for now), per the request from Robert Haas. I've come up with one issue though - in Windows, you can ...
Magnus Hagander
Jun 28, 2010 at 6:23 pm
Jul 8, 2010 at 10:27 am -
Recent discussions involving the possible benefits of a connection pool for certain users has reminded me of a brief discussion at The Royal Oak last month, where I said I would post a reference a ...
Kevin Grittner
Jun 25, 2010 at 5:34 pm
Jul 11, 2010 at 7:53 am -
It would be nice to get beta3 out the door sooner rather than later, but I sort of feel like we're not ready yet. In fact, we seem to be a bit stalled. The open items list currently lists four items. ...
Robert Haas
Jun 19, 2010 at 1:43 pm
Jun 28, 2010 at 8:40 am -
I spent some time investigating this today and have come to the conclusion that streaming replication is really, really broken in the face of potential crashes on the master. Using a copy of VMware ...
Robert Haas
Jun 16, 2010 at 7:47 pm
Jun 17, 2010 at 4:43 pm -
As it was reported before, we have an open item about leaky VIEWs for RLS. On the talk at Ottawa, Robert suggested me to post my idea prior to submit a patch. So, I'd like to explain my idea at ...
KaiGai Kohei
Jun 1, 2010 at 8:45 am
Jun 4, 2010 at 2:14 am -
We need to make extensive use of the 'xml_is_well_formed' function provided by the XML2 module. Yet the documentation says that the xml2 module will be deprecated since "XML syntax checking and XPath ...
Mike Berrow
Jun 28, 2010 at 3:03 pm
Jul 12, 2010 at 12:19 pm -
Hmm, GUC_UNIT_KB doesn't seem appropriate anymore. I'd suggest changing the code to match the documentation instead. Shouldn't this be backpatched, or was this a new bug in 9.0? -- Heikki Linnakangas ...
Heikki Linnakangas
Jun 25, 2010 at 2:26 pm
Jul 8, 2010 at 12:32 am -
We currently allow this: postgres=# create table t(a timestamptz not null primary key, check(a now())); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "t_pkey" for table "t" CREATE ...
Magnus Hagander
Jun 30, 2010 at 1:47 pm
Jun 30, 2010 at 11:42 pm -
test_us@workbook=# select has_table_privilege( 'public', 'test', 'SELECT' ); ERROR: role "public" does not exist test_us@workbook=# So there's no way to see if a particular privilege has been granted ...
Jim Nasby
Jun 10, 2010 at 10:13 pm
Oct 13, 2010 at 5:44 am -
Hi, When the trigger file is created while the recovery keeps waiting for the release of the lock by read only queries, it might take a very long time for the standby to become the master. The ...
Fujii Masao
Jun 9, 2010 at 8:47 am
Jul 2, 2010 at 4:13 am -
Because that's the consequences of fooling with pg_control. I committed the PG_CONTROL_VERSION bump that was missing from the patch Robert committed last night, but I wonder whether we shouldn't ...
Tom Lane
Jun 3, 2010 at 2:54 pm
Jun 4, 2010 at 6:43 pm -
Hi, Today, I tried to cancel the change of a tablespace for a table (ALTER TABLE ... SET TABLESPACE). I got the "Cancel request sent" but the query continued and finally succeed. It was a big issue ...
Guillaume Lelarge
Jun 21, 2010 at 4:46 pm
Jul 1, 2010 at 10:31 pm -
(moving to pgsql-hackers) Apparently not :-(. We have two options: 1. Make pg_get_expr() handle arbitrary (possibly even malicious) input gracefully. 2. Restrict pg_get_expr() to superusers only. ...
Heikki Linnakangas
Jun 9, 2010 at 8:44 am
Jun 30, 2010 at 6:14 pm -
I received two errors (described below) in installing 9.0beta2 on Kubuntu 10.04 , RhodiumToad on IRC recommended I post them here. I did not have a 2.x or 3.x python dev installed, but I was really ...
Chris
Jun 23, 2010 at 2:41 am
Jun 29, 2010 at 12:45 am -
Folks, There have been quite a number of fixes since Beta2. If we're going to make a summer release date at all, we need to get moving. Therefore, I propose that we set a beta3 release date for July ...
Josh Berkus
Jun 28, 2010 at 6:30 pm
Jun 30, 2010 at 12:33 am -
Dean Rasheed wrote: ... ... Doesn't seem like a lot of effort to me. You've already laid out most of the exceptions above, although they require a few tweaks. The rules should be: Requires quoting ...
Greg Sabino Mullane
Jun 7, 2010 at 2:00 pm
Jun 9, 2010 at 5:32 pm -
15
LLVM / clang
Hello, I'd like to experiment on compiling postgres with LLVM (either llvm-gcc or clang) on Linux, is it supported ? Where should I start ? Thanks ;)P. Caillaud
Jun 8, 2010 at 10:19 am
Jul 10, 2010 at 10:22 pm -
I misunderstood the earlier discussion on this and didn't realise you were considering committing in this way. For me, this is two patches, not one. I object to one and like the other. There isn't ...
Simon Riggs
Jun 24, 2010 at 7:14 am
Jun 25, 2010 at 5:08 pm -
Hi To be able to asses the performance characteristics of the different wal-related options, I patched pgbench to show the average latency of each individual statement. The idea is to be able to ...
Florian Pflug
Jun 12, 2010 at 3:07 pm
Aug 13, 2010 at 1:51 am -
Hi, I've been working to improve the syntax of the XMLEXISTS function that I put a patch forward for and have been attempting to get my head around how you modify the grammar. I admit I'm not getting ...
Mike Fowler
Jun 9, 2010 at 10:33 am
Aug 5, 2010 at 4:23 am -
I found a term "InvalidXLogRecPtr" in 9.0 docs. http://developer.postgresql.org/pgdocs/postgres/functions-admin.html#FUNCTIONS-RECOVERY-INFO-TABLE I think it should not appear in docs because it's a ...
Takahiro Itagaki
Jun 10, 2010 at 1:46 am
Jun 17, 2010 at 1:37 am -
The docs state, w.r.t. $subject: The password can be provided either in the primary_conninfo string or in a separate ~/.pgpass file on the standby server. I tried this with a database name of ...
Andrew Dunstan
Jun 6, 2010 at 8:42 pm
Jun 14, 2010 at 11:04 am -
(moving to -hackers) I guess I can't really disagree with that. Should we try to document this in some way? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company
Robert Haas
Jun 10, 2010 at 1:29 pm
Jun 30, 2010 at 10:22 pm -
13
About tapes
Hi to all. Please take a look at the initial comment contained into the logtape.c file: http://doxygen.postgresql.org/logtape_8c-source.html Almost at the beginning of that file, it is affirmed that ...Mac_man2005
Jun 18, 2010 at 6:41 pm
Jun 21, 2010 at 7:44 pm -
[ Thread moved to hackers. 8.4.4 RPMs were built with debug flags. ] Uh, where are we on this? Has it been completed? How are people informed about this? Do we need to post to the announce email ...
Bruce Momjian
Jun 13, 2010 at 1:08 am
Jun 14, 2010 at 11:15 pm -
On http://github.com/pbaros/postgres can be seen changes and my attempt to implement materialized views. The first commit to the repository implements following: Materialized view can be created, ...
Pavel Baros
Jun 25, 2010 at 3:13 pm
Jul 8, 2010 at 1:23 pm -
Hello I am testing HS + SR in a system running 9.0beta2. What I am doing is just trying all kind of crazy combinations and see how the system handles them. One of the test I knew was going to fail ...
Rafael Martinez
Jun 12, 2010 at 1:29 am
Jul 2, 2010 at 2:45 am -
All, Selena (and others) have done a terrific job on the Open Items list for 9.0.: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items However, I haven't see much progress in the last 10 days ...
Josh Berkus
Jun 8, 2010 at 5:33 pm
Jun 10, 2010 at 4:01 pm -
I talked to Sybase people about their latest technologies. Many features that shipped with their latest ASE 15.5 product has been in PostgreSQL since many years (like functional indexes, etc). :) One ...
Devrim Gündüz
Jun 30, 2010 at 6:55 pm
Jul 3, 2010 at 7:34 pm -
While testing a fix for the pg_restore issues mentioned a few days ago, I noticed that checkSeek() returns true on my old HPUX box even when the input is in fact not seekable, for instance a pipe. ...
Tom Lane
Jun 27, 2010 at 5:42 pm
Jun 28, 2010 at 3:19 pm -
By consensus, we have removed the new-to-9.0 operator text[] = text[] and renamed the hstore = text[] operator. (The current name is "%", but there is some discussion of "% ", some yet other name, or ...
Robert Haas
Jun 21, 2010 at 4:21 pm
Jun 21, 2010 at 6:23 pm -
[moving from -performance to -hackers; original subject is: PostgreSQL as a local in-memory cache] This seems useful to me so here's a patch to implement it. There didn't seem to be a suitable GUC ...
Robert Haas
Jun 28, 2010 at 12:54 am
Jul 20, 2010 at 12:48 am -
Folks, The PostgreSQL 9.1 Development Plan: http://wiki.postgresql.org/wiki/PostgreSQL_9.1_Development_Plan calls for a ReviewFest to run from the 15th of June (tomorrow) until the start of the first ...
Kevin Grittner
Jun 14, 2010 at 4:25 pm
Jul 8, 2010 at 5:03 pm -
I am curious how could I solve the problem: During refreshing I would like to know, if MV is stale or fresh? And I had an idea: In fact, MV need to know if its last refresh (transaction id) is older ...
Pavel Baros
Jun 12, 2010 at 3:17 pm
Jun 14, 2010 at 6:23 pm -
Hi, I understand this is very early to ask this.. but, is there any tentative timeline has been planned / available for the PostgreSQL 9.1 release, like for the alpha or beta releases before the ...
Pr, Solaiyappan (NSN - IN/Bangalore)
Jun 11, 2010 at 12:10 pm
Jun 14, 2010 at 4:21 pm -
Dear hackers, I have a pretty nasty problem to submit to your careful scrutiny. Please consider the following piece of SQL code: CREATE SCHEMA bar; SET search_path = bar; CREATE FUNCTION bar() ...
Jean-Baptiste Quenot
Jun 17, 2010 at 11:32 am
Jun 18, 2010 at 10:04 am -
Hey, While translating the plperl page from the manual, I found the following sentence: The <varname %_SHARED</varname variable and other global state within the language is public data. Should it be ...
Jehan-Guillaume (ioguix) de Rorthais
Jun 14, 2010 at 7:48 am
Jun 14, 2010 at 6:50 pm -
It looks like the recent keepalives patch won't support MacOS X, because MacOS X does not have the TCP_KEEPIDLE, TCP_KEEPINTVL, and TCP_KEEPCNT socket parameters. It does have this: #define ...
Robert Haas
Jun 28, 2010 at 7:07 pm
Jul 6, 2010 at 9:20 pm -
Hi, I tend to consider it a bug that there's no known way under windows to use the same trick as under Unix by using '/usr/bin/true' as your archive command. And this Unix trick itself does feel like ...
Dimitri Fontaine
Jun 14, 2010 at 10:39 am
Jul 5, 2010 at 9:52 am -
I have a short list of modules that have been built without respecting my LDFLAGS and/or LDFLAGS_SL. They are as follows: autoinc.so citext.so earthdistance.so insert_username.so isn.so lo.so ...
Aaron W. Swenson
Jun 27, 2010 at 12:13 pm
Jul 3, 2010 at 10:41 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 131 |
posts | 1,560 |
users | 133 |
website | postgresql.org... |
irc | #postgresql |
133 users for June 2010
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)