FAQ

PostgreSQL > pgsql-hackers > December 2012

Search Discussions

132 discussions - 1,701 posts

  • Hi all, This proposal is about add a column "datcreated" on "pg_database" to store the "timestamp" of the database creation. A couple weeks ago I had a trouble with a PostgreSQL instance, actually ...
    Fabrízio de Royes MelloFabrízio de Royes Mello
    Dec 27, 2012 at 12:48 am
    Jan 9, 2013 at 10:34 am
  • Patch looks good and also like it will/can be ready for 9.3. I'm happy to put time into this as committer and/or reviewer and take further responsibility for it, unless others wish to. LIKES * It's ...
    Simon RiggsSimon Riggs
    Dec 4, 2012 at 7:35 pm
    Jan 3, 2013 at 8:02 pm
  • I got a report today on the IRC channel about a pg_upgrade problem with upgrading clusters with indexes that exist but are invalid. For example, if you use CREATE INDEX CONCURRENTLY, then shut down ...
    Bruce MomjianBruce Momjian
    Dec 7, 2012 at 12:28 am
    Dec 14, 2012 at 6:41 pm
  • It's hard to know whether your tables will be locked for long periods when implementing DDL changes. The NOREWRITE option would cause an ERROR if the table would be rewritten by the command. This ...
    Simon RiggsSimon Riggs
    Dec 1, 2012 at 1:55 pm
    Dec 7, 2012 at 10:02 pm
  • http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=8de72b66a2edcf12c812de0a73bd50b6b7d81d62 Part of that patch was reverted later ...
    Jeff DavisJeff Davis
    Dec 4, 2012 at 1:34 am
    Dec 22, 2012 at 2:36 am
  • Hackers, Currently we can see each master's current replicas using pg_stat_replication. However, there is no way from a replica, that I know of, to figure out who its master is other than to look at ...
    Josh BerkusJosh Berkus
    Dec 19, 2012 at 3:43 am
    Jan 9, 2013 at 8:42 pm
  • We discussed this idea in the past [1] and Robert recently again mentioned this in another thread [2]. Please see a rebased/revised patch attached with the mail. This is mostly similar to what I's ...
    Pavan DeolaseePavan Deolasee
    Dec 15, 2012 at 12:42 pm
    Jan 8, 2013 at 6:17 am
  • I'm testing a checkout from a few days ago and trying to complete a day long pgbench stress test, with assertions and debugging on. I want to make sure the base code works as expected before moving ...
    Greg SmithGreg Smith
    Dec 23, 2012 at 7:36 am
    Jan 9, 2013 at 7:36 pm
  • I'm going to use PL/Python as an example, but I would also like to know if this could be applicable to other languages. When you do CREATE FUNCTION foo(...) ... LANGUAGE plpythonu AS $$ source code ...
    Peter EisentrautPeter Eisentraut
    Dec 16, 2012 at 6:37 am
    Jan 3, 2013 at 6:13 am
  • Some of the buildfarm members are failing the pg_upgrade regression test since commit 12ee6ec71f8754ff3573711032b9b4d5a764ba84. I can duplicate it here, and the symptom is: pg_restore: creating TYPE ...
    Tom LaneTom Lane
    Dec 1, 2012 at 4:10 am
    Dec 3, 2012 at 9:01 pm
  • This is the first pg_upgrade mismatch report we have gotten about 9.1. I have asked the reporter for details. Is what is the full 9.1 version number? ...
    Bruce MomjianBruce Momjian
    Dec 18, 2012 at 2:22 am
    Dec 20, 2012 at 6:57 pm
  • Hi, Please find attached v3 of the patch to add information to event triggers, including command string. This work has mostly been part of the original goal and its design is the result of much ...
    Dimitri FontaineDimitri Fontaine
    Dec 11, 2012 at 9:47 pm
    Jan 9, 2013 at 4:58 pm
  • Here is a patch for the first part of the JSON API that was recently discussed. It includes the json parser hook infrastructure and functions for json_get and friends, plus json_keys. As is, this ...
    Andrew DunstanAndrew Dunstan
    Dec 26, 2012 at 8:34 pm
    Jan 10, 2013 at 11:42 pm
  • We seriously tested the enum code so I am pretty confused why this is failing. If you do pg_dump --binary-upgrade --schema-only, do you see that a number like this being defined just before the enum ...
    Bruce MomjianBruce Momjian
    Dec 18, 2012 at 1:41 am
    Dec 19, 2012 at 5:13 pm
  • Hello I rechecked performance of dynamic SQL and it is significantly slower in 9.2 than 9.1 -- 9.1 postgres=# create or replace function test() returns void as $$ begin for i in 1..1000000 loop ...
    Pavel StehulePavel Stehule
    Dec 27, 2012 at 6:07 am
    Jan 10, 2013 at 6:43 am
  • In a fully-built source tree: $ cd pgsql/src/backend/parser $ make make: Nothing to be done for `all'. ... okay so far ... $ rm gram.o rm: remove regular file `gram.o'? y $ make make: Nothing to be ...
    Tom LaneTom Lane
    Dec 14, 2012 at 10:02 pm
    Dec 19, 2012 at 1:47 pm
  • Folks, So as a test I tried to connect a group of 9.3 streaming replicas in a circle (4 replicas). This was very easy to do: 1. create r1 as replica of master 2. create r2 as replica of r1 3. create ...
    Josh BerkusJosh Berkus
    Dec 19, 2012 at 3:03 am
    Jan 9, 2013 at 9:11 am
  • [moved to hackers] I think we should backpatch it for 9.2.3. I've seen another email which is probably due to the same issue (nested loop vs hash join). And some monitoring of a database I am ...
    Jeff JanesJeff Janes
    Dec 18, 2012 at 6:00 am
    Jan 11, 2013 at 1:07 am
  • Hi, When initiating a new logical replication "slot" I want to provide a 'SET TRANSACTION SNAPSHOT'able snapshot which can be used to setup a new replica. I have some questions arround this where I ...
    Andres FreundAndres Freund
    Dec 11, 2012 at 11:52 pm
    Dec 14, 2012 at 11:48 am
  • I committed background workers three weeks ago, claiming it worked on EXEC_BACKEND, and shortly thereafter I discovered that it didn't. I noticed that the problem is the kludge to cause postmaster ...
    Alvaro HerreraAlvaro Herrera
    Dec 27, 2012 at 5:15 pm
    Jan 2, 2013 at 4:28 pm
  • In both checkpointer.c and bgwriter.c, we do this before entering the main loop: /* * Use the recovery target timeline ID during recovery */ if (RecoveryInProgress()) ThisTimeLineID = ...
    Heikki LinnakangasHeikki Linnakangas
    Dec 19, 2012 at 4:00 pm
    Dec 21, 2012 at 8:14 am
  • The documentation for PQclear() doesn't say whether it is safe to call PQclear() more than once on the same PGresult pointer. In fact, it is not safe, but apparently only because of this last step ...
    Josh KupershmidtJosh Kupershmidt
    Dec 11, 2012 at 5:00 am
    Jan 2, 2013 at 4:36 pm
  • Hi, Now that XLRecPtr's are plain 64bit integers what are we supposed to use in code comparing and manipulating them? There already is plenty example of both, but I would like new code to go into one ...
    Andres FreundAndres Freund
    Dec 16, 2012 at 2:16 pm
    Dec 28, 2012 at 6:45 pm
  • Hi, Courtesy of me, Christmas comes a bit early this year. I wrote a patch which allows you to add STRICT into PERFORM and INSERT/UPDATE/DELETE without specifying an INTO clause. Observe: =# create ...
    Marko TiikkajaMarko Tiikkaja
    Dec 21, 2012 at 3:14 pm
    Dec 21, 2012 at 7:14 pm
  • Hello, I have a problem with PostgreSQL 9.2 with Pacemaker. HA standby sometime failes to start under normal operation. Testing with a bare replication pair showed that the standby failes startup ...
    Kyotaro HORIGUCHIKyotaro HORIGUCHI
    Dec 6, 2012 at 4:05 am
    Dec 12, 2012 at 3:36 pm
  • When there is 'ssl=on' then postmaster calls SSL_CTX_new(), which asks for random number, thus requiring initialization of randomness pool (RAND_poll). After that all forked backends think pool is ...
    Marko KreenMarko Kreen
    Dec 21, 2012 at 4:05 pm
    Dec 27, 2012 at 3:21 pm
  • pg_basebackup -x is supposed to include all the required WAL files in the backup, so that you have everything needed to restore a consistent database. However, it's not including the timeline history ...
    Heikki LinnakangasHeikki Linnakangas
    Dec 17, 2012 at 2:16 pm
    Jan 2, 2013 at 6:05 pm
  • As I'm working through the parallel dump patch, I notice this in one of the header files: #ifdef USE_ASSERT_CHECKING #define Assert(condition) \ if (!(condition)) \ { \ write_msg(NULL, "Failed ...
    Andrew DunstanAndrew Dunstan
    Dec 14, 2012 at 3:27 pm
    Dec 18, 2012 at 3:37 am
  • Someone just reported a problem when they had created a new tablespace inside the old data directory. I'm sure there can be other issues caused by this as well, but this is mainly a confusing ...
    Magnus HaganderMagnus Hagander
    Dec 1, 2012 at 1:45 pm
    Dec 5, 2012 at 1:04 am
  • Hello, Although this may have to be posted to pgsql-bugs or pgsql-general, let me ask you here because the problem probably needs PostgreSQL's code fix. [Problem] I'm using PostgreSQL 9.1.6 on ...
    MauMauMauMau
    Dec 6, 2012 at 2:44 pm
    Dec 17, 2012 at 9:30 pm
  • COPY IN loops in heap_multi_insert() extending the table until it fills the disk when trying to insert a wide row into a table with a low fill-factor. Internally fill-factor is implemented by ...
    David GouldDavid Gould
    Dec 12, 2012 at 11:03 am
    Dec 14, 2012 at 11:37 pm
  • I was looking at the following code in heapam.c: 261 /* 262 * If the all-visible flag indicates that all tuples on the page are 263 * visible to everyone, we can skip the per-tuple visibility tests ...
    Pavan DeolaseePavan Deolasee
    Dec 4, 2012 at 1:08 pm
    Dec 14, 2012 at 8:45 pm
  • In a BEFORE UPDATE trigger I need to know whether the row was previously modified by this transaction. Is it safe to use xmin and txid_current() for this purpose (xmin is 32-bit txid type but ...
    Vlad ArkhipovVlad Arkhipov
    Dec 6, 2012 at 8:58 am
    Dec 7, 2012 at 2:38 am
  • Hello guys, I've been finding performance issues when using a trigger to modify inserts on a partitioned table. If using the trigger the total time goes from 1 Hour to 4 hours. The trigger is pretty ...
    Charles GomesCharles Gomes
    Dec 21, 2012 at 4:25 pm
    Jan 3, 2013 at 5:29 pm
  • There are some system administration functions that have hardcoded superuser checks, specifically: pg_reload_conf pg_rotate_logfile pg_read_file pg_read_file_all pg_read_binary_file ...
    Peter EisentrautPeter Eisentraut
    Dec 18, 2012 at 5:08 pm
    Dec 20, 2012 at 12:14 am
  • Hello, After long delay (sorry) here's a patch implementing what was hand-waved at in http://archives.postgresql.org/pgsql-hackers/2012-10/msg00176.php I am still something at a loss at how to test ...
    Daniel FarinaDaniel Farina
    Dec 28, 2012 at 11:43 am
    Dec 30, 2012 at 6:32 am
  • Hello Can we implement REGROLE type, that simplify role name <- oid transformations? Regards Pavel
    Pavel StehulePavel Stehule
    Dec 25, 2012 at 10:26 am
    Dec 26, 2012 at 5:34 pm
  • Some idle thoughts has provoked me to sending this email. I'm wondering what I'm seeing here, is a simple missed optimisation or something that would be very difficult to implement, or even perhaps ...
    David RowleyDavid Rowley
    Dec 5, 2012 at 11:37 pm
    Dec 7, 2012 at 3:41 am
  • Hi,pgsql-hackers, I'm not sure whether it is a bug of using spgist index or not . OS Version: CentOS release 6.2 (Final) PostgreSQL Version: postgres=# select version(); version ...
    李海龙李海龙
    Dec 13, 2012 at 3:46 pm
    Jan 11, 2013 at 6:21 pm
  • Currently, ANALYZE collects data on all columns and stores these samples in pg_statistic where they can be seen via the view pg_stats. In some cases we have data that is private and we do not wish ...
    Simon RiggsSimon Riggs
    Dec 12, 2012 at 6:12 pm
    Dec 13, 2012 at 9:35 am
  • Hi All, I briefly mentioned this idea in one of the other thread, but starting a new thread to highlight the point. Today, we set the visibility map *only* in the first phase of vacuum. This works ...
    Pavan DeolaseePavan Deolasee
    Dec 6, 2012 at 9:31 am
    Dec 7, 2012 at 12:48 pm
  • The recent SET SCHEMA refactoring has changed the error message that you get when trying to move a function into the schema that already contains it. For a table, as ever, you get: rhaas=# create ...
    Robert HaasRobert Haas
    Dec 20, 2012 at 2:24 pm
    Jan 8, 2013 at 1:58 pm
  • Hi List, This might not be the right place to post, but I've got a minor patch for pg_top and would like to submit it for review. Basically, the rpm version in the repositories pg_top92-3.6.2 doesn't ...
    Brett MatonBrett Maton
    Dec 20, 2012 at 12:18 pm
    Dec 21, 2012 at 7:02 am
  • We are regularly teaching PostgreSQL courses at linuxhotel.de. Starting from the course in November, PG doesn't compile anymore on their default Debian Squeeze install laptops they hand out to the ...
    Christoph BergChristoph Berg
    Dec 17, 2012 at 5:03 pm
    Dec 19, 2012 at 10:08 am
  • Mikko TiihonenMikko Tiihonen
    Dec 12, 2012 at 10:11 pm
    Dec 14, 2012 at 9:00 pm
  • I wonder if we really need to make another pass over the entire visibility map to count the number of all-visible pages at the end of the vacuum. The code that I'm looking at is in ...
    Pavan DeolaseePavan Deolasee
    Dec 3, 2012 at 6:15 pm
    Dec 4, 2012 at 8:43 am
  • I'm with Heikki on the -1 on this. It's certainly unexpected to have the slave affect the master by default - people will expect the master to be independent. Also, it doesn't IMHO actually *help* ...
    Magnus HaganderMagnus Hagander
    Dec 1, 2012 at 12:09 am
    Dec 3, 2012 at 2:08 pm
  • Hi, I don't feel particularly qualified to comment, but in the interest of (hopefully) helping with the patch review process I'm going to comment anyway. (Having written this, I feel decidedly ...
    Karl O. PincKarl O. Pinc
    Dec 10, 2012 at 4:34 am
    Jan 9, 2013 at 7:29 pm
  • Hello I am not sure, but maybe is time to introduce ANSI SQL syntax for functions' named parameters It is defined in ANSI SQL 2011 CALL P (B = 1, A = 2) instead PostgreSQL syntax CALL ( B := 1, A := ...
    Pavel StehulePavel Stehule
    Dec 28, 2012 at 4:23 pm
    Jan 3, 2013 at 7:55 am
  • Bug #7758 seems to be a rediscovery of the behavior that Itagaki-san complained of a couple years ago: http://archives.postgresql.org/pgsql-hackers/2010-09/msg02035.php While reconsidering the ...
    Tom LaneTom Lane
    Dec 20, 2012 at 12:51 am
    Dec 20, 2012 at 9:43 pm
Dec 2012
123
Group Navigation
period‹ prev | Dec 2012 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions132
posts1,701
users128
websitepostgresql.org...
irc#postgresql

128 users for December 2012

Tom Lane: 189 posts Andres Freund: 147 posts Simon Riggs: 129 posts Robert Haas: 104 posts Bruce Momjian: 80 posts Pavel Stehule: 65 posts Heikki Linnakangas: 58 posts Dimitri Fontaine: 52 posts Stephen Frost: 50 posts Andrew Dunstan: 43 posts Amit Kapila: 41 posts Peter Eisentraut: 41 posts Pavan Deolasee: 40 posts Joshua Berkus: 36 posts Peter Geoghegan: 30 posts Alvaro Herrera: 29 posts Jeff Davis: 29 posts Tomas Vondra: 26 posts Kohei KaiGai: 25 posts Kevin Grittner: 24 posts
show more
Archives