Search Discussions

180 discussions - 2,039 posts

  • I'm not clear on why there's all this doom and gloom about how 8.2 will be "merely" a performance-oriented release, with few new features, eg ...
    Tom LaneTom Lane
    Aug 4, 2006 at 3:54 am
    Aug 22, 2006 at 9:22 pm
  • With time, it becomes ever clearer to me that prepared SQL statements are just a really bad idea. On some days, it seems like half the performance problems in PostgreSQL-using systems are because a ...
    Peter EisentrautPeter Eisentraut
    Aug 31, 2006 at 12:01 pm
    Sep 2, 2006 at 10:40 pm
  • Is it time to turn on autovacuum by default in 8.2? I know we wanted to be on the side of caution with 8.1, but perhaps we should evaluate the experiences now. Comments? -- Peter Eisentraut ...
    Peter EisentrautPeter Eisentraut
    Aug 17, 2006 at 4:32 pm
    Sep 3, 2006 at 1:31 am
  • Hello, Dave Cramer and I have dealt with a company today running 8.1.4 on Windows 2003. The application is a web app that runs via JDBC/Hibernate. The application will function perfectly for about ...
    Joshua D. DrakeJoshua D. Drake
    Aug 31, 2006 at 8:47 pm
    Oct 2, 2006 at 6:05 am
  • I have a PostgreSQL installation on a Debian box that had the 64bit SMP kernel installed before PostgreSQL was compiled and installed on it. Does PostgreSQL take any advantage of the 64 bit ...
    Naz GassiepNaz Gassiep
    Aug 20, 2006 at 8:00 pm
    Aug 25, 2006 at 4:32 pm
  • I see fairly nasty problems in the concurrent-index patch when it's trying to build a unique index. I think it's solvable but want some more eyeballs on my reasoning. Look at the code in ...
    Tom LaneTom Lane
    Aug 22, 2006 at 5:26 pm
    Aug 27, 2006 at 7:18 pm
  • Hi Since the discussion about how to force a specific plan has come up, I though I'd post an idea I had for this a while ago. It's not reall well though out yet, but anyway. When the topic of ...
    Florian G. PflugFlorian G. Pflug
    Aug 8, 2006 at 11:55 am
    Aug 26, 2006 at 8:36 pm
  • I think we have other things that demand our attention more than a half-baked feature. regards, tom lane
    Tom LaneTom Lane
    Aug 22, 2006 at 4:09 am
    Aug 24, 2006 at 6:58 pm
  • Oh - so it will not be possible to do an online backup _without_ forcing a WAL switch any more? Laurenz Albe
    Albe LaurenzAlbe Laurenz
    Aug 1, 2006 at 8:16 am
    Aug 16, 2006 at 10:08 pm
  • The is_select_command bit is wrong because it doesn't allow for left parentheses in front of the SELECT keyword (something entirely reasonable when considering big union/intersect/except trees). Also ...
    Tom LaneTom Lane
    Aug 16, 2006 at 5:51 pm
    Aug 24, 2006 at 3:51 am
  • Hello Package contains package's variables, shared protected functions and initialisation part, which is executed when any public function attached to package is called. Every package has defined ...
    Pavel StehulePavel Stehule
    Aug 7, 2006 at 9:44 am
    Aug 9, 2006 at 5:16 pm
  • We've seen more than one report of corruption of PG databases that seemed to be due to the willingness of the RPM init script to run initdb if it thinks the data directory isn't there. This is pretty ...
    Tom LaneTom Lane
    Aug 25, 2006 at 1:20 pm
    Sep 11, 2006 at 8:50 am
  • Since I have a stuck backend without client again, I'll have to kill -SIGTERM a backend. Fortunately, I do have console access to that machine and it's not win32 but a decent OS. For other cases I'd ...
    Andreas PflugAndreas Pflug
    Aug 3, 2006 at 12:48 am
    Aug 18, 2006 at 1:48 pm
  • I have looked over this addition, and I think I finally understand it. Given three tables, A, B, C, which join as A- B, B- C, C- A, you can really join them as A- B- C, and A- C- B. What full ...
    Bruce MomjianBruce Momjian
    Aug 11, 2006 at 4:18 am
    Aug 27, 2006 at 12:36 pm
  • Here is an new XML section for our SGML documentation. It explains the various XML capabilities, if we support them, and how to use them. Comments? ...
    Bruce MomjianBruce Momjian
    Aug 25, 2006 at 11:47 pm
    Aug 27, 2006 at 9:24 am
  • I'm in the process of committing the first version of the ecpg regression test suite to CVS. This is not exactly finished work, but it shows OK on all test on my machine and on Joachim's machine. The ...
    Michael MeskesMichael Meskes
    Aug 2, 2006 at 1:46 pm
    Aug 8, 2006 at 5:24 pm
  • Hi, Is anybody working on Bernd's updatable views patch? Right now I'm having a look at it -- mainly fixing some cosmetic issues right now, intending to eventually do an actual code review. I'll post ...
    Alvaro HerreraAlvaro Herrera
    Aug 13, 2006 at 6:17 am
    Feb 8, 2007 at 11:23 pm
  • Hi there, I guess many - if not most - here have tried pgcluster. For those who didn't, postgresql is pretty much the equivalent of pgcluster configured without load balancer or replicator, in ...
    Chahine HamilaChahine Hamila
    Aug 25, 2006 at 12:40 pm
    Sep 5, 2006 at 2:59 pm
  • At the link: http://www.postgresql.org/docs/8.1/static/source.html It gives some style configuration code to put in the .emacs file. However, when I do that, emacs doesn't appear to follow the style ...
    Jeff DavisJeff Davis
    Aug 10, 2006 at 6:42 pm
    Sep 28, 2006 at 5:41 pm
  • Hi guys Andrew and I got together and worked out a more detailed idea of how we want to add enums to the postgresql core. This follows on from his original enumkit prototype last year [1]. Here's a ...
    Tom DunstanTom Dunstan
    Aug 16, 2006 at 3:54 am
    Aug 23, 2006 at 9:38 am
  • Hi, We have just released an add-on to PostgreSQL supporting the GORDA Architecture and Programming Interface (GAPI). This opens up support for DBMS independent replication middleware, aimed at eager ...
    Alfranio correia juniorAlfranio correia junior
    Aug 4, 2006 at 9:07 am
    Aug 10, 2006 at 10:28 pm
  • We have still another complaint here: http://archives.postgresql.org/pgsql-bugs/2006-08/msg00109.php about pg_dump failing to cope nicely with any slightly-unusual condition related to a SERIAL ...
    Tom LaneTom Lane
    Aug 19, 2006 at 3:48 pm
    Aug 21, 2006 at 8:40 am
  • How often does that case come up in the real world, for tables that are large enough that you'd care about vacuum performance? regards, tom lane
    Tom LaneTom Lane
    Aug 27, 2006 at 4:33 pm
    Sep 5, 2006 at 12:08 am
  • I think a new backslash variable isn't the way to go. I would use a \pset variable to control what is happening. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your ...
    Bruce MomjianBruce Momjian
    Aug 17, 2006 at 4:30 pm
    Aug 28, 2006 at 2:26 pm
  • Why are either of these useful? What are the compatibility implications of changing them? Does the addition of the engine-load code break compatibility with older OpenSSL releases? regards, tom lane
    Tom LaneTom Lane
    Aug 30, 2006 at 2:16 pm
    Sep 7, 2006 at 5:55 pm
  • I think we shall have to reconsider that patch to turn it on by default. So far I've seen two categories of failure: * manual ANALYZE issued by regression tests fails because autovac is analyzing the ...
    Tom LaneTom Lane
    Aug 28, 2006 at 6:33 pm
    Aug 30, 2006 at 4:31 am
  • In view of the other patch submitted to support init/fini functions for shared libraries, I'm inclined to change this one to depend on that; in particular it seems like we could eliminate the ...
    Tom LaneTom Lane
    Aug 8, 2006 at 5:26 pm
    Aug 11, 2006 at 12:17 am
  • I'm in process of reviewing the restartable-recovery patch, http://archives.postgresql.org/pgsql-patches/2006-07/msg00356.php and I'm wondering if we really need to invent a "standby mode" boolean to ...
    Tom LaneTom Lane
    Aug 7, 2006 at 1:48 pm
    Sep 13, 2006 at 8:49 am
  • We just had a complaint on IRC that: devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector; ?column? ---------- f (1 row) and that searches for certain values would not return all ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Aug 24, 2006 at 4:35 pm
    Aug 29, 2006 at 1:59 pm
  • The latest HEAD is segfaulting on startup if I have the following lines in postgresql.conf: custom_variable_classes = 'plperl' plperl.use_strict = on If I comment out the second line then the server ...
    Michael FuhrMichael Fuhr
    Aug 13, 2006 at 12:07 pm
    Aug 16, 2006 at 12:31 am
  • PostgreSQL provides a way to load C extension modules with its internal FMGR. Unfortunately there is no portable way for an extension module to initialize (directly after the pg_dlopen() of the DSO) ...
    Ralf S. EngelschallRalf S. Engelschall
    Aug 2, 2006 at 7:04 pm
    Aug 8, 2006 at 7:40 pm
  • What's the current status of this patch ... has any work been done since the first of the month? I suppose the patch as given here no longer applies to HEAD, because of recent changes in rmgr for ...
    Tom LaneTom Lane
    Aug 15, 2006 at 1:38 am
    Sep 5, 2006 at 10:50 pm
  • Wait a minute. What I thought we had agreed to was a patch to make commands sent with \g use a cursor. This patch changes SendQuery so that *every* command executed via psql is treated this way. ...
    Tom LaneTom Lane
    Aug 28, 2006 at 5:11 pm
    Aug 30, 2006 at 9:40 am
  • What's up there? It has been down all week. We're trying to get the Slony-I 1.2 release out, so we can then migrate over to pgFoundry. But that doesn't working terribly well when gBorg's down... -- ...
    Chris BrowneChris Browne
    Aug 31, 2006 at 2:34 pm
    Sep 7, 2006 at 5:22 pm
  • I have cleaned up this patch a little. I have changed all the function signatures from varchar to text, fixed up the formatting and packaging a little, and renamed it to just "sslinfo". Note to the ...
    Peter EisentrautPeter Eisentraut
    Aug 23, 2006 at 1:55 pm
    Sep 4, 2006 at 8:11 pm
  • You have forgotten the problem of the factor not being exactly representable (eg, things like '10 days' * 0.1 not giving the expected result). Also, as coded this is subject to integer-overflow risks ...
    Tom LaneTom Lane
    Aug 31, 2006 at 6:30 pm
    Sep 1, 2006 at 2:52 pm
  • Hello, I had a customer call in today they are running Win2003 with 22 gig of ram (that may be a mistype on their end, it may be 32gigs of ram). They cranked up their postgresql max_connections to ...
    Joshua D. DrakeJoshua D. Drake
    Aug 9, 2006 at 11:17 pm
    Aug 23, 2006 at 5:34 pm
  • Platypus just started failing... http://pgbuildfarm.org/cgi-bin/show_log.pl?nm=platypus&dt=2006-08-09%2010:05:01 Rest of the farm is looking pretty green, though, so I'm not sure what to make of ...
    Jim C. NasbyJim C. Nasby
    Aug 9, 2006 at 4:08 pm
    Aug 11, 2006 at 2:04 am
  • Hello I suggest enhance plpgsq to simultaneous assignment. Main reason is missing parameter passing by reference and less readable getting values from functions with OUT parameters. Currently I have ...
    Pavel StehulePavel Stehule
    Aug 7, 2006 at 8:08 am
    Aug 8, 2006 at 9:55 pm
  • I was just looking at Martin Lesser's gripe here: http://archives.postgresql.org/pgsql-performance/2006-08/msg00053.php about how the planner is not real bright about the filter conditions it ...
    Tom LaneTom Lane
    Aug 4, 2006 at 6:40 pm
    Aug 8, 2006 at 8:17 am
  • Thanks for mentioning about pgpool! pgpool-II (not pgpool-2, please) does not try to resolve nondeterminism issues but try to add parallel SELECT query execution. Also we will continue to support ...
    Tatsuo IshiiTatsuo Ishii
    Aug 1, 2006 at 10:37 pm
    Aug 3, 2006 at 6:14 pm
  • All, In the spirit of our previous discussion, I am writing to inform you that Mark Cave-Ayland and I will be working on this TODO-item together. We are thinking through a new design (not based on ...
    Jonah H. HarrisJonah H. Harris
    Aug 5, 2006 at 3:12 pm
    Feb 9, 2007 at 5:19 pm
  • I think you will find that $(top_builddir)/$(subdir) is equivalent to "." -- Peter Eisentraut http://developer.postgresql.org/~petere/
    Peter EisentrautPeter Eisentraut
    Aug 28, 2006 at 3:29 am
    Aug 29, 2006 at 10:53 pm
  • seahorse just failed again with one of the dreaded "permission denied" errors we seem to sporadically getting reported on the lists: ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Aug 22, 2006 at 10:03 am
    Aug 24, 2006 at 3:19 am
  • I think this is the same issue discussed here: http://archives.postgresql.org/pgsql-hackers/2004-12/msg00408.php That was just before 8.0 release, so the change got postponed and then seems to have ...
    Tom LaneTom Lane
    Aug 9, 2006 at 10:20 pm
    Aug 10, 2006 at 2:17 pm
  • The restartableRecovery patch introduces the concept of standby_mode, where you define in the recovery.conf file that this server is acting as a log-shipping target. We can extend that concept to a ...
    Simon RiggsSimon Riggs
    Aug 1, 2006 at 12:23 am
    Aug 3, 2006 at 2:33 pm
  • Ah, this looks better. I get clean passes on both HPPA in-tree and Fedora x86_64 VPATH builds, so I think you've finally fixed all the issues. Congrats! regards, tom lane
    Tom LaneTom Lane
    Aug 29, 2006 at 1:38 pm
    Sep 6, 2006 at 4:50 pm
  • Hello, Can we get: Multiple table indexes (for uniqueness across partitions for example) Auto creations of partitions Hash partitioning Key partitioning Sub partitioning Added to the TODO list? ...
    Joshua D. DrakeJoshua D. Drake
    Aug 29, 2006 at 11:32 pm
    Sep 5, 2006 at 4:56 pm
  • This is my first post to a PostgreSQL mailing list, so please forgive me if I have posted to the wrong place Currently pg_dump has flags for dumping only table definitions and/or data. These flags ...
    Naz GassiepNaz Gassiep
    Aug 18, 2006 at 4:39 pm
    Aug 19, 2006 at 7:45 am
  • Hi, sorry if I'm on the wrong list (tell me so!). I'd like to know whether hstore isn't supposed to be in contrib any more and where it is supposed to live nowadays (I was close to file a complaint ...
    Aug 22, 2006 at 4:11 pm
    Sep 5, 2006 at 7:05 pm
Group Navigation
period‹ prev | Aug 2006 | next ›
Group Overview
grouppgsql-hackers @

165 users for August 2006

Tom Lane: 399 posts Bruce Momjian: 178 posts Andrew Dunstan: 111 posts Joshua D. Drake: 101 posts Jim Nasby: 100 posts Peter Eisentraut: 79 posts Alvaro Herrera: 73 posts Martijn van Oosterhout: 49 posts Magnus Hagander: 35 posts Josh Berkus: 34 posts David Fetter: 29 posts Simon Riggs: 28 posts Greg Stark: 27 posts Jonah H. Harris: 27 posts Stark: 25 posts Zoltan Boszormenyi: 23 posts Andreas Pflug: 22 posts Matthew T. O'Connor: 21 posts Stefan Kaltenbrunner: 21 posts Chris Browne: 20 posts
show more