Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-hackers - August 2012

2012-08-01

• Re: proposal - assign result of query to psql variable David Fetter (04:05)
• Re: JSON function reference in docs Tom Lane (04:42)
• Re: pg_dump and thousands of schemas Hugo <Nabble> (05:33)
• [PATCH] Make "psql -1 < file.sql" work as with "-f" Fabien COELHO (08:28)
• Re: Fixing syslogger rotation logic for first-time case Amit Kapila (12:59)
• Re: New statistics for WAL buffer dirty writes Robert Haas (14:07)
• Re: New statistics for WAL buffer dirty writes Tom Lane (14:12)
• Re: Help me develop new commit_delay advice Amit Kapila (14:14)
• Re: New statistics for WAL buffer dirty writes Robert Haas (14:42)
• Re: [patch] libpq one-row-at-a-time API Tom Lane (15:18)
• Re: Help me develop new commit_delay advice Peter Geoghegan (15:19)
• Re: compiler barriers (was: New statistics for WAL buffer dirty writes) Robert Haas (15:35)
• [PATCH] Support for Array ELEMENT Foreign Keys Marco Nenciarini (17:41)
• Re: [PATCH] Support for foreign keys with arrays Gabriele Bartolini (17:53)
• Re: [patch] libpq one-row-at-a-time API Marko Kreen (19:44)

2012-08-02

• Re: [patch] libpq one-row-at-a-time API Tom Lane (05:19)
• Git diff patch in context diff format Qi Huang (09:03)
• WIP Patch: Use sortedness of CSV foreign tables for query planning Etsuro Fujita (11:01)
• Re: Help me develop new commit_delay advice Amit Kapila (11:15)
• Issue in Behavior of Interval Datatype Amit Kapila (13:08)
• Reminder: 9.2beta3 wraps tonight Tom Lane (14:25)
• Re: cataloguing NOT NULL constraints Kevin Grittner (14:44)
• Re: cataloguing NOT NULL constraints Kevin Grittner (14:48)
• Re: Reminder: 9.2beta3 wraps tonight Robert Haas (15:01)
• Re: Reminder: 9.2beta3 wraps tonight Tom Lane (15:05)
• avoid unnecessary failure to open restored WAL files Fujii Masao (16:18)
• Re: WIP Patch: Use sortedness of CSV foreign tables for query planning Kevin Grittner (16:28)
• Re: Help me develop new commit_delay advice Josh Berkus (17:48)
• [repost] Help me develop new commit_delay advice Peter Geoghegan (18:02)
• Re: Help me develop new commit_delay advice Peter Geoghegan (18:04)
• Re: Re: SPGiST versus hot standby - question about conflict resolution rules Tom Lane (18:49)
• Re: [patch] libpq one-row-at-a-time API Marko Kreen (20:24)
• Re: [patch] libpq one-row-at-a-time API Tom Lane (21:01)
• Re: [patch] libpq one-row-at-a-time API Marko Kreen (21:44)

2012-08-03

• Re: WIP pgindent replacement Bruce Momjian (03:09)
• Re: WIP Patch: Use sortedness of CSV foreign tables for query planning Etsuro Fujita (03:45)
• Re: Word-smithing doc changes Bruce Momjian (04:26)
• Git diff patch in context diff format Qi Huang (06:56)
• Re: Git diff patch in context diff format Robert Haas (08:28)
• pg_dump custom format without timestamp? Fabien COELHO (08:54)
• Re: [PATCH] Make "psql -1 < file.sql" work as with "-f" Fabien COELHO (09:02)
• Re: Git diff patch in context diff format Qi Huang (10:12)
• [WIP] Performance Improvement by reducing WAL for Update Operation Amit kapila (11:46)
• FW: [WIP] Performance Improvement by reducing WAL for Update Operation Amit Kapila (12:10)
• Re: WIP pgindent replacement Andrew Dunstan (12:26)
• Re: Re: SPGiST versus hot standby - question aboutconflict resolution rules Noah Misch (12:37)
• Re: WIP Patch: Use sortedness of CSV foreign tables for query planning Robert Haas (12:38)
• [PATCH] Docs: Make notes on sequences and rollback more obvious Craig Ringer (13:55)
• Re: Word-smithing doc changes Bruce Momjian (13:59)
• Re: WIP pgindent replacement Bruce Momjian (14:03)
• Re: pg_dump custom format without timestamp? Tom Lane (14:10)
• Re: WIP pgindent replacement Tom Lane (14:33)
• Re: WIP pgindent replacement Robert Haas (14:48)
• Re: WIP pgindent replacement Bruce Momjian (14:51)
• CreateLockFile() race condition Noah Misch (14:56)
• Re: CreateLockFile() race condition Tom Lane (15:59)
• Re: CreateLockFile() race condition Robert Haas (16:43)
• Re: -Wformat-zero-length Bruce Momjian (16:44)
• Re: WIP pgindent replacement Andrew Dunstan (16:51)
• Re: -Wformat-zero-length Alvaro Herrera (16:53)
• Re: Word-smithing doc changes Alvaro Herrera (16:55)
• Re: Re: SPGiST versus hot standby - question about conflict resolution rules Tom Lane (17:14)
• Re: WIP pgindent replacement Bruce Momjian (17:23)
• Re: Word-smithing doc changes Bruce Momjian (17:23)
• Re: -Wformat-zero-length Bruce Momjian (17:32)
• Re: CreateLockFile() race condition Noah Misch (17:55)
• Re: Re: SPGiST versus hot standby - question about conflict resolution rules Tom Lane (18:02)
• Re: WIP pgindent replacement Andrew Dunstan (18:08)
• Re: pg_dump custom format without timestamp? Fabien COELHO (18:37)
• Re: WIP pgindent replacement Bruce Momjian (18:53)
• Re: -Wformat-zero-length Alvaro Herrera (19:10)
• Re: Re: [COMMITTERS] pgsql: Add temp_file_limit GUC parameter to constrain temporary file sp Bruce Momjian (19:15)
• Re: -Wformat-zero-length Bruce Momjian (19:22)
• Re: -Wformat-zero-length Robert Haas (20:01)
• Re: -Wformat-zero-length Bruce Momjian (20:02)
• Re: [WIP] Performance Improvement by reducing WAL for Update Operation Heikki Linnakangas (20:03)
• Re: [PATCH] Docs: Make notes on sequences and rollback more obvious Kevin Grittner (20:12)
• Re: Issue in Behavior of Interval Datatype Tom Lane (20:18)

2012-08-04

• Re: [PATCH] Docs: Make notes on sequences and rollback more obvious Craig Ringer (04:56)
• Re: Issue in Behavior of Interval Datatype Amit Kapila (06:18)
• Re: [WIP] Performance Improvement by reducing WAL for Update Operation Amit Kapila (06:41)
• [WIP] Performance Improvement by reducing WAL for Update Operation Amit Kapila (08:01)
• Statistics and selectivity estimation for ranges Alexander Korotkov (09:31)
• Re: [WIP] Performance Improvement by reducing WAL for Update Operation Heikki Linnakangas (14:21)
• Re: Word-smithing doc changes Bruce Momjian (14:35)
• Re: [WIP] Performance Improvement by reducing WAL for Update Operation Bruce Momjian (14:36)
• Re: Issue in Behavior of Interval Datatype Tom Lane (16:11)
• Re: WIP pgindent replacement Bruce Momjian (16:43)
• Re: cataloguing NOT NULL constraints Bruce Momjian (16:50)
• Pgadmin3 v1.14.2 foreign keys Mary F. Masterson (19:17)
• Pgadmin3 v1.14.2 foreign keys Mary F. Masterson (20:59)

2012-08-05

• WIP patch for LATERAL subqueries Tom Lane (21:58)
• Re: WIP patch for LATERAL subqueries Andrew Dunstan (22:58)
• spinlock->pthread_mutex : real world results Nils Goroll (23:19)
• Re: WIP patch for LATERAL subqueries Tom Lane (23:52)

2012-08-06

• Re: WIP patch for LATERAL subqueries Tom Lane (02:07)
• Re: WIP Patch: Use sortedness of CSV foreign tables for query planning Etsuro Fujita (02:41)
• Re: WIP patch for LATERAL subqueries Pavel Stehule (03:01)
• Re: [WIP] Performance Improvement by reducing WAL for Update Operation Amit Kapila (03:10)
• Windows Streaming replication -- Windows 2008 servers chinnaobi (05:41)
• Re: [WIP] Performance Improvement by reducing WAL for Update Operation Heikki Linnakangas (09:02)
• Re: Where is diskchecker.pl ? Magnus Hagander (09:26)
• Re: postgres 9 bind address for replication Magnus Hagander (09:53)
• Re: [WIP] Performance Improvement by reducing WAL for Update Operation Amit Kapila (11:30)
• Re: several problems in pg_receivexlog Magnus Hagander (11:48)
• Re: several problems in pg_receivexlog Magnus Hagander (11:56)
• Re: Re: [COMMITTERS] pgsql: Fix mapping of PostgreSQL encodings to Python encodings. Heikki Linnakangas (11:59)
• Re: WIP patch for LATERAL subqueries Robert Haas (12:45)
• Re: WIP Patch: Use sortedness of CSV foreign tables for query planning Robert Haas (12:48)
• Re: Windows Streaming replication -- Windows 2008 servers Robert Haas (12:50)
• Re: spinlock->pthread_mutex : real world results Robert Haas (12:54)
• Re: WIP patch for LATERAL subqueries Amit Kapila (14:07)
• Re: Statistics and selectivity estimation for ranges Heikki Linnakangas (14:09)
• Re: WIP patch for LATERAL subqueries Amit Kapila (14:23)
• Re: tzdata2012d Magnus Hagander (14:25)
• Re: WIP Patch: Use sortedness of CSV foreign tables for query planning Tom Lane (14:33)
• Re: WIP patch for LATERAL subqueries Robert Haas (14:37)
• Re: WIP patch for LATERAL subqueries Tom Lane (14:47)
• Re: SP-GiST for ranges based on 2d-mapping and quad-tree Heikki Linnakangas (14:49)
• Re: WIP patch for LATERAL subqueries Tom Lane (15:09)
• Re: WIP Patch: Use sortedness of CSV foreign tables for query planning Robert Haas (15:10)
• Re: WIP patch for LATERAL subqueries Robert Haas (15:14)
• Re: tzdata2012d Tom Lane (15:18)
• Re: WIP patch for LATERAL subqueries Tom Lane (15:25)
• Re: Statistics and selectivity estimation for ranges Matthias (16:00)
• Fwd: Statistics and selectivity estimation for ranges Matthias (16:08)
• Re: Where is diskchecker.pl ? Bruce Momjian (16:31)
• Re: Where is diskchecker.pl ? Rodrigo Gonzalez (16:54)
• Re: Fwd: Statistics and selectivity estimation for ranges Josh Berkus (17:19)
• Mailsystem maintenance/migration announcement Stefan Kaltenbrunner (17:21)
• Re: [PATCH] Docs: Make notes on sequences and rollback more obvious Robert Haas (18:27)
• redundant message? Alvaro Herrera (18:54)
• Re: redundant message? Robert Haas (19:08)
• Re: spinlock->pthread_mutex : real world results Martijn van Oosterhout (21:25)
• Re: spinlock->pthread_mutex : real world results Nils Goroll (22:10)

2012-08-07

• Re: WIP patch for LATERAL subqueries Amit Kapila (03:07)
• Beta 3 Craig Ringer (03:22)
• Re: Statistics and selectivity estimation for ranges Alexander Korotkov (04:25)
• Re: WIP Patch: Use sortedness of CSV foreign tables for query planning Etsuro Fujita (06:02)
• Re: [PATCH] Docs: Make notes on sequences and rollback more obvious Craig Ringer (07:59)
• is prefix pg_ reservated ? Pavel Stehule (11:16)
• Re: [PATCH] Docs: Make notes on sequences and rollback more obvious Robert Haas (12:39)
• Re: is prefix pg_ reservated ? Robert Haas (12:41)
• Re: WIP Patch: Use sortedness of CSV foreign tables for query planning Robert Haas (12:43)
• Re: Beta 3 Robert Haas (12:44)
• Re: Beta 3 Magnus Hagander (12:51)
• Re: Where is diskchecker.pl ? Magnus Hagander (13:00)
• Re: -Wformat-zero-length Magnus Hagander (13:06)
• Pg_ctl promote -- wait for slave to be promoted fully ? Magnus Hagander (13:22)
• Re: [PATCH] Docs: Make notes on sequences and rollback more obvious Kevin Grittner (13:45)
• Re: -Wformat-zero-length Bruce Momjian (14:01)
• WIP: pg_pretty_query Pavel Stehule (14:14)
• Re: WIP: pg_pretty_query Thom Brown (14:36)
• Re: -Wformat-zero-length Alvaro Herrera (14:38)
• Re: WIP: pg_pretty_query Pavel Stehule (14:54)
• Re: -Wformat-zero-length Bruce Momjian (14:59)
• Re: [PATCH] Docs: Make notes on sequences and rollback more obvious Jeff MacDonald (15:16)
• Re: WIP: pg_pretty_query Bruce Momjian (15:53)
• Re: WIP: pg_pretty_query Andrew Dunstan (16:30)
• Re: Beta 3 Robert Haas (16:31)
• Re: WIP: pg_pretty_query David Fetter (16:42)
• Re: Pg_ctl promote -- wait for slave to be promoted fully ? Fujii Masao (17:09)
• pg_upgrade bug in Windows on PG 9.2 Bruce Momjian (17:10)
• Re: [PATCH] Docs: Make notes on sequences and rollback more obvious David Fetter (17:13)
• Re: Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding Robert Haas (17:24)
• Re: WIP patch for LATERAL subqueries Tom Lane (17:40)
• Re: avoid unnecessary failure to open restored WAL files Simon Riggs (18:08)
• Re: WIP: pg_pretty_query Tom Lane (18:14)
• bug of pg_trgm? Fujii Masao (18:38)
• Re: WIP: pg_pretty_query Andrew Dunstan (19:01)
• Re: Inserting heap tuples in bulk in COPY Jeff Janes (19:58)
• Re: WIP: pg_pretty_query Tom Lane (19:58)
• Re: WIP: pg_pretty_query Peter Geoghegan (20:10)
• Re: Pg_ctl promote -- wait for slave to be promoted fully ? Robert Haas (20:37)
• Re: Inserting heap tuples in bulk in COPY Simon Riggs (20:52)
• Re: WIP: pg_pretty_query Tom Lane (21:11)
• Possible bug in PostgreSQL 9.2 stable: TwoPhaseGetDummyBackendId() Robert Ross (22:45)
• Re: WIP patch for LATERAL subqueries Tom Lane (23:08)
• Re: WIP fix proposal for bug #6123 Bruce Momjian (23:46)

2012-08-08

• Re: Inserting heap tuples in bulk in COPY Jeff Janes (02:44)
• Re: WIP: pg_pretty_query Pavel Stehule (03:06)
• Re: WIP: pg_pretty_query Pavel Stehule (03:09)
• Re: Inserting heap tuples in bulk in COPY Simon Riggs (07:36)
• Bug in libpq implentation and omission in documentation? Jim Vanns (09:01)
• Re: Bug in libpq implentation and omission in documentation? Dmitriy Igrishin (09:27)
• Re: Bug in libpq implentation and omission in documentation? Jim Vanns (09:36)
• Re: Bug in libpq implentation and omission in documentation? Heikki Linnakangas (11:24)
• Re: Bug in libpq implentation and omission in documentation? Jim Vanns (11:31)
• Re: Bug in libpq implentation and omission in documentation? Magnus Hagander (11:32)
• Re: WIP fix proposal for bug #6123 Kevin Grittner (14:26)
• Re: Bug in libpq implentation and omission in documentation? Tom Lane (14:35)
• Re: Possible bug in PostgreSQL 9.2 stable: TwoPhaseGetDummyBackendId() Tom Lane (15:08)
• Re: WIP patch for LATERAL subqueries Merlin Moncure (15:30)
• Re: WIP fix proposal for bug #6123 Bruce Momjian (17:27)
• Re: bug of pg_trgm? Tom Lane (17:28)
• Re: Git diff patch in context diff format Bruce Momjian (17:29)
• Re: avoid unnecessary failure to open restored WAL files Fujii Masao (17:31)
• Re: bug of pg_trgm? Tom Lane (18:05)
• Re: Git diff patch in context diff format Andrew Dunstan (19:05)
• Re: Inserting heap tuples in bulk in COPY Robert Haas (19:34)