Search Discussions
-
137
unlogged tables
Here is a series of three patches related to unlogged tables. 1. The first one (relpersistence-v1) is a mostly mechanical patch that replaces pg_class.relistemp (a Boolean) with ...Robert Haas
Nov 14, 2010 at 12:16 am
Dec 20, 2010 at 5:50 pm -
Final patch in this series for today spreads out the individual checkpoint fsync calls over time, and was written by myself and Simon Riggs. Patch is based against a system that's already had the two ...
Greg Smith
Nov 14, 2010 at 11:48 pm
Feb 11, 2011 at 4:01 am -
Per previous threats, I spent some time tonight running oprofile (using the directions Tom Lane was foolish enough to provide me back in May). I took testlibpq.c and hacked it up to just connect to ...
Robert Haas
Nov 24, 2010 at 5:07 am
Dec 7, 2010 at 6:41 am -
Hi, hackers, Attached is a patch that adds file_fdw, FDW which reads records from files on the server side, as a contrib module. This patch is based on "SQL/MED core functionality" patch. [SQL/MED - ...
Shigeru HANADA
Nov 25, 2010 at 8:12 am
Feb 21, 2011 at 4:37 pm -
This is the second patch for parallel pg_dump, now the actual part that parallelizes the whole thing. More precisely, it adds parallel backup/restore to pg_dump/pg_restore for the directory archive ...
Joachim Wieland
Nov 15, 2010 at 12:01 am
Dec 26, 2010 at 3:13 am -
Last week, I posted a couple of possible designs for making the visibility map crash-safe, which did not elicit much comment. Since this is an important prerequisite to index-only scans, I'm trying ...
Robert Haas
Nov 30, 2010 at 4:57 am
Jan 8, 2011 at 2:59 am -
Hi all, The discussion around wCTE during the last week or so has brought to my attention that we don't actually have a consensus on how exactly wCTEs should behave. The question seems to be whether ...
Marko Tiikkaja
Nov 11, 2010 at 2:15 am
Feb 25, 2011 at 5:19 pm -
Hi hackers, Attached is a patch that adds core functionality of SQL/MED. This patch provides: * new option HANDLER for FOREIGN DATA WRAPPER * CREATE/ALTER DDLs are supported * psql \dew command shows ...
Shigeru HANADA
Nov 25, 2010 at 7:34 am
Jan 5, 2011 at 11:37 am -
I've just looked at pg_execute_from_file[1]. The idea here is to execute all the SQL commands in a given file. My comments: * It applies well enough, and builds fine * It seems to work, and I've not ...
Joshua Tolley
Nov 25, 2010 at 6:35 am
Dec 8, 2010 at 2:28 pm -
Hello this patch remove a multiple detoasting of varlena values in plpgsql. It is usable mainly for iteration over longer array directly loaded from relation. It's doesn't have a impact on semantic ...
Pavel Stehule
Nov 22, 2010 at 12:47 pm
Mar 11, 2011 at 6:10 am -
A customer of ours is quite bothered about finding zero pages in an index after a system crash. The task now is to improve the diagnosability of such an issue and be able to definitively point to the ...
Gurjeet Singh
Nov 6, 2010 at 10:43 am
Dec 7, 2010 at 5:11 am -
Hackers, I've been trying to diagnose in a production database why certain tables never get autovacuumed despite having a substantial % of updates. The obvious reason is locks blocking autovacuum ...
Josh Berkus
Nov 17, 2010 at 9:46 pm
Feb 8, 2011 at 3:05 am -
I compiled the source with mingw gcc 4.5.0, that has been released recently. The compile was succeeded and worked well at least for simple queries, but there were many warnings during the compile. ...
Itagaki Takahiro
Nov 1, 2010 at 10:24 am
Dec 16, 2010 at 5:15 pm -
Hi, frequently i have accidents with DELETE/UPDATE commands. In fact, sometimes in the last 8 or 9 years (ok, a lot of times) I forget the entire WHERE clause or have a “not so perfectly“ WHERE ...
Daniel Loureiro
Nov 30, 2010 at 2:08 am
Dec 3, 2010 at 12:26 am -
Following the discussions here (http://archives.postgresql.org/message-id/12375.1289429390@sss.pgh.pa.us), here's a draft version of a rewrite of the GiST insertion algorithm and WAL-logging. The ...
Heikki Linnakangas
Nov 16, 2010 at 4:33 pm
Jan 9, 2011 at 7:38 pm -
This is the first of two patches for parallel pg_dump. In particular, this patch adds a new pg_dump archive type which can save pg_dump data to a directory, with each table/blob being a file so that ...
Joachim Wieland
Nov 15, 2010 at 12:18 am
Dec 16, 2010 at 10:55 pm -
Here is the next patch in this epic series. [0] I have addressed most of the issues pointed out in previous reviews and removed all major outstanding problems that were marked in the code. So it ...
Peter Eisentraut
Nov 15, 2010 at 12:06 am
Dec 16, 2010 at 11:11 am -
Currently, we overload "indent" meaning both "unix socket authentication" and "ident over tcp", depending on what type of connection it is. This is quite unfortunate - one of them being one of the ...
Magnus Hagander
Nov 17, 2010 at 3:35 pm
Mar 19, 2011 at 5:48 pm -
For the Serializable Snapshot Isolation (SSI) patch I needed a test suite which would handle concurrent sessions which interleaved statements in predictable ways. I was told pgTAP wasn't a good ...
Kevin Grittner
Nov 10, 2010 at 1:31 pm
Nov 12, 2010 at 6:58 pm -
We have the rm_safe_restartpoint mechanism to ensure that we don't use a checkpoint that splits a multi-level B-tree insertion as a restart point. But to my surprise, we don't have anything to ...
Heikki Linnakangas
Nov 2, 2010 at 10:56 am
Aug 23, 2012 at 2:14 pm -
Hi SQL/MED developers, Our company has just finished development of a database extension for Informix that provides tabular access to various types of structured files (NetCDF and HDF5, with more ...
Eric Davies
Nov 3, 2010 at 8:39 pm
Nov 24, 2010 at 9:58 am -
Attached patch adds some logging for each individual fsync call made during a checkpoint, along with a summary at the end. You need to have the following to see all of the detail: log_checkpoints=on ...
Greg Smith
Nov 14, 2010 at 9:45 pm
Dec 16, 2010 at 1:56 pm -
Hi list, PostgreSQL's default settings change when built with Linux kernel headers 2.6.33 or newer. As discussed on the pgsql-performance list, this causes a significant performance regression: ...
Marti Raudsepp
Nov 5, 2010 at 5:24 pm
Jan 15, 2011 at 4:59 pm -
Postgres supports ARRAY data types well, but there are some more array functions in the SQL standard. Also, the standard has MULTISET data type, that is an unordered array. It looks easy to support ...
Itagaki Takahiro
Nov 11, 2010 at 3:03 pm
Nov 18, 2010 at 8:52 am -
I try to take problem of iteration over ROW or RECORD variable from a different perspective. I would to design a solution where isn't necessary a conversion from binary value to text (this is a ...
Pavel Stehule
Nov 8, 2010 at 6:25 pm
Nov 9, 2010 at 8:02 pm -
There are also at least three non-Windows buildfarm members failing like so: gmake -C src all gmake[1]: Entering directory `/home/pgbuild/pgbuildfarm/HEAD/pgsql.6736/src' gmake[1]: *** virtual memory ...
Tom Lane
Nov 13, 2010 at 4:25 am
Nov 16, 2010 at 10:28 pm -
Hi list, Often enough when developing PostgreSQL views and functions, I have pasted the CREATE OR REPLACE commands into the wrong window/shell and ran them there without realizing that I'm creating a ...
Marti Raudsepp
Nov 28, 2010 at 3:15 pm
Jan 28, 2011 at 8:49 pm -
The attached patch is a contrib module to inject a few seconds delay on authentication failed. It is also a proof of the concept using the new ClientAuthentication_hook. This module provides a ...
KaiGai Kohei
Nov 4, 2010 at 12:49 pm
Nov 29, 2010 at 1:47 am -
The goal of this work is to address all of the shortcomings of previous POSIX shared memory patches as pointed out mostly by Tom Lane. Branch: ...
A.M.
Nov 14, 2010 at 12:49 am
Apr 14, 2011 at 6:23 pm -
Hackers, Seg contrib module contains the same bug in picksplit function as cube contrib module. Also, Guttman's split algorithm is not needed in unidimensional case, because sorting based algorithm ...
Alexander Korotkov
Nov 3, 2010 at 9:24 pm
Dec 15, 2010 at 11:15 pm -
I have a hot_standby system and use it to bear the load of various reporting queries that take 15-60 minutes each. In an effort to avoid long pauses in recovery, I set a vacuum_defer_cleanup_age ...
Noah Misch
Nov 29, 2010 at 6:17 am
Jun 16, 2011 at 4:14 pm -
Hi all, I'd like to revive Fernando Ike's patch implementing the "\dL" command for psql to list available languages, last version here: ...
Josh Kupershmidt
Nov 22, 2010 at 1:19 am
Jan 20, 2011 at 5:04 am -
Hello List, Is there any reason why Postgres should not support an "ALTER TABLE tablename [IF EXISTS]" feature? (And similar for other ALTER OBJECTTYPE) For example, a hypothetical statement that ...
Daniel Farina
Nov 5, 2010 at 7:31 am
Nov 30, 2010 at 3:04 am -
Hackers, I just thought of a good feature to put on the [E] list for TODO, if people agree: a switch to pg_dump called "--from-list" which would take a filename and dump the list of objects in that ...
Josh Berkus
Nov 24, 2010 at 2:34 am
Nov 26, 2010 at 6:59 pm -
Hi, http://archives.postgresql.org/pgsql-hackers/2010-11/msg01303.php When I did unusual operations (e.g., suspend bgwriter by gdb, pgbench -i and issue txid_current many times) on the master in ...
Fujii Masao
Nov 24, 2010 at 4:27 am
Nov 29, 2010 at 1:14 am -
I've spent a few hours pouring over the source code with coarse-toothed comb, trying to figure out just exactly what might break if we changed MyDatabaseId after backend startup time, or in other ...
Robert Haas
Nov 15, 2010 at 4:39 am
Nov 27, 2010 at 4:56 pm -
Hi, I work on implementing binary protocol, during test "select ?::int" has been executed few times to compile it to server prepared statement, but after this backend returned field format = text, ...
Radosław Smogura
Nov 24, 2010 at 7:07 am
Nov 26, 2010 at 9:01 am -
While designing writeable CTEs, I found it needs a new infrastructure that helps to share the result data among separated PlannedStmt. Up to now, in a portal we only have multiple plans that share ...
Hitoshi Harada
Nov 7, 2010 at 1:02 pm
Nov 8, 2010 at 10:38 pm -
Folks, For the past couple of years, I've been hearing from the PostGIS people among others that our type system just isn't flexible enough for their needs. It's really starting to show its age, or ...
David Fetter
Nov 12, 2010 at 4:43 pm
Nov 15, 2010 at 5:27 am -
Hey All, I just noticed that an editor at the w3c seems to have hit a wall with browser implementers, as they are all using Sqlite as their backend database, and so there is no second, independent ...
Charles Pritchard
Nov 7, 2010 at 2:26 am
Jan 16, 2011 at 12:51 am -
Hi, So I've been working on improving locks for foreign key checks, as discussed in a thread started by Joel Jacobson a while ago. I've posted about this: ...
Alvaro Herrera
Nov 25, 2010 at 10:01 pm
Dec 3, 2010 at 4:31 pm -
Hello, Here is the proposal to add synonyms to PostgreSQL. Initial goal is to add synonyms for relations (tables, views, sequences) and an infrastructure to allow synonyms for other database objects ...
Alexey Klyukin
Nov 30, 2010 at 4:08 pm
Dec 3, 2010 at 12:27 pm -
I have worked on some improvements on how we handle recursive make in our makefiles. Most places uses for loops, which has some disadvantages: parallel make doesn't work across directories, make -k ...
Peter Eisentraut
Nov 2, 2010 at 4:43 am
Nov 11, 2010 at 9:12 pm -
Hi, I am seeing the following here on 9.0.1 on Linux x86-64: LOG: redo starts at 1F8/FC00E978 FATAL: too many KnownAssignedXids CONTEXT: xlog redo insert: rel 1663/16384/18373; tid 3829898/23 and ...
Joachim Wieland
Nov 19, 2010 at 9:46 pm
Dec 15, 2010 at 7:54 pm -
Fellow Hackers, I'm writing a function to turn an EXPLAIN plan into a table with columns. As such, I need to have a complete list of the various bits of each plan node and their types for the table. ...
David E. Wheeler
Nov 5, 2010 at 8:27 pm
Nov 9, 2010 at 8:19 am -
We've gotten a few inquiries about whether Postgres can use "huge pages" under Linux. In principle that should be more efficient for large shmem regions, since fewer TLB entries are needed to support ...
Tom Lane
Nov 27, 2010 at 7:27 pm
Nov 29, 2010 at 3:53 pm -
Patch attached. Best, David
David E. Wheeler
Nov 22, 2010 at 11:37 pm
Nov 28, 2010 at 1:09 am -
The attached patch provides plugin modules a hook just after object creation time. In typical use cases, it enables to assign default security labels on object creation by the external security ...
KaiGai Kohei
Nov 9, 2010 at 10:52 am
Nov 25, 2010 at 4:52 pm -
The attached patch allows the security label provider to switch security label of the client during execution of certain functions. I named it as "label switcher function"; also called as "trusted- ...
KaiGai Kohei
Nov 13, 2010 at 3:37 am
Dec 14, 2010 at 12:23 am -
Hi, When we lock on a Xid or VirtualXid, there's no way to obtain clear information on the reason for locking. Consider the following example: CREATE TABLE foo (a int); Session 1: BEGIN; SELECT 1; -- ...
Alvaro Herrera
Nov 22, 2010 at 10:56 pm
Nov 25, 2010 at 7:09 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 158 |
posts | 2,109 |
users | 144 |
website | postgresql.org... |
irc | #postgresql |
144 users for November 2010
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)