pgsql-performance - October 2018

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

Oct. 1, 2018

Thread	Author	Time
Re: Why could different data in a table be processed with different performance?	Fabio Pardi	07:35

Oct. 2, 2018

Thread	Author	Time
Re: [HACKERS] proposal: schema variables	Thomas Munro	23:01

Oct. 5, 2018

Thread	Author	Time
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	01:34
Re: dsa_allocate() faliure	Thomas Munro	02:16

Oct. 6, 2018

Thread	Author	Time
Why the index is not used ?	ROS Didier	09:57
Re: Why the index is not used ?	Pavel Stehule	10:13
Re: Why the index is not used ?	Vladimir Ryabtsev	16:51

Oct. 7, 2018

Thread	Author	Time
Re: Why the index is not used ?	Paul McGarry	02:20
RE: Why the index is not used ?	ROS Didier	13:13
RE: Why the index is not used ?	ROS Didier	13:20
Re: Why the index is not used ?	Francisco Olarte	15:58
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	17:13
RE: Why the index is not used ?	ROS Didier	18:32
RE: Why the index is not used ?	Kumar, Virendra	18:41
Re: Why the index is not used ?	Vladimir Ryabtsev	18:48
Re: Why the index is not used ?	Vladimir Ryabtsev	19:32
Re: Why the index is not used ?	Tomas Vondra	20:07
Re: Why the index is not used ?	Paul McGarry	22:10

Oct. 8, 2018

Thread	Author	Time
RE: Why the index is not used ?	ROS Didier	06:29
RE: Why the index is not used ?	ROS Didier	08:32
Re: Why the index is not used ?	Jean-Paul Argudo	08:44
RE: Why the index is not used ?	ROS Didier	11:47
RE: Why the index is not used ?	ROS Didier	12:02
RE: Why the index is not used ?	ROS Didier	12:07
RE: Why the index is not used ?	Phil Endecott	13:14
RE: Why the index is not used ?	ROS Didier	14:10
RE: Why the index is not used ?	ROS Didier	14:29
RE: Why the index is not used ?	ROS Didier	15:32
Re: Why the index is not used ?	Tomas Vondra	20:00
Re: Why the index is not used ?	Paul McGarry	21:34
Re: Partial index plan/cardinality costing	James Coleman	22:05

Oct. 9, 2018

Thread	Author	Time
Re: Partial index plan/cardinality costing	Justin Pryzby	00:49
understand query on partition table	Mariel Cherkassky	09:19
Re: understand query on partition table 📎	Samed YILDIRIM	13:12

Oct. 10, 2018

Thread	Author	Time
Re: Why could different data in a table be processed with different performance?	Vladimir Ryabtsev	10:59

Oct. 11, 2018

Thread	Author	Time
does work_mem is used on temp tables?	Mariel Cherkassky	06:56
Re: does work_mem is used on temp tables?	Andrew Gierth	07:41
Re: does work_mem is used on temp tables?	Mariel Cherkassky	07:58

Oct. 12, 2018

Thread	Author	Time
One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed)	Sam R.	16:27

Oct. 15, 2018

Thread	Author	Time
Import csv in PostgreSQL	Dinesh Chandra 12108	05:42
Re: Import csv in PostgreSQL	Gabi D	06:09

Oct. 16, 2018

Thread	Author	Time
Re: One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed)	Sam R.	03:47

Oct. 19, 2018

Thread	Author	Time
Gained %20 performance after disabling bitmapscan	Yavuz Selim Sertoglu	07:19
Re: Gained %20 performance after disabling bitmapscan	Justin Pryzby	13:44
Re: Gained %20 performance after disabling bitmapscan	Tom Lane	13:52
Re: Gained %20 performance after disabling bitmapscan	Vladimir Ryabtsev	18:09
Re: Gained %20 performance after disabling bitmapscan	Jeff Janes	19:40

Oct. 22, 2018

Thread	Author	Time
Ynt: Gained %20 performance after disabling bitmapscan	Yavuz Selim Sertoglu	06:52
Ynt: Gained %20 performance after disabling bitmapscan	Yavuz Selim Sertoglu	06:55
Ynt: Gained %20 performance after disabling bitmapscan	Yavuz Selim Sertoglu	07:20
High CPU Usage of "SET ROLE" 📎	Ulf Lohbrügge	13:44
Re: High CPU Usage of "SET ROLE"	Tom Lane	13:57

Oct. 23, 2018

Thread	Author	Time
Re: [HACKERS] proposal: schema variables	Erik Rijkers	12:50
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	18:05

Oct. 25, 2018

Thread	Author	Time
DELETE / UPDATE from partition not optimized (11.0)	Dave E Martin	16:43

Oct. 26, 2018

Thread	Author	Time
Re: DELETE / UPDATE from partition not optimized (11.0)	Justin Pryzby	15:45
Re: Gained %20 performance after disabling bitmapscan	Jeff Janes	17:54

Oct. 28, 2018

Thread	Author	Time
Re: DELETE / UPDATE from partition not optimized (11.0)	Justin Pryzby	21:49

Oct. 29, 2018

Thread	Author	Time
Indexes on UUID - Fragmentation Issue	Uday Bhaskar V	13:29
Re: Indexes on UUID - Fragmentation Issue	Merlin Moncure	14:28
Re: Indexes on UUID - Fragmentation Issue	Andreas Karlsson	14:52
Re: Indexes on UUID - Fragmentation Issue	Uday Bhaskar V	14:56
Re: Indexes on UUID - Fragmentation Issue	MichaelDBA	19:12

Oct. 30, 2018

Thread	Author	Time
SCRAM question	MichaelDBA	17:51
Re: SCRAM question	Joshua D. Drake	18:03
Re: High CPU Usage of "SET ROLE"	Ulf Lohbrügge	19:49
Re: High CPU Usage of "SET ROLE"	Tom Lane	20:27
Re: High CPU Usage of "SET ROLE"	Jeff Janes	22:34

Oct. 31, 2018

Thread	Author	Time
Re: SCRAM question	Michael Paquier	09:55

Browse Archives

Prev | Next