Search Discussions
-
A customer of ours has been having trouble with corrupted data for some time. Of course, we've almost always blamed hardware (and we've seen RAID controllers have their firmware upgraded, among other ...
Alvaro Herrera
Sep 30, 2008 at 6:09 pm
Dec 7, 2009 at 5:54 pm -
Over in that TPC-H thread, I was bemoaning once again the never-finished support for SQL-spec interval literals. I decided to go look at exactly how unfinished it was, and it turns out that it's ...
Tom Lane
Sep 10, 2008 at 12:19 am
Nov 26, 2008 at 4:55 pm -
Hi, In PGCon 2008, I proposed synchronous log shipping replication. Sorry for late posting, but I'd like to start the discussion about its implementation from now. ...
Fujii Masao
Sep 5, 2008 at 2:21 pm
Sep 19, 2008 at 10:05 am -
I updated the series of patches for SE-PostgreSQL 8.4devel. [1/5] http://sepgsql.googlecode.com/files/sepostgresql-sepgsql-8.4devel-3-r1043.patch [2/5] ...
KaiGai Kohei
Sep 24, 2008 at 2:43 am
Nov 4, 2008 at 10:43 pm -
Transaction snapshots is probably the most difficult problem for Hot Standby to resolve. We *must* have a transaction snapshot to access table data in a consistent way, or we must accept some ...
Simon Riggs
Sep 11, 2008 at 12:08 am
Oct 2, 2008 at 10:42 pm -
These are my initial comments about the Common Table Expressions (CTE) patch, also known as WITH [RECURSIVE]. These comments are based on the patch here: ...
Jeff Davis
Sep 8, 2008 at 3:16 pm
Oct 5, 2008 at 3:42 pm -
Howdy, The statistics collector currently dumps the stats file at every 500ms. This is a major problem if the file becomes large -- occasionally we've been forced to disable stats collection to cope ...
Martin Pihlak
Sep 5, 2008 at 7:00 pm
Jan 23, 2009 at 4:59 am -
I'm trying to upgrade my copy of postgresql from 8.2.x to 8.3.4 on a Windows Vista SP1 laptop. I build postgres using mingw/msys and have had no issues with 8.1.x and 8.2.x. However, with 8.3.4 I run ...
Charlie Savage
Sep 23, 2008 at 6:35 pm
Nov 13, 2008 at 12:41 pm -
Dear PG hackers, Has there been any idea to port PG to a more modern programming language like C++? Of course there are some minor obstacles like a new OO design, this being a gigantic task to ...
Gevik Babakhani
Sep 19, 2008 at 7:55 pm
Sep 27, 2008 at 4:37 pm -
I went through the CVS logs to draft release notes, and found that the list of patches applied to REL7_4_STABLE is a bit skimpy: http://developer.postgresql.org/pgdocs/postgres/release-7-4-22.html ...
Tom Lane
Sep 18, 2008 at 1:20 pm
Sep 21, 2008 at 3:48 am -
Hackers, We currently have 38 patches pending, and only nine people reviewing them. At this rate, the September commitfest will take three months. If you are a postgresql hacker at all, or even want ...
Josh Berkus
Sep 4, 2008 at 5:38 pm
Sep 6, 2008 at 11:58 pm -
I am working on getting parallel pg_restore working. I'm currently getting all the scaffolding working, and hope to have a naive prototype posted within about a week. The major question is how to ...
Andrew Dunstan
Sep 21, 2008 at 7:29 pm
Sep 24, 2008 at 7:11 pm -
Attached is my WIP patch for parallel pg_restore. It's still very rough, but seems to work. Anyone who can test this with highend equipment would be helping some. cheers andrew
Andrew Dunstan
Sep 25, 2008 at 3:02 am
Oct 3, 2008 at 8:48 am -
The name is now mandatory, no need to toggle the format string anymore. -- Andrew Chernow eSilo, LLC every bit counts http://www.esilo.com/
Andrew Chernow
Sep 5, 2008 at 7:39 pm
Sep 19, 2008 at 8:14 pm -
Hi, In reviewing Volkan Yazici's (sorry for the dots) patch to improve plpgsql's error messages, I noticed that we have no PO files for plpgsql at all! It doesn't seem hard to add; I just had to ...
Alvaro Herrera
Sep 5, 2008 at 3:37 pm
Oct 9, 2008 at 8:07 pm -
I 100% agree with Heikki here; having the conversion spill out into the main backend is very expensive and adds lots of complexity. The only argument for the Zdenek's conversion spill appoach is that ...
Bruce Momjian
Sep 6, 2008 at 8:41 pm
Sep 30, 2008 at 7:08 am -
Patch now includes all previous agreed changes, plus I've found what looks to be a workable method of removing the shutdown checkpoint without loss of robustness. Patch summary Tuning * Bgwriter ...
Simon Riggs
Sep 30, 2008 at 10:51 pm
Dec 29, 2008 at 10:27 am -
I had a thought while looking over the column-level privileges patch that Stephen Frost is working on. To wit, that the only reason that column default expressions are stored in a separate catalog ...
Tom Lane
Sep 21, 2008 at 5:09 pm
Sep 29, 2008 at 12:54 pm -
Howdy, Not *exactly* hackers-related, but I wanted to get a feel for this from those who are likely to use project hosting, and to minimize the chances of a flame war. Right now I have pgTAP on ...
David E. Wheeler
Sep 18, 2008 at 6:22 pm
Sep 24, 2008 at 9:00 pm -
I finally committed the new version of the FSM rewrite, after fixing the latest round of Tom's comments. There's a few loose ends I'm going to address as subsequent patches: pg_relation_size() ...
Heikki Linnakangas
Sep 30, 2008 at 11:03 am
Oct 6, 2008 at 6:51 pm -
Greg Smith
Sep 22, 2008 at 8:57 am
Oct 1, 2008 at 11:02 am -
Greetings, First, a quick digression into what I've gleaned from the spec in terms of implementation, from SQL2003: -- Table-level grants. The spec basically says that a table-level -- grant is as if ...
Stephen Frost
Sep 1, 2008 at 6:51 am
Dec 3, 2008 at 1:48 am -
Hi, We've been profiling a large system (8 CPUs, 64 GB of memory, some dozens of disks) which seems rather more swamped than it should. Part of the problem seems to come from CleanupTempFiles, the ...
Alvaro Herrera
Sep 17, 2008 at 8:25 pm
Sep 19, 2008 at 4:59 am -
Um? AFAICS RmgrTable is not accessed in XLogInsert unless we use WAL_DEBUG. I see that RmgrTable should be malloc'd when required, but there is another issue; when to load rmgr libraries. Rmgr ...
ITAGAKI Takahiro
Sep 2, 2008 at 9:30 am
Sep 16, 2008 at 9:04 am -
Hi, AFAICS, PostgreSQL is not keeping info about when a table, database, sequence, etc was created. We cannot get that info even from OS, since CLUSTER or VACUUM FULL may change the metadata of ...
Devrim Gündüz
Sep 9, 2008 at 7:19 pm
Sep 10, 2008 at 4:05 pm -
Greg just sent me this patch, augmenting the one I sent to add source file and line to GUC vars; Greg's patch adds a column with the default value of each var. I forward it to -hackers to have a ...
Alvaro Herrera
Sep 2, 2008 at 1:17 am
Sep 9, 2008 at 1:05 pm -
Subtransactions cause a couple of problems for Hot Standby: * we don't record new subtransactionids in WAL, so we have no direct way to issue updates to subtrans while in recovery mode as would ...
Simon Riggs
Sep 16, 2008 at 11:53 am
Oct 20, 2008 at 8:17 pm -
Folks, Far and away the most common question we get in IRC includes phrases like: psql: FATAL: Ident authentication failed for user "root" This isn't exactly informative to newbies, so I'm proposing ...
David Fetter
Sep 12, 2008 at 2:44 am
Sep 12, 2008 at 4:49 pm -
Hey folks, Tom pointed out in the parent thread [1] that the error message for bogus AM/PM markers in to_timestamp is pretty lame: ERROR: invalid AM/PM string I agree, and once I started thinking ...
Brendan Jurd
Sep 26, 2008 at 5:25 pm
Feb 7, 2009 at 2:16 pm -
Hello all, Here is my review of the Test citext casts written by David Wheeler: http://archives.postgresql.org/message-id/F721EFF1-553C-4E25-A293-7BD08D6957F4@kineticode.com 1. The patch applies ...
Ryan Bradetich
Sep 5, 2008 at 4:40 am
Oct 1, 2008 at 10:10 pm -
I found a bug that pg_controldata ends with error if control files contain 0x1A (Ctrl+Z) on Windows. We probably need to add PG_BINARY when we open control files because 0x1A is an end-of-file marker ...
ITAGAKI Takahiro
Sep 18, 2008 at 2:32 am
Sep 24, 2008 at 1:35 pm -
I observed a curious bug in autovac just now. Since plain vacuum avoids calling GetTransactionSnapshot, an autovac worker that happens not to analyze any tables will never call GetTransactionSnapshot ...
Tom Lane
Sep 10, 2008 at 3:53 pm
Sep 11, 2008 at 12:10 pm -
Attached is a revamped version of the FSM rewrite. WAL-logging is now gone. Any inconsistencies between levels of the FSM is fixed during vacuum, and by searchers when they run into a dead end ...
Heikki Linnakangas
Sep 22, 2008 at 5:44 pm
Sep 26, 2008 at 1:44 pm -
Currently we have only Assert(), or a run-time test. Can we introduce levels of assertion? That way we can choose how paranoid a build to make, like setting log_min_messages. We know many Assertions ...
Simon Riggs
Sep 19, 2008 at 8:25 am
Sep 21, 2008 at 10:59 pm -
Hi, I am currently working in EnterpriseDB (www.enterprisedb.com). During the integration of pldebugger ( http://pgfoundry.org/projects/edb-debugger ) with postgres on windows I faced a problem that ...
MUHAMMAD ASIF
Sep 9, 2008 at 8:05 am
Jan 7, 2009 at 9:26 am -
I'm currently playing with Andrews parallel restore patch and it seems that pg is far from taking advantage of the hardware I have for testing (Dual Quad Core Xeon attached to Netapp with 68 ...
Stefan Kaltenbrunner
Sep 26, 2008 at 4:03 pm
Sep 26, 2008 at 7:23 pm -
Hi, we came across a database where a table had a toasted table, keeping huge amounts of disk space allocated. However, the table's current definition didn't explain why there was a toasted table. ...
Zoltan Boszormenyi
Sep 21, 2008 at 9:38 am
Sep 24, 2008 at 1:58 am -
Greg Smith
Sep 16, 2008 at 4:10 am
Oct 6, 2008 at 6:42 pm -
Hi Heikki, I finally performed iGen test. I used two v490 servers with 4 dual core SPARC CPUs and 32GB RAM. I have only one disk and I did not performed any disk I/O optimization. I tested 105 ...
Zdenek Kotala
Sep 18, 2008 at 11:42 am
Sep 22, 2008 at 6:44 pm -
Disabling autovacuum can have catastrophic effects, since it disables the ANALYZing of tables. Can we have a mode where we disable autoVACUUM yet enable autoANALYZE? ANALYZE times are fairly bounded ...
Simon Riggs
Sep 15, 2008 at 9:46 am
Sep 17, 2008 at 8:21 pm -
I was in a discussion with someone about the difference between ad-hoc storage systems and SQL. Yes, I know, I was rolling my eyes as well. One thing did strike me though was the idea that a table ...
Mark L. Woodward
Sep 28, 2008 at 10:35 pm
Oct 6, 2008 at 6:51 pm -
So I just noticed that we have a description of the Pg innards in the sourcecode, complete with a flowchart and all, at src/tools/backend. I had already seen this graph years ago; what shocked me the ...
Alvaro Herrera
Sep 7, 2008 at 8:52 pm
Sep 15, 2008 at 7:22 am -
Howdy, I'm trying to write a simple function that will return a string with the type name of a value. Unfortunately, it keeps dying on me. I don't even get any useful debugging information with ...
David E. Wheeler
Sep 1, 2008 at 11:41 pm
Sep 2, 2008 at 7:31 pm -
In the previous discussion there was mentioned that Postgres should move to the SQL-MED direction in remote connection handling. SQL-MED specifies that connections should have names and referenced ...
Marko Kreen
Sep 5, 2008 at 12:40 pm
Oct 22, 2008 at 10:59 am -
Okay, I got tired of seeing people complain about foreign-key constraint violations in data-only dumps. While it's true that the problem can't be solved in the general case (because of potentially ...
Tom Lane
Sep 7, 2008 at 6:06 pm
Oct 14, 2008 at 11:52 am -
Hello. Is it possible to create a foreign key constraint for ALL elements of an array field? CREATE TABLE a(id INTEGER); CREATE TABLE b(id INTEGER, a_ids INTEGER[]); Field b.a_ids contains a list of ...
Dmitry Koterov
Sep 21, 2008 at 12:39 am
Oct 6, 2008 at 6:51 pm -
Good: regression=# select 'T' ilike 't'; ?column? ---------- t (1 row) Not so good: regression=# select 'T' ilike E'\\t'; ?column? ---------- f (1 row) ISTM backslash is only supposed to turn off the ...
Tom Lane
Sep 26, 2008 at 2:04 am
Sep 26, 2008 at 11:42 pm -
$ grep -i D2MDIR * -R doc/src/sgml/Makefile:D2MSCRIPT= $(D2MDIR)/docbook2man-spec.pl I could not find anything in the code related to this. I am trying to create man pages in -HEAD, and getting an ...
Devrim Gündüz
Sep 2, 2008 at 12:11 pm
Sep 12, 2008 at 8:44 am -
Any status updates on the following patches? 1. Fragments in tsearch2 headlines: http://archives.postgresql.org/pgsql-hackers/2008-08/msg00043.php 2. Bug in hlCover: ...
Sushant Sinha
Sep 16, 2008 at 4:54 am
Jan 8, 2009 at 2:35 pm -
I looked a bit at the bug report here: http://archives.postgresql.org/pgsql-bugs/2008-09/msg00164.php ISTM that the fundamental problem is that plpgsql doesn't distinguish properly between a null row ...
Tom Lane
Sep 27, 2008 at 6:56 pm
Jan 8, 2009 at 5:19 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 145 |
posts | 1,887 |
users | 136 |
website | postgresql.org... |
irc | #postgresql |
136 users for September 2008
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)