pgsql-performance - July 2019

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)

Advanced Search

Browse Archives

Prev | Next

July 6, 2019

Thread	Author	Time
Custom opclass for column statistics?	Ancoron Luciferis	09:02
Re: Custom opclass for column statistics?	Tomas Vondra	13:38
Re: Custom opclass for column statistics?	Tom Lane	13:58
Re: Custom opclass for column statistics?	Ancoron Luciferis	15:35
Re: Custom opclass for column statistics?	Tomas Vondra	15:57
Re: Custom opclass for column statistics?	Ancoron Luciferis	23:17

July 7, 2019

Thread	Author	Time
Optimizing `WHERE x IN` query	Omar Roth	13:43
Re: Optimizing `WHERE x IN` query	Thomas Kellerer	14:33
Re: Bloom index cost model seems to be wrong	Thomas Munro	23:57

July 8, 2019

Thread	Author	Time
Re: UUID v1 optimizations...	Peter Geoghegan	00:26

July 9, 2019

Thread	Author	Time
Re: Optimizing `WHERE x IN` query	Omar Roth	14:44
Re: Optimizing `WHERE x IN` query	Nicolas Charles	15:21
Re: UUID v1 optimizations...	Ancoron Luciferis	22:08
Re: Custom opclass for column statistics?	Ancoron Luciferis	22:16

July 11, 2019

Thread	Author	Time
Re: Optimizing `WHERE x IN` query	Omar Roth	22:22
Re: Optimizing `WHERE x IN` query	Michael Lewis	22:24

July 16, 2019

Thread	Author	Time
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	12:50
Filtering on an enum field in a foreign table	Vladimir Ryabtsev	23:00

July 17, 2019

Thread	Author	Time
Re: Filtering on an enum field in a foreign table	Nikolay Samokhvalov	00:45
Re: Filtering on an enum field in a foreign table	Vladimir Ryabtsev	01:06
Re: Filtering on an enum field in a foreign table	Vladimir Ryabtsev	01:52
Searching in varchar column having 100M records	mayank rupareliya	11:03
Re: Searching in varchar column having 100M records	Sergei Kornilov	11:53
Re: Searching in varchar column having 100M records	Tomas Vondra	12:48
Re: Searching in varchar column having 100M records	Andreas Kretschmer	13:00
Re: Searching in varchar column having 100M records	David G. Johnston	13:57
Re: Perplexing, regular decline in performance	Hugh Ranalli	14:29
Re: Perplexing, regular decline in performance	Alvaro Herrera	17:55
Re: Perplexing, regular decline in performance	Andres Freund	18:52
Re: Searching in varchar column having 100M records	Gavin Flower	22:54

July 18, 2019

Thread	Author	Time
Re: Searching in varchar column having 100M records	mayank rupareliya	11:51
Re: Searching in varchar column having 100M records	Tomas Vondra	12:41
Re: Perplexing, regular decline in performance	Hugh Ranalli	20:01
Re: Searching in varchar column having 100M records	Gavin Flower	22:03
Re: Perplexing, regular decline in performance	Andres Freund	22:23

July 19, 2019

Thread	Author	Time
Re: Searching in varchar column having 100M records	mayank rupareliya	14:13
Re: Searching in varchar column having 100M records	Michael Lewis	17:33
Re: Searching in varchar column having 100M records	Tomas Vondra	18:39
Re: Searching in varchar column having 100M records	mgbii bax	20:51
Speeding up query pulling comments from pg_catalog	Ken Tanzer	23:03

July 20, 2019

Thread	Author	Time
Re: Speeding up query pulling comments from pg_catalog	Tom Lane	14:46
Re: Speeding up query pulling comments from pg_catalog	Ken Tanzer	19:08
Re: Speeding up query pulling comments from pg_catalog	Tom Lane	19:25

July 22, 2019

Thread	Author	Time
benchmarking effective_io_concurrency	Fabio Pardi	06:41
Re: benchmarking effective_io_concurrency	Rick Otten	12:06
Re: benchmarking effective_io_concurrency	Fabio Pardi	12:28
Re: Speeding up query pulling comments from pg_catalog	Ken Tanzer	17:53
Re: benchmarking effective_io_concurrency	Merlin Moncure	18:32
Re: Speeding up query pulling comments from pg_catalog	Tom Lane	19:57

July 23, 2019

Thread	Author	Time
zabbix on postgresql - very slow delete of events	Kristian Ejvind	08:07
Re: zabbix on postgresql - very slow delete of events	Kenneth Marshall	12:58
Re: zabbix on postgresql - very slow delete of events	Kristian Ejvind	13:41
Re: zabbix on postgresql - very slow delete of events	Kenneth Marshall	14:33

July 24, 2019

Thread	Author	Time
Re: zabbix on postgresql - very slow delete of events	Kristian Ejvind	08:11
Re: zabbix on postgresql - very slow delete of events	Maxim Boguk	13:54
Re: zabbix on postgresql - very slow delete of events	Maxim Boguk	14:05
Re: zabbix on postgresql - very slow delete of events	Kristian Ejvind	15:12
Re: zabbix on postgresql - very slow delete of events	Maxim Boguk	17:16

July 25, 2019

Thread	Author	Time
Standard uuid vs. custom data type uuid_v1	Ancoron Luciferis	09:26

July 27, 2019

Thread	Author	Time
Re: Standard uuid vs. custom data type uuid_v1	Tomas Vondra	13:47

July 29, 2019

Thread	Author	Time
High concurrency same row (inventory)	Jean Baro	06:17
Re: Standard uuid vs. custom data type uuid_v1	Ancoron Luciferis	08:13
Re: High concurrency same row (inventory)	Rick Otten	12:35
Re: High concurrency same row (inventory)	Jayadevan M	12:53
Re: High concurrency same row (inventory)	MichaelDBA	12:55
Partial join 📎	Arne Roland	16:43
Re: High concurrency same row (inventory)	Jean Baro	18:09
Re: High concurrency same row (inventory)	Michael Lewis	18:12

July 30, 2019

Thread	Author	Time
Re: High concurrency same row (inventory)	Jean Baro	00:04
Re: High concurrency same row (inventory)	Jean Baro	00:06
Re: High concurrency same row (inventory)	Jean Baro	00:26
Re: High concurrency same row (inventory)	MichaelDBA	01:13
Re: High concurrency same row (inventory)	Jean Baro	01:23

July 31, 2019

Thread	Author	Time
A question regarding streaming replication	Mariel Cherkassky	09:28
Re: A question regarding streaming replication	Fabio Pardi	09:41
Re: A question regarding streaming replication	Holger Jakobs	09:45
Oracle to postgres migration via ora2pg (blob data)	Daulat Ram	11:31
SV: Oracle to postgres migration via ora2pg (blob data)	Niels Jespersen	11:45
Re: Oracle to postgres migration via ora2pg (blob data)	Amol Tarte	16:02
Re: Oracle to postgres migration via ora2pg (blob data)	Gilles Darold	21:05

Browse Archives

Prev | Next