FAQ

PostgreSQL > pgsql-hackers > September 2008

Search Discussions

145 discussions - 1,887 posts

  • 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 HerreraAlvaro 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 LaneTom 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 MasaoFujii 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 KoheiKaiGai 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 RiggsSimon 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 DavisJeff 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 PihlakMartin 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 SavageCharlie 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 BabakhaniGevik 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 LaneTom 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 BerkusJosh 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 DunstanAndrew 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 DunstanAndrew 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 ChernowAndrew 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 HerreraAlvaro 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 MomjianBruce 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 RiggsSimon 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 LaneTom 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. WheelerDavid 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 LinnakangasHeikki Linnakangas
    Sep 30, 2008 at 11:03 am
    Oct 6, 2008 at 6:51 pm
  • Greg SmithGreg 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 FrostStephen 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 HerreraAlvaro 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 TakahiroITAGAKI 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üzDevrim 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 HerreraAlvaro 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 RiggsSimon 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 FetterDavid 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 JurdBrendan 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 BradetichRyan 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 TakahiroITAGAKI 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 LaneTom 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 LinnakangasHeikki 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 RiggsSimon 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 ASIFMUHAMMAD 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 KaltenbrunnerStefan 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 BoszormenyiZoltan Boszormenyi
    Sep 21, 2008 at 9:38 am
    Sep 24, 2008 at 1:58 am
  • Greg SmithGreg 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 KotalaZdenek 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 RiggsSimon 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. WoodwardMark 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 HerreraAlvaro 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. WheelerDavid 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 KreenMarko 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 LaneTom 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 KoterovDmitry 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 LaneTom 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üzDevrim 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 SinhaSushant 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 LaneTom Lane
    Sep 27, 2008 at 6:56 pm
    Jan 8, 2009 at 5:19 am
Sep 2008
123
Group Navigation
period‹ prev | Sep 2008 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions145
posts1,887
users136
websitepostgresql.org...
irc#postgresql

136 users for September 2008

Tom Lane: 337 posts Simon Riggs: 179 posts Heikki Linnakangas: 132 posts Alvaro Herrera: 86 posts Zdenek Kotala: 51 posts Andrew Dunstan: 50 posts Greg Stark: 50 posts Bruce Momjian: 48 posts Joshua Drake: 43 posts Markus Wanner: 40 posts Robert Haas: 35 posts KaiGai Kohei: 32 posts Magnus Hagander: 31 posts Ron Mayer: 28 posts David E. Wheeler: 27 posts Greg Smith: 25 posts Peter Eisentraut: 25 posts Andrew Chernow: 24 posts David Fetter: 24 posts Hannu Krosing: 24 posts
show more
Archives