FAQ

PostgreSQL > pgsql-hackers > June 2010

Search Discussions

131 discussions - 1,560 posts

  • 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 HaasRobert 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 ItagakiTakahiro 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 MasaoFujii 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 ZoltanBoszormenyi 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 MasaoFujii 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 HaasRobert 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 IshiiTatsuo 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 DunstanAndrew 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 KoheiKaiGai 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 EisentrautPeter 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 HaganderMagnus 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 GrittnerKevin 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 HaasRobert 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 HaasRobert 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 KoheiKaiGai 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 BerrowMike 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 LinnakangasHeikki 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 HaganderMagnus 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 NasbyJim 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 MasaoFujii 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 LaneTom 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 LelargeGuillaume 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 LinnakangasHeikki 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 ...
    ChrisChris
    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 BerkusJosh 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 MullaneGreg Sabino Mullane
    Jun 7, 2010 at 2:00 pm
    Jun 9, 2010 at 5:32 pm
  • 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. CaillaudP. 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 RiggsSimon 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 PflugFlorian 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 FowlerMike 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 ItagakiTakahiro 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 DunstanAndrew 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 HaasRobert Haas
    Jun 10, 2010 at 1:29 pm
    Jun 30, 2010 at 10:22 pm
  • 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_man2005Mac_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 MomjianBruce 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 BarosPavel 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 MartinezRafael 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 BerkusJosh 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üzDevrim 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 LaneTom 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 HaasRobert 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 HaasRobert 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 GrittnerKevin 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 BarosPavel 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)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 QuenotJean-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 RorthaisJehan-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 HaasRobert 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 FontaineDimitri 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. SwensonAaron W. Swenson
    Jun 27, 2010 at 12:13 pm
    Jul 3, 2010 at 10:41 pm
Jun 2010
123
Group Navigation
period‹ prev | Jun 2010 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions131
posts1,560
users133
websitepostgresql.org...
irc#postgresql

133 users for June 2010

Robert Haas: 251 posts Tom Lane: 239 posts Bruce Momjian: 84 posts Simon Riggs: 67 posts Heikki Linnakangas: 65 posts Fujii Masao: 64 posts Josh Berkus: 49 posts Kevin Grittner: 49 posts Andrew Dunstan: 48 posts Greg Stark: 43 posts KaiGai Kohei: 41 posts Magnus Hagander: 38 posts Peter Eisentraut: 32 posts David E. Wheeler: 28 posts Florian Pflug: 27 posts Stephen Frost: 26 posts Takahiro Itagaki: 25 posts Alvaro Herrera: 24 posts Dimitri Fontaine: 21 posts Jan Wieck: 18 posts
show more
Archives