Search Discussions
-
Hello hackers, I submit a patch to rectify the weird and confusing quirk of Postgres to use "zero dimensions" to signify an empty array. Rationale: The concept of an array without dimensions is a) ...
Brendan Jurd
Mar 20, 2013 at 11:46 pm
Apr 9, 2013 at 2:16 am -
Hello all, Sorry if this is a naive question. I was going through Greg Smith's slides on buffer cache(http://www.westnet.com/~gsmith/content/postgresql/InsideBufferCache.pdf). When going through the ...
Atri Sharma
Mar 22, 2013 at 4:52 am
Apr 9, 2013 at 7:07 am -
This was a surprising commit. Does this get us any closer to merging postgresql.conf and recovery.conf? - Heikki
Heikki Linnakangas
Mar 27, 2013 at 12:12 pm
Mar 31, 2013 at 9:20 pm -
vacuum_delay is designed to slow down VACUUMs from writing too many blocks. However, SELECTs also dirty data blocks but are NOT slowed down by vacuum_delay. So the current situation is that a large ...
Simon Riggs
Mar 24, 2013 at 11:14 am
Mar 26, 2013 at 5:50 pm -
This behavior surprised me a bit: david=# select '{"foo": 1, "foo": 2}'::json; json ---------------------- {"foo": 1, "foo": 2} I had expected something more like this: david=# select '{"foo": 1, ...
David E. Wheeler
Mar 7, 2013 at 7:49 pm
Mar 13, 2013 at 8:50 pm -
Using HEAD's pg_dump, I see "pg_dump -s regression" taking 5 seconds. On the other hand, running the same executable against the regression database on a 9.2 postmaster takes 1.2 seconds. Looks to me ...
Tom Lane
Mar 26, 2013 at 8:22 pm
Apr 6, 2013 at 12:09 am -
Hi, If failures happen with CREATE INDEX CONCURRENTLY, the system will be let with invalid indexes. I don't think that the user would like to see invalid indexes of an existing system being recreated ...
Michael Paquier
Mar 20, 2013 at 2:51 am
Mar 31, 2013 at 2:21 am -
All, Marty's issue w/ NestLoop reminded me that I'd put together a test case which illustrates a HashJoin doing the wrong thing. The test case is here: http://snowman.net/~sfrost/test_case.sql Simply ...
Stephen Frost
Mar 28, 2013 at 11:56 pm
Apr 13, 2013 at 3:06 am -
One of the core problems for a writable-foreign-tables feature is how to identify a previously-fetched row for UPDATE or DELETE actions. In an ordinary Postgres table, we use the ctid system column ...
Tom Lane
Mar 6, 2013 at 12:30 am
Mar 13, 2013 at 3:35 pm -
I'm getting an assertion failure in HEAD with materialized views, see below for backtrace. To reproduce, just run make installcheck, dump the regression database and then restore it, the server ...
Joachim Wieland
Mar 5, 2013 at 12:50 pm
Mar 22, 2013 at 7:47 pm -
If you try running pg_upgrade with the PGSERVICE environment variable set to some invalid/non-existent service pg_upgrade segfaults Program received signal SIGSEGV, Segmentation fault ...
Steve Singer
Mar 18, 2013 at 4:08 pm
Mar 28, 2013 at 9:17 pm -
I was just looking into why the -DCLOBBER_CACHE_ALWAYS buildfarm critters aren't managing to run the new "timeouts" isolation test successfully, despite very generous timeouts. The answer is that 2 ...
Tom Lane
Mar 20, 2013 at 6:02 pm
Mar 25, 2013 at 7:51 pm -
The issue is the behavior of the PostgreSQL server. "openssl verify" is germane only in that it points to the source of the problem -- OpenSSL's insistence on ultimately validating all certificates ...
Ian Pilcher
Mar 9, 2013 at 8:52 am
Mar 21, 2013 at 5:43 am -
Our final 9.3 commit-fest has has exceeded the two-month mark, so it is time to start targeting a date to close it and get to 9.3 beta. I see 25 items will needing attention before we can close it ...
Bruce Momjian
Mar 29, 2013 at 2:15 pm
Apr 2, 2013 at 9:02 pm -
True; how about this patch. Yours, Laurenz Albe
Albe Laurenz
Mar 1, 2013 at 12:01 pm
Mar 6, 2013 at 2:24 pm -
Hi all! I finally started to investigate why spoonbill stopped reporting to the buildfarm feedback about 2 months ago. It seems that the foreign-keys locking patch (or something commity very close to ...
Stefan Kaltenbrunner
Mar 26, 2013 at 6:50 pm
Apr 4, 2013 at 12:18 am -
Hi, I found that the regression test failed when I created the database cluster with the checksum and set wal_level to archive. I think that there are some bugs around checksum feature. Attached is ...
Fujii Masao
Mar 25, 2013 at 5:51 pm
Apr 3, 2013 at 7:15 pm -
Hi, if I understand things correctly REFRESH MATERIALIZED VIEW locks the materialized view with an AcessExclusiveLock even if the view already contains data. I am pretty sure that will - ...
Andres Freund
Mar 7, 2013 at 5:30 pm
Mar 8, 2013 at 6:33 pm -
Revisiting: http://www.postgresql.org/message-id/45661BE7.4050205@paradise.net.nz I think the reasons which the numeric average was slow were: (1) Using Numeric for count, which is slower than int8 ...
Hadi Moshayedi
Mar 16, 2013 at 4:15 am
Mar 20, 2013 at 4:45 pm -
(reposting" apparently I used a verboten word the first time around <sigh . Sorry for any duplicates) The -t and -n options of pg_dump do not dump anything from an extension configuration table, ...
Joe Conway
Mar 8, 2013 at 10:08 pm
Apr 6, 2013 at 11:49 pm -
For Dimitri's patch to add support for dropped objects in event triggers, there's an open question about how to report objects that are being dropped in a tabular format. What I proposed last had ...
Alvaro Herrera
Mar 18, 2013 at 8:03 pm
Mar 20, 2013 at 9:22 pm -
I spotted some low-hanging fruit in the pglz compression routine. It uses a hash table to keep track of string prefixes it has seen: #define PGLZ_HISTORY_LISTS 8192 /* must be power of 2 */ #define ...
Heikki Linnakangas
Mar 1, 2013 at 3:28 pm
Mar 19, 2013 at 5:28 am -
Hackers, This surprised me: david=# select array_length('{}'::text[], 1); array_length -------------- [null] I had expecte dit to retur 0. I might expect NULL for a NULL param, but not one that's ...
David E. Wheeler
Mar 15, 2013 at 9:56 pm
Mar 17, 2013 at 4:41 am -
Hi, When I accessed the materialized view in the standby server, I got the following ERROR message. Looks odd to me. Is this a bug? ERROR: materialized view "hogeview" has not been populated HINT ...
Fujii Masao
Mar 4, 2013 at 9:45 pm
Mar 26, 2013 at 3:26 pm -
Over the weekend, KDE came within a gnat's eyelash of losing *all* their authoritative git repos, despite having seemingly-extensive redundancy. Read about it here ...
Tom Lane
Mar 24, 2013 at 3:52 pm
Apr 4, 2013 at 1:36 am -
I would think that text_pattern_ops would work, no? Best, David
David E. Wheeler
Mar 20, 2013 at 5:45 am
Apr 2, 2013 at 5:50 pm -
Hm, this is exactly what I removed yesterday, because it makes the build fail outright on old gcc: gcc -O1 -Wall -Wmissing-prototypes -Wpointer-arith -Wformat-security -fno-strict-aliasing -g ...
Tom Lane
Mar 25, 2013 at 1:36 pm
Mar 27, 2013 at 4:20 pm -
What we want to do is make recovery parameters into GUCs, allowing them to be reset by SIGHUP and also to allow all users to see the parameters in use, from any session. The existing mechanism for ...
Simon Riggs
Mar 28, 2013 at 3:49 pm
Apr 1, 2013 at 11:52 am -
It struck me while looking at the regression test arrangements for postgres_fdw that as things are set up, the default username for outgoing connections is going to be that of the operating system ...
Tom Lane
Mar 22, 2013 at 4:19 pm
Mar 28, 2013 at 12:36 pm -
From my usage and http://www.postgresql.org/docs/9.2/interactive/sql-createtable.html I see that Postgres requires constraints like unique (and primary) keys, and foreign keys, to range over at least ...
Darren Duncan
Mar 25, 2013 at 3:29 am
Mar 27, 2013 at 9:56 am -
I realize that this isn't terribly critical, but I'd like to suggest that commit_delay be made PGC_SIGHUP on 9.3 (it's currently PGC_USERSET). It's not that a poorly chosen commit_delay setting has ...
Peter Geoghegan
Mar 20, 2013 at 9:50 pm
Mar 22, 2013 at 12:47 pm -
AFAICT, there's a bug in tm2timestamp(). You can't do this: postgres=# select '1999-12-31T24:00:00'::timestamptz; ERROR: timestamp out of range: "1999-12-31T24:00:00" But that's a perfectly legal ...
Magnus Hagander
Mar 4, 2013 at 1:38 pm
Mar 6, 2013 at 7:57 pm -
Folks, I'd like to add a new CF status, "Pending Discussion". This status would be used for patches which have long discussions regarding syntax or difficult functionality on this list which must be ...
Josh Berkus
Mar 3, 2013 at 9:32 pm
Mar 5, 2013 at 2:59 pm -
Hi hackers, While I was working on my empty array patch I was frequently irritated by the absence of an array_length(anyarray). The same goes for array_upper and array_lower. Most of the time when I ...
Brendan Jurd
Mar 21, 2013 at 12:38 am
Mar 23, 2013 at 9:53 am -
It looks like the recent matview patch broke pg_dump in a way, which make it impossible to dump 9.1 and 9.2 databases. it fails with pg_dump: [Archivierer (DB)] query failed: ERROR: function ...
Bernd Helmle
Mar 6, 2013 at 11:00 am
Mar 14, 2013 at 1:30 am -
Hello All First, I am new to this great forum. I have a challenge on my hand as follows. I am a long time libpq user but have never used the BYTEA data type nor its related functions until now. I ...
Cliff_Bytes
Mar 4, 2013 at 3:54 am
Mar 5, 2013 at 1:04 am -
Hi all, While playing with custom background workers, I noticed that postmaster does not notify its registered bgworkers if it receives SIGHUP, so you have to send a SIGHUP directly to the bgworker ...
Michael Paquier
Mar 21, 2013 at 8:06 am
Apr 11, 2013 at 12:56 am -
Hello! I'm an IT student, and I would like to apply for the 2013 GSoC. I've been looking at this mailing list for a while now, and I saw a suggestion for GSoC that particularly interested me ...
Viod
Mar 26, 2013 at 7:48 pm
Mar 27, 2013 at 10:15 am -
Craig, Here's for your summary. I stopped at --echo-hidden, working my way up from the bottom. Overall, it seems like mostly the patches which are still in queue are there for good reasons, although ...
Josh Berkus
Mar 3, 2013 at 9:35 pm
Mar 4, 2013 at 3:35 pm -
As we know, SSDs are widely used in various kinds of applications. But the SMGR in PostgreSQL still only support magnetic disk. How do we make full use of SSDs to improve the performance of ...
赖文豫
Mar 30, 2013 at 2:08 pm
Mar 31, 2013 at 12:18 am -
What do you suggest? I thought about changing the wording but the new wording is parallel to what's already in that paragraph, so likely the whole thing needs to be rewritten if we change any of it ...
Robert Haas
Mar 27, 2013 at 12:58 pm
Mar 28, 2013 at 7:58 pm -
Hi all, I have developed a new query optimizer for PostgreSQL and I would like to share it with the community. The optimizer's name is Sampling and Dynamic Programming (SDP). I put it into a plugin ...
Adriano Lange
Mar 22, 2013 at 11:36 pm
Mar 23, 2013 at 5:51 pm -
Hi, Attached is a small patch to test corner cases related to Sequences (basically aimed at increasing code-coverage of sequence.sql in regression tests). Look forward to any and all feedback. -- ...
Robins
Mar 12, 2013 at 4:35 pm
Mar 18, 2013 at 11:07 pm -
Hi, commit 3bf3ab8c563699138be02f9dc305b7b77a724307 ("Add a materialized view relations.") added this: src/backend/rewrite/rewriteDefine.c.orig | 945 +++++++++++++... ... create mode 100644 ...
Boszormenyi Zoltan
Mar 4, 2013 at 6:39 am
Mar 4, 2013 at 12:40 pm -
Since there has been some, um, grumbling about the quality of the release notes of late, I've prepared draft notes for next week's releases, covering commits through today. These are now committed ...
Tom Lane
Mar 29, 2013 at 1:46 am
Apr 21, 2013 at 1:14 pm -
Hi, I'm trying to write a background writer, and I'm facing a problem with timestamps. The following code is where I'm having a problem (it's just a demo for the problem) ...
Marc Cousin
Mar 20, 2013 at 2:38 pm
Apr 10, 2013 at 4:39 pm -
Hi, During the investigation of http://archives.postgresql.org/message-id/CAL_0b1t%3DWuM6roO8dki%3Dw8DhH8P8whhohbPjReymmQUrOcNT2A%40mail.gmail.com I noticed that during HS we do the following in ...
Andres Freund
Mar 30, 2013 at 6:20 pm
Mar 30, 2013 at 11:00 pm -
While looking at bug #7969, it occurred to me that it would be nice if we could catch resource leaks in WAL redo routines better. It would be useful during development, to catch bugs earlier, and it ...
Heikki Linnakangas
Mar 27, 2013 at 8:40 pm
Mar 28, 2013 at 3:09 pm -
CHECK_STACK_DEPTH checks if errordata_stack_depth is negative. Move the dereference of &errordata[errordata_stack_depth] after the check to avoid out-of-bounds read. --- ...
Xi Wang
Mar 23, 2013 at 10:38 pm
Mar 27, 2013 at 9:58 pm -
lag, [...]. This is not implemented in PostgreSQL (http://www.postgresql.org/docs/devel/static/functions-window.html) I've had a go at implementing this, and I've attached the resulting patch. It's ...
Nicholas White
Mar 19, 2013 at 12:27 am
Mar 25, 2013 at 12:15 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 101 |
posts | 1,441 |
users | 117 |
website | postgresql.org... |
irc | #postgresql |
117 users for March 2013
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)