pgsql-general - September 2016

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)

Browse Archives

Prev | Next

Sept. 1, 2016

Thread Author Time
Re: Vacuum Full - Questions Patrick B 00:32
UPDATE OR REPLACE? dandl 03:10
Re: Vacuum Full - Questions Venkata B Nagothi 03:57
Re: UPDATE OR REPLACE? Michael Paquier 04:03
Re: Vacuum Full - Questions Gary Evans 04:17
Text,Citext column and Btree index Viswanath 07:34
Re: Text,Citext column and Btree index Vik Fearing 07:57
Array element foreign keys Emrul 09:13
COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID Michelle Konzack 09:28
Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID Szymon Lipiński 09:29
Re: Do function calls the cached? Daniel Caldeweyher 11:02
Re: Array element foreign keys Tom Lane 11:48
Re: UPDATE OR REPLACE? Mike Sofen 12:20
Re: Clustered index to preserve data locality in a multitenant application? Igor Neyman 13:08
Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID rob stone 13:35
Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID Andreas Kretschmer 14:01
Re: UPDATE OR REPLACE? dandl 14:37
Re: UPDATE OR REPLACE? Adrian Klaver 14:45
Re: Rackspace to RDS using DMS (Postgres 9.2) Joshua D. Drake 16:28
Re: Rackspace to RDS using DMS (Postgres 9.2) Mike Sofen 17:44
Re: COL unique (CustomerID) plus COL unique (COUNT) inside CustomerID Kevin Grittner 18:39
error initializing the db Jennyfer Sanchez 20:22
Re: Clustered index to preserve data locality in a multitenant application? Eduardo Morras 20:50
Re: Rackspace to RDS using DMS (Postgres 9.2) Patrick B 21:15
Re: Rackspace to RDS using DMS (Postgres 9.2) Vick Khera 21:15

Sept. 2, 2016

Thread Author Time
Re: UPDATE OR REPLACE? dandl 00:08
2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 Patrick B 02:48
Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 Venkata B Nagothi 03:36
Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 Patrick B 04:40
How to reduce WAL files in Point in time recovery Amee Sankhesara - Quipment India 04:58
What limits Postgres performance when the whole database lives in cache? dandl 10:49
Duplicate data despite unique constraint Jonas Tehler 11:32
Re: Duplicate data despite unique constraint Adrian Klaver 13:02
Re: Duplicate data despite unique constraint Albe Laurenz 13:06
Re: UPDATE OR REPLACE? Adrian Klaver 13:31
Re: UPDATE OR REPLACE? dandl 14:43
PG_MODULE_MAGIC issue with small extension Brent Douglas 14:51
Re: PG_MODULE_MAGIC issue with small extension Tom Lane 15:07
Re: PG_MODULE_MAGIC issue with small extension Brent Douglas 15:15
Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 David Gibbons 15:16
Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly 15:18
Re: PG_MODULE_MAGIC issue with small extension Tom Lane 15:19
Re: PG_MODULE_MAGIC issue with small extension Brent Douglas 15:26
Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 David Gibbons 16:44
Re: What limits Postgres performance when the whole database lives in cache? Scott Marlowe 17:10
RETURNS TABLE function returns nothingness Alexander Farber 17:21
Re: RETURNS TABLE function returns nothingness Pavel Stehule 17:27
Re: What limits Postgres performance when the whole database lives in cache? Andres Freund 17:32
Re: RETURNS TABLE function returns nothingness Alexander Farber 17:35
Re: RETURNS TABLE function returns nothingness Adrian Klaver 17:40
Re: RETURNS TABLE function returns nothingness Tom Lane 17:45
Re: What limits Postgres performance when the whole database lives in cache? Dorian Hoxha 18:34
Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 Steve Crawford 18:46
Re: error initializing the db Adrian Klaver 18:48
Re: error initializing the db Tom Lane 19:51
Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 Scott Marlowe 21:28
Re: What limits Postgres performance when the whole database lives in cache? Bruce Momjian 22:24
Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 Venkata B Nagothi 23:20
Re: How to reduce WAL files in Point in time recovery Venkata B Nagothi 23:26
Re: a column definition list is required for functions returning "record" Jim Nasby 23:55

Sept. 3, 2016

Thread Author Time
Re: What limits Postgres performance when the whole database lives in cache? Peter Geoghegan 00:34
Re: What limits Postgres performance when the whole database lives in cache? dandl 00:39
Re: What limits Postgres performance when the whole database lives in cache? dandl 00:44
Re: What limits Postgres performance when the whole database lives in cache? dandl 00:45
Re: What limits Postgres performance when the whole database lives in cache? 'Bruce Momjian' 02:01
Re: What limits Postgres performance when the whole database lives in cache? dandl 03:36
PostgreSQL Database performance Pradeep 03:38
Re: What limits Postgres performance when the whole database lives in cache? Peter Geoghegan 04:04
Re: What limits Postgres performance when the whole database lives in cache? Simon Riggs 08:51
IDE for function/stored proc development. Tim Uckun 09:36
Re: IDE for function/stored proc development. Pavel Stehule 11:03
Re: IDE for function/stored proc development. Tim Uckun 12:49
Re: Filters not supported for LDAP authentication Magnus Hagander 13:06
Re: IDE for function/stored proc development. Mike Sofen 13:28
Re: IDE for function/stored proc development. Edson Richter 13:51
Re: IDE for function/stored proc development. Michael Sheaver 16:19
Re: IDE for function/stored proc development. Adrian Klaver 19:38
Upgrading using pg_dumpall Rich Shepard 21:19
Re: Upgrading using pg_dumpall Adrian Klaver 21:36
Re: Upgrading using pg_dumpall Rich Shepard 21:44
Re: Upgrading using pg_dumpall Adrian Klaver 22:06
Re: Upgrading using pg_dumpall Rich Shepard 22:43
Re: Upgrading using pg_dumpall Adrian Klaver 22:54
Re: Upgrading using pg_dumpall Rich Shepard 23:01
Re: Upgrading using pg_dumpall Adrian Klaver 23:11
Re: Upgrading using pg_dumpall Rich Shepard 23:16
Re: Upgrading using pg_dumpall Adrian Klaver 23:23
Re: Upgrading using pg_dumpall Rich Shepard 23:51

Sept. 4, 2016

Thread Author Time
Re: Upgrading using pg_dumpall Charles Clavadetscher 06:52
Re: PGDATA / data_directory Christoph Berg 09:40
Re: Upgrading using pg_dumpall Rich Shepard 12:40
Re: Upgrading using pg_dumpall Adrian Klaver 13:51
Re: Upgrading using pg_dumpall 📎 Rich Shepard 14:07
Re: Upgrading using pg_dumpall Rich Shepard 14:08
Re: Upgrading using pg_dumpall Adrian Klaver 14:08
Re: Upgrading using pg_dumpall Rich Shepard 14:09
postgres_fdw + presto Nicolas Paris 14:14
Re: Upgrading using pg_dumpall Adrian Klaver 14:53
Re: Upgrading using pg_dumpall Adrian Klaver 14:56
Re: Upgrading using pg_dumpall Rich Shepard 15:11
Re: Upgrading using pg_dumpall Rich Shepard 15:14
Re: Upgrading using pg_dumpall Charles Clavadetscher 15:14
Re: Upgrading using pg_dumpall Charles Clavadetscher 15:16
Re: Upgrading using pg_dumpall Charles Clavadetscher 15:19
Re: Upgrading using pg_dumpall Adrian Klaver 15:26
Re: Upgrading using pg_dumpall Adrian Klaver 15:47
Re: Upgrading using pg_dumpall [FIXED] Rich Shepard 16:01
Re: Upgrading using pg_dumpall Rich Shepard 16:04
Re: Upgrading using pg_dumpall Rich Shepard 16:07
Re: Upgrading using pg_dumpall [FIXED] Adrian Klaver 16:10
Re: Upgrading using pg_dumpall [FIXED] Adrian Klaver 16:18
Re: Upgrading using pg_dumpall [FIXED] Rich Shepard 16:38
Re: Upgrading using pg_dumpall Rich Shepard 16:43
Re: Upgrading using pg_dumpall [FIXED] Rich Shepard 16:52
please remove outdated site from 2005 Lukas Lehner 18:33
Re: Upgrading using pg_dumpall Adrian Klaver 18:59
Re: Upgrading using pg_dumpall Rich Shepard 19:10
Re: Upgrading using pg_dumpall Adrian Klaver 19:28
Re: Upgrading using pg_dumpall Rich Shepard 19:42
Re: Upgrading using pg_dumpall Adrian Klaver 19:43
Re: Upgrading using pg_dumpall Adrian Klaver 19:48
Re: Upgrading using pg_dumpall Rich Shepard 19:55
Re: Upgrading using pg_dumpall Adrian Klaver 20:02
Re: please remove outdated site from 2005 Raymond O'Donnell 20:19
Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 Patrick B 20:37
Re: BDR: Transactions with global lock Craig Ringer 23:28

Sept. 5, 2016

Thread Author Time
Get date timestamp(3) without time zone column - PGSQL 9.5 Patrick B 02:57
Re: Get date timestamp(3) without time zone column - PGSQL 9.5 Sameer Kumar 03:06
Re: Get date timestamp(3) without time zone column - PGSQL 9.5 Patrick B 03:17
Re: Get date timestamp(3) without time zone column - PGSQL 9.5 Tom Lane 03:18
Re: Get date timestamp(3) without time zone column - PGSQL 9.5 Pavel Stehule 03:34
Re: Get date timestamp(3) without time zone column - PGSQL 9.5 Lucas Possamai 03:37
Re: Get date timestamp(3) without time zone column - PGSQL 9.5 amulsul 03:43
Re: Materialized view auto refresh Nguyễn Trần Quốc Vinh 06:20
Re: IDE for function/stored proc development. Martijn Tonies (Upscene Productions) 08:02
Re: IDE for function/stored proc development. Daevor The Devoted 08:29
Re: IDE for function/stored proc development. Martijn Tonies (Upscene Productions) 08:42
Re: IDE for function/stored proc development. Edson Richter 11:35
Restricted access on DataBases Durumdara 12:45
Re: Restricted access on DataBases amul sul 13:02
Re: Restricted access on DataBases Adrian Klaver 14:19
Re: Restricted access on DataBases Charles Clavadetscher 15:56
Re: Restricted access on DataBases rob stone 16:23
Re: Restricted access on DataBases Charles Clavadetscher 16:25
postgres driver for mysql Mimiko 18:38
Re: postgres driver for mysql Adrian Klaver 19:42
postgres question: Views with duplicate field names Ryan Murphy 19:55
Re: postgres question: Views with duplicate field names Adrian Klaver 20:06
Re: postgres question: Views with duplicate field names Ryan Murphy 20:13
Re: postgres question: Views with duplicate field names Adrian Klaver 20:18
Re: Get date timestamp(3) without time zone column - PGSQL 9.5 Patrick B 21:13
Re: postgres question: Views with duplicate field names Tom Lane 21:25
Re: postgres question: Views with duplicate field names Ryan Murphy 21:28

Sept. 6, 2016

Thread Author Time
Re: postgres question: Views with duplicate field names Ryan Murphy 00:03
Help with slow query - Pgsql 9.2 Patrick B 01:53
Re: postgres question: Views with duplicate field names Ryan Murphy 03:43
Re: Materialized view auto refresh hari.prasath 07:42
Re: Restricted access on DataBases Durumdara 08:26
Privileges on public schema can't be revoked? Greg Fodor 08:27
Re: postgres driver for mysql Glyn Astill 09:03
pgadmin4 rc1 query tool performance Attila Soki 09:35
Check if there 6 last records of same type without gaps Alexander Farber 10:32
Re: Check if there 6 last records of same type without gaps Sándor Daku 11:30
Re: Check if there 6 last records of same type without gaps Alexander Farber 12:23
Re: Check if there 6 last records of same type without gaps Sándor Daku 12:30
Re: Check if there 6 last records of same type without gaps Alexander Farber 12:35
Re: Check if there 6 last records of same type without gaps Charles Clavadetscher 12:52
Re: Check if there 6 last records of same type without gaps Alexander Farber 13:19
Re: pgadmin4 rc1 query tool performance Adrian Klaver 13:23
Re: Check if there 6 last records of same type without gaps Alexander Farber 13:32
Re: Check if there 6 last records of same type without gaps Sándor Daku 13:35
Re: Check if there 6 last records of same type without gaps Alexander Farber 13:38
Re: 2.5TB Migration from SATA to SSD disks - PostgreSQL 9.2 Vick Khera 15:51
Re: Clustered index to preserve data locality in a multitenant application? Nicolas Grilly 16:21
Re: pgadmin4 rc1 query tool performance Attila Soki 16:40
pgAdmin 4 records limit of 2000 dudedoe01 17:05
Re: PostgreSQL Database performance Naveed Shaikh 17:51
Re: PostgreSQL Database performance Ilya Kazakevich 17:52
Re: Privileges on public schema can't be revoked? Stephen Frost 17:52
Re: Privileges on public schema can't be revoked? Tom Lane 18:07
Re: PostgreSQL Database performance Naveed Shaikh 18:08
Re: Help with slow query - Pgsql 9.2 Jeff Janes 18:51
Re: [GENERAL] C++ port of Postgres Christian Convey 18:56
Re: [GENERAL] C++ port of Postgres Heikki Linnakangas 18:58
Re: PostgreSQL Database performance Scott Marlowe 19:08
Re: [GENERAL] C++ port of Postgres Tom Lane 19:12
Re: [GENERAL] C++ port of Postgres Christian Convey 19:15
Re: PostgreSQL Database performance Steve Atkins 19:18
Re: pgAdmin 4 records limit of 2000 Adrian Klaver 19:26
Re: PostgreSQL Database performance Jeff Janes 19:31
Re: PostgreSQL Database performance Scott Marlowe 19:57
Re: pgAdmin 4 records limit of 2000 dudedoe01 19:58
Thanks to the Pg community (Louisiana Flood) Joshua D. Drake 20:07
Re: pgAdmin 4 records limit of 2000 Melvin Davidson 20:09
Re: Privileges on public schema can't be revoked? Greg Fodor 20:16
Re: Privileges on public schema can't be revoked? Stephen Frost 20:23
Re: Privileges on public schema can't be revoked? Tom Lane 20:32
Setup pgpool-II with streaming replication Ashish Chauhan 21:10
Postgres UPGRADE from 9.2 to 9.4 Patrick B 22:22
Re: Postgres UPGRADE from 9.2 to 9.4 Rich Shepard 22:27

Browse Archives

Prev | Next