FAQ

Search Discussions

173 discussions - 2,520 posts

  • Here is a new version of the patch, with most issues discussed in previous posts fixed. I've been struggling with two areas: - pg_dump sorting for MVs which depend on other MVs - proper handling of ...
    Kevin GrittnerKevin Grittner
    Jan 16, 2013 at 5:41 am
    Mar 8, 2013 at 3:31 pm
  • I mentioned last year that I wanted to start working on parallelism: https://wiki.postgresql.org/wiki/Parallel_Query_Execution Years ago I added thread-safety to libpq. Recently I added two parallel ...
    Bruce MomjianBruce Momjian
    Jan 15, 2013 at 10:14 pm
    Jan 24, 2013 at 11:17 pm
  • From: Andres Freund <<span class="m_body_email_addr" title="a7123d721660884e237a7e21487ad396" andres@2ndquadrant.com</span Subject: [PATCH] xlogreader-v4 In-Reply-To: Hi, this is the latest and ...
    Andres FreundAndres Freund
    Jan 8, 2013 at 7:10 pm
    Feb 20, 2013 at 3:28 am
  • Hi, using the MinGW cross-compiled PostgreSQL binaries from Fedora 18, I get the following error for both 32 and 64-bit compiled executables. listen_addresses = '*' and "trust" authentication was set ...
    Boszormenyi ZoltanBoszormenyi Zoltan
    Jan 18, 2013 at 10:43 pm
    Mar 22, 2013 at 4:50 pm
  • Hi, I took the liberty to create a new thread for $subject, because the main comments I've been receiving about Event Triggers at this point is how difficult it is to try and follow our discussions ...
    Dimitri FontaineDimitri Fontaine
    Jan 30, 2013 at 1:50 pm
    Mar 29, 2013 at 8:28 am
  • Hi, I have a bug pending that autovacuum fails to give priority to for-wraparound tables. When xid consumption rate is high and dead tuple creation is also high, it is possible that some tables are ...
    Alvaro HerreraAlvaro Herrera
    Jan 24, 2013 at 9:57 pm
    Mar 21, 2013 at 10:16 pm
  • Andres FreundAndres Freund
    Jan 15, 2013 at 1:38 am
    Feb 4, 2013 at 3:39 pm
  • Changing up the subject line because this is no longer a work in progress nor is it pg_ping anymore. I added the code comments, but realized it was already in the docs. I will provide a separate ...
    Phil SorberPhil Sorber
    Jan 21, 2013 at 5:24 pm
    Feb 10, 2013 at 9:03 pm
  • Greetings, Attached is a patch to add a 'COMPRESSED' option to COPY which will cause COPY to expect a gzip'd file on input and which will output a gzip'd file on output. Included is support for ...
    Stephen FrostStephen Frost
    Jan 14, 2013 at 2:16 am
    Jan 17, 2013 at 2:48 am
  • Here is a patch to add an option -I/--idempotent to pg_ctl, the result of which is that pg_ctl doesn't error on start or stop if the server is already running or already stopped. The previous ...
    Peter EisentrautPeter Eisentraut
    Jan 14, 2013 at 11:38 am
    Mar 6, 2013 at 4:37 am
  • The way it is now (9.2.2): 1. set up a new system 2. forget to install libperl-dev 3. ./configure --with-perl 4. get no failures or warnings 5. make 6. make errors out on plperl.so The way it should ...
    Josh BerkusJosh Berkus
    Jan 9, 2013 at 1:48 am
    Jan 14, 2013 at 5:09 pm
  • Hello this is very simple patch - it enables hidden_queries for commands \sf and \ef to be consistent with other describing commands. bash-4.1$ ./psql postgres -E psql (9.3devel) Type "help" for ...
    Pavel StehulePavel Stehule
    Jan 11, 2013 at 11:05 am
    Mar 4, 2013 at 7:45 pm
  • Greetings, We were surprised recently to note that the temp files that are created during a CREATE INDEX don't go into either a temp tablespace set for the user or into the tablespace which the ...
    Stephen FrostStephen Frost
    Jan 8, 2013 at 10:09 pm
    Jan 10, 2013 at 1:59 pm
  • Since we've fixed a couple of relatively nasty bugs recently, the core committee has determined that it'd be a good idea to push out PG update releases soon. The current plan is to wrap on Monday Feb ...
    Tom LaneTom Lane
    Jan 23, 2013 at 3:19 am
    Feb 7, 2013 at 2:59 pm
  • Hi, At the company I work for, we've been splitting dumps into separate files and diffing them for a while now. By far the biggest problem we had was with views: pg_dump by default dumps views on one ...
    Marko TiikkajaMarko Tiikkaja
    Jan 10, 2013 at 12:23 pm
    Feb 4, 2013 at 10:04 am
  • As a reminder, COPY FREEZE still does not issue any warning/notice if the freezing does not happen: Requests copying the data with rows already frozen, just as they would be after running the ...
    Bruce MomjianBruce Momjian
    Jan 23, 2013 at 7:02 pm
    Feb 2, 2013 at 7:27 pm
  • Hello, Please let me know if I can do something to get the bug fix (https://commitfest.postgresql.org/action/patch_view?id=902) committed. I would like to fix other bugs related to postgres ...
    Alexander LawAlexander Law
    Jan 23, 2013 at 5:06 pm
    Feb 20, 2013 at 12:00 pm
  • A user reported an interesting issue today. After restoring a dump created with --clean on a running application in his development environment his application started complaining of missing tables ...
    Peter van HardenbergPeter van Hardenberg
    Jan 21, 2013 at 11:25 pm
    Jan 25, 2013 at 2:42 pm
  • Hi, hackers, The attached is a patch to improve compression speeds with loss of compression ratios in backend/utils/adt/pg_lzcompress.c. Recent modern compression techniques like google LZ4 and ...
    Takeshi YamamuroTakeshi Yamamuro
    Jan 7, 2013 at 7:31 am
    Jan 9, 2013 at 7:57 am
  • If you dump a table with -t schema.table, and in the receiving database that schema does not exist, pg_restore-9.3devel will restore into the pg_catalog schema: HEAD $ cat test.sh #!/bin/sh ...
    Erik RijkersErik Rijkers
    Jan 13, 2013 at 10:17 am
    Apr 22, 2013 at 3:15 pm
  • Hi all, There is a strange bug with the latest master head (commit 7fcbf6a). When the WAL stream with a master is cut on a slave, slave returns a FATAL (well normal...), but then enters in recovery ...
    Michael PaquierMichael Paquier
    Jan 17, 2013 at 4:47 am
    Jan 22, 2013 at 12:25 am
  • Hello We use successfully use auto_explain. We miss support cancelled queries - we need same info for queries, that we cancel after x minutes. Subtask of this feature can be dumping currently ...
    Pavel StehulePavel Stehule
    Jan 11, 2013 at 12:43 pm
    Jan 13, 2013 at 8:32 pm
  • Hi, Here is the log output from the failing pg_regress after enabling checkpoints and timestamps: 2013-01-15 21:20:19 MSK [50f58fd3.589e:1] LOG: database system was shut down at 2013-01-15 21:20:19 ...
    Sergey KoposovSergey Koposov
    Jan 15, 2013 at 5:28 pm
    Jan 16, 2013 at 3:37 pm
  • So, it turns out the reason I got no feedback on this tool, was that I forgot both to email about and to actually push the code to github :O So this is actually code that's almost half a year old and ...
    Magnus HaganderMagnus Hagander
    Jan 1, 2013 at 3:10 pm
    Jan 25, 2013 at 9:23 pm
  • This patch adds sepgsql support for permission checks equivalent to the existing SCHEMA USE privilege. This feature is constructed on new OAT_SCHEMA_SEARCH event type being invoked around ...
    Kohei KaiGaiKohei KaiGai
    Jan 15, 2013 at 8:28 pm
    Apr 17, 2013 at 1:57 pm
  • Now that a standby server can follow timeline switches through streaming replication, we should do teach pg_receivexlog to do the same. Patch attached. I made one change to the way START_STREAMING ...
    Heikki LinnakangasHeikki Linnakangas
    Jan 15, 2013 at 2:05 pm
    Jan 24, 2013 at 5:42 am
  • Intel's icc and PathScale's pathcc compilers optimize away several overflow checks, since they consider signed integer overflow as undefined behavior. This leads to a vulnerable binary. Currently we ...
    Xi WangXi Wang
    Jan 20, 2013 at 7:52 am
    Feb 23, 2013 at 5:42 pm
  • Can somebody explain why a standalone count(*) returns 1? postgres=# select count(*); count ------- 1 (1 row) I agree it's an odd thing for someone to query, but I feel it should return 0, and not ...
    Gurjeet SinghGurjeet Singh
    Jan 13, 2013 at 9:12 pm
    Jan 21, 2013 at 8:11 pm
  • Here is a proposed patch for the issue discussed in <http://archives.postgresql.org/pgsql-hackers/2012-07/msg00569.php : I'd propose getting rid of lanplistrusted, at least for access checking ...
    Peter EisentrautPeter Eisentraut
    Jan 11, 2013 at 12:00 pm
    Mar 27, 2013 at 8:27 pm
  • Here is a patch for psql's \l command to accept patterns, like \d commands do. While at it, I also added an "S" option to show system objects and removed system objects from the default display. This ...
    Peter EisentrautPeter Eisentraut
    Jan 7, 2013 at 12:15 pm
    Mar 4, 2013 at 3:24 am
  • Hi, I want to test my lock_timeout code under Windows and I compiled the whole PG universe with the MinGW cross-compiler for 64-bit under Fedora 18. The problem contrib directories where Makefile ...
    Boszormenyi ZoltanBoszormenyi Zoltan
    Jan 18, 2013 at 9:42 pm
    Jan 21, 2013 at 2:23 am
  • Reference: http://postgresql.1045698.n5.nabble.com/Simple-join-doesn-t-use-index-td5738689.html This is a pretty common gotcha: user sets shared_buffers but misses the esoteric but important ...
    Merlin MoncureMerlin Moncure
    Jan 8, 2013 at 2:39 pm
    Jan 10, 2013 at 6:45 pm
  • This patch adds sepgsql the feature of name qualified creation label. Background, on creation of a certain database object, sepgsql assigns a default security label according to the security policy ...
    Kohei KaiGaiKohei KaiGai
    Jan 15, 2013 at 8:02 pm
    Mar 28, 2013 at 7:46 pm
  • Per this comment in lazy_scan_heap(), almost all tuple removal these days happens in heap_page_prune(): case HEAPTUPLE_DEAD: /* * Ordinarily, DEAD tuples would have been removed by * ...
    Noah MischNoah Misch
    Jan 8, 2013 at 2:50 am
    Feb 4, 2013 at 3:00 am
  • Observation is that whenever a checkpoint happens and the wal_level configured is hot_standby then one standby snapshot XLOG gets written with the information of "running transaction". So if first ...
    Amit KapilaAmit Kapila
    Jan 7, 2013 at 12:39 pm
    Jan 10, 2013 at 12:40 pm
  • Greetings, We've come across this rather annoying error happening during our builds: ERROR: could not create directory "pg_tblspc/25120/PG_9.3_201212081/231253": File exists It turns out that this is ...
    Stephen FrostStephen Frost
    Jan 17, 2013 at 2:19 pm
    Jan 19, 2013 at 6:50 pm
  • Since commit 2065dd2834e832eb820f1fbcd16746d6af1f6037, there have been a few buildfarm failures along the lines of -- Commit table drop COMMIT PREPARED 'regress-two'; ! PANIC: failed to re-find ...
    Tom LaneTom Lane
    Jan 14, 2013 at 9:35 pm
    Jan 15, 2013 at 5:18 pm
  • Hello, I have read the developers FAQ which directed me to this mailing list. I am still using Postgresql on Zeta (descendant of BeOS), but it is becoming time to upgrade, so I installed Haiku (open ...
    Mark HellegersMark Hellegers
    Jan 11, 2013 at 9:27 pm
    Jan 13, 2013 at 6:58 pm
  • Hi, While checking whether I could reproduce the replication delay reported by Michael Paquier I found this very nice tidbit: In a pretty trivial replication setup of only streaming replication I can ...
    Andres FreundAndres Freund
    Jan 17, 2013 at 9:46 pm
    Jan 19, 2013 at 7:05 am
  • Overall, the WAL record is MAXALIGN'd, so with 8 byte alignment we waste 4 bytes per record. Or put another way, if we could reduce record header by 4 bytes, we would actually reduce it by 8 bytes ...
    Simon RiggsSimon Riggs
    Jan 9, 2013 at 8:36 pm
    Jan 11, 2013 at 12:15 am
  • I'll take another stab at providing pkg-config files for the client-side libraries. The main reason this time around is that this works a lot better (or at all) for multi-arch library installations ...
    Peter EisentrautPeter Eisentraut
    Jan 15, 2013 at 7:15 pm
    Mar 31, 2013 at 11:18 pm
  • Hi all Would a committer be willing to pop some entries in .gitignore for Windows native build outputs? *.sln *.vcproj *.vcxproj It'd make life easier when testing Windows changes. -- Craig Ringer ...
    Craig RingerCraig Ringer
    Jan 23, 2013 at 5:05 am
    Jan 25, 2013 at 4:27 am
  • Hi, I made a patch to divide privileges for replication role. Currently(9.2), the privilege for replication role is true / false which means that standby server is able to connect to another server ...
    Tomonari KatsumataTomonari Katsumata
    Jan 19, 2013 at 3:47 am
    Jan 23, 2013 at 9:28 am
  • In multi-arch OS installations, using a single foo-config script to find libraries is problematic, because you don't know which architecture it will point to, and you can't choose which one you ...
    Peter EisentrautPeter Eisentraut
    Jan 14, 2013 at 11:51 am
    Mar 21, 2013 at 3:46 am
  • I have not had anyone follow up on this, so I have added docs and will add this to the commitfest. Recap: This adds the following: json_agg(anyrecord) - json to_json(any) - json ...
    Andrew DunstanAndrew Dunstan
    Jan 11, 2013 at 4:00 pm
    Mar 1, 2013 at 12:54 am
  • This error message change looks rather odd, and has my head spinning a bit: - errmsg("SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join"))); + errmsg("SELECT FOR ...
    Andrew DunstanAndrew Dunstan
    Jan 23, 2013 at 4:58 pm
    Feb 6, 2013 at 3:30 am
  • Over in the thread about enhanced error fields, I claimed that "constraints are uniquely named among those associated with a table, or with a domain". But it turns out that that ain't necessarily so, ...
    Tom LaneTom Lane
    Jan 29, 2013 at 12:25 am
    Jan 30, 2013 at 9:11 pm
  • TODO Item: Prevent temporary tables created with ON COMMIT DELETE ROWS from repeatedly truncating the table on every commit if the table is already empty Please find attached two patches, ...
    Gurjeet SinghGurjeet Singh
    Jan 14, 2013 at 10:32 pm
    Jan 29, 2013 at 8:46 am
  • Folks, Andrew Gierth asked me to send this out as his email is in a parlous state at the moment. My comments will follow in replies. Without further ado: SQL2008 says, for 7.6 <table reference 6) a) ...
    David FetterDavid Fetter
    Jan 24, 2013 at 5:51 pm
    Jan 26, 2013 at 12:30 am
  • Above is a very creative query that was posted to the bugs list by bricklen. It reports all non-default server settings, plus version(). Here is a realigned version: SELECT 'version'::text AS name, ...
    Bruce MomjianBruce Momjian
    Jan 19, 2013 at 4:05 pm
    Jan 20, 2013 at 2:52 pm
Group Navigation
period‹ prev | Jan 2013 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions173
posts2,520
users151
websitepostgresql.org...
irc#postgresql

151 users for January 2013

Tom Lane: 364 posts Andres Freund: 176 posts Robert Haas: 173 posts Bruce Momjian: 115 posts Simon Riggs: 98 posts Stephen Frost: 97 posts Andrew Dunstan: 91 posts Pavel Stehule: 78 posts Alvaro Herrera: 73 posts Amit Kapila: 73 posts Heikki Linnakangas: 73 posts Craig Ringer: 68 posts Peter Eisentraut: 68 posts Dimitri Fontaine: 61 posts Magnus Hagander: 57 posts Zoltán Böszörményi: 49 posts Noah Misch: 44 posts Joshua Berkus: 43 posts Phil Sorber: 41 posts Michael Paquier: 32 posts
show more
Archives