FAQ

PostgreSQL > pgsql-hackers > March 2013

Search Discussions

101 discussions - 1,441 posts

  • 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 JurdBrendan 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 SharmaAtri 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 LinnakangasHeikki 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 RiggsSimon 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. WheelerDavid 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 LaneTom 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 PaquierMichael 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 FrostStephen 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 LaneTom 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 WielandJoachim 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 SingerSteve 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 LaneTom 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 PilcherIan 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 MomjianBruce Momjian
    Mar 29, 2013 at 2:15 pm
    Apr 2, 2013 at 9:02 pm
  • True; how about this patch. Yours, Laurenz Albe
    Albe LaurenzAlbe 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 KaltenbrunnerStefan 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 MasaoFujii 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 FreundAndres 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 MoshayediHadi 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 ConwayJoe 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 HerreraAlvaro 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 LinnakangasHeikki 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. WheelerDavid 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 MasaoFujii 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 LaneTom 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. WheelerDavid 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 LaneTom 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 RiggsSimon 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 LaneTom 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 DuncanDarren 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 GeogheganPeter 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 HaganderMagnus 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 BerkusJosh 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 JurdBrendan 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 HelmleBernd 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_BytesCliff_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 PaquierMichael 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 ...
    ViodViod
    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 BerkusJosh 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 HaasRobert 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 LangeAdriano 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. -- ...
    RobinsRobins
    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 ZoltanBoszormenyi 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 LaneTom 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 CousinMarc 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 FreundAndres 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 LinnakangasHeikki 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 WangXi 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 WhiteNicholas White
    Mar 19, 2013 at 12:27 am
    Mar 25, 2013 at 12:15 am
Mar 2013
123
Group Navigation
period‹ prev | Mar 2013 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions101
posts1,441
users117
websitepostgresql.org...
irc#postgresql

117 users for March 2013

Tom Lane: 189 posts Simon Riggs: 66 posts Robert Haas: 64 posts Michael Paquier: 59 posts Alvaro Herrera: 55 posts Heikki Linnakangas: 55 posts Kevin Grittner: 54 posts Andres Freund: 53 posts Josh Berkus: 52 posts Craig Ringer: 46 posts Greg Smith: 41 posts Bruce Momjian: 40 posts Amit Kapila: 35 posts Daniel Farina: 27 posts Fujii Masao: 27 posts Andrew Dunstan: 26 posts Greg Stark: 26 posts Jeff Davis: 26 posts Pavel Stehule: 24 posts Ants Aasma: 23 posts
show more
Archives