PgSql

[HACKERS] Bug? Concurrent COMMENT ON and DROP object
In the following scenario, we can see orphan comments. session.1 session.2 ---------------------- ---------------------- 1: CREATE TYPE my_typ AS (a int, b text); 2: BEGIN; 3: COMMENT ON TYPE my_typ IS 'testtest'; 4: ... 6 Jul 2010 03:33

get_whatever_oid, part 2
(2010/06/15 2:25), Robert Haas wrote: Per previous discussion: http://archives.postgresql.org/pgsql-hackers/2010-05/msg01195.php http://archives.postgresql.org/pgsql-hackers/2010-05/msg01577.php Changes in this patch: - Rename TSParserGetPrsid to get_tsparser_oid, TSDictionaryGetDictid to ... 12 Jul 2010 04:10

64-bit pgbench V2
Greg Smith <greg(a)2ndquadrant.com> writes: The main tricky part was figuring how to convert the \setshell implementation. That uses strtol to parse the number that should have been returned by the shell call. It turns out there are a stack of ways to do something similar but return 64 bits instead: P... 12 Jul 2010 16:16

[HACKERS] 64-bit pgbench V2
Attached is an updated second rev of the patch I sent a few months ago, to expand pgbench to support database scales larger than around 4,294--where the 32-bit integer for the account number overflows in the current version. The current limit makes for about a 60GB database. Last week I ran this on a system w... 5 Jul 2010 19:58

t_self as system column
Alvaro Herrera <alvherre(a)alvh.no-ip.org> writes: Is there a reason we don't have t_self as one of the system columns that you can examine from SQL? I'd propose its addition otherwise. pg_attribute bloat? I'm a bit hesitant to add a row per table for something we've gotten along without for so long, especial... 7 Jul 2010 16:46

Buildfarm + Git tryouts
Excerpts from Chris Browne's message of lun jul 05 12:33:49 -0400 2010: 3. Some problems checking status. i) Status Line: 491 bad ts parameter - [timestamp omitted] is in the future I know my clock's reasonable - ntp is reporting I'm within 0.25s of some stratum 2 nodes. Is it possible that the ... 5 Jul 2010 14:26

logistics for beta3
Robert Haas <robertmhaas(a)gmail.com> writes: - Someone will need to branch the tree after the wrap and stamp it 9.1devel. Who is doing that? Marc generally takes care of making branches. * bump catalog version for plpython3u change? Use RTLD_GLOBAL? -- I don't immediately know what the bit about RTLD_G... 6 Jul 2010 15:35

[HACKERS] logistics for beta3
On Mon, Jun 28, 2010 at 2:40 PM, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: Josh Berkus <josh(a)agliodbs.com> writes: Therefore, I propose that we set a beta3 release date for July 8th. That should give it enough space from the American Holiday. You mean wrap on Thursday the 8th for release on Monday the 12th? ... 5 Jul 2010 11:05

Always truncate segments before unlink
Takahiro Itagaki <itagaki.takahiro(a)oss.ntt.co.jp> writes: In mdunlink(), we truncate the first main fork to zero length and actually unlink at the next checkpoint, but other segments are not truncated and only unlinked. Then, if another backend open the segments, disk spaces occupied by them are not reclaim... 16 Jul 2010 05:34

Table partitioning - is anything coming?
Igor Kryltsov wrote: I am not asking any firm dates but when (and if) do you think roughly it will be any enhancements on automating partitioning in Postgres? The earliest possible date for that is the summer of 2011 when PostgreSQL 9.1 might be released: http://wiki.postgresql.org/wiki/PostgreSQL_9... 5 Jul 2010 11:05