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

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

Nov. 5, 2016

Thread Author Time
Re: What is the best thing to do with PUBLIC schema in Postgresql database [email protected] 00:45
Trouble with regexp_matches Edson Richter 17:01
Re: Trouble with regexp_matches Adrian Klaver 17:13
Re: Trouble with regexp_matches Tom Lane 17:21
RES: Trouble with regexp_matches Edson Richter 18:08
RES: Trouble with regexp_matches Edson Richter 18:56
Re: RES: Trouble with regexp_matches Adrian Klaver 19:43

Nov. 6, 2016

Thread Author Time
Parallel pg_dump/restore and LOs Andreas Joseph Krogh 11:34
timestamp without timezone to have timezone Benjamin Adams 14:11
Re: timestamp without timezone to have timezone Melvin Davidson 15:10
Re: timestamp without timezone to have timezone Adrian Klaver 16:07
Re: timestamp without timezone to have timezone Steve Crawford 18:16
Re: timestamp without timezone to have timezone Adrian Klaver 20:29
Re: Exclude pg_largeobject form pg_dump 📎 Guillaume Lelarge 20:33

Nov. 7, 2016

Thread Author Time
Dynamic execution returning large result sets Emrul 01:12
Re: Dynamic execution returning large result sets Adrian Klaver 01:18
Linux equivalent library for "postgres.lib" from Windows Gadamsetty, Kiran 05:28
Re: Exclude pg_largeobject form pg_dump amul sul 06:06
Re: High load average every 105 minutes Nhan Nguyen 06:45
Re: High load average every 105 minutes Chris Mair 09:54
Re: High load average every 105 minutes Chris Mair 10:02
Re: High load average every 105 minutes Chris Mair 10:03
Re: Dynamic execution returning large result sets Emrul 10:04
Changing foreign key referential actions in big databases Arthur Silva 10:09
checkpoint_timout with no WAL activity Tom DalPozzo 10:50
Re: What is the best thing to do with PUBLIC schema in Postgresql database Albe Laurenz 11:00
Re: checkpoint_timout with no WAL activity amul sul 12:14
Re: checkpoint_timout with no WAL activity Tom DalPozzo 12:21
Re: checkpoint_timout with no WAL activity Michael Paquier 12:22
Re: checkpoint_timout with no WAL activity Michael Paquier 12:26
Re: checkpoint_timout with no WAL activity Tom DalPozzo 12:32
Database Recovery from Corrupted Dump or Raw database table file. Howard News 12:44
Surviving connections after internet problem Durumdara 13:12
Re: Database Recovery from Corrupted Dump or Raw database table file. Albe Laurenz 13:12
Documentation archive links broken for 6.3 up to 7.1 Daniel Westermann 13:15
Re: Database Recovery from Corrupted Dump or Raw database table file. Howard News 13:23
Re: Database Recovery from Corrupted Dump or Raw database table file. Vick Khera 13:44
Re: Database Recovery from Corrupted Dump or Raw database table file. Howard News 14:14
Re: How to hint 2 coulms IS NOT DISTINCT FROM each other Merlin Moncure 14:22
Re: Changing foreign key referential actions in big databases Adrian Klaver 14:29
Re: Changing foreign key referential actions in big databases Tom Lane 14:33
Re: Surviving connections after internet problem Albe Laurenz 15:06
Re: Changing foreign key referential actions in big databases Arthur Silva 16:13
Re: Changing foreign key referential actions in big databases Arthur Silva 16:17
Re: Questions on Post Setup MASTER and STANDBY replication - Postgres9.1 Joanna Xu 19:29
Abscence of synonym Rakesh Kumar 19:39
Re: Abscence of synonym Andy Colson 20:01
Re: Exclude pg_largeobject form pg_dump 📎 Guillaume Lelarge 21:01

Nov. 8, 2016

Thread Author Time
Re: Exclude pg_largeobject form pg_dump Andreas Joseph Krogh 00:06
Re: checkpoint_timout with no WAL activity Michael Paquier 02:17
Re: High load average every 105 minutes Nhan Nguyen 02:41
Fwd: Creating multiple instances of postresql on Windows environment 📎 kaustubh kelkar 03:27
Re: Linux equivalent library for "postgres.lib" from Windows Michael Paquier 03:51
Re: Linux equivalent library for "postgres.lib" from Windows John R Pierce 04:29
Re: Linux equivalent library for "postgres.lib" from Windows John R Pierce 04:32
Re: Exclude pg_largeobject form pg_dump amul sul 05:01
Re: Linux equivalent library for "postgres.lib" from Windows Gadamsetty, Kiran 05:01
Re: Linux equivalent library for "postgres.lib" from Windows Michael Paquier 05:15
Re: Surviving connections after internet problem Durumdara 10:32
Re: Linux equivalent library for "postgres.lib" from Windows Albe Laurenz 10:37
Re: Surviving connections after internet problem Albe Laurenz 10:42
Re: Fwd: Creating multiple instances of postresql on Windows environment Adrian Klaver 14:44
PHP-Shop with PostgreSQL Michelle Konzack 14:46
Re: PHP-Shop with PostgreSQL John DeSoi 15:51
Re: Fwd: Creating multiple instances of postresql on Windows environment Howard News 17:32
Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists otar shavadze 17:43
Must I create an index for child table if master table have one? Edmundo Robles 18:08
Re: PHP-Shop with PostgreSQL Joshua D. Drake 18:24
Re: Must I create an index for child table if master table have one? David G. Johnston 18:33
Re: Must I create an index for child table if master table have one? Melvin Davidson 18:46
Re: Must I create an index for child table if master table have one? Melvin Davidson 18:51
which work memory parameter is used for what? Hector Yuen 18:53
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Oleg Bartunov 18:56
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Jeff Janes 19:40
Running on Docker, AWS with Data Stored on EBS Ryan Mahoney 19:48
resolution order for foreign key actions? Karl Czajkowski 20:08
Best practices to manage custom statistics Moreno Andreo 20:13
Re: Running on Docker, AWS with Data Stored on EBS David G. Johnston 20:19
Re: resolution order for foreign key actions? Adrian Klaver 20:20
Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists 📎 otar shavadze 20:27
Re: Best practices to manage custom statistics Adrian Klaver 20:28
Re: Running on Docker, AWS with Data Stored on EBS Ryan Mahoney 20:41
Re: Running on Docker, AWS with Data Stored on EBS David G. Johnston 20:48
Re: resolution order for foreign key actions? David G. Johnston 20:56
Re: PHP-Shop with PostgreSQL Raymond O'Donnell 21:16
which work memory parameter is used for what? Hector Yuen 22:34
Re: resolution order for foreign key actions? 📎 Karl Czajkowski 22:41
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Tom Lane 23:05

Nov. 9, 2016

Thread Author Time
Re: which work memory parameter is used for what? John R Pierce 02:02
Re: which work memory parameter is used for what? Andreas Joseph Krogh 02:45
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Jeff Janes 04:19
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Tom Lane 04:35
Re: ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints Michael Paquier 06:10
Re: ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints david.turon 07:20
FTS query, statistics and planner estimations… Pierre Ducroquet 09:22
Re: [GENERAL] FTS query, statistics and planner estimations… Francisco Olarte 09:40
Re: [GENERAL] Re: [GENERAL] FTS query, statistics and planner estimations… Pavel Stehule 09:51
Re: FTS query, statistics and planner estimations… Artur Zakirov 10:01
Re: FTS query, statistics and planner estimations… Pierre Ducroquet 10:11
Re: Re: [GENERAL] FTS query, statistics and planner estimations… Pierre Ducroquet 10:13
Re: FTS query, statistics and planner estimations… Pierre Ducroquet 10:19
Re: [GENERAL] FTS query, statistics and planner estimations… Pavel Stehule 10:41
Re: [GENERAL] FTS query, statistics and planner estimations… Francisco Olarte 10:44
Re: ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints Tom Lane 14:45
Re: which work memory parameter is used for what? Adrian Klaver 14:54
Re: which work memory parameter is used for what? Andreas Joseph Krogh 15:05
Re: which work memory parameter is used for what? David G. Johnston 16:07
Re: which work memory parameter is used for what? Melvin Davidson 16:11
Postgresql error (and service disruption) on Windows [email protected] 18:10
Postgresql errors on Windows with F-Secure AntiVirus Moreno Andreo 18:29
Re: Postgresql errors on Windows with F-Secure AntiVirus Scott Marlowe 18:56
Re: Postgresql errors on Windows with F-Secure AntiVirus Scott Marlowe 18:58
Role and grants Fran ... 19:05
Re: Role and grants Melvin Davidson 19:53
Re: Role and grants Adrian Klaver 20:02
Re: Role and grants Fran ... 22:46
Re: Role and grants John R Pierce 22:52
Re: Role and grants Adrian Klaver 23:37

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

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