FAQ

PostgreSQL > pgsql-hackers > March 2011

Search Discussions

175 discussions - 1,956 posts

  • I have gotten two reports via IRC that months after using 9.0 pg_upgrade, some of the clog files have been removed while there is still data in the table needing those clog files. These reports came ...
    Bruce MomjianBruce Momjian
    Mar 29, 2011 at 8:17 pm
    Apr 25, 2011 at 4:05 pm
  • Or else we should close the CommitFest and cut alpha4. Anyone have an opinion on which way to go? I think it's fair to say that Simon is working pretty actively on Sync Rep and that the bug count is ...
    Robert HaasRobert Haas
    Mar 1, 2011 at 6:43 pm
    Apr 27, 2011 at 7:55 pm
  • Latest version of Sync Rep, which includes substantial internal changes and simplifications from previous version. (25-30 changes). Includes all outstanding technical comments, typos and docs. I will ...
    Simon RiggsSimon Riggs
    Mar 3, 2011 at 10:53 am
    Apr 30, 2011 at 2:29 am
  • Attached is a WIP patch that allows SQL-language functions to reference their parameters by name. It uses p_post_columnref_hook, so potentially ambiguous references prefer the column... that seems to ...
    Matthew DraperMatthew Draper
    Mar 25, 2011 at 7:41 pm
    Apr 26, 2011 at 3:19 pm
  • The discussion on the thread was that its not sync rep unless we have the strictest guarantees. We have the strictest guarantees, so it qualifies as sync rep. Relaxations are possible and, to some ...
    Simon RiggsSimon Riggs
    Mar 6, 2011 at 11:28 pm
    Mar 25, 2011 at 12:12 pm
  • Hi, I'd like to add an ability to validate the corectness of PostgreSQL configuration files, i.e. postgresql.conf, pg_hba.conf, pg_ident.conf without actually applying them. The idea is that it would ...
    Alexey KlyukinAlexey Klyukin
    Mar 30, 2011 at 4:14 pm
    Oct 2, 2011 at 8:58 pm
  • It's about dependences. If my extension requires a procedural language, will adding that language to the `requires` control key do what I think it should do? If not, how should one require a PL? Come ...
    David E. WheelerDavid E. Wheeler
    Mar 2, 2011 at 9:15 pm
    Mar 5, 2011 at 6:13 pm
  • Hi, I have implemented initial concept of 2nd level cache. Idea is to keep some segments of shared memory for special buffers (e.g. indices) to prevent overwrite those by other operations. I added ...
    Radosław SmoguraRadosław Smogura
    Mar 17, 2011 at 7:47 pm
    Apr 26, 2011 at 7:49 pm
  • Agreed. I think that user who wants to request smart shutdown expects all the existing connections to basically be closed normally by the client. So it doesn't seem to be good idea to forcibly close ...
    Fujii MasaoFujii Masao
    Mar 9, 2011 at 7:38 am
    Mar 22, 2011 at 7:51 pm
  • Attached is a patch that adds a 'json' contrib module. Although we may want a built-in JSON data type in the near future, making it a module (for the time being) has a couple advantages: * ...
    Joseph AdamsJoseph Adams
    Mar 28, 2011 at 5:22 pm
    Jun 18, 2011 at 10:29 am
  • Proposed changes: Make synchronous_replication into an enum, so we can now also say synchronous_replication = recv, flush or apply as well as on or off. synchronous_replication = on is the same as ...
    Simon RiggsSimon Riggs
    Mar 27, 2011 at 9:45 pm
    Mar 30, 2011 at 7:59 am
  • I was trying to build the Windows msvc build for the first time and ran into some issues. The documentation talks about obtaining and using the "Platform SDK". I understand that this is nowadays ...
    Peter EisentrautPeter Eisentraut
    Mar 31, 2011 at 7:38 pm
    May 11, 2011 at 4:19 am
  • In a previous thread (http://postgresql.1045698.n5.nabble.com/Set-hint-bits-upon-eviction-from-BufMgr-td4264323.html) I was playing with the idea of granting the bgwriter the ability to due last ...
    Merlin MoncureMerlin Moncure
    Mar 29, 2011 at 9:35 pm
    Jun 29, 2011 at 3:11 pm
  • People are confused about what template0 is for, so I created the attached one-line patch to add a database comment to template0. No initdb, I assume, becuase it is just a comment. I plan to work on ...
    Bruce MomjianBruce Momjian
    Mar 11, 2011 at 10:25 pm
    Mar 15, 2011 at 6:37 pm
  • Looking over the autovacuum.c code, I see: /* * Determine the oldest datfrozenxid/relfrozenxid that we will allow to * pass without forcing a vacuum. (This limit can be tightened for * particular ...
    Bruce MomjianBruce Momjian
    Mar 31, 2011 at 4:17 pm
    May 7, 2011 at 7:29 pm
  • Hi, I am currently looking at a physical file belonging to a corrupt index. This is with PG 8.3.13 on an ext3 filesystem on suse linux with a RAID1 setup. The sequence of operation seems nothing ...
    Nikhil SontakkeNikhil Sontakke
    Mar 22, 2011 at 8:02 pm
    Mar 22, 2011 at 8:02 pm
  • Was this cluster upgraded to 8.4.4 from 8.4.0? It sounds to me like a known bug in 8.4.0 which was fixed by this commit: commit 7fc7a7c4d082bfbd579f49e92b046dd51f1faf5f Author: Tom Lane ...
    David ChristensenDavid Christensen
    Mar 1, 2011 at 1:43 am
    Mar 8, 2011 at 7:00 pm
  • It has bothered me that many of our time routines use special magic constants for time values, e.g. 24, 12, 60, etc. The attached patch changes these magic constants to macros to clarify the code. I ...
    Bruce MomjianBruce Momjian
    Mar 11, 2011 at 5:51 pm
    Sep 5, 2011 at 7:39 pm
  • Hello, i have an old system where used implicit casting float<- integer numeric<- float numeric<- integer I want define implicit casts, but postgresql don`t know cast priority now postgresql have ...
    ZotovZotov
    Mar 10, 2011 at 1:20 pm
    May 11, 2011 at 10:05 pm
  • Hi, I was randomly testing some date related stuff on PG & observed that the outputs were wrong. e.g. postgres=# SELECT TO_DATE('01-jan-2010', 'DD-MON-YY'); to_date ------------ 3910-01-01 <--------- ...
    Piyush NewePiyush Newe
    Mar 16, 2011 at 12:22 pm
    Sep 7, 2011 at 1:51 pm
  • Here's a quick enumeration of some things I think need discussion about the collations patch: * Are we happy yet with the collation assignment behavior (see parse_collate.c)? A couple of specific ...
    Tom LaneTom Lane
    Mar 26, 2011 at 4:36 am
    Apr 18, 2011 at 7:53 pm
  • hi, So, I hit a strange problem with Streaming Replication, that I cannot explain. Executive summary: when using hot backup made on straming replication slave, sometimes (depending on load) generated ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Mar 25, 2011 at 8:31 pm
    Mar 30, 2011 at 8:12 am
  • Hi, I've noticed some weirdness when trying to grant various types of permissions on a foreign table and thought I'd report it here: postgres=# \d stuff Foreign table "public.stuff" Column | Type | ...
    Thom BrownThom Brown
    Mar 31, 2011 at 11:55 pm
    May 13, 2011 at 7:52 pm
  • Greetings, In a discussion which came up at PgEast, I questioned if it'd be possible to set the 'all visible' hint bit and give the tuples the frozen XID when loading data into a table which was ...
    Stephen FrostStephen Frost
    Mar 24, 2011 at 9:08 pm
    Mar 25, 2011 at 8:26 pm
  • I took a look at the open item concerning typed tables and pg_upgrade: http://archives.postgresql.org/pgsql-hackers/2011-03/msg00767.php "pg_dump --binary-upgrade" emits commands to recreate the ...
    Noah MischNoah Misch
    Mar 29, 2011 at 9:50 pm
    Apr 21, 2011 at 5:30 am
  • For historical reasons, what we now think of as VACUUM is referred to in some portions of the code as "lazy vacuum", to distinguish it from pre-9.0 VACUUM FULL. As I understand it, VACUUM works like ...
    Robert HaasRobert Haas
    Mar 14, 2011 at 7:36 pm
    Apr 9, 2011 at 12:14 pm
  • Hello, Most database connectors/frameworks nowadays support a URI style connection string. Something like: pgsql://user:pass@host/database Do we think psql should support this style of connection ...
    Joshua D. DrakeJoshua D. Drake
    Mar 31, 2011 at 11:26 pm
    Apr 6, 2011 at 8:06 pm
  • We have run across a problem with autovacuum that occurs when it can truncate off a large amount of empty blocks. It behaves different in version 9.0 than previous versions. Both behaviors are bad. ...
    Jan WieckJan Wieck
    Mar 26, 2011 at 2:31 pm
    Apr 1, 2011 at 10:16 pm
  • I got a report from someone using pg_upgrade coming from PG 8.3 --- turns out we didn't rename toast tables to match the new relfilenode in pre-8.4, so the attached applied patch avoids the check for ...
    Bruce MomjianBruce Momjian
    Mar 6, 2011 at 2:15 am
    Dec 8, 2011 at 7:06 pm
  • Is there any documentation of $SUBJECT? Because the more I look at this patch the more I think it's misdesigned; either that or I fundamentally misunderstand what it's trying to do. I complained ...
    Tom LaneTom Lane
    Mar 7, 2011 at 4:43 pm
    Mar 10, 2011 at 8:22 pm
  • Specifically, if we're not going to remove write location, then I think we need to apply something like the attached. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise ...
    Robert HaasRobert Haas
    Mar 23, 2011 at 3:35 pm
    Mar 26, 2011 at 12:25 am
  • I've attached a small patch with a bit of clarification and a typo fix in the synchronous_standby_names parameter info. -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux ...
    Thom BrownThom Brown
    Mar 7, 2011 at 9:58 am
    Mar 10, 2011 at 3:52 pm
  • Per previous discussion, I'm going to wrap alpha5 Monday morning Eastern time, barring objections. This time, I'm going to try to make sure that announcements actually go out; I dropped the ball on ...
    Robert HaasRobert Haas
    Mar 27, 2011 at 1:41 am
    May 5, 2011 at 4:54 pm
  • I took a crack at implementing the first approach described above, which seems to be by far the simplest idea we've come up with to date. Patch attached. It doesn't seem to be that complicated, which ...
    Robert HaasRobert Haas
    Mar 22, 2011 at 8:43 pm
    Mar 31, 2011 at 10:31 am
  • Hi, I try to known how a database is implemented and I have been reading PG source codes for a month. Now, I only know a little about how PG work. :( I just know PG work like this but I don't know ...
    HomHom
    Mar 17, 2011 at 2:57 pm
    Mar 20, 2011 at 3:44 pm
  • I am not sure the following pg_ctl behaviour is really a bug, but I find it unexpected enough to report. I was testing synchronous replication in a test setup on a single machine. (After all, one ...
    Erik RijkersErik Rijkers
    Mar 18, 2011 at 5:19 pm
    Oct 19, 2011 at 4:20 am
  • It stroke me today again, that \dt+ isn't displaying the acurate table size for tables, since it uses pg_relation_size() till now. With having pg_table_size() since PostgreSQL 9.0 available, i ...
    Bernd HelmleBernd Helmle
    Mar 21, 2011 at 6:56 pm
    Apr 8, 2011 at 7:56 pm
  • This might be nitpicking (or i'm currently missing something), but i recognized that setting wal_buffers = -1 always triggers the following on reload, even if nothing to wal_buffers had changed: $ ...
    Bernd HelmleBernd Helmle
    Mar 31, 2011 at 12:38 pm
    Apr 6, 2011 at 4:14 pm
  • Hackers, I would like to ask you about currency of the work above. I propose to develop functionality of GIN and GiST q-gram indexes with following features: 1) Handle edit distance (e.g. levenshtein ...
    Alexander KorotkovAlexander Korotkov
    Mar 25, 2011 at 5:33 pm
    Apr 5, 2011 at 3:03 pm
  • On the open items list, we have: conversion from integer literals to money type http://archives.postgresql.org/pgsql-testers/2011-01/msg00000.php What this is really complaining about is that we ...
    Robert HaasRobert Haas
    Mar 31, 2011 at 8:28 pm
    Apr 5, 2011 at 1:38 pm
  • Hi! PostgreSQL is applying for GSoC again this year. We're looking for: * Mentors * Project ideas Would you like to mentor? Please let me know! Our application closes on Friday, so please contact me ...
    Selena DeckelmannSelena Deckelmann
    Mar 8, 2011 at 6:44 am
    Mar 28, 2011 at 6:25 am
  • Currently, we don't measure any statistics about the ordering correlation of multi-column indexes, which means that btcostestimate has to pick a number out of the air if there's more than one column. ...
    Tom LaneTom Lane
    Mar 13, 2011 at 11:40 pm
    Mar 16, 2011 at 12:58 am
  • Heyho! I'm poking around a bit in PostgreSQL's source for curiosity's sake. Is there a short howto on how to start / debug postgres from within the unpacked/compiled tar? Are there scripts that set ...
    Adrian von BidderAdrian von Bidder
    Mar 8, 2011 at 9:11 am
    Mar 9, 2011 at 12:55 pm
  • I believe I've figured out why synchronous replication has such terrible performance with fsync=off: it has a nasty race condition. It may happen - if the standby responds very quickly - that the ...
    Robert HaasRobert Haas
    Mar 26, 2011 at 1:11 am
    Mar 28, 2011 at 1:27 am
  • I'm seeing this failure on a build machine with an old (and therefore unusable) version of flex: gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels ...
    Dave PageDave Page
    Mar 11, 2011 at 3:41 pm
    Mar 22, 2011 at 9:44 pm
  • So I was moving some error checks around and all of a sudden the regression tests blew up on me, with lots of errors about how type X didn't support collations (which indeed it didn't). After some ...
    Tom LaneTom Lane
    Mar 9, 2011 at 9:49 pm
    Mar 15, 2011 at 8:22 pm
  • I've thought of another area that AFAICT the current patch fails to address at all: what should happen in user-defined functions? Consider create function my_lt(x text, y text) returns bool as $$ ...
    Tom LaneTom Lane
    Mar 12, 2011 at 5:17 pm
    Mar 15, 2011 at 7:44 pm
  • I am unsure on that one. We have many 'char' mentions in catalog.sgml, and I don't see any of them shown as '"char"'. (Wow, we should have just called this type char1, but I think that name came from ...
    Bruce MomjianBruce Momjian
    Mar 11, 2011 at 11:13 am
    Sep 6, 2011 at 3:20 pm
  • Hi, maybe we should change the "1000 digits" here: http://developer.postgresql.org/pgdocs/postgres/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL because ISTM that up to 2^17 digits are supported ...
    Gianni CiolliGianni Ciolli
    Mar 11, 2011 at 11:44 am
    Apr 27, 2011 at 12:20 pm
  • Maybe I'm being overly simplistic or incorrect here, but I was thinking that there might be a route to reducing hint bit impact to the main sufferers of the feature without adding too much pain in ...
    Merlin MoncureMerlin Moncure
    Mar 25, 2011 at 2:52 pm
    Apr 5, 2011 at 3:59 pm
Mar 2011
1234
Group Navigation
period‹ prev | Mar 2011 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions175
posts1,956
users140
websitepostgresql.org...
irc#postgresql

140 users for March 2011

Robert Haas: 337 posts Tom Lane: 223 posts Bruce Momjian: 114 posts Simon Riggs: 113 posts Fujii Masao: 98 posts Heikki Linnakangas: 91 posts Kevin Grittner: 61 posts Peter Eisentraut: 56 posts Alvaro Herrera: 44 posts Greg Stark: 43 posts Andrew Dunstan: 37 posts Dimitri Fontaine: 37 posts Magnus Hagander: 32 posts Joshua Berkus: 29 posts Merlin Moncure: 26 posts David E. Wheeler: 24 posts Jan Urbański: 24 posts Yeb Havinga: 24 posts Nikhil Sontakke: 23 posts Martijn van Oosterhout: 21 posts
show more
Archives