pgsql-performance - October 2013

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, 2013

Thread	Author	Time
Re: BASH script for collecting analyze-related info 📎	Ken Tanzer	02:40
Reseting statistics counters	Xenofon Papadopoulos	11:50
Re: Reseting statistics counters	Pavel Stehule	11:56

Oct. 2, 2013

Thread	Author	Time
Re: [GENERAL] Help on ṕerformance	Merlin Moncure	13:57
Re: [GENERAL] Help on ṕerformance	Carlos Eduardo Sotelo Pinto	16:22

Oct. 3, 2013

Thread	Author	Time
57 minute SELECT	Samuel Stearns	00:56
Re: 57 minute SELECT	Samuel Stearns	01:03
Re: 57 minute SELECT	David Johnston	01:17
Re: 57 minute SELECT	Samuel Stearns	01:17
Re: 57 minute SELECT	Samuel Stearns	01:30
Re: 57 minute SELECT	Samuel Stearns	01:35
Re: 57 minute SELECT	Claudio Freire	01:45
Re: 57 minute SELECT	Samuel Stearns	01:47
Re: 57 minute SELECT	David Johnston	01:48
Re: 57 minute SELECT	Samuel Stearns	02:04
Re: 57 minute SELECT	Claudio Freire	04:13
Re: 57 minute SELECT	Samuel Stearns	04:19
Re: 57 minute SELECT	Ivan Voras	10:08
Re: 57 minute SELECT	[email protected]	12:59
Re: 57 minute SELECT	David Kerr	16:20
Re: 57 minute SELECT	David Kerr	16:25
Re: 57 minute SELECT	Samuel Stearns	22:49
Re: 57 minute SELECT	Samuel Stearns	23:05

Oct. 4, 2013

Thread	Author	Time
Re: [GENERAL] Re: [GENERAL] Help on ṕerformance	Rémi Cura	08:46

Oct. 8, 2013

Thread	Author	Time
postgreSQL query via JDBC in different OS taking different running time?	Aftab Ahmed Chandio	01:48
Re: postgreSQL query via JDBC in different OS taking different running time?	Kevin Grittner	03:35
Re: postgreSQL query via JDBC in different OS taking different running time?	John R Pierce	03:37
Re: postgreSQL query via JDBC in different OS taking different running time?	David Johnston	03:44
Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time?	Luca Ferrari	11:02
Is there a Maximum number of partitions in which constraint_exclusion works?	Marcelo Vega	15:31

Oct. 10, 2013

Thread	Author	Time
limit connections pgpool	Jeison Bedoya Delgado	15:00
Re: postgreSQL query via JDBC in different OS taking different running time?	Merlin Moncure	21:44

Oct. 11, 2013

Thread	Author	Time
Re: limit connections pgpool	Michael Paquier	03:10
Re: limit connections pgpool	Tatsuo Ishii	03:38

Oct. 14, 2013

Thread	Author	Time
CPU spikes and transactions	Tony Kay	23:00
Re: CPU spikes and transactions	Tony Kay	23:26
Re: CPU spikes and transactions	Tomas Vondra	23:42
Re: CPU spikes and transactions	Tomas Vondra	23:45

Oct. 15, 2013

Thread	Author	Time
Re: CPU spikes and transactions	Merlin Moncure	13:00
Re: CPU spikes and transactions	Tony Kay	15:59
Re: CPU spikes and transactions	Tony Kay	16:09
Re: CPU spikes and transactions	Julien Cigar	17:26
Re: CPU spikes and transactions	Tony Kay	19:07
Re: CPU spikes and transactions	Julien Cigar	19:41
Hot Standby performance issue	sparikh	20:40
Re: CPU spikes and transactions	Tomas Vondra	21:46

Oct. 16, 2013

Thread	Author	Time
Re: CPU spikes and transactions	Merlin Moncure	03:14
Planner Conceptual Error when Joining a Subquery -- Outer Query Condition not Pulled Into Subquery	Gavin Wahl	06:33
Re: BASH script for collecting analyze-related info	Ken Tanzer	07:20
Re: Planner Conceptual Error when Joining a Subquery -- Outer Query Condition not Pulled Into Subquery	Tom Lane	08:28

Oct. 17, 2013

Thread	Author	Time
Re: Planner Conceptual Error when Joining a Subquery -- Outer Query Condition not Pulled Into Subquery	Gavin Wahl	02:45
Re: BASH script for collecting analyze-related info	Ken Tanzer	04:50

Oct. 18, 2013

Thread	Author	Time
Re: Hot Standby performance issue	sparikh	21:49
Re: Hot Standby performance issue	Sethu Prasad	23:15
Re: Hot Standby performance issue	Tomas Vondra	23:19
Re: Hot Standby performance issue	Tomas Vondra	23:23

Oct. 19, 2013

Thread	Author	Time
Re: Hot Standby performance issue	sparikh	00:53

Oct. 20, 2013

Thread	Author	Time
Re: Hot Standby performance issue	Tomas Vondra	00:20
Re: Hot Standby performance issue	Kevin Grittner	16:03
Re: Hot Standby performance issue	sparikh	17:58
Re: Hot Standby performance issue	Tomas Vondra	23:01

Oct. 21, 2013

Thread	Author	Time
Re: Hot Standby performance issue	sparikh	15:05
Re: Hot Standby performance issue	Tomas Vondra	19:58
Re: Hot Standby performance issue	sparikh	21:18
Re: Hot Standby performance issue	Tomas Vondra	21:54
Re: Hot Standby performance issue	sparikh	22:59
Re: Hot Standby performance issue	Tomas Vondra	23:14

Oct. 22, 2013

Thread	Author	Time
Re: Hot Standby performance issue	sparikh	00:00
Re: Hot Standby performance issue	Magnus Hagander	04:49
Re: Hot Standby performance issue	Tomas Vondra	17:54
Re: Hot Standby performance issue	Tomas Vondra	18:00
Logic of lowering seq_page_cost for SSD?	Josh Berkus	18:56
Re: Hot Standby performance issue	sparikh	21:41
Re: Hot Standby performance issue	sparikh	21:50
Re: Hot Standby performance issue	Tomas Vondra	23:09
Re: Hot Standby performance issue	Tomas Vondra	23:15

Oct. 23, 2013

Thread	Author	Time
Re: Hot Standby performance issue	sparikh	01:23

Oct. 25, 2013

Thread	Author	Time
Re: Hot Standby performance issue	ramistuni	21:22

Oct. 26, 2013

Thread	Author	Time
Re: Hot Standby performance issue	Tomas Vondra	14:16

Oct. 28, 2013

Thread	Author	Time
Re: Hot Standby performance issue	sparikh	20:23
Re: Hot Standby performance issue	sparikh	20:57
Problems with hash join over nested loop	Jim Nasby	21:58
Re: Problems with hash join over nested loop	Tom Lane	23:13
Re: Problems with hash join over nested loop	Jim Nasby	23:53

Oct. 29, 2013

Thread	Author	Time
Re: Problems with hash join over nested loop	Merlin Moncure	14:10
Re: Problems with hash join over nested loop	Jim Nasby	16:21
Re: Problems with hash join over nested loop	Tom Lane	16:45
Re: Problems with hash join over nested loop	Jim Nasby	16:52
Re: Problems with hash join over nested loop	Tom Lane	18:20
Re: Problems with hash join over nested loop	Jim Nasby	20:08
Re: Problems with hash join over nested loop	Tom Lane	20:36
Adding foreign key constraint holds exclusive lock for too long (on production database)	Ben Hoyt	21:27

Oct. 30, 2013

Thread	Author	Time
Re: Adding foreign key constraint holds exclusive lock for too long (on production database)	David Johnston	00:18
Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)	Tom Lane	00:30
Re: postgres connections	si24	14:16
Re: Adding foreign key constraint holds exclusive lock for too long (on production database)	Josh Berkus	18:20
Re: Problems with hash join over nested loop	Jim Nasby	22:27
Re: Problems with hash join over nested loop	Jim Nasby	22:32
Re: Problems with hash join over nested loop	Tom Lane	23:06

Oct. 31, 2013

Thread	Author	Time
Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)	Ben Hoyt	08:01
Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)	Tom Lane	14:19
Update Trigger latency utilizing the IS DISTINCT FROM syntax 📎	fburgess	22:27
Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)	Ben Hoyt	23:32

Browse Archives

Prev | Next