Search Discussions

142 discussions - 1,658 posts

  • For the last week or so, in between various other tasks, I've been trying to understand why performance drops off when you run pgbench -n -S -c $CLIENTS -j $CLIENTS -T $A_FEW_MINUTES at very high ...
    Robert HaasRobert Haas
    Jul 21, 2011 at 1:46 am
    Jul 29, 2011 at 4:37 am
  • Hello, Could you let me go on with this topic? It is hard to ignore this glitch for us using CJK - Chinese, Japanese, and Korean - characters on databse.. Maybe.. Saying on Japanese under the ...
    Jul 8, 2011 at 9:53 am
    Oct 30, 2011 at 6:49 pm
  • I was mulling this idea over some more (the same ideas keep floating back to the top...). I don't think an LSN can actually work, because there's no guarantee that the order in which the WAL records ...
    Robert HaasRobert Haas
    Jul 28, 2011 at 2:52 am
    Jul 30, 2011 at 8:17 am
  • Hi, The attached patch introduces pg_constraint rows for NOT NULL column constraints. This patch is a heavily reworked version of Bernd Helmle's patch here: ...
    Alvaro HerreraAlvaro Herrera
    Jul 7, 2011 at 9:34 pm
    Aug 16, 2012 at 4:08 pm
  • We're nearing completion of testing the migration of a lot of code which used our custom Java framework into PostgreSQL functions and triggers. Yesterday our testers ran into surprising behavior ...
    Kevin GrittnerKevin Grittner
    Jul 20, 2011 at 6:58 pm
    Oct 26, 2012 at 8:08 pm
  • Hi all I've got through a review of the VS 2010 support patches. Between work being busy and some interesting issues getting my 64-bit build environment set up it took longer than anticipated. Sorry. ...
    Craig RingerCraig Ringer
    Jul 5, 2011 at 12:25 pm
    Jan 3, 2012 at 1:47 pm
  • Hackers; I just noticed that somewhere between 8.2 and 8.4, an exception is raised trying to alter table ONLY some_partition_parent ADD CHECK (foo). I can understand why it makes sense to handle this ...
    Jerry SieversJerry Sievers
    Jul 26, 2011 at 2:31 am
    Jul 30, 2011 at 4:55 am
  • I would like to request that full support for the UUID data type can added. I think that even though there is a contrib module, since this is a standard datatype that Postgres ought to be the one ...
    Michael GouldMichael Gould
    Jul 3, 2011 at 6:42 pm
    Aug 18, 2011 at 5:23 pm
  • I was adding gcc printf attributes to more functions in obscure places, and now I'm seeing this in pg_upgrade: relfilenode.c:72:2: warning: zero-length gnu_printf format string [-Wformat-zero-length] ...
    Peter EisentrautPeter Eisentraut
    Jul 7, 2011 at 8:55 pm
    Aug 25, 2012 at 8:25 pm
  • A bit later than expected, but here is my summary on the patch: -- Patch Status The patch applies cleanly. Since it's primarily targeted as an addition to contrib/, it doesn't touch the backend ...
    Bernd HelmleBernd Helmle
    Jul 4, 2011 at 11:10 am
    Jul 25, 2011 at 10:49 am
  • Hackers, With regard to this change: http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=5f7b58fad8f45c69bb67944779dce67e2f481995 I'm wondering if it would be possible to restore the ...
    David E. WheelerDavid E. Wheeler
    Jul 13, 2011 at 5:28 pm
    Jul 22, 2011 at 5:34 pm
  • My client has been seeing regular instances of the following sort of problem: ... 03:06:09.453 exec_simple_query, postgres.c:900 03:06:12.042 XX000: could not find pg_class tuple for index 2662 at ...
    Jul 28, 2011 at 1:13 am
    Aug 16, 2011 at 8:09 pm
  • I wrote a FDW for Oracle to a) learn some server coding and b) see how well the FDW API works for me. I came up with three questions/experiences: 1) GetUserMapping throws an error if there is no user ...
    Albe LaurenzAlbe Laurenz
    Jul 20, 2011 at 3:00 pm
    Aug 27, 2011 at 4:05 pm
  • Hey, So I am looking intently on what it is going to take to get the URI patch done for psql [1] and was digging around the web and have a URI parser library. It is under the New BSD license and is ...
    Joshua D. DrakeJoshua D. Drake
    Jul 21, 2011 at 5:43 pm
    Aug 10, 2011 at 5:01 pm
  • Can someone help me understand pg_locks? There are three fields related to virtual and real xids: virtualtransaction | text | transactionid | xid | virtualxid | text | Our docs say ...
    Bruce MomjianBruce Momjian
    Jul 10, 2011 at 4:01 am
    Jul 15, 2011 at 5:13 pm
  • That sounds like a deficiency to overcome. It should be possible for those system catalogs to be virtual, defined like union views over similar immutable tables for the read-only database plus ...
    Darren DuncanDarren Duncan
    Jul 8, 2011 at 3:56 am
    Jul 12, 2011 at 10:13 am
  • Hi all, The psql output for \d+ on indexes, sequences, and views is rather bogus. Examples below from the SQL at bottom. So, if you look at \d+ newtbl, the right-most column named Description should ...
    Josh KupershmidtJosh Kupershmidt
    Jul 16, 2011 at 3:55 pm
    Aug 13, 2011 at 8:10 pm
  • In reviewing the 2PC changes mentioned in a separate post, both Dan and I realized that these were dependent on the assumption that SSI's commitSeqNo is assigned in the order in which the ...
    Kevin GrittnerKevin Grittner
    Jul 5, 2011 at 5:04 pm
    Jul 7, 2011 at 9:40 pm
  • According to the suggestion from Robert, I'd like to see opinions about this feature prior to its implementation. In addition to this suggestion, I think the big static array also contains the ...
    Kohei KaigaiKohei Kaigai
    Jul 29, 2011 at 3:58 pm
    Aug 8, 2011 at 5:36 pm
  • Please consider adding this minor patch, or offering improvements. *Problem*: vacuumlo required PostgreSQL to use more locks per transaction than possible resulting in an error and a log file full of ...
    Jul 24, 2011 at 6:48 pm
    Aug 8, 2011 at 1:20 pm
  • Some of these new error messages from the SSI code are a mouthful: not enough elements in RWConflictPool to record a rw-conflict not enough elements in RWConflictPool to record a potential ...
    Peter EisentrautPeter Eisentraut
    Jul 15, 2011 at 5:22 am
    Aug 15, 2011 at 12:27 pm
  • Right - I've done so in this reply. There isn't a problem as such with the AV Launcher patch - there's a problem with most or all remaining auxiliary processes, that needs to be worked out once and ...
    Peter GeogheganPeter Geoghegan
    Jul 18, 2011 at 1:12 pm
    Aug 10, 2011 at 6:03 pm
  • We've had several complaints about that tab-completion bug in the Apple-supplied version of libedit, most recently here: http://archives.postgresql.org/pgsql-bugs/2011-06/msg00119.php I had a bug ...
    Tom LaneTom Lane
    Jul 22, 2011 at 2:24 am
    Aug 9, 2011 at 7:32 am
  • Hi All, As per discussion here http://archives.postgresql.org/pgsql-hackers/2011-05/msg01119.php PFA a patch which implements the idea with some variation. At the start of the first pass, we remember ...
    Pavan DeolaseePavan Deolasee
    Jul 12, 2011 at 8:48 pm
    Jul 21, 2011 at 8:19 pm
  • Attached is patch for the WAL writer that removes its tight polling loop (which probably doesn't get hit often in practice, as we just sleep if wal_writer_delay is under a second), and, at least ...
    Peter GeogheganPeter Geoghegan
    Jul 13, 2011 at 9:56 pm
    Jul 18, 2011 at 2:51 pm
  • All, As you can probably tell, we are not ready to end the commitfest. (I think Robert gave me this CF to show why even talking about a one-week mini-fest is a fantasy. If so, successful.). I've ...
    Josh BerkusJosh Berkus
    Jul 15, 2011 at 9:06 pm
    Jul 21, 2011 at 11:56 am
  • Hello, The attached patch changes the location of the dumpUserConfig call in the dumpRoles function of pg_dumpall. This is related to this thread: ...
    Phil SorberPhil Sorber
    Jul 27, 2011 at 9:03 pm
    Oct 14, 2011 at 6:16 pm
  • Here is a rebased version of per-column FDW options patch. I've proposed this patch in last CF, but it was marked as returned with feedback. So I would like to propose in next CF 2011-09. I already ...
    Shigeru HanadaShigeru Hanada
    Jul 29, 2011 at 8:36 am
    Aug 25, 2011 at 4:49 pm
  • All, Currently we have 8 patches "Ready for Committer" in the current CF. Some of them have been that status for some time. From traffic on this list, I'm getting the impression that nobody other ...
    Josh BerkusJosh Berkus
    Jul 14, 2011 at 7:01 pm
    Jul 17, 2011 at 3:16 am
  • On machines with lots of CPU cores, pgbench can start eating up a lot of system time. Investigation reveals that the problem is with random(), which glibc implements like this: long int __random () { ...
    Robert HaasRobert Haas
    Jul 29, 2011 at 9:00 pm
    Aug 13, 2011 at 1:34 am
  • [resending after gzip of test patch] In reviewing the recent fix to 2PC coverage in SSI, I found some cases which didn't seem to be covered. Dan bit the bullet and came up with an additional ...
    Kevin GrittnerKevin Grittner
    Jul 5, 2011 at 5:06 pm
    Aug 25, 2011 at 8:50 pm
  • Hi all, I would like to fix psql's incomplete and inconsistent handling of object comments. I think this subject can be handled separately from the pg_comments discussion, and we can focus on the ...
    Josh KupershmidtJosh Kupershmidt
    Jul 9, 2011 at 5:17 pm
    Aug 11, 2011 at 3:17 pm
  • In the 9.0 version of exclusion constraints, we added an extra check to ensure that, when searching for a conflict, a tuple at least found itself as a conflict. This extra check is not present in ...
    Jeff DavisJeff Davis
    Jul 5, 2011 at 4:27 pm
    Aug 12, 2011 at 8:27 pm
  • I've long harbored a suspicion, based on some testing I did on my home machine, that WALInsertLock is a big performance bottleneck. But I just did some benchmarking that doesn't entirely support that ...
    Robert HaasRobert Haas
    Jul 25, 2011 at 8:07 pm
    Jul 26, 2011 at 6:02 pm
  • The part of the expression which is probably causing this: (MaxTransactionId + 1) / OLDSERXID_ENTRIESPERPAGE - 1 Which I fear may not be getting into overflow which will not do the right thing even ...
    Kevin GrittnerKevin Grittner
    Jul 8, 2011 at 12:22 pm
    Jul 8, 2011 at 4:14 pm
  • Hello all, a lazy deep SQL validation inside plpgsq functions is interesting attribute. It allows to work with temporary tables and it make testing and debugging harder, because lot of errors in ...
    Pavel StehulePavel Stehule
    Jul 8, 2011 at 4:32 am
    Jul 22, 2011 at 4:51 am
  • Hi folks It looks like pgflex.bat and pgbison.bat in the win32 build files would benefit from a tweak to eliminate a complaint from Perl. Perl emits the error: Hash %ENV missing the % in argument 1 ...
    Craig RingerCraig Ringer
    Jul 3, 2011 at 12:14 pm
    Jul 5, 2011 at 6:21 pm
  • Hello. System: PostgreSQL v9.0 Windows XP SP3 SQL: COPY "tablename" TO STDOUT WITH (FORMAT binary) ERROR: syntax error at or near "binary" LINE 1: ...OPY "tablename" TO STDOUT WITH (FORMAT binary) ^ ...
    Pavel GolubPavel Golub
    Jul 5, 2011 at 2:52 pm
    Jul 5, 2011 at 4:04 pm
  • Hi, I have read http://www.postgresql.org/docs/9.1/static/xfunc-c.html and my idea is, to write a C function which returns a set of rows. To generate the result set, I would like to access indexes ...
    Achim DommaAchim Domma
    Jul 25, 2011 at 12:03 pm
    Aug 2, 2011 at 12:48 pm
  • hi, would it be possible to incorporate http://www.postgres.cz/index.php/Enhanced-psql in core PostgreSQL/psql? This patch adds lots of nice functionalities, which we could definitely use. Best ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Jul 9, 2011 at 10:29 am
    Jul 11, 2011 at 1:35 am
  • Hi While reviewing the (now applied) XPATH escaping patches, Radoslaw found one case where the previous failure of XPATH to escape its return value was offset by XMLATTRIBUTES insistence to escape ...
    Florian PflugFlorian Pflug
    Jul 26, 2011 at 8:45 pm
    Aug 11, 2011 at 9:13 am
  • Hi, I guess $subject wasn't implemented because plain unique indexes aren't represented in pg_constraint and thus do not have a place to store information about being deferred? Other than that I do ...
    Andres FreundAndres Freund
    Jul 12, 2011 at 4:46 pm
    Jul 26, 2011 at 2:01 pm
  • Pg_upgrade writes temporary files (e.g. _dumpall output) into the current directory, rather than a temporary directory or the user's home directory. (This was decided by community discussion.) I have ...
    Bruce MomjianBruce Momjian
    Jul 23, 2011 at 12:45 pm
    Jul 26, 2011 at 1:30 am
  • Hi, I noticed that the test alter_table.sql is creating two tables tab1 and tab2 and it's not dropping it. Any test which follows this test and tries to create tables with names tab1 and tab2 will ...
    Ashutosh BapatAshutosh Bapat
    Jul 7, 2011 at 7:05 am
    Jul 13, 2011 at 5:58 am
  • CommitSubTransaction(true) does this: ResourceOwnerRelease(s- curTransactionOwner, RESOURCE_RELEASE_LOCKS, true, isTopLevel /* == true */); ... ResourceOwnerDelete(s- curTransactionOwner); Because ...
    Heikki LinnakangasHeikki Linnakangas
    Jul 19, 2011 at 7:49 pm
    Jul 22, 2011 at 7:34 am
  • Hi, Here are a few questions that were asked by a customer, who are trying to assess the pros and cons of using Postgres and its SR feature. I would like to get an opinion of someone more involved ...
    Gurjeet SinghGurjeet Singh
    Jul 19, 2011 at 7:17 pm
    Jul 20, 2011 at 8:47 pm
  • All, We're almost at the end of the CommitFest, and three patches have not yet been reviewed: lazy vxid locks https://commitfest.postgresql.org/action/patch_view?id=585 sepgsql - userspace access ...
    Josh BerkusJosh Berkus
    Jul 14, 2011 at 12:42 am
    Jul 15, 2011 at 7:27 pm
  • Looking at: timestamptz_part(PG_FUNCTION_ARGS) I see: if (TIMESTAMP_NOT_FINITE(timestamp)) { result = 0; PG_RETURN_FLOAT8(result); } The assumption is that extracting _anything_ from an infinite ...
    Bruce MomjianBruce Momjian
    Jul 13, 2011 at 6:43 pm
    Jul 13, 2011 at 10:44 pm
  • Hi all, I noticed that the plpgsql extension gets installed with an extension comment of 'PL/pgSQL procedural language', which comes from plpgsql.control. That seems fine and dandy, but take a look ...
    Josh KupershmidtJosh Kupershmidt
    Jul 3, 2011 at 3:02 am
    Jul 3, 2011 at 11:05 pm
  • Should we document that sessions that exceed this limit generate an error? I don't see any mention of this in the docs. -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB ...
    Bruce MomjianBruce Momjian
    Jul 17, 2011 at 9:09 pm
    Aug 3, 2012 at 7:16 pm
Group Navigation
period‹ prev | Jul 2011 | next ›
Group Overview
grouppgsql-hackers @

134 users for July 2011

Robert Haas: 255 posts Tom Lane: 211 posts Florian Pflug: 80 posts Alvaro Herrera: 72 posts Kevin Grittner: 60 posts Heikki Linnakangas: 56 posts Bruce Momjian: 54 posts Joshua Berkus: 51 posts Peter Eisentraut: 48 posts Simon Riggs: 39 posts Noah Misch: 38 posts Andrew Dunstan: 35 posts Kohei KaiGai: 32 posts Jeff Davis: 31 posts Magnus Hagander: 29 posts Peter Geoghegan: 24 posts Alexander Korotkov: 23 posts Yeb Havinga: 23 posts David E. Wheeler: 22 posts Pavel Stehule: 20 posts
show more