Search Discussions

183 discussions - 2,439 posts

  • I'm happy to see we've crossed the point where the worst of the Hot Standby and Streaming Replication issues are sorted out. A look at the to-do lists: ...
    Greg SmithGreg Smith
    Feb 26, 2010 at 8:33 am
    Mar 11, 2010 at 5:59 am
  • Hi, As you all know, Index Organized tables are a way by which we can automatically cluster the data based on the primary key. While i was thinking about an implementation for postgres, it looks like ...
    Gokulakannan SomasundaramGokulakannan Somasundaram
    Feb 21, 2010 at 7:17 pm
    Mar 2, 2010 at 9:04 am
  • I've been discussing this with Josh, Heikki, and Peter E. over the past few weeks. As Peter observed years ago, prepared statements can perform badly because their plans are overly generic. Also, ...
    Jeroen VermeulenJeroen Vermeulen
    Feb 9, 2010 at 12:09 pm
    Mar 3, 2010 at 5:13 am
  • Simon, Fujii, All: While demoing HS/SR at SCALE, I ran into a problem which is likely to be a commonly encountered bug when people first setup HS/SR. Here's the sequence: 1) Set up a brand new master ...
    Josh BerkusJosh Berkus
    Feb 23, 2010 at 5:45 pm
    Mar 2, 2010 at 1:33 pm
  • My son has brought to my attention that our current crop of Python client libraries is inadequate/confusing. I took a look myself, and asked on our IRC channel, and am now convinced this area needs ...
    Bruce MomjianBruce Momjian
    Feb 5, 2010 at 2:19 pm
    Feb 16, 2010 at 3:56 am
  • http://archives.postgresql.org/pgsql-hackers/2010-01/msg01520.php http://archives.postgresql.org/pgsql-hackers/2010-01/msg02589.php As I pointed out previously, the standby might restore a ...
    Fujii MasaoFujii Masao
    Feb 10, 2010 at 5:06 am
    Mar 31, 2010 at 2:01 am
  • Tollef Fog HeenTollef Fog Heen
    Feb 9, 2010 at 1:25 pm
    Jun 24, 2010 at 2:41 pm
  • Folks, While hacking on PL/Parrot, I ran across an issue where when trying to load PL/pgsql, it's done unconditionally and fails. How do we fix pg_regress to be a little more subtle about this? ...
    David FetterDavid Fetter
    Feb 18, 2010 at 9:51 pm
    Feb 22, 2010 at 2:06 am
  • Hello, I noticed this morning that the k nearest neighbor gist patch https://commitfest.postgresql.org/action/patch_view?id=230 was still being considered for inclusion in 9. Sadly, this feature ...
    Ragi Y. BurhumRagi Y. Burhum
    Feb 11, 2010 at 12:50 am
    Feb 14, 2010 at 6:08 pm
  • Hi, I'm trying to figure out how difficult is this What we need: - a shared catalog - an API for filling the catalog - a scheduler daemon - pg_dump support A shared catalog ------------------------- ...
    Jaime CasanovaJaime Casanova
    Feb 20, 2010 at 9:33 pm
    Mar 2, 2010 at 12:10 am
  • Greetings, hackers! The flurry of patches that vendors have recently been making to OpenSSL to address the potential man-in-the-middle attack during SSL renegotiation have disabled SSL renegotiation ...
    Chris CampbellChris Campbell
    Feb 3, 2010 at 11:25 am
    Feb 25, 2010 at 3:10 pm
  • We want to teach people that Hot Standby and Streaming Replication are two different features. However, Streaming Replication calls its main parameter "standby_mode" which reminds more of Hot Standby ...
    Joachim WielandJoachim Wieland
    Feb 10, 2010 at 11:04 am
    Apr 5, 2010 at 6:45 pm
  • I was recently experimenting with explain analyze and I realized there are two things arguably wrong with the "Buffers" output in explain analyze: Firstly, it's printing out a number of buffers. We ...
    Greg StarkGreg Stark
    Feb 9, 2010 at 7:50 pm
    Feb 11, 2010 at 4:21 am
  • Hi, I'm wondering if we could detect a funcion has a side effect, i.e. does a write to database. This is neccessary for pgpool to decide if a qeury should to be sent to all of databases or not. If a ...
    Tatsuo IshiiTatsuo Ishii
    Feb 23, 2010 at 3:51 am
    Mar 2, 2010 at 10:28 am
  • Consider the following (rather lame) query: rhaas=# explain (verbose) select (select oid from pg_class a where a.oid = b.relfilenode) from pg_class b; QUERY PLAN ...
    Robert HaasRobert Haas
    Feb 20, 2010 at 2:34 am
    Jul 1, 2010 at 5:22 am
  • In connection with the recent discussion of changing SearchSysCache call format, Robert espoused the view that right now is the time when there are a minimal number of outstanding patches that would ...
    Tom LaneTom Lane
    Feb 18, 2010 at 4:34 am
    Feb 26, 2010 at 5:39 pm
  • There was some discussion a few weeks ago about inter-stored-procedure calling from PL/Perl. I thought I'd post the documentation (and tests) for a module I'm working on to simplify calling SQL ...
    Tim BunceTim Bunce
    Feb 12, 2010 at 11:10 pm
    Feb 18, 2010 at 5:50 pm
  • Hi, While playing around with another issue with the patch, I came across the following: = create table foo(a int); CREATE TABLE = with t as (insert into foo values(0)) select * from foo; a --- (0 ...
    Marko TiikkajaMarko Tiikkaja
    Feb 8, 2010 at 7:30 pm
    Feb 14, 2010 at 4:48 am
  • The buildfarm indicates that this patch has got some serious issues. regards, tom lane
    Tom LaneTom Lane
    Feb 15, 2010 at 6:57 am
    Feb 28, 2010 at 7:37 pm
  • I spent many hours on this patch and am attaching an updated version. I have restructured the code and added many comments, but this is the main one: * Ideally, the server encoding and locale ...
    Bruce MomjianBruce Momjian
    Feb 28, 2010 at 4:28 am
    Apr 26, 2010 at 1:32 pm
  • if we can do this, how should it work? Simon said: """ Yes, I think so. Rough design... integrated_user_processes = 'x, y, z' would run x(), y() and z() in their own processes. These would execute ...
    Jaime CasanovaJaime Casanova
    Feb 22, 2010 at 6:34 pm
    Feb 25, 2010 at 5:53 pm
  • With the libpq fixes, I get further (more on that fix later, btw), but now I get stuck in this. When I do something on the master that generates WAL, such as insert a record, and then try to query ...
    Magnus HaganderMagnus Hagander
    Feb 15, 2010 at 3:37 pm
    Feb 22, 2010 at 4:47 am
  • Folks, Would it be worthwhile to light up some buildfarm animals on OpenVMS? http://www.openvms.org/stories.php?story=10/02/09/2319162 Cheers, David. -- David Fetter <david@fetter.org ...
    David FetterDavid Fetter
    Feb 16, 2010 at 8:45 am
    Feb 17, 2010 at 3:14 am
  • This doesn't seem to be a great reason. Letting weird states exist is not a feature, its a risk. Let me explain. This would only happen if a VACUUM FULL had been run on the pre-9.0 database and it ...
    Simon RiggsSimon Riggs
    Feb 11, 2010 at 10:10 am
    Feb 16, 2010 at 8:20 pm
  • We're down to 5 patches remaining, and 1 day remaining, so it's time to try to wrap things up. * Fix large object support in pg_dump. I think this is just waiting for a second opinion on whether the ...
    Robert HaasRobert Haas
    Feb 14, 2010 at 4:35 am
    Feb 18, 2010 at 2:27 am
  • I'm seeing these messages in the standby server log: WARNING: unlogged operation performed, data may be missing HINT: This can happen if you temporarily disable archive_mode without taking a new base ...
    Simon RiggsSimon Riggs
    Feb 1, 2010 at 8:41 am
    Feb 3, 2010 at 10:50 am
  • Hi! This patch enables showing configure status at the end of ./configure run and thus makes ./configure process a bit easier to follow (in the sense of what features are actually enabled). Päikest, ...
    Priit LaesPriit Laes
    Feb 10, 2010 at 6:52 am
    Feb 15, 2010 at 2:36 pm
  • It looks like some recent patches have broken a couple of things on the buildfarm. Mingw builds are missing in6addr_any in backend/libpq/auth.c, added by a recent RADIUS support fix. Looks like we ...
    Andrew DunstanAndrew Dunstan
    Feb 9, 2010 at 1:07 am
    Feb 16, 2010 at 5:08 pm
  • There was a huge earthquake in Chile this morning ... Alvaro, you OK? --Josh Berkus
    Josh BerkusJosh Berkus
    Feb 27, 2010 at 8:28 pm
    Mar 2, 2010 at 1:35 pm
  • It's just taken me 15 minutes to locate the settings for primary_conninfo to better understand Stefan's recent post. The commit referred to here is an extremely bad change. If you intended this to be ...
    Simon RiggsSimon Riggs
    Feb 23, 2010 at 11:24 pm
    Feb 24, 2010 at 7:03 pm
  • So this is what I did about my two complaints earlier about the explain buffer patch. a) Changed the line description to "Total Buffer Usage" which at least hints that it's something more akin to the ...
    Greg StarkGreg Stark
    Feb 15, 2010 at 1:25 am
    Feb 16, 2010 at 4:36 pm
  • Hi, Attached is a documentation patch for writeable CTEs. Most of it is explaining how this feature works in select.sgml. I wasn't sure if that's the right place, but couldn't find a better one. I ...
    Marko TiikkajaMarko Tiikkaja
    Feb 4, 2010 at 4:05 pm
    Feb 10, 2010 at 2:45 pm
  • Hi there, I've been working on a patch to add hostname support to pg_hba.conf. It's not ready for public display yet, but I would just like to run a couple of issues / discussion points past ...
    Bart SamwelBart Samwel
    Feb 11, 2010 at 1:21 pm
    Jul 19, 2010 at 1:28 pm
  • Some more _personalized_ copyright noticed have crept into our source tree: /src/tutorial/basics.source Copyright (c) 1994, Andrew Yu, University of California /contrib/intagg/Makefile Copyright (c) ...
    Bruce MomjianBruce Momjian
    Feb 2, 2010 at 7:38 pm
    Feb 16, 2010 at 8:38 pm
  • Hi, sorry for repost but previous message didn't get through. So I'm trying another list and sending without attachment which I can send privately upon request (strace output mentioned below). We've ...
    Jakub OuhrabkaJakub Ouhrabka
    Feb 16, 2010 at 7:16 am
    Feb 17, 2010 at 7:42 am
  • The proposed new implementation of listen/notify works by shoving all of a transaction's outgoing notifies into the global queue during pre-commit, then sending PROCSIG_NOTIFY_INTERRUPT to listening ...
    Tom LaneTom Lane
    Feb 15, 2010 at 2:31 am
    Feb 16, 2010 at 11:21 pm
  • Right now, log_error_verbosity displays the source code error location in this format: LOCATION: parserOpenTable, parse_relation.c:858 I think it would be clearer to add '()' next to the function ...
    Bruce MomjianBruce Momjian
    Feb 10, 2010 at 11:58 pm
    Feb 12, 2010 at 11:22 pm
  • One glaring issue with the current documentation layout is that the documentation for the various options in recovery.conf is split in two places. The old options, restore_command, recovery_target_* ...
    Heikki LinnakangasHeikki Linnakangas
    Feb 12, 2010 at 9:16 am
    Feb 19, 2010 at 10:10 am
  • Our documentation says listen/notify will return an error if executed on the hot standby server: o LISTEN, UNLISTEN, NOTIFY since they currently write to system tables With the listen/notify system ...
    Bruce MomjianBruce Momjian
    Feb 17, 2010 at 11:45 pm
    Feb 18, 2010 at 4:13 am
  • I tried to set up a simple master/slave setup and immediately ran into this assertion failure. The slave is just a cold copy of the database immediately after initdb. The first WAL segment hasn't ...
    Greg StarkGreg Stark
    Feb 23, 2010 at 2:47 pm
    Feb 26, 2010 at 2:36 pm
  • Hi *, I just wanted all interested people know that psycopg2 2.0.14 to be released in the next few days will be under the LGPL3 + OpenSSL exception (example code and tests under the LGPL3 alone ...
    Federico Di GregorioFederico Di Gregorio
    Feb 14, 2010 at 1:20 am
    Feb 16, 2010 at 3:55 pm
  • Not happy with these changes without discussion. * "entering standby mode" isn't a more informative message. Two people have already said on-list that "standby mode" name might need to be changed. ...
    Simon RiggsSimon Riggs
    Feb 12, 2010 at 2:46 pm
    Feb 15, 2010 at 7:33 am
  • Hi, I am trying to checkout code from different branches (such as 8.3, 8.4). I found a few ways to checkout code from CVS: 1. webCVS: http://anoncvs.postgresql.org/cvsweb.cgi/ 2. cvs -z3 -d ...
    M ZM Z
    Feb 9, 2010 at 3:24 am
    Feb 10, 2010 at 3:54 am
  • I see that lazy_vacuum_rel() truncates the heap before it does vacuuming of the free space map. Once upon a time this wouldn't have mattered, but now it means that cancel interrupts are likely to be ...
    Tom LaneTom Lane
    Feb 8, 2010 at 5:31 pm
    Feb 9, 2010 at 1:54 am
  • Hi all, I know it is late in the cycle, but I still think that the current behaviour of ERRORing during execution of a query but FATALing during IDLE IN TRANSACTION is very confusing to the user. ...
    Andres FreundAndres Freund
    Feb 13, 2010 at 9:41 pm
    Apr 19, 2010 at 4:48 pm
  • Hello list, I'm wondering if there would be community support for adding using the execute message with a rownum 0 in the c libpq client library, as it is used by the jdbc driver with setFetchSize. ...
    Yeb HavingaYeb Havinga
    Feb 26, 2010 at 8:28 pm
    Mar 22, 2010 at 8:21 am
  • I have two 9.0devel machines (*not* alpha but cvs as of 2010.02.19 22.48). One primary, one slave. In an attempt to keep track of standby progression (versus primary), I ran slave-side: replicas=# ...
    Erik RijkersErik Rijkers
    Feb 24, 2010 at 7:40 pm
    Mar 8, 2010 at 1:27 pm
  • With the following settings custom_variable_classes = 'auto_explain' auto_explain.log_min_duration = 0 auto_explain.log_format = 'xml' auto_explain.log_analyze = on auto_explain.log_verbose = on ...
    Andrew DunstanAndrew Dunstan
    Feb 16, 2010 at 3:41 pm
    Feb 20, 2010 at 3:46 pm
  • Hello, Testing 9.0devel HS/SR: I used cvs HEAD (today) with the new_smart_shutdown_20100201.patch of Fujii Masao. Replication works well. The slave can be stopped and restarted. However, whenever ...
    Erik RijkersErik Rijkers
    Feb 3, 2010 at 9:40 pm
    Feb 12, 2010 at 9:55 am
  • We have an optimization to bulkload date in pg_restore, but the code only works in parallel restore (--jobs = 2). Why don't we do the same optimization in the serial restore (--jobs = 1) ? We checks ...
    Takahiro ItagakiTakahiro Itagaki
    Feb 10, 2010 at 2:55 am
    Jul 15, 2010 at 2:49 am
Group Navigation
period‹ prev | Feb 2010 | next ›
Group Overview
grouppgsql-hackers @

148 users for February 2010

Tom Lane: 360 posts Robert Haas: 245 posts Bruce Momjian: 191 posts Heikki Linnakangas: 116 posts Simon Riggs: 90 posts Alvaro Herrera: 81 posts Fujii Masao: 77 posts Josh Berkus: 62 posts Greg Smith: 55 posts Magnus Hagander: 55 posts Andrew Dunstan: 54 posts Gokulakannan Somasundaram: 48 posts Greg Stark: 46 posts Andres Freund: 37 posts Dimitri Fontaine: 37 posts Takahiro Itagaki: 37 posts David E. Wheeler: 33 posts Tim Bunce: 31 posts Jeff Davis: 30 posts Boszormenyi Zoltan: 28 posts
show more