Search Discussions
-
[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 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 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ö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 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 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 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 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 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 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 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 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. 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 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 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 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 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. 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 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 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 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 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 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 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 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 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 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 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 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 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. 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 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 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 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 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 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 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 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...". ...
Kev
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 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 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 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 ...
Decibel
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 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 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 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 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 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 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)
May 4, 2009 at 2:37 pm
May 27, 2009 at 3:00 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 143 |
posts | 1,518 |
users | 136 |
website | postgresql.org... |
irc | #postgresql |
136 users for May 2009
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)