pgsql-general since 2022-01-24 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

Jan. 24, 2022

Thread Author Time
Broken logical replication 📎 Игорь Выскорко 07:48
Re: Cannot find hstore operator Paul van der Linden 09:17
Re: Cannot find hstore operator Dominique Devienne 09:55
Re: Cannot find hstore operator Ganesh Korde 10:19
Re: Cannot find hstore operator Dominique Devienne 10:40
Proposed German Translation of Code of Conduct Policy 📎 Umair Shahid 12:32
Re: Cannot find hstore operator David G. Johnston 14:48
tstzrange on large table gives poor estimate of expected rows Tom Dearman 14:55
Re: Cannot find hstore operator Dominique Devienne 16:27
Re: Cannot find hstore operator Adrian Klaver 16:39
Re: tstzrange on large table gives poor estimate of expected rows Michael Lewis 17:43
Re: Cannot find hstore operator David G. Johnston 17:59
Big variance in execution times of simple queries Hannes Erven 22:07
Re: Big variance in execution times of simple queries Tom Lane 22:57
Re: Proposed German Translation of Code of Conduct Policy Karsten Hilbert 23:48

Jan. 25, 2022

Thread Author Time
GIN index [email protected] 02:42
Undetected Deadlock Michael Harris 04:49
Re: Undetected Deadlock Michael Harris 05:02
Re: Undetected Deadlock Rob Sargent 05:06
Robust ways for checking allowed values in a column Shaozhong SHI 13:55
Re: Robust ways for checking allowed values in a column Guillaume Lelarge 14:16
Re: Robust ways for checking allowed values in a column David G. Johnston 14:25
Re: Robust ways for checking allowed values in a column Ray O'Donnell 14:26
Re: GIN index Julien Rouhaud 15:33
Re: tstzrange on large table gives poor estimate of expected rows Tom Dearman 16:09
Re: Robust ways for checking allowed values in a column Shaozhong SHI 16:35
Re: Robust ways for checking allowed values in a column Rob Sargent 16:40
Counting the number of repeated phrases in a column Shaozhong SHI 17:10
Aw: Counting the number of repeated phrases in a column Karsten Hilbert 17:22
Re: Counting the number of repeated phrases in a column Shaozhong SHI 17:30
Aw: Re: Counting the number of repeated phrases in a column Karsten Hilbert 17:40
Re: Counting the number of repeated phrases in a column David G. Johnston 17:57
Re: Counting the number of repeated phrases in a column Laura Smith 18:37
NIST 800-53v4 scanning? Ben Chobot 18:53
Re: Counting the number of repeated phrases in a column benj.dev 21:21
Re: Counting the number of repeated phrases in a column Ivan Panchenko 21:33
Re: Undetected Deadlock Alvaro Herrera 23:11

Jan. 26, 2022

Thread Author Time
Re: Counting the number of repeated phrases in a column Jian He 06:05
Re: Counting the number of repeated phrases in a column Shaozhong SHI 08:11
Re: Counting the number of repeated phrases in a column benj.dev 09:52
Re: Counting the number of repeated phrases in a column Ivan E. Panchenko 10:38
SELECT with LIKE clause makes full table scan Matthias Apitz 10:55
Re: SELECT with LIKE clause makes full table scan Josef Šimánek 11:20
Re: SELECT with LIKE clause makes full table scan Matthias Apitz 11:39
Re: SELECT with LIKE clause makes full table scan Dominique Devienne 11:39
Re: SELECT with LIKE clause makes full table scan Julien Rouhaud 12:13
Re: SELECT with LIKE clause makes full table scan Dominique Devienne 13:34
Re: SELECT with LIKE clause makes full table scan Julien Rouhaud 13:51
Re: SELECT with LIKE clause makes full table scan Imre Samu 14:20
Re: SELECT with LIKE clause makes full table scan Tom Lane 15:03
Re: SELECT with LIKE clause makes full table scan Matthias Apitz 15:07
Re: SELECT with LIKE clause makes full table scan Julien Rouhaud 15:21
Re: SELECT with LIKE clause makes full table scan Matthias Apitz 15:28
Could not serialize access due to concurrent update Mladen Gogala 16:31
Re: Counting the number of repeated phrases in a column Shaozhong SHI 20:35
Counting the number of repeated phrases in a column David G. Johnston 20:55
Re: Counting the number of repeated phrases in a column Rob Sargent 21:40
Re: Counting the number of repeated phrases in a column Karsten Hilbert 22:09
Re: Counting the number of repeated phrases in a column Merlin Moncure 23:23

Jan. 27, 2022

Thread Author Time
Re: Undetected Deadlock Michael Harris 00:20
Re: Undetected Deadlock Michael Lewis 01:14
PostgreSQL Management and monitoring tool Lucas 01:28
could not open relation with OID Ben Chobot 01:30
Re: Packages and inner subprograms for PL/pgSQL Bryn Llewellyn 01:54
Re: PostgreSQL Management and monitoring tool Bruce Momjian 02:00
Re: Undetected Deadlock Michael Harris 02:54
Re: Undetected Deadlock Michael Lewis 03:20
Re: PostgreSQL Management and monitoring tool Lucas 03:24
Re: PostgreSQL Management and monitoring tool Rob Sargent 04:01
Re: PostgreSQL Management and monitoring tool Lucas 04:08
Re: PostgreSQL Management and monitoring tool Mladen Gogala 04:27
Re: could not open relation with OID Michael Paquier 05:14
Re: Broken logical replication Игорь Выскорко 05:47
Re: Counting the number of repeated phrases in a column Merlin Moncure 17:03
Re: Counting the number of repeated phrases in a column Rob Sargent 17:09
Re: Counting the number of repeated phrases in a column Merlin Moncure 17:35
Re: Counting the number of repeated phrases in a column benj.dev 17:56
Re: could not open relation with OID Ben Chobot 20:21
Re: Counting the number of repeated phrases in a column Merlin Moncure 23:10

Jan. 28, 2022

Thread Author Time
Re: Undetected Deadlock Michael Harris 05:27
Re: PostgreSQL Management and monitoring tool Umair Shahid 11:21
Will Barman support restore of single database? Andreas Joseph Krogh 15:05
pg_try_advisory_lock is waiting? Mladen Gogala 23:05
Re: pg_try_advisory_lock is waiting? Michael Lewis 23:14

Jan. 29, 2022

Thread Author Time
Re: pg_try_advisory_lock is waiting? Tom Lane 00:08
Re: pg_try_advisory_lock is waiting? Mladen Gogala 00:33
Re: pg_try_advisory_lock is waiting? Michael Lewis 01:54
Regarding PGperffarm_server Setup Sourav Prasad Das 17:34
what is the solution like oracle DB's datafile Yudianto Prasetyo 22:15
Re: pg_try_advisory_lock is waiting? Mladen Gogala 22:16

Jan. 30, 2022

Thread Author Time
Re: what is the solution like oracle DB's datafile Julien Rouhaud 13:11
Re: what is the solution like oracle DB's datafile Julien Rouhaud 13:23
Re: what is the solution like oracle DB's datafile Julien Rouhaud 13:43
Re: what is the solution like oracle DB's datafile Yudianto Prasetyo 13:51
Re: what is the solution like oracle DB's datafile Julien Rouhaud 14:17
Re: what is the solution like oracle DB's datafile Yudianto Prasetyo 14:24
Re: what is the solution like oracle DB's datafile Mladen Gogala 17:03
Re: what is the solution like oracle DB's datafile Josef Šimánek 17:19
Re: what is the solution like oracle DB's datafile Yudianto Prasetyo 22:13

Jan. 31, 2022

Thread Author Time
Re: what is the solution like oracle DB's datafile Laurenz Albe 05:10
Can one call pg_total_relation_size over foreign data wrapper? Ketan Popat 08:07
Re: pg_try_advisory_lock is waiting? Merlin Moncure 20:36
Re: what is the solution like oracle DB's datafile Yudianto Prasetyo 22:17

Feb. 1, 2022

Thread Author Time
Re: Undetected Deadlock Michael Harris 06:50
Extension has owner 12:08
Re: Extension has owner Tom Lane 15:03
Re: Counting the number of repeated phrases in a column Shaozhong SHI 18:49
Re: Counting the number of repeated phrases in a column Shaozhong SHI 23:29

Feb. 2, 2022

Thread Author Time
Subscription stuck at initialize state Abhishek Bhola 02:26
Re: Subscription stuck at initialize state Steve Baldwin 02:31
Two academic questions Дмитрий Иванов 03:15
Re: Two academic questions David G. Johnston 04:18
Re: Subscription stuck at initialize state Abhishek Bhola 04:20
Re: Two academic questions Дмитрий Иванов 05:02
Re: Two academic questions David G. Johnston 05:19
Re: Two academic questions Дмитрий Иванов 06:12
Re: Two academic questions David G. Johnston 06:36
Re: Two academic questions Дмитрий Иванов 07:12
Re: Counting the number of repeated phrases in a column Karsten Hilbert 07:56
Regular Expression For Duplicate Words Shaozhong SHI 08:00
Re: Regular Expression For Duplicate Words David G. Johnston 15:22
pg_basebackup with hostssl ? Laura Smith 15:48
Re: pg_basebackup with hostssl ? Adrian Klaver 16:30
Re: pg_basebackup with hostssl ? Laura Smith 16:37
Re: pg_basebackup with hostssl ? Laura Smith 16:40
Re: pg_basebackup with hostssl ? Adrian Klaver 16:50
Re: pg_basebackup with hostssl ? David G. Johnston 16:51
Re: pg_basebackup with hostssl ? Laura Smith 17:18
Re: pg_basebackup with hostssl ? Adrian Klaver 17:20
Re: Regular Expression For Duplicate Words Jian He 18:21
Re: pg_basebackup with hostssl ? Laura Smith 18:35
increasing effective_cache_size slows down join queries by a factor of 4000x Artyom Shaposhnikov 19:05
Re: increasing effective_cache_size slows down join queries by a factor of 4000x Michael Lewis 19:46
Can Postgres beat Oracle for regexp_count? Shaozhong SHI 20:20
Re: Can Postgres beat Oracle for regexp_count? David G. Johnston 20:43
Re: increasing effective_cache_size slows down join queries by a factor of 4000x Artyom Shaposhnikov 21:10
Re: increasing effective_cache_size slows down join queries by a factor of 4000x Imre Samu 21:18
Re: Can Postgres beat Oracle for regexp_count? Tom Lane 22:26
Re: increasing effective_cache_size slows down join queries by a factor of 4000x Tomas Vondra 23:34

Feb. 3, 2022

Thread Author Time
Re: Subscription stuck at initialize state Abhishek Bhola 00:53
Re: Subscription stuck at initialize state Abhishek Bhola 05:02
Re: Can Postgres beat Oracle for regexp_count? Shaozhong SHI 05:26
Re: Can Postgres beat Oracle for regexp_count? David G. Johnston 05:50
Re: Can Postgres beat Oracle for regexp_count? Tom Lane 05:59
Re: Undetected Deadlock Michael Harris 06:25
Re: Subscription stuck at initialize state Vijaykumar Jain 06:33
Re: Subscription stuck at initialize state Abhishek Bhola 07:14
Re: Subscription stuck at initialize state Vijaykumar Jain 08:25
Re: Undetected Deadlock Simon Riggs 09:04
Re: Can Postgres beat Oracle for regexp_count? Shaozhong SHI 09:17
max_connections different between primary and standby: is it possible? Luca Ferrari 09:36
Re: max_connections different between primary and standby: is it possible? Vijaykumar Jain 09:41
Re: Subscription stuck at initialize state Abhishek Bhola 09:43
Re: max_connections different between primary and standby: is it possible? Julien Rouhaud 09:47
sort order for UTF-8 char column with Japanese UTF-8 Matthias Apitz 10:14
Re: sort order for UTF-8 char column with Japanese UTF-8 Matthias Apitz 10:51
Increase fetch fize of oracl_fdw(ALTER SERVER) aditya desai 11:40
Re: max_connections different between primary and standby: is it possible? Bharath Rupireddy 12:09
Re: Can Postgres beat Oracle for regexp_count? David G. Johnston 13:00
Re: max_connections different between primary and standby: is it possible? Julien Rouhaud 14:19
Oracle to postgresql migration 📎 Rama Krishnan 14:54
Re: max_connections different between primary and standby: is it possible? Tom Lane 14:55
Re: sort order for UTF-8 char column with Japanese UTF-8 Tom Lane 15:00
Re: Oracle to postgresql migration Laurenz Albe 15:10
Using the indexing and sampling APIs to realize progressive features hohenstein 15:24
Re: Can Postgres beat Oracle for regexp_count? Shaozhong SHI 15:32
Re: Undetected Deadlock Tom Lane 16:36
Re: Subscription stuck at initialize state Vijaykumar Jain 18:04
Re: sort order for UTF-8 char column with Japanese UTF-8 Matthias Apitz 19:11
Re: Using the indexing and sampling APIs to realize progressive features Vijaykumar Jain 19:27
Re: increasing effective_cache_size slows down join queries by a factor of 4000x A Shaposhnikov 19:32
Re: Regular Expression For Duplicate Words Peter J. Holzer 19:48
Re: increasing effective_cache_size slows down join queries by a factor of 4000x Vijaykumar Jain 20:30
Re: increasing effective_cache_size slows down join queries by a factor of 4000x A Shaposhnikov 21:08
Re: Regular Expression For Duplicate Words Shaozhong SHI 21:09
pg_cron for vacuum - dynamic table set saket bansal 21:29
Re: pg_cron for vacuum - dynamic table set Adrian Klaver 21:40
Re: pg_cron for vacuum - dynamic table set David G. Johnston 21:48
Re: sort order for UTF-8 char column with Japanese UTF-8 Thomas Munro 21:50
Re: pg_cron for vacuum - dynamic table set Michael Lewis 21:53
Re: pg_cron for vacuum - dynamic table set Ron 21:55
Re: increasing effective_cache_size slows down join queries by a factor of 4000x Michael Lewis 22:30
Re: Subscription stuck at initialize state Abhishek Bhola 23:02

Feb. 4, 2022

Thread Author Time
Re: Undetected Deadlock Michael Harris 01:08
Re: Increase fetch fize of oracl_fdw(ALTER SERVER) aditya desai 03:50
Re: Increase fetch fize of oracl_fdw(ALTER SERVER) Steve Midgley 03:55
Re: Increase fetch fize of oracl_fdw(ALTER SERVER) David G. Johnston 03:56
Re: Increase fetch fize of oracl_fdw(ALTER SERVER) aditya desai 03:59
Fwd: Increase fetch fize of oracl_fdw(ALTER SERVER) aditya desai 04:02
Re: Increase fetch fize of oracl_fdw(ALTER SERVER) David G. Johnston 04:14
Re: Increase fetch fize of oracl_fdw(ALTER SERVER) aditya desai 04:18
Re: Increase fetch fize of oracl_fdw(ALTER SERVER) aditya desai 04:18
Re: increasing effective_cache_size slows down join queries by a factor of 4000x A Shaposhnikov 04:21
Re: Can Postgres beat Oracle for regexp_count? Merlin Moncure 04:32
Postgres Version Upgrade to 14.1 error rob stan 06:02
Re: Postgres Version Upgrade to 14.1 error Pavel Stehule 06:16
Re: sort order for UTF-8 char column with Japanese UTF-8 Matthias Apitz 08:29
Re: sort order for UTF-8 char column with Japanese UTF-8 Tom Lane 14:38
Re: increasing effective_cache_size slows down join queries by a factor of 4000x Tomas Vondra 17:01
Re: Postgres Version Upgrade to 14.1 error rob stan 20:17

Browse Archives

Prev | Next