Peripheral Links

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

pgsql-general - October 2012

2012-10-01

• Re: Would my postgresql 8.4.12 profit from doubling RAM? Jeff Janes (00:39)
• Re: transitive pruning optimization on the right side of a join for partition tables Ondrej Ivanič (01:35)
• enforcing transaction mode for read-write queries. Rajesh Kumar Mallah (02:22)
• Re: enforcing transaction mode for read-write queries. David Johnston (03:24)
• Re: opened connection Darren Duncan (03:24)
• Re: transitive pruning optimization on the right side of a join for partition tables Waldo, Ethan (03:30)
• Re: enforcing transaction mode for read-write queries. Rajesh Kumar Mallah (04:42)
• Re: opened connection Scott Marlowe (05:17)
• Re: opened connection Levente Kovacs (06:59)
• Planner choice on NULLs (9.1.5) with 2 conditional indexes Marc Mamin (07:34)
• Re: Planner choice on NULLs (9.1.5) with 2 conditional indexes Marc Mamin (08:06)
• Re: strange permission error Mr Dash Four (08:20)
• Re: opened connection Jasen Betts (08:35)
• Re: pg_upgrade: out of memory Carrington, Matthew (Produban) (08:43)
• Re: strange permission error John R Pierce (08:47)
• Again, problem with pgbouncer Phoenix Kiula (10:26)
• Re: Again, problem with pgbouncer raghu ram (10:44)
• Re: pg_upgrade: out of memory Andrew Hastie (11:51)
• What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Moshe Jacobson (13:36)
• Re: pg_upgrade: out of memory Tom Lane (13:39)
• Postgres error when adding new page Marco Craveiro (13:47)
• Re: pg_upgrade: out of memory Carrington, Matthew (Produban) (13:53)
• Re: Postgres error when adding new page Peter Geoghegan (14:02)
• Re: opened connection Tom Lane (14:17)
• Re: Postgres error when adding new page Marco Craveiro (14:24)
• Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Merlin Moncure (14:28)
• strange hot_standby behaviour pfote (14:28)
• Re: Postgres error when adding new page Tom Lane (14:42)
• Re: Postgres error when adding new page Marco Craveiro (14:49)
• Re: pg_upgrade: out of memory Carrington, Matthew (Produban) (14:50)
• Re: strange hot_standby behaviour Lonni J Friedman (14:56)
• Re: shared memory settings Vick Khera (14:57)
• Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Moshe Jacobson (15:21)
• Securing .pgpass File? Shaun Thomas (15:32)
• Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Merlin Moncure (16:22)
• Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Merlin Moncure (16:28)
• Re: Again, problem with pgbouncer Phoenix Kiula (16:59)
• Re: Securing .pgpass File? Darren Duncan (17:19)
• Re: Securing .pgpass File? Shaun Thomas (17:26)
• Re: strange hot_standby behaviour Andreas Pfotenhauer (17:43)
• Re: pg_upgrade: out of memory Andrew Hastie (17:48)
• Re: Securing .pgpass File? Steve Atkins (18:42)
• Re: pg_upgrade: out of memory Tom Lane (18:53)
• Re: Securing .pgpass File? Jeff Janes (19:05)
• Pg, Netezza, and... Sybase? yary (19:49)
• Thousands of schemas and ANALYZE goes out of memory Hugo <Nabble> (19:52)
• Re: Securing .pgpass File? Shaun Thomas (20:10)
• Re: Pg, Netezza, and... Sybase? Bruce Momjian (20:18)
• Re: Pg, Netezza, and... Sybase? Tom Lane (20:37)
• Re: Thousands of schemas and ANALYZE goes out of memory Tom Lane (20:39)
• Re: Pg, Netezza, and... Sybase? David Johnston (20:52)
• Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Moshe Jacobson (20:58)
• Re: Thousands of schemas and ANALYZE goes out of memory Hugo <Nabble> (21:00)
• Re: Securing .pgpass File? Alan Hodgson (21:02)
• How to search for composite type array ChoonSoo Park (21:49)
• Re: Pg, Netezza, and... Sybase? yary (22:02)
• Re: Thousands of schemas and ANALYZE goes out of memory Jeff Janes (22:39)
• Re: How to search for composite type array David Johnston (22:56)
• Re: Securing .pgpass File? Greg Sabino Mullane (23:02)

2012-10-02

• pg_typeof equivalent for numeric scale, numeric/timestamp precision? Craig Ringer (02:19)
• Can I force a query plan to materialise part? Toby Corkindale (02:33)
• Re: Can I force a query plan to materialise part? David Johnston (02:44)
• Re: Can I force a query plan to materialise part? Ondrej Ivanič (03:02)
• Re: Can I force a query plan to materialise part? Toby Corkindale (03:22)
• Re: Can I force a query plan to materialise part? Toby Corkindale (03:28)
• Re: Again, problem with pgbouncer Phoenix Kiula (03:29)
• Re: Can I force a query plan to materialise part? Ondrej Ivanič (05:37)
• Can not start postgresSQL 8.4 Boriss Redkins (08:42)
• Re: Securing .pgpass File? Jasen Betts (09:02)
• Re: Can not start postgresSQL 8.4 Thomas Kellerer (09:10)
• Re: Again, problem with pgbouncer Phoenix Kiula (09:27)
• Re: strange permission error Mr Dash Four (09:36)
• insert ... returning in plpgsql Willy-Bas Loos (13:01)
• Re: insert ... returning in plpgsql Leif Biberg Kristensen (13:06)
• Re: insert ... returning in plpgsql Cédric Villemain (13:13)
• Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Merlin Moncure (13:18)
• Re: insert ... returning in plpgsql Willy-Bas Loos (13:24)
• Re: strange permission error Tom Lane (14:01)
• Game Server Lags Arvind Singh (14:02)
• Re: Game Server Lags Craig Ringer (14:16)
• Re: Game Server Lags Peter Geoghegan (14:24)
• Re: Question about ip4r contrib and PostgreSQL 9.2 Merlin Moncure (14:49)
• Long-running query on replica not timing out Andrew Hannon (15:48)
• Re: Explicitly inserting NULL values into NOT NULL DEFAULT 0 columns Etienne Rouxel (16:01)
• Re: Re: Explicitly inserting NULL values into NOT NULL DEFAULT 0 columns David Johnston (16:36)
• Re: Thousands of schemas and ANALYZE goes out of memory Hugo <Nabble> (17:38)
• Re: How to search for composite type array ChoonSoo Park (18:03)
• stored procedure multiple call call question Chris McDonald (18:42)
• Re: stored procedure multiple call call question Chris McDonald (18:48)
• Re: Securing .pgpass File? Martijn van Oosterhout (21:19)
• Re: Thousands of schemas and ANALYZE goes out of memory Martijn van Oosterhout (21:33)
• Re: stored procedure multiple call call question David Johnston (21:37)
• Re: pg_typeof equivalent for numeric scale, numeric/timestamp precision? Martijn van Oosterhout (21:50)

2012-10-03

• invalid page header in block... Royce Ausburn (00:05)
• Re: Thousands of schemas and ANALYZE goes out of memory Jeff Janes (00:09)
• Re: Thousands of schemas and ANALYZE goes out of memory Chris Angelico (00:14)
• Indexing JSON type Ankur Soni (03:54)
• Unable to uninstall completely Postgre SQL Alex Putra (05:19)
• Replication err Khizer (05:35)
• Re: Postgres error when adding new page Marco Craveiro (06:37)
• Re: stored procedure multiple call call question Chris McDonald (08:19)
• Re: strange permission error Mr Dash Four (10:29)
• pros and cons of two security models Chris Travers (11:06)
• Re: Indexing JSON type Andreas Kretschmer (13:15)
• [PL/PGSQL] column name substitution in PG8.4 Léon Melis (13:15)
• Re: pros and cons of two security models Stephen Frost (13:17)
• Re: Replication err Andreas Kretschmer (13:18)
• Re: Replication err Shaun Thomas (13:33)
• Re: Securing .pgpass File? Shaun Thomas (13:38)
• Upgrading 8.3-rc1 to 8.3.20 Leonardo M. Ramé (14:21)
• syntax error collate Niklas Langvig (14:31)
• Postgres will not start due to corrupt index Robert Sosinski (14:33)
• Re: Upgrading 8.3-rc1 to 8.3.20 Raymond O'Donnell (14:41)
• Re: Postgres will not start due to corrupt index Merlin Moncure (14:44)
• Re: Upgrading 8.3-rc1 to 8.3.20 Andreas Kretschmer (14:51)
• Re: Postgres will not start due to corrupt index Robert Sosinski (14:54)
• PostgreSQL force create table / ignore constraints? hartrc (15:12)
• Fwd: pros and cons of two security models Chris Travers (15:13)
• Re: Postgres will not start due to corrupt index Tom Lane (15:43)
• Determining that a schema has changed for purpose of monitoring Thor Michael Støre (15:48)
• Re: Upgrading 8.3-rc1 to 8.3.20 Leonardo M. Ramé (17:11)
• Re: Unable to uninstall completely Postgre SQL John R Pierce (17:29)
• Re: Again, problem with pgbouncer Phoenix Kiula (18:01)
• Sequence and Schema permissions information schema hartrc (18:03)
• Re: Again, problem with pgbouncer dinesh kumar (18:13)
• surprising behavior or nothing to see here? Ben Chobot (18:13)
• Re: Postgres will not start due to corrupt index Igor Neyman (18:19)
• Re: Sequence and Schema permissions information schema Tom Lane (18:30)
• Re: Postgres will not start due to corrupt index Tom Lane (18:46)
• Re: surprising behavior or nothing to see here? Tom Lane (18:50)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Wolf Schwurack (18:50)
• Re: surprising behavior or nothing to see here? Ben Chobot (18:55)
• Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Moshe Jacobson (19:14)
• Re: syntax error collate Raymond O'Donnell (19:41)
• Re: Postgres will not start due to corrupt index Igor Neyman (19:51)
• Re: PostgreSQL force create table / ignore constraints? Frank Lanitz (20:22)
• user defined XML aggregate not working as (i think) it should Rhys A.D. Stewart (22:35)

2012-10-04

• Re: Fwd: pros and cons of two security models Stephen Frost (01:25)
• Re: user defined XML aggregate not working as (i think) it should Tom Lane (01:58)
• Re: Fwd: pros and cons of two security models Chris Travers (02:08)
• COPY FROM with BYTEA fields - escaping doesn't work Toby Corkindale (02:58)
• Re: [PL/PGSQL] column name substitution in PG8.4 Merlin Moncure (03:15)
• Re: pg_typeof equivalent for numeric scale, numeric/timestamp precision? Craig Ringer (03:33)
• Re: pros and cons of two security models Craig Ringer (03:34)
• Re: COPY FROM with BYTEA fields - escaping doesn't work Toby Corkindale (03:48)
• Re: user defined XML aggregate not working as (i think) it should Rhys A.D. Stewart (05:16)
• Re: Determining that a schema has changed for purpose of monitoring Chris (05:45)
• Moving from Java 1.5 to Java 1.6 Swayam Prakash Vemuri (06:52)
• pg_upgrade default ports in the --help output Виктор Егоров (07:29)
• Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Ivan Voras (10:12)
• Return dynamic columns of a temporary table clear chan (12:00)
• Re: pg_upgrade default ports in the --help output Adrian Klaver (13:36)
• Re: pg_upgrade default ports in the --help output Виктор Егоров (13:50)
• Re: Moving from Java 1.5 to Java 1.6 David Fetter (15:13)
• Re: Return dynamic columns of a temporary table Pavel Stehule (15:39)
• Re: Moving from Java 1.5 to Java 1.6 Shaun Thomas (15:45)
• Re: Thousands of schemas and ANALYZE goes out of memory Jeff Janes (16:17)
• Re: Moving from Java 1.5 to Java 1.6 Achilleas Mantzios (16:38)
• Re: Thousands of schemas and ANALYZE goes out of memory Hugo <Nabble> (17:54)
• Re: Thousands of schemas and ANALYZE goes out of memory Tom Lane (18:14)
• Re: Thousands of schemas and ANALYZE goes out of memory Jeff Janes (19:56)
• Re: Building an home computer for best Poker Tracker performance serraios (19:58)
• Trajectory of a [Pg] DBA Thalis Kalfigkopoulos (20:44)
• Re: pg_upgrade default ports in the --help output Bruce Momjian (21:06)
• Re: Thousands of schemas and ANALYZE goes out of memory Tom Lane (23:14)

2012-10-05

• Re: Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Moshe Jacobson (02:53)
• Re: Building an home computer for best Poker Tracker performance Craig Ringer (03:45)
• Re: Trajectory of a [Pg] DBA Ben Chobot (04:13)
• Re: Trajectory of a [Pg] DBA Scott Marlowe (05:09)
• Re: Moving from Java 1.5 to Java 1.6 Thomas Kellerer (06:21)
• Re: Moving from Java 1.5 to Java 1.6 John R Pierce (06:34)
• Re: Trajectory of a [Pg] DBA Chris Angelico (06:35)
• Re: Moving from Java 1.5 to Java 1.6 Thomas Kellerer (07:01)
• Re: Moving from Java 1.5 to Java 1.6 Thomas Kellerer (07:04)
• Re: Moving from Java 1.5 to Java 1.6 Craig Ringer (07:06)
• Re: Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Ivan Voras (08:09)
• Re: Trajectory of a [Pg] DBA Andrew Sullivan (11:51)
• Re: Trajectory of a [Pg] DBA Shaun Thomas (13:43)
• Re: Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Merlin Moncure (13:55)
• Counting all results before LIMIT Moshe Jacobson (14:29)
• Add a stemmer for fts P Gouv (14:52)
• Re: Counting all results before LIMIT P Gouv (15:02)
• Re: Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Ivan Voras (15:13)
• Re: Counting all results before LIMIT Mike Christensen (15:17)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Phoenix Kiula (15:37)
• Re: Counting all results before LIMIT Edson Richter (15:37)
• Re: Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS? Moshe Jacobson (15:40)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Wolf Schwurack (16:01)
• pg_dump problem Leonardo M. Ramé (20:51)
• Re: pg_dump problem Tom Lane (21:30)
• Re: pg_dump problem Leonardo Rame (21:58)

2012-10-06

• CTE materializing sets? Liam Caffrey (00:45)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Phoenix Kiula (02:00)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Adrian Klaver (02:07)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Shashank Tripathi (02:13)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Phoenix Kiula (02:23)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Adrian Klaver (02:24)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Phoenix Kiula (02:30)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Adrian Klaver (02:36)
• Re: [Pgbouncer-general] Again, problem with pgbouncer Johnny Tan (12:24)