FAQ

PostgreSQL > pgsql-hackers > May 2009

Search Discussions

143 discussions - 1,518 posts

  • [moving this onto -hackers, where I think it belongs] Tom Lane wrote: It appears that our git repo is only picking up the branch tags (e.g. REL8_0_STABLE) , not all the release tags (e.g. REL8_0_5) . ...
    Andrew DunstanAndrew Dunstan
    May 26, 2009 at 2:40 pm
    Jun 13, 2009 at 4:19 pm
  • While discussing potential changes to PostgreSQL documentation of transaction isolation levels, Emmanuel Cecchet pointed out an intriguing new paper[1] on a new algorithm to provide true serializable ...
    Kevin GrittnerKevin Grittner
    May 5, 2009 at 3:54 pm
    Jan 13, 2010 at 11:12 pm
  • hello everybody, i would like to propose an extension to our SELECT FOR UPDATE mechanism. especially in web applications it can be extremely useful to have the chance to terminate a lock after a ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    May 11, 2009 at 8:48 am
    Feb 19, 2010 at 9:51 pm
  • Hi, Preliminary note: I'm using the term "extension" as if it's what we already agree to call them, feel free to ignore this and use whatever term you see fit. We'll have the naming issue tackled, ...
    Dimitri FontaineDimitri Fontaine
    May 25, 2009 at 9:17 am
    Jun 1, 2009 at 7:46 pm
  • Well, here we are! Yet another thread about some piece of information that's omitted from EXPLAIN and can't easily be added because there are a zillion things we want to add to EXPLAIN and it's not ...
    Robert HaasRobert Haas
    May 24, 2009 at 12:47 am
    May 27, 2009 at 1:42 pm
  • I want to try to get agreement that it would be a good idea to implement serializable transactions, and what that would look like from the user side. At this point, we should avoid discussions of ...
    Kevin GrittnerKevin Grittner
    May 27, 2009 at 8:35 pm
    Jun 4, 2009 at 11:10 pm
  • bytea columns, people often complaining about a) size and b) duration of the dump. That latter occurred recently to me, a customer would like to dump large tables (approx. 12G in size) with pg_dump, ...
    Bernd HelmleBernd Helmle
    May 5, 2009 at 11:08 am
    Aug 4, 2009 at 4:48 pm
  • I found out at PGCon that the internal format of tsvector changed slightly from 8.3 to 8.4. Teodor gave me a conversion function and I have adjusted pg_migrator to install a v8_3_tsvector data type ...
    Bruce MomjianBruce Momjian
    May 26, 2009 at 1:45 am
    Jun 1, 2009 at 4:02 pm
  • Sorry about this, but I don't agree with that fix and think it needs more discussion, at very least. (I'm also not sure why this fix needs to applied with such haste, even taking priority over other ...
    Simon RiggsSimon Riggs
    May 7, 2009 at 1:06 pm
    May 16, 2009 at 8:02 am
  • I am seeing Postgres 8.3.7 running as a service on Windows Server 2003 repeatedly fail to restart after a backend crash because of the following code in port/win32_shmem.c: /* * If the segment ...
    Andrew DunstanAndrew Dunstan
    May 1, 2009 at 6:59 am
    May 5, 2009 at 9:50 am
  • Hello all. Please, approve my ideas for implementation. Standart has feature T431: Extended grouping capabilities. This feature i found in TODO-list: http://wiki.postgresql.org/wiki/Todo - SQL ...
    Олег ЦаревОлег Царев
    May 10, 2009 at 12:57 pm
    Sep 4, 2009 at 3:19 am
  • Attached patch cleanups hash index headers to allow compile hasham for 8.3 version. It helps to improve pg_migrator with capability to migrate database with hash index without reindexing. I discussed ...
    Zdenek KotalaZdenek Kotala
    May 22, 2009 at 8:21 pm
    May 26, 2009 at 7:25 pm
  • Hello, I have been doing some testing with pgbench and I realized that it forces the use of public as its search_path. This is bad if: * You want to run multiple pgbench instances within the same ...
    Joshua D. DrakeJoshua D. Drake
    May 5, 2009 at 10:04 pm
    May 8, 2009 at 7:11 pm
  • Hi, I think that can be useful the command \di on psql show the method of index (hash, btree, ...) like: test=# \di List of relations Schema | Name | Type | Owner | Table | Method ...
    Ricardo BessaRicardo Bessa
    May 8, 2009 at 8:27 pm
    Jul 6, 2009 at 5:02 pm
  • While trying to test Tom's theory about Windows not being able to reinitialise shared memory when a backend crashes, I was doing some testing on my Vista box. I killed a backend using the task ...
    Andrew DunstanAndrew Dunstan
    May 2, 2009 at 7:14 pm
    May 5, 2009 at 5:00 pm
  • Patch for plpythonu Primary motivation of the attached patch is to support handling bytea conversion allowing for embedded nulls, which in turn allows for supporting the marshal module. Secondary ...
    Caleb WeltonCaleb Welton
    May 26, 2009 at 11:28 pm
    Sep 9, 2009 at 9:45 pm
  • I was just talking to Bruce about his results from testing pg_migrator, and we realized there are a couple of changes that we need to slip into the core code before 8.4 goes final. 1. pg_dumpall ...
    Tom LaneTom Lane
    May 7, 2009 at 4:05 pm
    May 8, 2009 at 9:55 pm
  • Hello, Here is a diff of version_stamp.pl. It is not quite done as I can't actually get it to run. No matter what I do it doesn't appear to be able to open configure.in. If someone could help me ...
    Joshua D. DrakeJoshua D. Drake
    May 8, 2009 at 9:16 pm
    Feb 26, 2010 at 12:02 am
  • Hi, FORCE QUOTE option of COPY WITH CSV requires an explicit column list, but '*' (all columns) would be also useful for typical usages. I searched the ML archive and found one request before: The ...
    Itagaki TakahiroItagaki Takahiro
    May 12, 2009 at 5:14 am
    Jul 25, 2009 at 12:08 am
  • Yesterday Jignesh Shah presented his extensive benchmark results comparing 8.4-beta1 with 8.3.7 at PGCon: http://blogs.sun.com/jkshah/entry/pgcon_2009_performance_comparison_of While most cases were ...
    Greg SmithGreg Smith
    May 22, 2009 at 4:27 pm
    Jun 7, 2009 at 4:50 pm
  • Hello, This patch is intended to supplement Pavel's patch for named and mixed notation support in 8.5. This patch makes it so a plpgsql function can call another function with the same parameter ...
    Steve PrenticeSteve Prentice
    May 21, 2009 at 5:32 pm
    Sep 14, 2009 at 4:10 pm
  • As we discussed at pgcon2009 there are some changes/fixes necessary in information_schema.columns to allow correct work of applications and services via OLEDB on Windows. Here are some: 1. data_type ...
    Konstantin IzmailovKonstantin Izmailov
    May 22, 2009 at 3:34 pm
    Jul 7, 2009 at 6:43 pm
  • I use pgTAP to make sure my functions produce the correct errors using throws_ok(). So when I get an error from a plpgsql function, it looks like this: ERROR: upper bound of FOR loop cannot be null ...
    Kevin FieldKevin Field
    May 28, 2009 at 7:09 pm
    Jun 1, 2009 at 5:40 pm
  • I tried to run msgfmt -v ... on solaris and I got following error: Processing file "psql-cs.po"... GNU PO file found. Generating the MO file in the GNU MO format. Processing file "psql-cs.po"... ...
    Zdenek KotalaZdenek Kotala
    May 25, 2009 at 4:10 pm
    May 28, 2009 at 6:06 am
  • Greetings, I've run into an annoying issue which I would think could be handled better. Basically, indexes using text_pattern_ops don't work with some complex regexps even when they (imv anyway) ...
    Stephen FrostStephen Frost
    May 6, 2009 at 2:52 pm
    May 6, 2009 at 9:00 pm
  • Hello. PostgreSQL is very fast when we perform (even on a huge table) ALTER TABLE ... ADD COLUMN ... NULL; (nullable without a default value). This is because of NULL bitmap in tuples. And it's ...
    Dmitry KoterovDmitry Koterov
    May 21, 2009 at 8:06 am
    May 28, 2009 at 4:17 pm
  • I had a situation where I needed to connect to multiple postgresql servers in a variety of programs written in a variety of languages, including some which connected to multiple servers at the same ...
    Seth RobertsonSeth Robertson
    May 8, 2009 at 4:02 pm
    May 11, 2009 at 5:05 pm
  • Hi, Would a patch adding 'IF EXISTS' support to: - ALTER TABLE ... DROP COLUMN - ALTER TABLE ... DROP CONSTRAINT possibly be accepted? Having it makes the annoying task of writing/testing of ...
    Andres FreundAndres Freund
    May 4, 2009 at 2:18 pm
    Jul 20, 2009 at 2:46 am
  • Just wanted to check some thoughts about how memory allocation works in complex queries. Been thinking some more about recent Solaris testing results that *seemed* to show issues with multiple ...
    Simon RiggsSimon Riggs
    May 19, 2009 at 11:29 am
    May 21, 2009 at 6:58 am
  • Andrew, Tom, Just wanted to remark on my tests of this feature since the last set of patches. First of all, no locking. Yay. Andrew's latest algorithm tends to result in building indexes on the same ...
    Josh BerkusJosh Berkus
    May 15, 2009 at 4:15 am
    Mar 1, 2010 at 9:22 am
  • This is a WIP patch (for the TODO item in the subject) that I'm putting in the Commit Fest queue for 8.5. regards... -- Dickson S. Guedes mail/xmpp: guedes@guedesoft.net - skype: guediz ...
    Dickson S. GuedesDickson S. Guedes
    May 7, 2009 at 2:30 am
    Jul 29, 2009 at 9:28 pm
  • Some feedback 1. Want some very clear and supported way to know whether Postgres is fully up. Currently, if you write _PG_init you sometimes need to know if it is being executed by LOAD or as a ...
    Simon RiggsSimon Riggs
    May 20, 2009 at 6:48 pm
    Jul 6, 2009 at 8:52 am
  • We currently have a (really handy) facility to pull a message from the archives by message-ID, eg: ...
    Robert HaasRobert Haas
    May 21, 2009 at 4:10 am
    Jun 28, 2009 at 1:49 am
  • The docs contain the following sage advice concerning from_collapse_limit: "It is usually wise to keep this less than geqo_threshold." I've been thinking through this advice on and off for about 2 ...
    Robert HaasRobert Haas
    May 21, 2009 at 3:40 am
    Jun 2, 2009 at 5:39 pm
  • I am in the middle of helping a customer recover from a situation where a tablespace was missing when a machine was rebooted and postgres restarted, and I'm wondering if we should not have some sort ...
    Andrew DunstanAndrew Dunstan
    May 31, 2009 at 5:09 pm
    May 31, 2009 at 8:09 pm
  • I have always assumed that there is some very good reason why EXPLAIN ANALYZE reports the number of rows as an integer rather than a floating point value, but in reading explain.c it seems that the ...
    Robert HaasRobert Haas
    May 29, 2009 at 1:30 am
    Jun 2, 2009 at 2:57 pm
  • I have a Sun blade 1000 that's just collecting dust now days. I was wondering if there were any pg-hackers that could find use for it. Its dual UltraSPARC III 750 (I think) and has two 36? gig fiber ...
    Andy ColsonAndy Colson
    May 28, 2009 at 1:52 am
    May 29, 2009 at 2:45 am
  • In a thread on -perform it has been observed that our Read-Only scalability is not as good as it could be. One problem being that we need to scan the whole of the ProcArray to derive a snapshot, ...
    Simon RiggsSimon Riggs
    May 14, 2009 at 4:59 pm
    May 17, 2009 at 10:11 pm
  • Hi, I have a script that automatically generates the SQL to create some views. I'd like it to check whether its generated SQL matches the SQL returned by "select definition from pg_views where...". ...
    KevKev
    May 13, 2009 at 3:59 pm
    May 14, 2009 at 6:59 pm
  • Hi, sitting here on my flight back I went through the list of all warnings gcc spits out when using -Wextra. There are a whole lot of them (~ 1700) that mostly (except one) fall into one of four ...
    Michael MeskesMichael Meskes
    May 25, 2009 at 10:07 am
    Jun 3, 2009 at 3:04 pm
  • I attached another cleanup patch which fixes following warnings reported by Sun Studio: "zic.c", line 1534: warning: const object should have initializer: tzh0 "dynloader.c", line 7: warning: empty ...
    Zdenek KotalaZdenek Kotala
    May 28, 2009 at 9:11 am
    May 29, 2009 at 4:17 pm
  • Back in January, there was some discussion of creation a web application to make it easier to manage CommitFests. http://archives.postgresql.org/message-id/20090127134245.GA6444@alvh.no-ip.org This ...
    Robert HaasRobert Haas
    May 27, 2009 at 1:19 am
    May 27, 2009 at 11:30 am
  • One of the talks at PGCon (update in place?) recommended running vacuumdb -z to analyze all tables to rebuild statistics. Problem with that is it also vacuums everything. ISTM it'd be useful to be ...
    DecibelDecibel
    May 24, 2009 at 2:31 am
    Feb 26, 2010 at 4:15 am
  • Hi -hackers, A customer of us recently wanted to separate user errors from system errors as different teams are working on these 2 types of errors and while they might want to ignore user errors ...
    Guillaume SmetGuillaume Smet
    May 10, 2009 at 12:32 pm
    Jul 3, 2009 at 10:54 pm
  • Hi all, A long long time ago (in 2004) I ran a series of tests surveying the results of changing BLCKSZ when it was used for both the WAL logs and the rest of the database system: ...
    Mark WongMark Wong
    May 27, 2009 at 2:51 am
    May 28, 2009 at 7:15 am
  • OK - done, and thanks for the search tip. I still stand by my original comment. I think there is no semantic question about what CREATE IF NOT EXISTS ought to do. It ought to create the object if it ...
    Robert HaasRobert Haas
    May 6, 2009 at 1:29 am
    May 7, 2009 at 1:48 pm
  • Hello! This is a patch that allows choosing not to dump the data for the selected tables. The intended usage is to make backups smaller and faster, by allowing skipping unneeded data, while still ...
    Vadim TrochinskyVadim Trochinsky
    May 1, 2009 at 8:36 am
    May 1, 2009 at 10:09 pm
  • Hi, The following documentation page explains the GiST API to extensions authors: http://www.postgresql.org/docs/current/static/gist-implementation.htm I think we should be a little more verbose, and ...
    Dimitri FontaineDimitri Fontaine
    May 1, 2009 at 2:41 am
    Jun 13, 2009 at 7:12 am
  • The attached addresses items#2 and 3 as listed by Bruce here: http://momjian.us/cgi-bin/pgsql/joe I think it is consistent with the discussions we had a PGCon last week. Any objections to me ...
    Joe ConwayJoe Conway
    May 27, 2009 at 1:51 am
    Jun 2, 2009 at 11:08 pm
  • Hi, Re-opening the discussion related to triggers to promote standby server. In the earlier dicussion, there were 2 proposals, Trigger based on file and trigger based on signals. I think there was no ...
    K, Niranjan (NSN - IN/Bangalore)K, Niranjan (NSN - IN/Bangalore)
    May 4, 2009 at 2:37 pm
    May 27, 2009 at 3:00 pm
May 2009
123
Group Navigation
period‹ prev | May 2009 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions143
posts1,518
users136
websitepostgresql.org...
irc#postgresql

136 users for May 2009

Tom Lane: 284 posts Robert Haas: 107 posts Simon Riggs: 79 posts Andrew Dunstan: 76 posts Peter Eisentraut: 57 posts Heikki Linnakangas: 54 posts Kevin Grittner: 53 posts Alvaro Herrera: 50 posts Bruce Momjian: 46 posts Greg Stark: 45 posts Pavel Stehule: 36 posts Josh Berkus: 31 posts Dimitri Fontaine: 28 posts Magnus Hagander: 28 posts Zdenek Kotala: 28 posts David E. Wheeler: 26 posts Aidan Van Dyk: 22 posts Andres Freund: 22 posts Greg Stark: 19 posts Joshua D. Drake: 19 posts
show more
Archives