pgsql-general since 2022-01-29 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. 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
Re: Postgres Version Upgrade to 14.1 error Adrian Klaver 20:23

Feb. 5, 2022

Thread Author Time
Re. Backup of postgresql database [email protected] 03:14
Re: Re. Backup of postgresql database Ron 03:49
Re: Re. Backup of postgresql database Benedict Holland 05:01
Re: Re. Backup of postgresql database [email protected] 08:37
Re: Re. Backup of postgresql database [email protected] 08:38
Re: Re. Backup of postgresql database Ron 15:14

Feb. 6, 2022

Thread Author Time
Re: Undetected Deadlock 📎 Tom Lane 22:57

Feb. 8, 2022

Thread Author Time
Locks on FK Tables From Partitioning Aaron Sipser 16:51
Question on tablefunc extension Lu, Dan 17:30
Re: Question on tablefunc extension Adrian Klaver 20:26
Re: Locks on FK Tables From Partitioning Tom Lane 23:13

Feb. 9, 2022

Thread Author Time
Why are data files getting modified? Abhishek Bhola 08:29
Compile 14.1 in EL5.8 Gabriela Serventi 13:19
Re: Locks on FK Tables From Partitioning Simon Riggs 13:54
Re: Compile 14.1 in EL5.8 Tom Lane 14:38
Re: Why are data files getting modified? Laurenz Albe 15:14
Re: Why are data files getting modified? Abhishek Bhola 15:29
Re: Why are data files getting modified? Laurenz Albe 16:09
Network Card Not Listening at Startup Ludwig Isaac Lim 16:32
Re: Network Card Not Listening at Startup Tom Lane 17:49
DELETING then INSERTING record with same PK in the same TRANSACTION Andrew Hardy 18:11
Re: DELETING then INSERTING record with same PK in the same TRANSACTION Brent Wood 18:34
Re: DELETING then INSERTING record with same PK in the same TRANSACTION Adrian Klaver 18:37
Re: DELETING then INSERTING record with same PK in the same TRANSACTION David G. Johnston 19:26