Search Discussions
-
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 ...
MauMau
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 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 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 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 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 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 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 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 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 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 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 Haas
Dec 20, 2012 at 2:24 pm
Jan 8, 2013 at 1:58 pm -
6
pg_top
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 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 Berg
Dec 17, 2012 at 5:03 pm
Dec 19, 2012 at 10:08 am -
Mikko 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 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 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. 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 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 Lane
Dec 20, 2012 at 12:51 am
Dec 20, 2012 at 9:43 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 132 |
posts | 1,701 |
users | 128 |
website | postgresql.org... |
irc | #postgresql |
128 users for December 2012
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)