pgsql-general since 2016-11-10 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)

Browse Archives

Prev | Next

Nov. 10, 2016

Thread Author Time
Re: which work memory parameter is used for what? Melvin Davidson 01:35
Re: Postgresql error (and service disruption) on Windows Michael Paquier 02:24
Syncing Data of data type BLOB into Postgres- Bytea Cynthia Hombakazi Ngejane 06:55
How the Planner in PGStrom differs from PostgreSQL? Mark Anns 07:11
Syncing Data of data type BLOB into Postgres- Bytea Cynthia Hombakazi Ngejane 07:35
Re: Linux equivalent library for "postgres.lib" from Windows David Guyot 08:14
Re: initdb createuser commands Samuel Williams 09:59
Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) Juliano 10:34
Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) Raymond O'Donnell 10:44
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists otar shavadze 12:41
Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) JingYuan Chen 12:49
Postgresql 94 from PostgreSQL RPM Repository (with Yum) Steve Clark 12:56
Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) Tim Clarke 13:20
Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) rob stone 13:31
Re: Syncing Data of data type BLOB into Postgres- Bytea Adrian Klaver 14:31
Re: Postgresql 94 from PostgreSQL RPM Repository (with Yum) Devrim Gündüz 14:36
Re: Postgresql 94 from PostgreSQL RPM Repository (with Yum) Adrian Klaver 14:40
Re: Row level security performance joining large tables Stephen Frost 14:50
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Tom Lane 15:11
Re: How to hint 2 coulms IS NOT DISTINCT FROM each other Kim Rose Carlsen 18:40
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Jeff Janes 20:20
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Tom Lane 20:58

Nov. 11, 2016

Thread Author Time
PLPGSQL returning number of rows Patrick B 00:44
Re: PLPGSQL returning number of rows David G. Johnston 00:57
row => text => row Marc Mamin 08:55
Re: row => text => row Tom Lane 15:01
Re: row => text => row Adrian Klaver 15:14
Change column type from int to bigint - quickest way Andreas Brandl 15:30
Change column type from int to bigint - quickest way Andreas Brandl 15:34
Re: Change column type from int to bigint - quickest way Tom Lane 16:12

Nov. 12, 2016

Thread Author Time
Re: Change column type from int to bigint - quickest way Merlin Moncure 01:17
pg_dumpall: could not connect to database "template1": FATAL: aws backup 21:20
Re: pg_dumpall: could not connect to database "template1": FATAL: Adrian Klaver 21:31
Re: pg_dumpall: could not connect to database "template1": FATAL: Scott Marlowe 22:37

Nov. 13, 2016

Thread Author Time
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists otar shavadze 01:33
Why is this query not using GIN index? Aaron Lewis 11:50
Trigram is slow when 10m rows Aaron Lewis 11:54
Re: pg_dumpall: could not connect to database "template1": FATAL: aws backup 13:51
Re: pg_dumpall: could not connect to database "template1": FATAL: aws backup 13:51
Re: Trigram is slow when 10m rows Oleg Bartunov 14:04
Re: Why is this query not using GIN index? Oleg Bartunov 14:10
Re: Trigram is slow when 10m rows Aaron Lewis 14:25
Re: Why is this query not using GIN index? Aaron Lewis 14:26
Re: Why is this query not using GIN index? Julien Rouhaud 14:33
Re: Why is this query not using GIN index? Aaron Lewis 15:05
Re: pg_dumpall: could not connect to database "template1": FATAL: Adrian Klaver 15:57
Re: pg_dumpall: could not connect to database "template1": FATAL: Adrian Klaver 16:09
Re: pg_dumpall: could not connect to database "template1": FATAL: aws backup 16:51
Re: pg_dumpall: could not connect to database "template1": FATAL: aws backup 17:04
Re: pg_dumpall: could not connect to database "template1": FATAL: John R Pierce 17:04
Re: pg_dumpall: could not connect to database "template1": FATAL: Adrian Klaver 17:08
Re: pg_dumpall: could not connect to database "template1": FATAL: Adrian Klaver 17:13
Re: pg_dumpall: could not connect to database "template1": FATAL: John R Pierce 17:27
Re: Why is this query not using GIN index? Oleg Bartunov 18:40
Re: Why is this query not using GIN index? Tom Lane 18:51
Re: Trigram is slow when 10m rows Oleg Bartunov 19:02
Re: pg_dumpall: could not connect to database "template1": FATAL: aws backup 21:01
Re: pg_dumpall: could not connect to database "template1": FATAL: Adrian Klaver 21:12
Re: Exclude pg_largeobject form pg_dump 📎 Guillaume Lelarge 21:23
Re: pg_dumpall: could not connect to database "template1": FATAL: John R Pierce 21:27
Re: pg_dumpall: could not connect to database "template1": FATAL: aws backup 21:29
Re: Trigram is slow when 10m rows Jeff Janes 21:30
Re: pg_dumpall: could not connect to database "template1": FATAL: aws backup 21:33
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Jeff Janes 22:57
Sequential parallel scan / agg James Sewell 23:04
Re: Sequential parallel scan / agg melvin6925 23:43

Nov. 14, 2016

Thread Author Time
Re: Sequential parallel scan / agg James Sewell 00:13
Re: Sequential parallel scan / agg James Sewell 00:58
Wal files being delayed - Pgsql 9.2 Patrick B 02:22
Re: Wal files being delayed - Pgsql 9.2 Venkata B Nagothi 02:33
Re: Why is this query not using GIN index? Aaron Lewis 03:50
Request to share information regarding deadlock in postgresql-8.1.18 Yogesh Sharma 07:01
Re: Request to share information regarding deadlock in postgresql-8.1.18 John R Pierce 07:19
Re: Request to share information regarding deadlock in postgresql-8.1.18 Yogesh Sharma 07:52
Re: Request to share information regarding deadlock in postgresql-8.1.18 John R Pierce 08:50
Re: Sequential parallel scan / agg Tobias Bussmann 10:36
Converting a TimestampTz into a C# DateTime valeriof 11:52
Re: Converting a TimestampTz into a C# DateTime Albe Laurenz 12:12
Re: Syncing Data of data type BLOB into Postgres- Bytea Adrian Klaver 14:58
Re: Syncing Data of data type BLOB into Postgres- Bytea Adrian Klaver 15:14
Re: Converting a TimestampTz into a C# DateTime Jerome Wagner 15:16
Re: Converting a TimestampTz into a C# DateTime Tom Lane 15:36
Re: Converting a TimestampTz into a C# DateTime Albe Laurenz 15:38
Re: Converting a TimestampTz into a C# DateTime Arjen Nienhuis 17:56
C code with embedded SQL Poul Kristensen 18:21
Re: C code with embedded SQL Joshua D. Drake 18:24
Re: C code with embedded SQL John R Pierce 18:32
Re: C code with embedded SQL John R Pierce 18:40
Re: How the Planner in PGStrom differs from PostgreSQL? Kouhei Kaigai 19:53

Nov. 15, 2016

Thread Author Time
Fwd: Mail to be posted in PostgreSQL community kaustubh kelkar 05:15
Re: Fwd: Creating multiple instances of postresql on Windows environment kaustubh kelkar 05:19
Re: How the Planner in PGStrom differs from PostgreSQL? Mark Anns 05:25
Re: How the Planner in PGStrom differs from PostgreSQL? John R Pierce 05:33
Re: How the Planner in PGStrom differs from PostgreSQL? Mark Anns 05:43
Question about RUM's TODO-list Andreas Joseph Krogh 07:17
Incorrect information about GIN-index in RUM's docs Andreas Joseph Krogh 07:37
Re: Incorrect information about GIN-index in RUM's docs Oleg Bartunov 07:48
Re: How the Planner in PGStrom differs from PostgreSQL? John R Pierce 08:02
Re: Incorrect information about GIN-index in RUM's docs Andreas Joseph Krogh 08:12
Re: Incorrect information about GIN-index in RUM's docs Artur Zakirov 08:26
Re: Fwd: Creating multiple instances of postresql on Windows environment Karsten Hilbert 08:31
Re: How the Planner in PGStrom differs from PostgreSQL? Albe Laurenz 08:35
Re: How the Planner in PGStrom differs from PostgreSQL? Mark Anns 08:35
Re: Fwd: Creating multiple instances of postresql on Windows environment John R Pierce 08:36
Re: How the Planner in PGStrom differs from PostgreSQL? Mark Anns 08:42
Re: Fwd: Mail to be posted in PostgreSQL community Venkata B Nagothi 08:56
Re: Converting a TimestampTz into a C# DateTime valeriof 11:00
Re: Fwd: Mail to be posted in PostgreSQL community kaustubh kelkar 11:23
Re: Fwd: Creating multiple instances of postresql on Windows environment Karsten Hilbert 11:23
Re: Converting a TimestampTz into a C# DateTime Albe Laurenz 13:19
Re: Fwd: Mail to be posted in PostgreSQL community Adrian Klaver 15:02
pg_restore --clean failing due to dependancies Arnaud L. 15:11
Re: Fwd: Mail to be posted in PostgreSQL community Adrian Klaver 15:13
Re: pg_restore --clean failing due to dependancies Adrian Klaver 15:21
Re: Best practices to manage custom statistics Moreno Andreo 15:39
Re: pg_restore --clean failing due to dependancies Tom Lane 15:44
Re: pg_restore --clean failing due to dependancies Arnaud L. 15:55
Re: pg_restore --clean failing due to dependancies Arnaud L. 16:09
Re: pg_restore --clean failing due to dependancies Tom Lane 16:26
Re: pg_restore --clean failing due to dependancies Adrian Klaver 16:42
Re: pg_restore --clean failing due to dependancies Adrian Klaver 16:50
Re: Converting a TimestampTz into a C# DateTime valeriof 17:06
Re: Best practices to manage custom statistics Adrian Klaver 17:19
Upgrade from 9.5.4 to 9.6.1 Rich Shepard 22:37
dumping table contents in a sensible order Chris Withers 22:56
Re: dumping table contents in a sensible order Jerry Sievers 23:17
Re: dumping table contents in a sensible order [email protected] 23:31

Nov. 16, 2016

Thread Author Time
Re: Upgrade from 9.5.4 to 9.6.1 John R Pierce 00:25
Re: Upgrade from 9.5.4 to 9.6.1 Adrian Klaver 00:55
Re: Upgrade from 9.5.4 to 9.6.1 Rich Shepard 01:00
Re: Upgrade from 9.5.4 to 9.6.1 John R Pierce 01:01
Re: dumping table contents in a sensible order Adrian Klaver 01:05
Re: Upgrade from 9.5.4 to 9.6.1 Rich Shepard 01:06
Re: Upgrade from 9.5.4 to 9.6.1 Adrian Klaver 01:10
Re: Upgrade from 9.5.4 to 9.6.1 Rich Shepard 01:18
Re: Upgrade from 9.5.4 to 9.6.1 Adrian Klaver 01:21
Re: Upgrade from 9.5.4 to 9.6.1 Adrian Klaver 01:23
Re: Upgrade from 9.5.4 to 9.6.1 Adrian Klaver 01:43
Re: Syncing Data of data type BLOB into Postgres- Bytea John DeSoi 01:55
Re: Upgrade from 9.5.4 to 9.6.1 Rich Shepard 02:00
Re: Syncing Data of data type BLOB into Postgres- Bytea Adrian Klaver 05:15
Re: Request to share information regarding errors Yogesh Sharma 06:09
Re: Request to share information regarding errors Charles Clavadetscher 06:44
Re: Request to share information regarding errors Yogesh Sharma 06:59
Re: dumping table contents in a sensible order Chris Withers 07:28
Re: Request to share information regarding errors Charles Clavadetscher 07:45
Full text search tsv column aproach vs concat confusion cen 08:54
Re: Change column type from int to bigint - quickest way Merlin Moncure 14:49
Re: Upgrade from 9.5.4 to 9.6.1 Rich Shepard 15:33
Re: Upgrade from 9.5.4 to 9.6.1 Alban Hertroys 15:52
Re: Upgrade from 9.5.4 to 9.6.1 Rich Shepard 16:06
Re: Change column type from int to bigint - quickest way David G. Johnston 16:08
Re: Upgrade from 9.5.4 to 9.6.1 Rich Shepard 16:17
Re: pg_restore --clean failing due to dependancies Tom Lane 19:05
Re: Change column type from int to bigint - quickest way Andreas Brandl 19:25
Re: Wal files being delayed - Pgsql 9.2 Patrick B 21:35
Check integrity between servers Patrick B 23:19

Nov. 17, 2016

Thread Author Time
Streaming replication failover/failback Israel Brewster 00:51
Re: Check integrity between servers Patrick B 00:53
Re: Streaming replication failover/failback Adrian Klaver 01:24
Request to share information regarding deadlock in postgresql-9.3.6 Yogesh Sharma 02:22
pg_class (system) table increasing size. dhaval jaiswal 02:30
Re: pg_class (system) table increasing size. David G. Johnston 02:43
Re: Request to share information regarding deadlock in postgresql-9.3.6 John R Pierce 03:04
Re: pg_class (system) table increasing size. dhaval jaiswal 03:08
Re: Check integrity between servers Venkata B Nagothi 06:07
Re: Exclude pg_largeobject form pg_dump Amul Sul 06:15
Re: Request to share information regarding deadlock in postgresql-9.3.6 Yogesh Sharma 07:30
Re: pg_restore --clean failing due to dependancies Arnaud L. 08:06
Re: Request to share information regarding deadlock in postgresql-9.3.6 Charles Clavadetscher 08:11
Re: Request to share information regarding deadlock in postgresql-9.3.6 Charles Clavadetscher 08:17
Re: Streaming replication failover/failback Jehan-Guillaume de Rorthais 08:39
Re: How the Planner in PGStrom differs from PostgreSQL? Mark Anns 09:56
Re: How the Planner in PGStrom differs from PostgreSQL? Mark Anns 10:09
Re: libpq backwards compatbility Andy Halsall 10:58
Re: pg_class (system) table increasing size. Adrian Klaver 14:45
Re: pg_class (system) table increasing size. Adrian Klaver 14:59
Re: How the Planner in PGStrom differs from PostgreSQL? Amit Langote 15:28
help with moving tablespace kbrannen 16:16
Re: help with moving tablespace David G. Johnston 17:26
Re: Streaming replication failover/failback Israel Brewster 17:26
Re: Streaming replication failover/failback Israel Brewster 17:32
Re: help with moving tablespace kbrannen 18:19
Re: pg_class (system) table increasing size. dhaval jaiswal 18:33
Re: help with moving tablespace rob stone 18:47
Re: pg_class (system) table increasing size. Melvin Davidson 20:27
Re: pg_class (system) table increasing size. Alvaro Herrera 21:16
Re: pg_class (system) table increasing size. Kevin Grittner 22:19

Nov. 18, 2016

Thread Author Time
pgbench and scaling Rakesh Kumar 01:08
Re: pgbench and scaling Rakesh Kumar 01:10
Partial update on an postgres upsert violates constraint Andreas Terrius 06:13
Re: How the Planner in PGStrom differs from PostgreSQL? Mark Anns 06:29
Re: Full text search tsv column aproach vs concat confusion Artur Zakirov 09:07
Feature request: separate logging otheus uibk 13:00
Re: How the Planner in PGStrom differs from PostgreSQL? Kouhei Kaigai 13:35
Re: How the Planner in PGStrom differs from PostgreSQL? Kouhei Kaigai 14:06
Trim performance on 9.5 📎 William Ivanski 14:06
Re: Trim performance on 9.5 vinny 14:16
Re: Streaming replication failover/failback Jehan-Guillaume de Rorthais 14:48
Re: pgbench and scaling Vick Khera 15:14

Browse Archives

Prev | Next