pgsql-performance since 2011-09-26 00:00

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

Sept. 26, 2011

Thread Author Time
Re: Query optimization using order by and limit Stephen Frost 00:34
Re: Query optimization using order by and limit Tom Lane 01:24
overzealous sorting? anthony.shipman 06:28
Re: [PERFORMANCE] Insights: fseek OR read_cluster? Craig Ringer 07:59
Re: overzealous sorting? Marc Cousin 09:39
Re: [PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges 12:51
How to find record having % as part of data. Biswa 13:34
Re: How to find record having % as part of data. Biswa 14:19
postgres constraint triggers Maria L. Wilson 16:52
Re: Performance Anomaly with "col in (A, B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane 17:07
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Craig James 17:18
Re: Performance Anomaly with "col in (A, B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane 17:35
Re: [PERFORMANCE] Insights: fseek OR read_cluster? Marti Raudsepp 19:06
Re: slow query on tables with new columns added. 📎 M. D. 20:13
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett 21:11
Re: slow query on tables with new columns added. Filip Rembiałkowski 23:45

Sept. 27, 2011

Thread Author Time
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Craig Ringer 00:09
Re: Performance Anomaly with "col in (A, B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane 00:39
Re: overzealous sorting? anthony.shipman 02:45
Ineffective autovacuum Royce Ausburn 03:45
Re: Ineffective autovacuum Tom Lane 04:21
Re: postgres constraint triggers Ben Chobot 04:54
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Samuel Gendler 05:06
Re: Ineffective autovacuum Royce Ausburn 05:08
Re: overzealous sorting? Marc Cousin 08:54
Re: overzealous sorting? anthony.shipman 09:05
Re: overzealous sorting? Mark Kirkwood 09:22
Re: Ineffective autovacuum Marti Raudsepp 10:29
Re: : Performance Improvement Strategy Venkat Balaji 12:29
Re: : Performance Improvement Strategy Venkat Balaji 12:31
: Tracking Full Table Scans Venkat Balaji 12:36
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett 12:40
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett 12:57
Re: Ineffective autovacuum Tom Lane 13:49
Re: Ineffective autovacuum Scott Marlowe 14:00
Re: Ineffective autovacuum Royce Ausburn 14:27
Re: : Tracking Full Table Scans Kevin Grittner 14:32
Re: overzealous sorting? Marc Cousin 15:00
Re: [PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges 16:12
Re: : Tracking Full Table Scans Venkat Balaji 16:26
PostgreSQL-9.0 Monitoring System to improve performance Venkat Balaji 16:35
Re: : Tracking Full Table Scans Venkat Balaji 16:42
Re: : Tracking Full Table Scans Kevin Grittner 17:15

Sept. 28, 2011

Thread Author Time
Re: postgres constraint triggers Craig Ringer 00:37
Re: : Tracking Full Table Scans Craig Ringer 00:55
Re: overzealous sorting? anthony.shipman 05:13
Re: : Tracking Full Table Scans Venkat Balaji 06:09
Re: : Tracking Full Table Scans Venkat Balaji 06:13
Re: PostgreSQL-9.0 Monitoring System to improve performance Greg Smith 07:05
Re: PostgreSQL-9.0 Monitoring System to improve performance Tomas Vondra 12:14
: Create table taking time Venkat Balaji 17:06
: Looking for PG Books Venkat Balaji 17:17
Re: : Looking for PG Books Josh Berkus 18:54
Re: : Create table taking time Josh Berkus 18:55
Re: : Create table taking time Scott Marlowe 19:14

Sept. 29, 2011

Thread Author Time
Re: : Create table taking time Venkat Balaji 08:02
Select se bloquea Numael Vacca Duran 12:43
Re: : Create table taking time Kevin Grittner 13:48
the number of child tables --table partitioning Jian Shi 14:14
Re: Select se bloquea Claudio Freire 14:21
Re: the number of child tables --table partitioning Kevin Grittner 15:08
Re: : Create table taking time Merlin Moncure 16:52
Re: the number of child tables --table partitioning Ondrej Ivanič 21:12

Sept. 30, 2011

Thread Author Time
Shortcutting too-large offsets? Josh Berkus 00:39
array_except -- Find elements that are not common to both arrays bricklen 02:32
Re: postgres constraint triggers Ben Chobot 03:01
Re: array_except -- Find elements that are not common to both arrays Merlin Moncure 03:08
Re: array_except -- Find elements that are not common to both arrays bricklen 03:27
Re: : Create table taking time Venkat Balaji 05:22
Re: PostgreSQL-9.0 Monitoring System to improve performance Venkat Balaji 10:30
Re: PostgreSQL-9.0 Monitoring System to improve performance Venkat Balaji 10:32
Re: : Create table taking time Venkat Balaji 11:20
Re: PostgreSQL-9.0 Monitoring System to improve performance Gregg Jaskiewicz 11:53
Re: array_except -- Find elements that are not common to both arrays Vitalii Tymchyshyn 12:23
Re: array_except -- Find elements that are not common to both arrays bricklen 14:28
Re: Shortcutting too-large offsets? Tom Lane 14:36
Re: Shortcutting too-large offsets? pasman pasmański 15:08
Re: the number of child tables --table partitioning Merlin Moncure 17:01
Re: the number of child tables --table partitioning alexandre - aldeia digital 17:13
Re: array_except -- Find elements that are not common to both arrays bricklen 18:07
Re: Shortcutting too-large offsets? Josh Berkus 18:44
Re: Shortcutting too-large offsets? Tom Lane 18:56
Re: array_except -- Find elements that are not common to both arrays Ben Chobot 20:15
Re: array_except -- Find elements that are not common to both arrays Merlin Moncure 21:12
Re: PostgreSQL-9.0 Monitoring System to improve performance Bobby Dewitt 21:29
Re: array_except -- Find elements that are not common to both arrays bricklen 23:43

Oct. 2, 2011

Thread Author Time
Suggestions for Intel 710 SSD test David Boreham 02:39
Re: Suggestions for Intel 710 SSD test Andy 03:22
Re: Suggestions for Intel 710 SSD test Gregory Gerard 04:00
Re: Suggestions for Intel 710 SSD test Arjen van der Meijden 08:33
[No subject] Eduardo Nazor 09:59
Re: Suggestions for Intel 710 SSD test David Boreham 13:49
Re: Suggestions for Intel 710 SSD test David Boreham 14:02
Re: Suggestions for Intel 710 SSD test David Boreham 23:33

Oct. 3, 2011

Thread Author Time
Re: Suggestions for Intel 710 SSD test Gregory Gerard 00:26
Re: Suggestions for Intel 710 SSD test David Boreham 00:44
Re: Suggestions for Intel 710 SSD test 📎 Greg Smith 04:35
Re: Suggestions for Intel 710 SSD test David Boreham 04:49
Re: Suggestions for Intel 710 SSD test David Boreham 05:24
Re: Suggestions for Intel 710 SSD test Gregory Gerard 05:55
Re: Suggestions for Intel 710 SSD test David Boreham 05:57
Query with order by and limit is very slow - wrong index used Nowak Michał 09:44
Re: Query with order by and limit is very slow - wrong index used Gregg Jaskiewicz 10:02
Re: Query with order by and limit is very slow - wrong index used Nowak Michał 10:51
Re: : Performance Improvement Strategy Venkat Balaji 10:59
Re: Query with order by and limit is very slow - wrong index used Gregg Jaskiewicz 11:20
Fwd: Query with order by and limit is very slow - wrong index used Nowak Michał 13:08
How can i get record by data block not by sql? 姜头 13:52
Re: Query with order by and limit is very slow - wrong index used Nowak Michał 13:59
Re: Query with order by and limit is very slow - wrong index used Cédric Villemain 14:28
Re: How can i get record by data block not by sql? Ben Chobot 14:29
Re: Query with order by and limit is very slow - wrong index used Tom Lane 15:12
Re: : Performance Improvement Strategy Kevin Grittner 16:15
Re: : Performance Improvement Strategy Venkat Balaji 16:54
pkey is not used on productive database Soporte @ TEKSOL S.A. 17:48
Re: Query with order by and limit is very slow - wrong index used Marcin Mańk 22:45

Oct. 4, 2011

Thread Author Time
Re: Query with order by and limit is very slow - wrong index used Nowak Michał 07:10
Re: array_except -- Find elements that are not common to both arrays Gavin Flower 07:16
Re: Query with order by and limit is very slow - wrong index used Gregg Jaskiewicz 08:08
Re: Query with order by and limit is very slow - wrong index used Nowak Michał 08:55
Window functions and index usage Anssi Kääriäinen 09:39
: Column Performance in a query Venkat Balaji 10:25
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji 10:50
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Heikki Linnakangas 11:08
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji 11:23
Re: pkey is not used on productive database hubert depesz lubaczewski 12:55
Re: pkey is not used on productive database Scott Marlowe 13:01
Re: Window functions and index usage Robert Klemme 13:27
Re: Window functions and index usage Anssi Kääriäinen 14:06
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter pasman pasmański 14:15
Re: Window functions and index usage Tom Lane 14:36
Re: Window functions and index usage Robert Klemme 14:52
Re: Window functions and index usage Anssi Kääriäinen 15:00
Re: Window functions and index usage Anssi Kääriäinen 15:05
Re: array_except -- Find elements that are not common to both arrays Merlin Moncure 16:10
Re: : Column Performance in a query Ondrej Ivanič 22:26
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Greg Smith 22:32
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Scott Marlowe 22:47
Re: Query with order by and limit is very slow - wrong index used Kevin Grittner 23:33

Oct. 5, 2011

Thread Author Time
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji 02:50
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Greg Smith 05:32
Re: : Performance Improvement Strategy Venkat Balaji 09:08
Re: : Performance Improvement Strategy Raghavendra 09:30
Re: : Performance Improvement Strategy Guillaume Cottenceau 09:39
Re: : Performance Improvement Strategy Kevin Grittner 16:13
Re: : Performance Improvement Strategy Scott Marlowe 17:09
Re: : Performance Improvement Strategy Tom Lane 18:15
Intel 710 Endurance Test Results David Boreham 19:15
pg9 replication over WAN ? Ben Ciceron 21:53
Re: Allow sorts to use more available memory Bruce Momjian 21:54

Oct. 6, 2011

Thread Author Time
Re: : Performance Improvement Strategy Raghavendra 09:31
Re: : Performance Improvement Strategy Scott Marlowe 19:20

Oct. 7, 2011

Thread Author Time
Re: pg9 replication over WAN ? mark 03:22
Performance problem with a table with 38928077 record 📎 Giovanni Mancuso 10:04
Re: Performance problem with a table with 38928077 record Guillaume Cottenceau 10:24
Re: Performance problem with a table with 38928077 record Gregg Jaskiewicz 10:29
Re: Performance problem with a table with 38928077 record Cédric Villemain 12:59
Re: Performance problem with a table with 38928077 record 📎 Giovanni Mancuso 15:12
Re: PostgreSQL-9.0 Monitoring System to improve performance Fernando Hevia 22:01
Re: PostgreSQL-9.0 Monitoring System to improve performance Ben Ciceron 22:13

Oct. 8, 2011

Thread Author Time
Re: Performance problem with a table with 38928077 record 📎 Giovanni Mancuso 15:04

Oct. 10, 2011

Thread Author Time
Re: : Performance Improvement Strategy Leonardo Francalanci 08:04
Adding more memory = hugh cpu load alexandre - aldeia digital 13:26
Re: Adding more memory = hugh cpu load Kevin Grittner 13:51
Re: Adding more memory = hugh cpu load Shaun Thomas 14:04
Re: Adding more memory = hugh cpu load Leonardo Francalanci 15:14
Re: Adding more memory = hugh cpu load Shaun Thomas 15:39
Re: Adding more memory = hugh cpu load Greg Smith 16:07
Re: Adding more memory = hugh cpu load Leonardo Francalanci 16:14
Re: Adding more memory = hugh cpu load alexandre - aldeia digital 17:31
Re: Adding more memory = hugh cpu load Kevin Grittner 17:46
Re: Adding more memory = hugh cpu load alexandre - aldeia digital 18:54
Re: Adding more memory = hugh cpu load Kevin Grittner 19:39
Re: Adding more memory = hugh cpu load Shaun Thomas 20:25
Re: Adding more memory = hugh cpu load alexandre - aldeia digital 20:34
Re: Adding more memory = hugh cpu load Kevin Grittner 20:52
Rapidly finding maximal rows James Cranch 21:59
Re: Adding more memory = hugh cpu load Samuel Gendler 22:02

Oct. 11, 2011

Thread Author Time
Re: Adding more memory = hugh cpu load Claudio Freire 02:19
Re: Adding more memory = hugh cpu load Greg Smith 06:42
Re: Adding more memory = hugh cpu load Greg Smith 06:50
Re: Adding more memory = hugh cpu load Leonardo Francalanci 08:57
Rapidly finding maximal rows James Cranch 10:16
Re: Adding more memory = hugh cpu load Ivan Voras 10:20
Re: Adding more memory = hugh cpu load alexandre - aldeia digital 11:54
Re: Adding more memory = hugh cpu load alexandre - aldeia digital 12:14
Re: Adding more memory = hugh cpu load Luca Tettamanti 12:50
Composite keys Carlo Stonebanks 15:16
Re: Adding more memory = hugh cpu load Greg Smith 15:32
Query tuning help CS DBA 17:52
Re: Query tuning help Pavel Stehule 18:02
Re: Adding more memory = hugh cpu load [solved] alexandre - aldeia digital 18:02
Re: Query tuning help Szymon Guz 18:03
Re: Adding more memory = hugh cpu load [solved] Claudio Freire 18:05
Re: Query tuning help CS DBA 18:14
Re: should i expected performance degradation over time Anibal David Acosta 18:20
Re: Query tuning help CS DBA 18:31
Re: Query tuning help Pavel Stehule 18:59
postgresql query runtime Radhya sahal 19:08
Re: postgresql query runtime Pavel Stehule 19:11

Browse Archives

Prev | Next