pgsql-performance - April 2021

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

April 1, 2021

Thread Author Time
Re: High availability management tool. Dorian Hoxha 07:59
Re: High availability management tool. Hüseyin Demir 09:08
Re: High availability management tool. Adalberto Caccia 09:23

April 3, 2021

Thread Author Time
SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 13:38
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bharath Rupireddy 13:47
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule 14:08
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Michael Lewis 14:10
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Justin Pryzby 14:16
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 14:59
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:04
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 15:08
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:12
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 15:22
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:24
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 15:30
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 15:33
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule 15:35
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:38
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Tom Lane 15:39
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Justin Pryzby 15:41
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:42
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Bruce Momjian 15:43
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 15:44
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 17:36
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule 17:41
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 17:45
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. Pavel Stehule 17:50

April 4, 2021

Thread Author Time
[PATCH] force_parallel_mode and GUC categories 📎 Justin Pryzby 01:25
Re: proposal: schema variables 📎 Pavel Stehule 08:30
SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS aditya desai 10:42
Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration. aditya desai 11:10
Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Amine Tengilimoglu 17:01
Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Justin Pryzby 17:19

April 5, 2021

Thread Author Time
PosgtgreSQL hot standby reading WAL from muli-attached volume? Gunther Schadow 22:22

April 6, 2021

Thread Author Time
Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS aditya desai 05:09
Substitute for synonym in Oracle after migration to postgres aditya desai 07:52
Re: Substitute for synonym in Oracle after migration to postgres Laurenz Albe 08:19
Re: Substitute for synonym in Oracle after migration to postgres hubert depesz lubaczewski 10:41
select count(*) is slow aditya desai 13:14
Re: Substitute for synonym in Oracle after migration to postgres aditya desai 13:19
Re: select count(*) is slow Tom Lane 13:25
Re: select count(*) is slow aditya desai 13:30
Re: select count(*) is slow Andrew Dunstan 15:44
Re: SHARED LOCKS , EXCLUSIVE LOCKS, ACCESS EXCLUSIVE LOCKS Andrew Dunstan 15:49

April 7, 2021

Thread Author Time
Re: select count(*) is slow aditya desai 08:09

April 8, 2021

Thread Author Time
procedure using CURSOR to insert is extremely slow Szalontai Zoltán 11:24
str_aggr function not wokring aditya desai 11:31
Re: procedure using CURSOR to insert is extremely slow Hervé Schweitzer (HER) 11:40
RE: str_aggr function not wokring Patrick FICHE 11:41
RE: procedure using CURSOR to insert is extremely slow Szalontai Zoltán 11:58