FAQ

PostgreSQL > pgsql-hackers > May 2012

Search Discussions

142 discussions - 1,584 posts

  • I have completed my draft of the 9.2 release notes, and committed it to git. I am waiting for our development docs to build, but after 40 minutes, I am still waiting ...
    Bruce MomjianBruce Momjian
    May 10, 2012 at 3:11 am
    Sep 23, 2012 at 8:27 pm
  • Hello here is patch with enhancing ErrorData structure. Now constraints errors and RI uses these fields Regards Pavel Stehule
    Pavel StehulePavel Stehule
    May 9, 2012 at 1:34 pm
    Jan 6, 2013 at 8:39 pm
  • Hi, I've been running some tests on pg 9.2beta1 and in particular a set of queries like create table _tmp0 as select * from ( select *, (select healpixid from idt_match as m where ...
    Sergey KoposovSergey Koposov
    May 24, 2012 at 1:25 pm
    Jun 7, 2012 at 5:57 pm
  • Hi, I just read a very interesting post about "schema version management". Quote: "You could set it up so that every developer gets their own test database, sets up the schema there, takes a dump, ...
    Joel JacobsonJoel Jacobson
    May 20, 2012 at 7:42 pm
    Jul 15, 2012 at 2:56 am
  • Let me have a discussion to get preferable interface for row-level security. My planned feature will perform to append additional conditions to WHERE clause implicitly, to restrict tuples being ...
    Kohei KaiGaiKohei KaiGai
    May 23, 2012 at 12:00 pm
    Jun 10, 2012 at 8:24 am
  • So collecting a few requirements from various places: * Ability to have a Role that can only access one Database * Allow user info to be dumped with a database, to make a db completely ...
    Simon RiggsSimon Riggs
    May 22, 2012 at 9:46 am
    May 28, 2012 at 7:59 pm
  • Hi all, as a part of my master's thesis I have created temporal support patch for PostgreSQL. It enables the creation of special temporal tables with entries versioning. Modifying operations (UPDATE, ...
    Miroslav ©imulčíkMiroslav ©imulčík
    May 16, 2012 at 9:15 pm
    Aug 29, 2012 at 3:45 am
  • The attached very simple patch moves the commit_delay + commit_siblings sleep into XLogFlush, where the leader alone sleeps. This appears to be a much more effective site for a delay. Benchmark ...
    Peter GeogheganPeter Geoghegan
    May 29, 2012 at 1:19 am
    Jul 3, 2012 at 3:28 am
  • Hi hackers After playing around with array_to_json() and row_to_json() functions a bit it I have a question - why do we even have 2 variants *_to_json() Collapsing array_to_json() and row_to_json() ...
    Hannu KrosingHannu Krosing
    May 1, 2012 at 12:03 pm
    May 5, 2012 at 3:49 pm
  • I had a request from a customer asking if we could make a switch to specifically disable the "unexpected EOF" message that fills lots of peoples logs. Along the same way that we have a flag to turn ...
    Magnus HaganderMagnus Hagander
    May 3, 2012 at 12:26 pm
    May 7, 2012 at 5:28 pm
  • Hello I have to goals for 9.3. First goal is plpgsql_check_function, second goal is enhancing ErrorData and error management to support new fields: COLUMN_NAME, CONSTRAINT_NAME, CONSTRAINT_SCHEMA, ...
    Pavel StehulePavel Stehule
    May 1, 2012 at 12:22 pm
    May 2, 2012 at 10:36 pm
  • pg_upgrade is a little over-keen about checking for shared libraries that back functions. In particular, it checks for libraries that support functions created in pg_catalog, even if pg_dump doesn't ...
    Andrew DunstanAndrew Dunstan
    May 25, 2012 at 2:21 pm
    May 29, 2012 at 11:07 pm
  • Doing some beta testing, managed to produce this issue using the daily snapshot from Tuesday: 1. Created master server, loaded it with a couple dummy databases. 2. Created standby server. 3. Did ...
    Josh BerkusJosh Berkus
    May 13, 2012 at 7:05 pm
    May 18, 2012 at 5:44 pm
  • We allow non-superuser database owners to execute CREATE LANGUAGE for a trusted language (one marked as tmpldbacreate in pg_pltemplate). Currently, the C-language support functions for the language ...
    Tom LaneTom Lane
    May 30, 2012 at 4:02 pm
    Jul 22, 2012 at 11:50 pm
  • Shall I commit to master and all supported branches? -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
    Tatsuo IshiiTatsuo Ishii
    May 31, 2012 at 12:21 am
    Sep 3, 2012 at 4:37 am
  • Is there plan to implement such external functions before 9.2 release? If not, keepalive protocol seems to be almost useless because there is no use of it for a user and the increase in the number of ...
    Fujii MasaoFujii Masao
    May 23, 2012 at 6:28 pm
    Aug 9, 2012 at 4:13 pm
  • We've previously discussed the possible desirability of extending relations in larger increments, rather than one block at a time, for performance reasons. I attempted to determine how much ...
    Robert HaasRobert Haas
    May 1, 2012 at 2:08 pm
    May 31, 2012 at 7:18 pm
  • Attached patch latches up the WAL Writer, reducing wake-ups and thus saving electricity in a way that is more-or-less analogous to my work on the BGWriter ...
    Peter GeogheganPeter Geoghegan
    May 2, 2012 at 3:36 pm
    May 10, 2012 at 6:38 am
  • Hi all, I noticed that when synchronous_commit=off were not waking up the wal sender latch in xact.c:RecordTransactionCommit which leads to ugly delays of approx 7 seconds (1 + ...
    Andres FreundAndres Freund
    May 10, 2012 at 7:51 pm
    Jun 8, 2012 at 8:10 am
  • Hello, I was running some tests on PG9.2beta where I'm creating and dropping large number of tables (~ 20000). And I noticed that table dropping was extremely slow -- e.g. like half a second per ...
    Sergey KoposovSergey Koposov
    May 30, 2012 at 12:40 am
    Jun 8, 2012 at 12:28 am
  • While going through Readme in backend\storage\buffer, I found some point misleading. Normal Buffer Replacement Strategy ---------------------------------- -------------- .. .. Each buffer header ...
    Amit KapilaAmit Kapila
    May 9, 2012 at 1:38 am
    May 24, 2012 at 10:39 pm
  • So, I set up a test which should have been ideal setup for index-only scan. The index was 1/10 the size of the table, and fit in RAM (1G) which the table does not: bench2=# select ...
    Joshua BerkusJoshua Berkus
    May 17, 2012 at 3:08 am
    May 23, 2012 at 3:47 pm
  • It seems pretty confusing that synchronous_commit = 'remote_write' means write confirmed to the remote socket, not write to the file system. Is there no better term we could some up with? ...
    Bruce MomjianBruce Momjian
    May 9, 2012 at 1:13 am
    May 10, 2012 at 11:28 pm
  • According to http://archives.postgresql.org/pgsql-general/2012-04/msg00374.php advisory locks now cause problems for prepared transactions, which ought to ignore them. It appears to me that this got ...
    Tom LaneTom Lane
    May 3, 2012 at 12:19 am
    May 30, 2012 at 8:26 pm
  • Yesterday I had a client that experienced a sudden high load on one of their servers (8.3.5 - yes, I know. Those of you with clients will understand). When I checked, almost all connections were in a ...
    Greg Sabino MullaneGreg Sabino Mullane
    May 24, 2012 at 5:33 pm
    Jun 10, 2012 at 11:19 pm
  • Hi all, One of the issues we've been looking at with PostGIS is how to interrupt long-running processing tasks in external libraries, particularly GEOS. After a few tests here, it seems that even the ...
    Mark Cave-AylandMark Cave-Ayland
    May 16, 2012 at 10:25 am
    Jun 7, 2012 at 10:23 am
  • I've been testing the crash recovery of REL9_2_BETA1, using the same method I posted in the "Scaling XLog insertion" thread. I have the checkpointer occasionally throw a FATAL error, which causes the ...
    Jeff JanesJeff Janes
    May 18, 2012 at 4:23 pm
    May 25, 2012 at 7:10 pm
  • If pg_stat_statements is set to store it's data across restarts, it stores it in global/pg_stat_statements.stat. This causes some interesting things to happen in combination with a base backup - ...
    Magnus HaganderMagnus Hagander
    May 24, 2012 at 10:43 am
    May 28, 2012 at 11:15 am
  • This code is our pre-9.2 group commit implementation, pretty much in its entirety: if (CommitDelay 0 && enableFsync && MinimumActiveBackends(CommitSiblings)) pg_usleep(CommitDelay); This code is ...
    Peter GeogheganPeter Geoghegan
    May 13, 2012 at 11:18 pm
    May 15, 2012 at 4:39 pm
  • Quite apart from the practical difficulties that we have with Flex (the fact that the authors are non-responsive and possibly retired, that annoying compiler warning, and the fact that we are forced ...
    Peter GeogheganPeter Geoghegan
    May 2, 2012 at 12:53 am
    May 3, 2012 at 9:36 pm
  • Hi Hackers How hard would it be to add support for LIKE syntax, similar to table def in field list declaration for generic record functions What I'dd like to be able to do is to have a generic ...
    Hannu KrosingHannu Krosing
    May 2, 2012 at 11:40 am
    May 3, 2012 at 4:05 pm
  • In 9.1: regression=# select pg_size_pretty(8*1024*1024); pg_size_pretty ---------------- 8192 kB (1 row) In HEAD: regression=# select pg_size_pretty(8*1024*1024); ERROR: function ...
    Tom LaneTom Lane
    May 26, 2012 at 12:30 am
    Oct 21, 2012 at 10:22 pm
  • Hm. This fixes the stability-within-transaction problem, but it's also introduced a change in the definition of age(), no? Previously, in an xact that had an XID, the age was measured relative to ...
    Tom LaneTom Lane
    May 11, 2012 at 4:13 pm
    May 29, 2012 at 7:00 pm
  • Currently, the following can happen: 1. A backend needs a new transaction, so it calls GetNewTransactionId(). It acquires XidGenLock and then calls ExtendCLOG(). 2. ExtendCLOG() decides that a new ...
    Robert HaasRobert Haas
    May 3, 2012 at 4:38 pm
    May 4, 2012 at 2:05 pm
  • Now that there are index only scans, there is a use case for having a composite index which has the primary key or a unique key as the prefix column(s) but with extra columns after that. Currently ...
    Jeff JanesJeff Janes
    May 22, 2012 at 5:24 pm
    Jun 3, 2012 at 7:49 pm
  • pg 9.2 git master AMD 8120 (8-core) / 6 GB memory / Centos 6.2 I have experimented a bit with dropping a table from master, then querying that table from a sync-rep slave. It is a little worrying ...
    Erik RijkersErik Rijkers
    May 26, 2012 at 9:21 am
    May 31, 2012 at 2:16 pm
  • At dinner on Friday night at PGCon, the end of the table that included Tom Lane, Stephen Frost, and myself got to talking about the idea of including some kind of metapage in every relation, ...
    Robert HaasRobert Haas
    May 21, 2012 at 5:57 pm
    May 25, 2012 at 11:42 pm
  • In 9.1, the pg_basebackup option --xlog takes no argument. In 9.2, it takes a required argument. I think such compatibility breaks should be avoided, especially in client-side programs. Now you can't ...
    Peter EisentrautPeter Eisentraut
    May 28, 2012 at 8:11 pm
    Jun 12, 2012 at 5:34 pm
  • Hello I proposed new psql's format "shell". This format is optimized for processing returned result in shell: postgres=# select * from foo; a | b | c --------------+----+------------ Hello, World | ...
    Pavel StehulePavel Stehule
    May 26, 2012 at 3:40 pm
    Jun 4, 2012 at 8:32 pm
  • Hi, We just came across a situation where a corrupted HFS+ filesystem appears to return ERANGE on a customer machine. Our first reaction was to turn zero_damaged_pages on to allow taking a pg_dump ...
    Alvaro HerreraAlvaro Herrera
    May 16, 2012 at 1:39 pm
    May 21, 2012 at 10:09 pm
  • I would like to propose to improve parsing efficiency of contrib/file_fdw by selective parsing proposed by Alagiannis et al.[1], which means that for a CSV/TEXT file foreign table, file_fdw performs ...
    Etsuro FujitaEtsuro Fujita
    May 8, 2012 at 11:22 am
    Jul 13, 2012 at 1:57 am
  • I bumped into a bug in the new buffering GiST build code. I did this: create table gisttest (t text); insert into gisttest select a||'fooooooooooooooooooooooooooooooooooooooooooooooo' from ...
    Heikki LinnakangasHeikki Linnakangas
    May 18, 2012 at 4:27 pm
    Jun 5, 2012 at 6:48 am
  • Hi list, This bug isn't causing me any immediate problems -- the plan works out well regardless -- but PostgreSQL 8.4.7 is somehow overestimating the number of rows coming from a nestloop join, when ...
    Marti RaudseppMarti Raudsepp
    May 28, 2012 at 7:46 am
    May 29, 2012 at 5:27 pm
  • While researching a problem reported on the -general list by a user who lost a disk containing his index tablespace, I ran into something, but I'm not sure is a serious bug or just an inconsistency ...
    Michael NolanMichael Nolan
    May 8, 2012 at 4:14 am
    May 12, 2012 at 4:03 am
  • Hackers, Shouldn't a call to elog(NOTICE) invalidate the current tranaction? david=# begin; BEGIN Time: 0.178 ms david=# do language plperl $$ elog(ERROR, 'foo')$$; ERROR: foo at line 1. CONTEXT ...
    David E. WheelerDavid E. Wheeler
    May 10, 2012 at 11:21 pm
    May 11, 2012 at 5:19 pm
  • I have been reviewing how our new libpq URL syntax compares against existing implementations of URL syntaxes in other drivers or higher-level access libraries. In the case of SQLAlchemy, there is an ...
    Peter EisentrautPeter Eisentraut
    May 9, 2012 at 6:17 pm
    May 29, 2012 at 4:27 am
  • I've switched servers yesterday night and the previous slave is now the master. This is 9.0.6 (originally) / 9.0.7 (now) on Linux. Now I'm seeing a bunch of ERROR: could not open relation with OID ...
    Joachim WielandJoachim Wieland
    May 16, 2012 at 2:37 am
    May 24, 2012 at 6:54 pm
  • Do we have a full list of externally defined open standards that we follow? Are there any known incompatibilities from externally defined open standards? (I know about the SQL standard stuff). Are ...
    Simon RiggsSimon Riggs
    May 12, 2012 at 9:38 am
    May 24, 2012 at 3:50 am
  • Hello, This question may be appropriate for pgsql-general, but let me ask here because the only relevant discussion seems to have been done on pgsql-hackers ...
    MauMauMauMau
    May 9, 2012 at 12:11 pm
    May 11, 2012 at 3:54 pm
  • As part of a blog, I started looking at how a user could measure the pressure on shared buffers, e.g. how much are they being used, recycled, etc. They way you normally do it on older operating ...
    Bruce MomjianBruce Momjian
    May 30, 2012 at 4:56 pm
    May 31, 2012 at 10:15 pm
May 2012
123
Group Navigation
period‹ prev | May 2012 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions142
posts1,584
users121
websitepostgresql.org...
irc#postgresql

121 users for May 2012

Tom Lane: 261 posts Robert Haas: 191 posts Bruce Momjian: 100 posts Simon Riggs: 73 posts Magnus Hagander: 61 posts Joshua Berkus: 56 posts Peter Geoghegan: 51 posts Peter Eisentraut: 49 posts Jeff Janes: 42 posts Florian Pflug: 36 posts Fujii Masao: 35 posts Merlin Moncure: 34 posts Andrew Dunstan: 31 posts Heikki Linnakangas: 30 posts Sergey Koposov: 26 posts Stephen Frost: 26 posts Alvaro Herrera: 22 posts Kevin Grittner: 22 posts Alexander Korotkov: 20 posts Kohei KaiGai: 20 posts
show more
Archives