Home > mailing lists

Mailing lists [pgsql-general]

1 January 2018

00:19 Find duplicates in a column then print Information to a file Sherman Willden
00:23 Re: Find duplicates in a column then print Information to a file Martin Moore
00:53 Re: Find duplicates in a column then print Information to a file Francisco Olarte
01:04 Re: Find duplicates in a column then print Information to a file Sherman Willden
01:23 Re: Find duplicates in a column then print Information to a file Rob Sargent
02:08 Re: Find duplicates in a column then print Information to a file Tom Lane
03:10 Re: invalid memory alloc request size 576460752438159360 Ibrahim Edib Kokdemir
03:39 Re: invalid memory alloc request size 576460752438159360 Peter Geoghegan
03:53 Re: invalid memory alloc request size 576460752438159360 Peter Geoghegan
04:20 Re: invalid memory alloc request size 576460752438159360 Ibrahim Edib Kokdemir
05:06 is single row update improved with function Rob Sargent
05:31 Re: is single row update improved with function David Rowley
06:04 Re: is single row update improved with function Rob Sargent
09:07 Re: is single row update improved with function Rob Sargent
19:12 Re: invalid memory alloc request size 576460752438159360 Ibrahim Edib Kokdemir
19:41 Selecting a JSON object of arrays from a PostgreSQL table Alexander Farber
20:34 Re: Selecting a JSON object of arrays from a PostgreSQL table Ivan E. Panchenko
22:15 Re: Selecting a JSON object of arrays from a PostgreSQL table Alexander Farber
22:56 Slow system due to ReorderBufferGetTupleBuf? Martin Moore
23:42 Use of Port 5433 with Postgresql 9.6 Graeme
23:44 Re: Slow system due to ReorderBufferGetTupleBuf? Peter Geoghegan

2 January 2018

00:11 Re: Use of Port 5433 with Postgresql 9.6 Karsten Hilbert
00:15 Re: Use of Port 5433 with Postgresql 9.6 Andreas Kretschmer
00:40 Re: Use of Port 5433 with Postgresql 9.6 Jeff Janes
00:54 Re: Use of Port 5433 with Postgresql 9.6 Paul Jungwirth
13:07 Returning Values from INSERT ON CONFLICT DO NOTHING Igal Sapir
13:43 Re: Returning Values from INSERT ON CONFLICT DO NOTHING Igal Sapir
13:59 Re: Returning Values from INSERT ON CONFLICT DO NOTHING Jov
14:22 Select for update / deadlock possibility? Durumdara
15:28 Re: Selecting a JSON object of arrays from a PostgreSQL table Alexander Farber
17:24 MSSQL compatibility layer James Harper
17:31 Re: Select for update / deadlock possibility? Rakesh Kumar
17:36 PGPool encrypted connections from Application Vikas Sharma
18:01 Re: PGPool encrypted connections from Application Tatsuo Ishii
18:09 Re: Slow system due to ReorderBufferGetTupleBuf? Martin Moore
18:22 Re: Select for update / deadlock possibility? Durumdara
18:23 Re: MSSQL compatibility layer Thomas Kellerer
20:02 Re: Select for update / deadlock possibility? Jeff Janes
20:36 Re: Select for update / deadlock possibility? Durumdara
21:13 5 USD for PostgreSQL books at PacktPub Alexander Farber
21:16 Re: 5 USD for PostgreSQL books at PacktPub Vincenzo Romano
21:23 Re: Select for update / deadlock possibility? Tom Lane
22:37 Re: Use of Port 5433 with Postgresql 9.6 Graeme

3 January 2018

03:28 Re: Slow system due to ReorderBufferGetTupleBuf? Martin Moore
04:38 Error creating a table Dale Seaburg
04:40 Re: Error creating a table Joshua D. Drake
05:24 Need information on the tools available to upload the shape files tothe postgreSQL database Ramamoorthi, Meenakshi
05:33 Re: Need information on the tools available to upload the shape files to the postgreSQL database James Keener
06:22 Fwd: Query error: could not resize shared memory segment Thuc Nguyen Canh
08:45 Mailing list archiver Jordan Deitch
09:51 BDR: remove junk replication identifier milist ujang
09:53 Re: Query error: could not resize shared memory segment Thomas Munro
10:05 Re: Query error: could not resize shared memory segment Thuc Nguyen Canh
10:13 Re: Query error: could not resize shared memory segment Thomas Munro
10:22 Re: Query error: could not resize shared memory segment Thuc Nguyen Canh
10:39 Re: Query error: could not resize shared memory segment Tom Lane
10:43 Re: Query error: could not resize shared memory segment Thomas Munro
10:49 Re: Query error: could not resize shared memory segment Thuc Nguyen Canh
11:05 Re: Query error: could not resize shared memory segment Thomas Munro
11:13 Re: Query error: could not resize shared memory segment Thuc Nguyen Canh
11:16 Re: Query error: could not resize shared memory segment Thomas Munro
11:34 Re: Query error: could not resize shared memory segment Tom Lane
11:50 Re: Query error: could not resize shared memory segment Thuc Nguyen Canh
12:18 Re: Returning Values from INSERT ON CONFLICT DO NOTHING Igal Sapir
13:27 RE: Mailing list archiver Kellner Thiemo
16:19 Re: Mailing list archiver Michelle Konzack
16:28 Re: Mailing list archiver Magnus Hagander
17:10 Re: Mailing list archiver Peter J. Holzer
19:20 Re: Mailing list archiver Michelle Konzack
19:50 Re: Mailing list archiver Alvaro Herrera
20:00 Re: Mailing list archiver Jordan Deitch
20:15 Re: Mailing list archiver Michelle Konzack
20:53 Request to Enforce the password Strength for PostgreSQL Databases Goli, Vijay
23:53 Re: Mailing list archiver Steve Atkins

4 January 2018

00:43 RE: Replication questions - read-only and temporary read/write slaves Jonathan Ruiz
00:43 Re: Deadlock between concurrent index builds on different tables Jeff Janes
00:47 Re: Mailing list archiver Ivan E. Panchenko
03:36 Re: Mailing list archiver Magnus Hagander
03:44 Re: Mailing list archiver Jordan Deitch
10:45 Re: Request to Enforce the password Strength for PostgreSQL Databases Michael Paquier
10:52 Re: Replication questions - read-only and temporary read/write slaves Michael Paquier
14:19 Re: Pg Upgrade failing as it is not able to start and stop server properly kiran gadamsetty
21:24 Re: Pg Upgrade failing as it is not able to start and stop serverproperly Bruce Momjian

5 January 2018

00:58 Re: Replication questions - read-only and temporary read/write slaves Tiffany Thang
01:02 Re: Production Database requirement Michelle Konzack
01:39 Bulk Insert/Update Scenario Mana M
02:43 Re: Bulk Insert/Update Scenario Jordan Deitch
03:19 Re: Bulk Insert/Update Scenario legrand legrand
03:47 Re: Bulk Insert/Update Scenario Mana M
04:03 Re: Bulk Insert/Update Scenario Jordan Deitch
05:04 Re: Replication questions - read-only and temporary read/write slaves Michael Paquier
09:57 BDR PG9.4 Replica Identity Full ning chan
23:07 What generates pg_config.h? Travis Allison

6 January 2018

00:24 Re: What generates pg_config.h? Adrian Klaver
01:57 Re: What generates pg_config.h? Travis Allison
02:15 Re: What generates pg_config.h? Tom Lane
02:19 Re: What generates pg_config.h? Adrian Klaver
02:49 Re: What generates pg_config.h? rob stone
02:51 Re: What generates pg_config.h? Travis Allison
03:27 Re: What generates pg_config.h? Alvaro Herrera
04:56 Re: What generates pg_config.h? Tom Lane
05:03 Re: What generates pg_config.h? Travis Allison
05:29 Re: What generates pg_config.h? Tom Lane
05:40 Re: What generates pg_config.h? Adrian Klaver
10:01 Re: What generates pg_config.h? Travis Allison
10:05 Re: What generates pg_config.h? Tom Lane
11:36 Re: What generates pg_config.h? Travis Allison
21:24 Re: What generates pg_config.h? Adrian Klaver
21:42 Re: What generates pg_config.h? Christoph Berg

7 January 2018

02:36 Re: What generates pg_config.h? Travis Allison
10:46 Two columns with same name in subselect--any way to SELECT without *? Ken Tanzer
11:10 Re: Two columns with same name in subselect--any way to SELECTwithout *? Adrian Klaver
11:16 Re: Two columns with same name in subselect--any way to SELECTwithout *? Ken Tanzer
13:01 Re: Two columns with same name in subselect--any way to SELECTwithout *? Ken Tanzer
13:33 Re: Two columns with same name in subselect--any way to SELECTwithout *? David G. Johnston

8 January 2018

06:35 Re: core system is getting unresponsive because over 300 cpu load pinker
20:20 Re: Pg Upgrade failing as it is not able to start and stop server properly Guru Prashanth Thanakodi
21:46 Materialized views in PGSQL 9.3 with replication on. Vikas Sharma
22:32 Re: Pg Upgrade failing as it is not able to start and stop server properly Tom Lane

9 January 2018

03:12 Supartitions in PGSQL 10 Kumar, Virendra
03:15 Re: Supartitions in PGSQL 10 Thomas Kellerer
04:44 RES: Supartitions in PGSQL 10 Márcio A. Sepp
05:20 How Many Partitions are Good Performing Kumar, Virendra
05:54 Re: How Many Partitions are Good Performing Rakesh Kumar
06:51 Re: How Many Partitions are Good Performing Michael Paquier
07:25 help with generation_series in pg10 Márcio A. Sepp
11:19 Re: help with generation_series in pg10 Adrian Klaver
11:42 Re: help with generation_series in pg10 David G. Johnston
15:48 Getting started with first user. Agnar Renolen
16:01 Re: help with generation_series in pg10 Alvaro Herrera
16:03 Re: help with generation_series in pg10 Vincenzo Romano
17:48 Sv: Re: [GENERAL] pg_dump streaming fails - PostgreSQL 9.2 Andreas Joseph Krogh
18:44 Re: Sv: Re: [GENERAL] pg_dump streaming fails - PostgreSQL 9.2 Jeff Janes
21:20 Number of rows returned by Sort node Vitaliy Garnashevich
21:23 Re: Number of rows returned by Sort node Tom Lane
22:13 Re: Getting started with first user. Adrian Klaver
22:14 Re: Getting started with first user. Jaime Soler
22:14 RES: help with generation_series in pg10 Márcio A. Sepp
22:17 Re: Getting started with first user. John McKown
22:23 Re: RES: help with generation_series in pg10 Alvaro Herrera
22:32 Re: Getting started with first user. Raymond O'Donnell
22:43 Re: Number of rows returned by Sort node Vitaliy Garnashevich
23:15 Re: How Many Partitions are Good Performing Andrew Staller
23:20 Re: Supartitions in PGSQL 10 Andrew Staller
23:21 RE: How Many Partitions are Good Performing Kumar, Virendra
23:25 Re: How Many Partitions are Good Performing Vincenzo Romano
23:42 data-checksums Rakesh Kumar
23:54 Re: data-checksums Stephen Frost
23:58 Re: data-checksums Rakesh Kumar

10 January 2018

00:39 Re: data-checksums Andres Freund
00:41 Re: data-checksums Alvaro Herrera
01:02 Re: data-checksums Rakesh Kumar
01:04 Re: data-checksums Rakesh Kumar
01:20 Re: data-checksums Jeff Janes
01:20 Re: Getting started with first user. Agnar Renolen
01:30 Hi i like to unscribe me, sorry for the incovenient. Moises Lima dos Anjos
02:02 Re: data-checksums George Neuner
02:22 Re: data-checksums Andres Freund
02:37 Re: data-checksums Joshua D. Drake
02:47 Sv: Re: data-checksums Andreas Joseph Krogh
04:06 Re: Sv: Re: data-checksums Andres Freund
04:30 Sv: Re: Sv: Re: data-checksums Andreas Joseph Krogh
04:42 Re: Sv: Re: Sv: Re: data-checksums Rob Sargent
05:25 Sv: Re: Sv: Re: Sv: Re: data-checksums Andreas Joseph Krogh
06:01 Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Andres Freund
06:31 Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Andreas Joseph Krogh
07:51 Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Stephen Frost
07:55 Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Andres Freund
17:49 Segmentation fault with core dump Glauco Torres
18:21 String comparison problem in select - too many results Durumdara
20:19 Re: help with generation_series in pg10 Merlin Moncure
20:28 Re: help with generation_series in pg10 Merlin Moncure
21:22 RES: help with generation_series in pg10 Márcio A. Sepp
21:25 Re: String comparison problem in select - too many results David G. Johnston
23:06 Re: How Many Partitions are Good Performing pinker
23:08 Re: Segmentation fault with core dump Tom Lane
23:13 Re: Segmentation fault with core dump Merlin Moncure
23:37 Re: Segmentation fault with core dump Alvaro Herrera
23:41 Re: Segmentation fault with core dump Tom Lane
23:47 Re: Segmentation fault with core dump Alvaro Herrera

11 January 2018

00:04 Re: Segmentation fault with core dump Glauco Torres
00:12 Re: Segmentation fault with core dump Tom Lane
00:21 Re: Segmentation fault with core dump Glauco Torres
00:38 Re: Segmentation fault with core dump Tom Lane
01:39 Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Andres Freund
02:23 Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Thomas Poty
03:36 Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Jeff Janes
03:59 Sv: Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Andreas Joseph Krogh
04:33 RE: How Many Partitions are Good Performing Kumar, Virendra
05:27 creating a table in plpython? Celia McInnis
05:34 Re: creating a table in plpython? David G. Johnston
05:46 Re: creating a table in plpython? Celia McInnis
09:35 FOSDEM booth volunteer Andreas 'ads' Scherbaum
12:54 Parallel Query Krithika Venkatesh
14:57 Re: String comparison problem in select - too many results Durumdara
15:05 Re: Parallel Query Rafia Sabih
15:15 RE: How Many Partitions are Good Performing pinker
16:11 Re: String comparison problem in select - too many results Francisco Olarte
17:00 ORDER BY custom type Andreas Joseph Krogh
18:23 Re: String comparison problem in select - too many results Durumdara
18:51 Sv: ORDER BY custom type Andreas Joseph Krogh
21:40 Updating a pre-10 partitioned table to use PG 10 partitioning Alban Hertroys
22:23 Multiple central connection service files Curt Tilmes
22:58 Missing WAL file after running pg_rewind Dylan Luong
22:58 Re: Multiple central connection service files David G. Johnston

12 January 2018

01:28 RE: Updating a pre-10 partitioned table to use PG 10 partitioning Igor Neyman
03:34 characters converted to ??? in postgres armand pirvu
04:12 Re: characters converted to ??? in postgres Peter Eisentraut
07:37 Re: Missing WAL file after running pg_rewind Michael Paquier
07:40 Re: Updating a pre-10 partitioned table to use PG 10 partitioning Michael Paquier
07:52 Re: characters converted to ??? in postgres armand pirvu
11:02 Moving from pgFouine to pgBadger Issue with Total query duration metric Sreekanth Palluru
13:25 Update blocking another update Sachin Kotwal
13:56 pg_basebackup is taking more time than expected Raghavendra Rao J S V
16:08 Re: String comparison problem in select - too many results Francisco Olarte
16:27 Incredibly slow queries oninformation_schema.constraint_column_usage? Viktor Fougstedt
19:07 Re: pg_basebackup is taking more time than expected Stephen Frost
19:45 ADD OR ALTER column Geoff Winkless
19:56 Re: ADD OR ALTER column Rakesh Kumar
20:10 Re: characters converted to ??? in postgres Peter Eisentraut
20:14 Sv: ADD OR ALTER column Andreas Joseph Krogh
20:39 Re: ADD OR ALTER column Geoff Winkless
20:53 Get IEEE754 bytes of real and double types for msgpack encoding Tom Kazimiers
22:05 Re: pg_basebackup is taking more time than expected pinker

13 January 2018

03:44 RE: Missing WAL file after running pg_rewind Dylan Luong
09:11 Re: characters converted to ??? in postgres armand pirvu
10:39 Re: Updating a pre-10 partitioned table to use PG 10 partitioning Keith
12:37 Postgres 9.4 using primary key index in almost all queries leading todegraded performance Rahul Sharma
15:50 psql format result as markdown tables Nicolas Paris
16:33 Re: Missing WAL file after running pg_rewind Michael Paquier
22:07 Re: pg_basebackup is taking more time than expected Raghavendra Rao J S V
22:22 Re: pg_basebackup is taking more time than expected Stephen Frost
22:32 Re: pg_basebackup is taking more time than expected Raghavendra Rao J S V
22:41 Re: pg_basebackup is taking more time than expected Stephen Frost
23:08 Re: Postgres 9.4 using primary key index in almost all queries leading to degraded performance Tom Lane

14 January 2018

04:10 Re: psql format result as markdown tables Melvin Davidson
04:19 Re: psql format result as markdown tables Stephen Frost
04:25 Re: psql format result as markdown tables Stephen Frost
05:12 Re: psql format result as markdown tables Tom Lane
16:01 Using random() in update produces same random value for all Alex Magnum
16:24 Re: Using random() in update produces same random value for all Ken Tanzer
16:27 Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Peter J. Holzer
17:14 Re: String comparison problem in select - too many results Peter J. Holzer
18:03 Is ORDER BY in sub-query preserved when outer query is only projection? Andreas Joseph Krogh
18:20 Re: String comparison problem in select - too many results Francisco Olarte
18:30 Re: Is ORDER BY in sub-query preserved when outer query is only projection? Francisco Olarte
18:40 Sv: Re: Is ORDER BY in sub-query preserved when outer query is only projection? Andreas Joseph Krogh
23:47 Re: String comparison problem in select - too many results Peter J. Holzer

15 January 2018

01:44 Re: psql format result as markdown tables Vick Khera
06:13 RE: Missing WAL file after running pg_rewind Dylan Luong
06:27 Re: Missing WAL file after running pg_rewind Michael Paquier
13:59 Re: String comparison problem in select - too many results Durumdara
15:45 Re: Update blocking another update Guillaume Lelarge
19:38 why SSD is slower than HDD SAS 15K ? Neto pr
20:57 Re: pg_basebackup is taking more time than expected Raghavendra Rao J S V
21:12 Re: pg_basebackup is taking more time than expected David G. Johnston
21:35 RE: pg_basebackup is taking more time than expected Kellner Thiemo
23:13 Re: why SSD is slower than HDD SAS 15K ? Vick Khera
23:47 Re: why SSD is slower than HDD SAS 15K ? Neto pr
23:48 Re: Re: Is ORDER BY in sub-query preserved when outer query is only projection? Haroldo Stenger

16 January 2018

00:04 Re: Re: Is ORDER BY in sub-query preserved when outer query is only projection? David G. Johnston
00:10 Sv: Re: Re: Is ORDER BY in sub-query preserved when outer query is only projection? Andreas Joseph Krogh
01:16 Re: why SSD is slower than HDD SAS 15K ? Merlin Moncure
06:54 Re: why SSD is slower than HDD SAS 15K ? NTPT
06:57 Insert results in 0 1 Sherman Willden
07:35 Re: why SSD is slower than HDD SAS 15K ? Neto pr
07:54 Re: why SSD is slower than HDD SAS 15K ? Neto pr
08:13 Re: Insert results in 0 1 Rob Sargent
11:36 Re: Insert results in 0 1 Michael Paquier
13:44 Re: why SSD is slower than HDD SAS 15K ? NTPT
13:56 RE: Moving from pgFouine to pgBadger Issue with Total query duration metric Ahmed, Nawaz
16:18 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 adsj@novozymes.com (Adam Sjøgren)
20:47 SSD filesystem aligned to DBMS Neto pr
22:01 Re: SSD filesystem aligned to DBMS Scott Marlowe
22:32 OPtimize the performance of a query hmidi slim
22:44 Re: OPtimize the performance of a query hmidi slim
22:46 Re: OPtimize the performance of a query James Keener
22:48 Re: OPtimize the performance of a query Melvin Davidson
22:49 Re: OPtimize the performance of a query Pavel Stehule
22:49 Re: OPtimize the performance of a query Alban Hertroys
22:50 Re: SSD filesystem aligned to DBMS Michael Loftis
23:57 Re: OPtimize the performance of a query hmidi slim
23:57 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value76753264 in pg_toast_10920100 Jorge Daniel

17 January 2018

00:05 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 adsj@novozymes.com (Adam Sjøgren)
00:08 Re: OPtimize the performance of a query Pavel Stehule
00:28 Re: SSD filesystem aligned to DBMS Neto pr
00:35 Re: OPtimize the performance of a query hmidi slim
00:36 Re: OPtimize the performance of a query Pavel Stehule
02:23 Re: OPtimize the performance of a query Gavin Flower
02:47 Re: SSD filesystem aligned to DBMS George Neuner
04:54 Extra files in "base" dir not seen in relfilenodes Daniel Farina
05:03 Re: Extra files in "base" dir not seen in relfilenodes Tom Lane
05:08 Re: Extra files in "base" dir not seen in relfilenodes Daniel Farina
05:18 Re: Extra files in "base" dir not seen in relfilenodes Tom Lane
08:50 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value76753264 in pg_toast_10920100 Michael Paquier
12:57 Parallel Btree index scan Krithika Venkatesh
13:02 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 adsj@novozymes.com (Adam Sjøgren)
17:35 Re: Parallel Btree index scan Rakesh Kumar
19:08 READ COMMITTED vs. index-only scans Jacek Kołodziej
20:30 Re: READ COMMITTED vs. index-only scans Melvin Davidson
21:17 Re: READ COMMITTED vs. index-only scans Laurenz Albe
21:21 Re: READ COMMITTED vs. index-only scans Francisco Olarte
21:45 Re: READ COMMITTED vs. index-only scans Jacek Kołodziej
22:01 Re: Configuration of pgaudit settings in postgreSQL.conf causespostgreSQL to fail to start Brysounds
22:04 Re: READ COMMITTED vs. index-only scans Melvin Davidson
23:16 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 Tom Lane
23:23 Re: Extra files in "base" dir not seen in relfilenodes Alvaro Herrera
23:35 Re: Extra files in "base" dir not seen in relfilenodes Tom Lane

18 January 2018

00:51 Possible hang in 10.1 with JSON query over partially indexedpartitions Paul Jones
00:56 Re: READ COMMITTED vs. index-only scans Tom Lane
01:00 RE: READ COMMITTED vs. index-only scans Karen Stone
02:27 Bad performance when inserting many data simultanously hmidi slim
02:34 Re: READ COMMITTED vs. index-only scans Jacek Kołodziej
07:39 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value76753264 in pg_toast_10920100 Michael Paquier
18:39 Partitioning constraints vs before-trigger Nikolay
22:06 Connection type Enrico Pirozzi
22:11 Could not read block in file Don Seiler
22:19 Re: Connection type Steve Atkins
22:22 Call sql function in psql Abhra Kar
22:27 Re: Call sql function in psql Rob Sargent
22:31 Re: Call sql function in psql David G. Johnston
22:34 Re: Connection type Enrico Pirozzi

19 January 2018

01:00 Possible hang in 10.1 with JSON query over partially indexedpartitions Paul Jones
03:05 warning for subquery that references a table but not its columns Seamus Abshere
07:07 Re: Possible hang in 10.1 with JSON query over partially indexed partitions Tom Lane
09:49 Re: warning for subquery that references a table but not its columns Tom Lane
12:58 Re: Call sql function in psql Abhra Kar
17:33 pgaudit? Bjørn T Johansen
21:34 Notify client when a table was full hmidi slim
21:40 Re: Notify client when a table was full Raymond O'Donnell
21:44 Re: Notify client when a table was full David G. Johnston
21:46 Use left hand column for null values
21:47 Re: Notify client when a table was full hmidi slim
21:50 Re: Notify client when a table was full David G. Johnston
21:59 Re: Use left hand column for null values David G. Johnston
22:03 Query optimization with repeated calculations Robert McGehee
23:15 Re: Query optimization with repeated calculations Tom Lane

20 January 2018

02:53 Re: pgaudit? Adrian Klaver
07:54 Re: Possible bug: could not open relation with OID [numbers] SQLState: XX000 pinker

21 January 2018

07:42 array_agg and/or =ANY doesn't appear to be functioning as I expect Rhys A.D. Stewart
10:00 Re: array_agg and/or =ANY doesn't appear to be functioning as Iexpect Hannes Erven
18:27 Re: Notify client when a table was full Michael Paquier
19:40 License question regarding distribution of binaries Rafał Zabrowarny

22 January 2018

00:31 Re: Notify client when a table was full Francisco Olarte
00:44 Re: Notify client when a table was full Vincenzo Romano
00:57 Best non-networked front end for postgresql Sherman Willden
01:05 Re: Best non-networked front end for postgresql Vincenzo Romano
02:45 How to measure query time - with warm up and cached data Neto pr
02:45 Re: Best non-networked front end for postgresql Tim Clarke
02:47 Re: Best non-networked front end for postgresql Adrian Klaver
03:53 Re: How to measure query time - with warm up and cached data Peter J. Holzer
06:54 Re: How to measure query time - with warm up and cached data Neto pr
07:07 Re: Best non-networked front end for postgresql Michael Paquier
08:21 Re: array_agg and/or =ANY doesn't appear to be functioning as I expect Rhys A.D. Stewart
12:39 Setting up streaming replication problems Thiemo Kellner
13:18 Re: Setting up streaming replication problems Andreas Kretschmer
14:07 Re: Notify client when a table was full Steve Atkins
14:21 Re: pgaudit? Bjørn T Johansen
19:58 Re: Notify client when a table was full John McKown
20:15 Re: Notify client when a table was full Vincenzo Romano
20:19 Re: License question regarding distribution of binaries John McKown
21:24 Slow alter sequence with PG10.1 Michael Krüger
21:37 Re: Using random() in update produces same random value for all Olleg Samoylov
23:16 Re: Using random() in update produces same random value for all Tom Lane

23 January 2018

00:46 Re: Slow alter sequence with PG10.1 Rakesh Kumar
00:55 Re: Slow alter sequence with PG10.1 David G. Johnston
01:47 Re: Slow alter sequence with PG10.1 Ivan E. Panchenko
01:52 Re: Slow alter sequence with PG10.1 Laurenz Albe
02:01 Re: Using random() in update produces same random value for all Jeff Janes
02:15 Re: Using random() in update produces same random value for all Tom Lane
02:46 Hardware advice Alban Hertroys
03:18 Changing locale/charset Martin Moore
03:29 Re: Slow alter sequence with PG10.1 Adrian Klaver
04:11 Re: Slow alter sequence with PG10.1 Michael Krüger
04:35 Re: Changing locale/charset Peter Eisentraut
04:47 Re: Slow alter sequence with PG10.1 Michael Krüger
04:51 Re: Slow alter sequence with PG10.1 Peter Eisentraut
05:40 Re: Slow alter sequence with PG10.1 David G. Johnston
05:54 Re: Slow alter sequence with PG10.1 Kenneth Marshall
07:12 Re: Slow alter sequence with PG10.1 Adrian Klaver
12:35 Re: Slow alter sequence with PG10.1 Michael Krüger
13:36 Re: FW: Setting up streaming replication problems Thiemo Kellner, NHC Barhufpflege
16:15 Re: Using random() in update produces same random value for all Olleg Samoylov
20:03 Re: Changing locale/charset Adrian Klaver

24 January 2018

00:04 Re: FW: Setting up streaming replication problems Martin Goodson
00:08 Re: FW: Setting up streaming replication problems Pavan Teja
00:21 Re: Hardware advice Tomas Vondra
00:25 Re: FW: Setting up streaming replication problems Martin Goodson
05:14 Any community members in Phoenix, AZ? Joshua D. Drake
06:08 Re: Is it possible to sort strings in EBCDIC order in PostgreSQLserver? Jeremy Schneider
06:35 Re: Any community members in Phoenix, AZ? David G. Johnston
07:16 Re: Any community members in Phoenix, AZ? Joshua D. Drake
07:37 RE: Any community members in Phoenix, AZ? Will LaShell
16:52 PGSQL 10, many Random named DB Durumdara
17:06 Re: PGSQL 10, many Random named DB Adam Tauno Williams
17:18 Re: PGSQL 10, many Random named DB Condor
17:27 Re: PGSQL 10, many Random named DB Vincenzo Romano
17:52 PostgreSQL 9.6: view based on sequence Enrico Pirozzi
17:56 Re: PostgreSQL 9.6: view based on sequence Vincenzo Romano
18:02 Re: PostgreSQL 9.6: view based on sequence Enrico Pirozzi
18:05 Re: PostgreSQL 9.6: view based on sequence Enrico Pirozzi
18:06 Re: PostgreSQL 9.6: view based on sequence Vincenzo Romano
18:10 Re: PostgreSQL 9.6: view based on sequence Enrico Pirozzi
18:11 Re: PostgreSQL 9.6: view based on sequence Vincenzo Romano
19:42 Re: PGSQL 10, many Random named DB Adrian Klaver
19:52 Re: PostgreSQL 9.6: view based on sequence Enrico Pirozzi
20:02 Re: PostgreSQL 9.6: view based on sequence Vincenzo Romano
20:38 Re: PostgreSQL 9.6: view based on sequence Enrico Pirozzi
22:57 CannotAcquireResourceException in Junit Abhra Kar
23:22 Re: PGSQL 10, many Random named DB Merlin Moncure
23:40 Re: PGSQL 10, many Random named DB Rob Sargent

25 January 2018

00:12 Re: PGSQL 10, many Random named DB Melvin Davidson
00:15 PgSql 9.4 onwards Vikas Sharma
02:25 \g filename Rob Sargent
02:30 \g filename Rob Sargent
02:38 Re: \g filename Adrian Klaver
02:42 Re: \g filename Rob Sargent
03:27 Using Token (JWT) authentication mechanism in Postgres Julio Cesar Tenganan Daza
04:07 Re: Using Token (JWT) authentication mechanism in Postgres James Keener
10:06 Re: CannotAcquireResourceException in Junit Rob Sargent
10:32 Re: CannotAcquireResourceException in Junit Abhra Kar
10:58 Re: CannotAcquireResourceException in Junit Rob Sargent
11:45 AFTER UPDATE trigger updating other records Ian Harding
14:43 Re: Using Token (JWT) authentication mechanism in Postgres Alexander Kukushkin
15:38 Re: PGSQL 10, many Random named DB Durumdara
22:51 Re: PGSQL 10, many Random named DB Laurenz Albe
23:07 Re: PostgreSQL 9.6: view based on sequence Peter Eisentraut
23:13 Postgres and Unix groups Rakesh Kumar
23:19 Deferrable constraint trigger Maciej Kołuda
23:38 Re: PostgreSQL 9.6: view based on sequence Enrico Pirozzi

26 January 2018

00:51 Re: AFTER UPDATE trigger updating other records Adrian Klaver
01:10 AFTER UPDATE trigger updating other records David G. Johnston
02:20 pg 10.1 missing libpq in postgresql-devel support-tiger
02:53 A little RULE help? Steven Winfield
03:10 Re: pg 10.1 missing libpq in postgresql-devel Martin Marques
03:54 Re: PGSQL 10, many Random named DB Merlin Moncure
04:00 Re: AFTER UPDATE trigger updating other records Ian Harding
04:06 Re: AFTER UPDATE trigger updating other records Ian Harding
04:33 Re: AFTER UPDATE trigger updating other records David G. Johnston
04:59 Re: pg 10.1 missing libpq in postgresql-devel Adrian Klaver
05:20 Re: A little RULE help? Vik Fearing
05:21 RE: A little RULE help? Steven Winfield
05:22 Re: A little RULE help? Adrian Klaver
05:25 Re: A little RULE help? Adrian Klaver
05:34 RE: A little RULE help? Steven Winfield
05:41 Re: A little RULE help? Adrian Klaver
15:33 Re: Deferrable constraint trigger Laurenz Albe
15:47 Re: FW: Setting up streaming replication problems Thiemo Kellner
19:58 PostgreSQL Restore Database Without Backup and Log fabio.silva
20:00 Re: AFTER UPDATE trigger updating other records Ian Harding
20:47 Information on savepoint requirement within transctions Robert Zenz
20:54 RE: Using Token (JWT) authentication mechanism in Postgres Julio Cesar Tenganan Daza
20:59 Re: Information on savepoint requirement within transctions Melvin Davidson
21:19 RE: A little RULE help? Steven Winfield
21:21 Re: Using Token (JWT) authentication mechanism in Postgres Alexander Kukushkin
21:32 Re: Information on savepoint requirement within transctions Robert Zenz
21:42 Re: Information on savepoint requirement within transctions Melvin Davidson
21:57 Re: Information on savepoint requirement within transctions Robert Zenz
22:11 Re: Information on savepoint requirement within transctions David G. Johnston
22:12 Re: Information on savepoint requirement within transctions David G. Johnston
22:27 Re: Information on savepoint requirement within transctions Melvin Davidson
22:41 Re: Information on savepoint requirement within transctions David G. Johnston
22:47 Re: Information on savepoint requirement within transctions Melvin Davidson
23:08 Re: Information on savepoint requirement within transctions David G. Johnston

27 January 2018

07:26 Re: A little RULE help? Vik Fearing

28 January 2018

06:34 Re: pg 10.1 missing libpq in postgresql-devel support-tiger
07:43 Re: pg 10.1 missing libpq in postgresql-devel Adrian Klaver
19:58 Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP Ryan Murphy
20:40 Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP David G. Johnston
20:46 Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP Ryan Murphy
21:53 Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP Andy Colson

29 January 2018

01:22 Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP Rob Sargent
01:30 Re: PostgreSQL Restore Database Without Backup and Log Adrian Klaver
01:41 Re: PostgreSQL Restore Database Without Backup and Log Tom Lane
01:56 pg_trgm Extension Installed but Operators and Functions do not exist Igal @ Lucee.org
02:35 Re: pg_trgm Extension Installed but Operators and Functions do not exist Tom Lane
02:49 Re: pg_trgm Extension Installed but Operators and Functions do notexist Igal @ Lucee.org
03:45 Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP David G. Johnston
04:24 Re: FW: Setting up streaming replication problems Thiemo Kellner
05:11 Re: FW: Setting up streaming replication problems Martin Goodson
05:42 How to Optimize pg_trgm Performance Igal @ Lucee.org
09:48 Re: [GENERAL] pgpass file type restrictions Bruce Momjian
11:03 Re: FW: Setting up streaming replication problems Thiemo Kellner
11:56 Consider Spaces in pg_trgm for Better Similarity Igal @ Lucee.org
12:02 Re: Downsides of liberally using CREATE TEMP TABLE ... ON COMMIT DROP Rob Sargent
14:19 Re: FW: Setting up streaming replication problems Andreas Kretschmer
14:37 Re: Information on savepoint requirement within transctions Robert Zenz
17:37 Re: Information on savepoint requirement within transctions Adam Tauno Williams
17:49 Fwd: Re: Information on savepoint requirement within transctions Robert Zenz
19:36 Re: Information on savepoint requirement within transctions David G. Johnston
19:59 Re: Information on savepoint requirement within transctions Robert Zenz
20:11 Re: Information on savepoint requirement within transctions Alban Hertroys
20:34 PG Sharding Matej
20:44 Re: PG Sharding Melvin Davidson
21:06 Re: Information on savepoint requirement within transctions Robert Zenz
21:15 Re: PG Sharding Thomas Boussekey
21:33 Re: Information on savepoint requirement within transctions Tom Lane
21:45 Which specific flags to use for bash client applications for DaVinci Resolve? Seth Goldin
21:46 Re: Information on savepoint requirement within transctions David G. Johnston
21:49 Re: PG Sharding Matej
21:50 Re: Information on savepoint requirement within transctions Robert Zenz
22:00 Re: Information on savepoint requirement within transctions Tom Lane
22:01 Re: PG Sharding Thomas Boussekey
22:09 Re: Information on savepoint requirement within transctions David G. Johnston
22:12 Re: Which specific flags to use for bash client applications forDaVinci Resolve? Steve Crawford
22:15 Re: [GENERAL] Matching statement and duration log lines Bruce Momjian
22:16 Re: PG Sharding Konstantin Gredeskoul
22:19 pgpool Connections Distributions Among Nodes Kumar, Virendra
22:41 Using AWS ephemeral SSD storage for production database workload? Pritam Barhate
22:50 Re: PG Sharding Rakesh Kumar
22:52 Re: pgpool Connections Distributions Among Nodes Adrian Klaver
22:52 Re: pgpool Connections Distributions Among Nodes Glauco Torres
22:56 Re: Which specific flags to use for bash client applications forDaVinci Resolve? Seth Goldin
23:00 RE: pgpool Connections Distributions Among Nodes Kumar, Virendra
23:32 Re: Using AWS ephemeral SSD storage for production database workload? Tomas Vondra
23:57 Re: Using AWS ephemeral SSD storage for production database workload? Pritam Barhate

30 January 2018

00:31 EXPLAIN BUFFERS: dirtied Vitaliy Garnashevich
00:38 Re: EXPLAIN BUFFERS: dirtied Tom Lane
01:18 Re: pg 10.1 missing libpq in postgresql-devel support-tiger
01:21 Re: EXPLAIN BUFFERS: dirtied Vitaliy Garnashevich
01:41 Re: Using AWS ephemeral SSD storage for production databaseworkload? Steven Lembark
02:02 Re: Using AWS ephemeral SSD storage for production database workload? Paul A Jungwirth
02:25 Re: pg 10.1 missing libpq in postgresql-devel Adrian Klaver
02:35 Re: EXPLAIN BUFFERS: dirtied Tomas Vondra
02:36 Re: Using AWS ephemeral SSD storage for production database workload? Pritam Barhate
03:18 pgcrypto Documentation/Function Mismatch Gary Chambers
03:38 best way to storing logs Ibrahim Edib Kokdemir
04:46 Re: pgpool Connections Distributions Among Nodes Tatsuo Ishii
05:06 Meaning of query age in pg_stat_activity Jan De Moerloose
05:10 Re: Meaning of query age in pg_stat_activity Nikolay Samokhvalov
05:11 Re: Meaning of query age in pg_stat_activity Adrian Klaver
05:19 Re: Meaning of query age in pg_stat_activity Jan De Moerloose
05:29 Re: Meaning of query age in pg_stat_activity Nikolay Samokhvalov
05:45 Re: Meaning of query age in pg_stat_activity Jan De Moerloose
05:55 Re: best way to storing logs PT
08:07 Re: Information on savepoint requirement within transctions David G. Johnston
09:02 Re: Using AWS ephemeral SSD storage for production database workload? Ben Madin
09:05 Re: Using AWS ephemeral SSD storage for production database workload? Sam Gendler
09:22 Re: Using AWS ephemeral SSD storage for production database workload? Ben Chobot
10:25 Re: Using AWS ephemeral SSD storage for production database workload? Pritam Barhate
11:52 Re: Meaning of query age in pg_stat_activity Nikolay Samokhvalov
12:04 Re: Meaning of query age in pg_stat_activity Nikolay Samokhvalov
13:48 session_replication_role meaning? Luca Ferrari
13:55 Re: EXPLAIN BUFFERS: dirtied Vitaliy Garnashevich
14:03 Re: Information on savepoint requirement within transctions Laurenz Albe
14:30 Re: session_replication_role meaning? Achilleas Mantzios
14:36 Re: session_replication_role meaning? Laurenz Albe
14:40 Re: Information on savepoint requirement within transctions Robert Zenz
14:47 Re: PG Sharding Matej
16:11 Re: CannotAcquireResourceException in Junit Abhra Kar
17:05 Re: PG Sharding Rakesh Kumar
17:18 Re: PG Sharding Matej
17:32 pgAdmin 4 loading shapefiles Findlay, Thomas C
17:52 Re: CannotAcquireResourceException in Junit rob stone
19:40 Alter view with dependence without drop view! Elson Vaz
19:44 pgadmin 4 shapefile loader Findlay, Thomas C
19:47 pg10 logical replication set schema Gabriel Furstenheim Milerud
20:26 Re: PG Sharding Thomas Boussekey
20:30 Re: session_replication_role meaning? Jan Wieck
21:25 Re: Information on savepoint requirement within transctions Rakesh Kumar
21:29 Re: Information on savepoint requirement within transctions David G. Johnston
21:34 Re: Alter view with dependence without drop view! btober@computer.org
22:13 PostgreSQL Kerberos Authentication HIRTZ Jorge Alberto TENARIS
22:50 Re: PostgreSQL Kerberos Authentication Poul Kristensen
23:01 Many Backends stuck in wait event IPC/ParallelFinish Steven Winfield
23:07 Re: pgAdmin 4 loading shapefiles Adrian Klaver
23:35 ERROR: invalid memory alloc request size 1073741824 Stefan Blanke
23:48 Re: Alter view with dependence without drop view! David G. Johnston

31 January 2018

00:02 RE: PostgreSQL Kerberos Authentication HIRTZ Jorge Alberto TENARIS
00:12 Re: Alter view with dependence without drop view! Melvin Davidson
00:16 Streaming replication: replicant server not starting (9.4.4, Win2008) Tim Bowden
00:38 Re: Streaming replication: replicant server not starting (9.4.4, Win 2008) Ibrahim Edib Kokdemir
02:56 Re: ERROR: invalid memory alloc request size 1073741824 Tomas Vondra
03:43 Re: ERROR: invalid memory alloc request size 1073741824 Jan Wieck
03:47 Working with JSONB data having node lists geoff hoffman
03:50 Re: Alter view with dependence without drop view! Ken Tanzer
04:00 Re: ERROR: invalid memory alloc request size 1073741824 Tomas Vondra
04:03 Re: Alter view with dependence without drop view! Thomas Kellerer
04:14 Re: Working with JSONB data having node lists David G. Johnston
04:50 Re: How to Optimize pg_trgm Performance Ivan E. Panchenko
10:15 Re: pg10 logical replication set schema Peter Eisentraut
10:19 Re: session_replication_role meaning? Peter Eisentraut
10:32 Re: PostgreSQL Kerberos Authentication Peter Eisentraut
14:04 RE: Working with JSONB data having node lists Steven Winfield
16:17 Understanding Huge Pages Pavel Suderevsky
17:59 Re: PG Sharding Matej
18:21 Re: [solved] Setting up streaming replication problems Thiemo Kellner
18:26 Re: [solved] Setting up streaming replication problems Thiemo Kellner
18:45 Recreating functions after starting the database server. Konrad Witaszczyk
19:03 Re: Recreating functions after starting the database server. Achilleas Mantzios
19:22 Re: Recreating functions after starting the database server. Konrad Witaszczyk
19:32 Re: Recreating functions after starting the database server. Achilleas Mantzios
19:39 Re: Recreating functions after starting the database server. Konrad Witaszczyk
20:18 Re: pgAdmin 4 loading shapefiles Daniel Gustafsson
21:39 RE: A little RULE help? Steven Winfield
22:02 Re: A little RULE help? David G. Johnston
22:17 Re: A little RULE help? Achilleas Mantzios
22:21 Re: [solved] Setting up streaming replication problems Thiemo Kellner
22:32 Re: postgres for production Peter J. Holzer
22:52 Please help me understand unlogged tables Alexander Stoddard
22:57 Equivalent shell script of create user and schema in specificpostgres db Abhra Kar
23:13 Re: Equivalent shell script of create user and schema in specificpostgres db Karsten Hilbert
23:32 Re: ERROR: invalid memory alloc request size 1073741824 Stefan Blanke
23:32 Re: Bulk Insert/Update Scenario Peter J. Holzer
23:35 RE: PostgreSQL Kerberos Authentication HIRTZ Jorge Alberto TENARIS
23:56 Issue with WAL logs temporary not replaying Eugene Pirogov