pgsql-general since 2015-06-17 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

June 17, 2015

Thread Author Time
Re: pg_xlog on a hot_stanby slave Venkata Balaji N 00:44
pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Douglas Stetner 01:06
pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Douglas Stetner 01:09
Re: pg_xlog on a hot_stanby slave Sameer Kumar 01:17
Re: serialization failure why? Bill Moran 01:45
Feature Request: bigtsvector CPT 05:58
Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Albe Laurenz 07:17
Re: pg_xlog on a hot_stanby slave Xavier 12 07:20
Re: pg_xlog on a hot_stanby slave Xavier 12 07:21
Re: pg_xlog on a hot_stanby slave Xavier 12 07:23
Test for char errors 夏高 08:15
Re: Test for char errors Michael Paquier 08:27
Re: [GENERAL] pg_xlog on a hot_standby slave filling up Christoph Berg 10:22
Re: serialization failure why? Filipe Pina 11:29
Re: serialization failure why? Filipe Pina 11:31
Re: serialization failure why? Kevin Grittner 11:52
Re: Momentary Delay Anderson Valadares 13:33
Re: serialization failure why? Filipe Pina 13:40
Re: [GENERAL] pg_xlog on a hot_standby slave filling up Jeff Frost 15:39
Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Tom Lane 16:06
Index Advice in PG Jony Cohen 19:10
pg_class.reltuples VS pg_stat_all_tables.n_live_tup for estimation of table William Dunn 19:14
Re: pg_class.reltuples VS pg_stat_all_tables.n_live_tup for estimation of table Tom Lane 19:48
Re: pg_class.reltuples VS pg_stat_all_tables.n_live_tup for estimation of table William Dunn 20:52
writable cte triggers reverse order Миша Тюрин 21:14

June 18, 2015

Thread Author Time
Re: [GENERAL] psql weird behaviour with charset encodings Noah Misch 00:47
Re: Momentary Delay Bill Moran 01:55
Re: pg_xlog on a hot_stanby slave Sameer Kumar 02:00
Re: [GENERAL] psql weird behaviour with charset encodings Michael Paquier 03:37
Re: pg_xlog on a hot_stanby slave Xavier 12 07:17
Select query regarding info Yogesh. Sharma 07:29
Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Piotr Gackiewicz 08:58
My postgres is not logging anymore Maila Fatticcioni 09:34
Re: My postgres is not logging anymore Raymond O'Donnell 09:48
Re: serialization failure why? Filipe Pina 10:36
Re: Select query regarding info Bill Moran 10:37
Re: serialization failure why? Simon Riggs 10:51
Re: [GENERAL] pg_xlog on a hot_standby slave filling up Christoph Berg 10:53
Re: Select query regarding info Thomas Kellerer 10:54
Re: My postgres is not logging anymore Maila Fatticcioni 12:13
PL/pgSQL: How to return two columns and multiple rows Sven Geggus 12:36
Re: PL/pgSQL: How to return two columns and multiple rows Pavel Stehule 12:44
Re: PL/pgSQL: How to return two columns and multiple rows David G. Johnston 12:45
Re: PL/pgSQL: How to return two columns and multiple rows Chris Travers 12:50
Re: My postgres is not logging anymore Raymond O'Donnell 12:53
Re: PL/pgSQL: How to return two columns and multiple rows Raymond O'Donnell 12:54
Re: PL/pgSQL: How to return two columns and multiple rows Tom Lane 13:03
Re: PL/pgSQL: How to return two columns and multiple rows Merlin Moncure 13:10
Re: PL/pgSQL: How to return two columns and multiple rows David G. Johnston 13:15
Re: PL/pgSQL: How to return two columns and multiple rows Sven Geggus 13:32
Re: PL/pgSQL: How to return two columns and multiple rows David G. Johnston 13:43
Re: PL/pgSQL: How to return two columns and multiple rows Sven Geggus 13:47
Re: PL/pgSQL: How to return two columns and multiple rows Sven Geggus 13:52
Re: PL/pgSQL: How to return two columns and multiple rows David G. Johnston 13:56
Re: writable cte triggers reverse order Tom Lane 14:01
valgrind Peter Kroon 14:16
Re: PL/pgSQL: How to return two columns and multiple rows Sven Geggus 14:31
Re: PL/pgSQL: How to return two columns and multiple rows David G. Johnston 14:49
Re: PL/pgSQL: How to return two columns and multiple rows Alvaro Herrera 15:49
Re: PL/pgSQL: How to return two columns and multiple rows Sven Geggus 16:00
Re: PL/pgSQL: How to return two columns and multiple rows David G. Johnston 16:11
PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot 17:09
Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) [email protected] 17:16
Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Will Platnick 17:17
Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot 17:41
Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) [email protected] 18:10
Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot 19:19
Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Jerry Sievers 19:46
Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Igor Neyman 19:59
Re: PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) [email protected] 20:02
Re: [PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site) Sheena, Prabhjot 20:26
Is there any way to measure disk activity for each query? Oleg Serov 22:05
Re: Is there any way to measure disk activity for each query? Jeff Janes 23:07
Re: Test for char errors 夏高 23:29

June 19, 2015

Thread Author Time
Issues setting up BDR with multiple databases Jorge Torralba 00:09
Re: Test for char errors Michael Paquier 00:13
Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Douglas Stetner 00:25
Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Douglas Stetner 00:26
Postgresql 9.2 has standby server lost data? Paula Price 00:45
Re: pg_xlog on a hot_stanby slave Sameer Kumar 01:31
Implementing PostgreSQL in High Availability אביאל בוסקילה 05:05
Re: Issues setting up BDR with multiple databases Craig Ringer 05:19
Re: Issues trying to run bdr_init_copy with new setup Craig Ringer 05:20
WAL log archival on standby James Sewell 05:38
Re: WAL log archival on standby Michael Paquier 05:45
Re: valgrind Albe Laurenz 08:19
How to craft a query that uses memory? Holger.Friedrich-Fa-Trivadis 10:42
Re: How to craft a query that uses memory? Albe Laurenz 10:56
Transaction abort difference between psql, isql, ODBC and JDBC pgsql 8.4 Gary Cowell 11:15
Re: Transaction abort difference between psql, isql, ODBC and JDBC pgsql 8.4 Glyn Astill 11:51
Re: How to craft a query that uses memory? Holger.Friedrich-Fa-Trivadis 13:21
Re: Transaction abort difference between psql, isql, ODBC and JDBC pgsql 8.4 Adrian Klaver 13:46
Re: [GENERAL] pg_xlog on a hot_standby slave filling up Christoph Berg 14:50
Re: [GENERAL] pg_xlog on a hot_standby slave filling up Jeff Frost 15:49
Postgres SIGALRM timer Scottix 15:52
Re: Planner cost adjustments Daniel Begin 16:05
Re: How to craft a query that uses memory? Scott Marlowe 16:42
Re: Postgresql 9.2 has standby server lost data? Adrian Klaver 18:01
Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Tom Lane 18:42
Re: Postgres SIGALRM timer Tom Lane 19:32
Re: Postgresql 9.2 has standby server lost data? Paula Price 20:05
Re: Is there any way to measure disk activity for each query? Julien Rouhaud 20:17
Re: Postgresql 9.2 has standby server lost data? Adrian Klaver 20:35

June 20, 2015

Thread Author Time
Re: WAL log archival on standby Sameer Kumar 12:14
Trying to avoid a simple temporary variable declaration in a pl/pgsql function David G. Johnston 14:23
Re: Trying to avoid a simple temporary variable declaration in a pl/pgsql function Tom Lane 14:56
Re: Trying to avoid a simple temporary variable declaration in a pl/pgsql function David G. Johnston 15:07
Re: Postgresql 9.2 has standby server lost data? Jerry Sievers 15:51
Re: Trying to avoid a simple temporary variable declaration in a pl/pgsql function Charles Clavadetscher 15:57
Re: Trying to avoid a simple temporary variable declaration in a pl/pgsql function Jerry Sievers 16:12
INSERT a number in a column based on other columns OLD INSERTs litu16 17:44
Re: INSERT a number in a column based on other columns OLD INSERTs Adrian Klaver 18:38
Re: INSERT a number in a column based on other columns OLD INSERTs litu16 19:18
Re: INSERT a number in a column based on other columns OLD INSERTs Bill Moran 19:37
Re: INSERT a number in a column based on other columns OLD INSERTs Charles Clavadetscher 19:41
Re: INSERT a number in a column based on other columns OLD INSERTs Adrian Klaver 19:48

June 21, 2015

Thread Author Time
Re: INSERT a number in a column based on other columns OLD INSERTs litu16 01:07
Re: INSERT a number in a column based on other columns OLD INSERTs Charles Clavadetscher 14:49
Re: INSERT a number in a column based on other columns OLD INSERTs Charles Clavadetscher 14:55
Re: INSERT a number in a column based on other columns OLD INSERTs litu16 19:28
Re: CLOG read problem after pg_basebackup Andres Freund 21:39

June 22, 2015

Thread Author Time
Re: INSERT a number in a column based on other columns OLD INSERTs Adrian Klaver 00:12
Re: INSERT a number in a column based on other columns OLD INSERTs Albe Laurenz 08:00
Re: Postgresql 9.2 has standby server lost data? Albe Laurenz 08:04
Re: Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Albe Laurenz 08:13
Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Piotr Gackiewicz 09:06
How to speed up pg_trgm / gin index scan Christian Ramseyer 11:51
Less is More Paul Ramsey 13:09
Re: Less is More Tom Lane 13:18
cascading replication and replication slots. Leif Gunnar Erlandsen 13:32
Re: Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Tom Lane 15:45
foreign keys to foreign tables Rick Otten 16:04
Re: Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Tom Lane 16:06
Re: foreign keys to foreign tables Tom Lane 16:21
Re: How to speed up pg_trgm / gin index scan Jeff Janes 17:00
Re: foreign keys to foreign tables William Dunn 17:06
Re: foreign keys to foreign tables Rick Otten 17:12
Re: foreign keys to foreign tables Rick Otten 17:16
Re: How to speed up pg_trgm / gin index scan Christian Ramseyer 17:39
Re: How to speed up pg_trgm / gin index scan Jaime Casanova 18:32
Re: extracting PII data and transforming it across table. Suresh Raja 21:09
Run analyze on schema Suresh Raja 21:10
Re: How to speed up pg_trgm / gin index scan Jeff Janes 22:10
Re: How to speed up pg_trgm / gin index scan Oleg Bartunov 23:30
Re: Run analyze on schema Jerry Sievers 23:53

June 23, 2015

Thread Author Time
Re: Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Tom Lane 02:42
Re: How to speed up pg_trgm / gin index scan Christian Ramseyer 09:39
Re: How to speed up pg_trgm / gin index scan Christian Ramseyer 09:43
cascading replication and replication_slots Leif Gunnar Erlandsen 11:18
Re: cascading replication and replication_slots Michael Paquier 11:32
Re: cascading replication and replication_slots Leif Gunnar Erlandsen 11:56
Re: Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Tom Lane 16:13
Re: Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Tom Lane 17:00
Re: Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Tom Lane 17:25
[No subject] Bruno Hass de Andrade 17:58
Re: John R Pierce 18:14
Re: cascading replication and replication slots. Andres Freund 18:34
Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux Piotr Gackiewicz 20:56
native api or odbc? Ted Toth 22:56
Re: Postgresql 9.2 has standby server lost data? Paula Price 23:49

June 24, 2015

Thread Author Time
Re: native api or odbc? Bret Stern 01:58
Re: native api or odbc? John R Pierce 01:59
Re: native api or odbc? George Weaver 02:09
Re: [GENERAL] Run analyze on schema Suresh Raja 03:34
Pgbouncer compile in VS2013 Yelai, Ramkumar IN BLR STS 05:27
INSERT a real number in a column based on other columns OLD INSERTs litu16 06:20
Re: Albe Laurenz 07:51
Include.d and warnings Andomar 09:01
Counting the occurences of a substring within a very large text Marc Mamin 10:55
Re: Counting the occurences of a substring within a very large text Chris Mair 11:26
Re: Counting the occurences of a substring within a very large text Albe Laurenz 11:43
Re: Counting the occurences of a substring within a very large text Andy Colson 13:24
Re: Counting the occurences of a substring within a very large text Marc Mamin 13:28
Re: Counting the occurences of a substring within a very large text Marc Mamin 13:30
Re: Include.d and warnings Adrian Klaver 13:43
DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows) Gauthier, Dave 13:44
Re: Counting the occurences of a substring within a very large text Marc Mamin 13:51
mirroring a server and/or hot standby John Bleichert 13:54
Re: Counting the occurences of a substring within a very large text Geoff Winkless 14:03
Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows) Adrian Klaver 14:03
Re: mirroring a server and/or hot standby Holger.Friedrich-Fa-Trivadis 14:04
Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows) Andy Colson 14:09
Re: mirroring a server and/or hot standby John Bleichert 14:20
Re: Include.d and warnings Tom Lane 14:43
Re: mirroring a server and/or hot standby Holger.Friedrich-Fa-Trivadis 14:55
Re: Counting the occurences of a substring within a very large text Marc Mamin 15:05
Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows) Gauthier, Dave 15:13
Re: Counting the occurences of a substring within a very large text Tom Lane 16:21
Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows) Andy Colson 16:32
Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows) Francisco Olarte 16:49
Re: native api or odbc? Merlin Moncure 16:53
checking for NULLS in aggregate Seb 16:54
Re: DB access speeds, App(linux)<->PG(linux) vs App(linux) <->MSSql(Windows) Gauthier, Dave 17:20
Re: Include.d and warnings Adrian Klaver 17:59
Re: checking for NULLS in aggregate David G. Johnston 18:06
pgbouncer issue Sheena, Prabhjot 18:09
Re: Counting the occurences of a substring within a very large text Albe Laurenz 18:27
Re: INSERT a real number in a column based on other columns OLD INSERTs Adrian Klaver 21:52
Re: INSERT a real number in a column based on other columns OLD INSERTs David G. Johnston 22:31

June 25, 2015

Thread Author Time
Re: INSERT a real number in a column based on other columns OLD INSERTs litu16 04:06

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30