pgsql-performance - August 2012

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
Jump to day: 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 30 31

Aug. 1, 2012

Thread Author Time
Re: pg_dump and thousands of schemas Hugo <Nabble> 05:33
Re: Help me develop new commit_delay advice 📎 Amit Kapila 14:14
Re: Help me develop new commit_delay advice Peter Geoghegan 15:19
Re: Using ctid column changes plan drastically Kevin Grittner 16:42

Aug. 2, 2012

Thread Author Time
Re: Help me develop new commit_delay advice Amit Kapila 11:15
query using incorrect index Russell Keane 14:54
Re: Help me develop new commit_delay advice Josh Berkus 17:48
[repost] Help me develop new commit_delay advice Peter Geoghegan 18:02
Re: Help me develop new commit_delay advice Peter Geoghegan 18:04
Re: query using incorrect index Kevin Grittner 20:13

Aug. 3, 2012

Thread Author Time
Messed up time zones Laszlo Nagy 08:31
Re: Messed up time zones JC de Villa 08:58
Re: query using incorrect index Robert Klemme 09:18
Re: Messed up time zones Laszlo Nagy 09:18
Re: Messed up time zones JC de Villa 09:48
Re: query using incorrect index Russell Keane 09:50
Re: query using incorrect index Russell Keane 10:00
Re: Messed up time zones Laszlo Nagy 10:40
Re: Messed up time zones Laszlo Nagy 10:55
Re: Messed up time zones Tom Lane 14:19
Re: query using incorrect index Kevin Grittner 14:33
Re: Messed up time zones Laszlo Nagy 15:23
Re: Messed up time zones Bill MacArthur 15:34
Re: query using incorrect index Russell Keane 15:57
Re: Messed up time zones Laszlo Nagy 16:06
Re: Messed up time zones Steve Crawford 16:20
Re: Messed up time zones Tom Lane 16:38
Re: [ADMIN] Messed up time zones Laszlo Nagy 17:21
Re: Messed up time zones Laszlo Nagy 17:25
Re: Messed up time zones Laszlo Nagy 18:25
Re: [ADMIN] Messed up time zones Steve Crawford 18:25
Re: [ADMIN] Messed up time zones Laszlo Nagy 18:37
Re: Linux memory zone reclaim Josh Berkus 22:30
Re: Linux memory zone reclaim Scott Marlowe 23:02
Re: Linux memory zone reclaim Josh Berkus 23:15

Aug. 4, 2012

Thread Author Time
slow query, different plans Midge Brown 00:38
Re: slow query, different plans Greg Williamson 01:30
Re: slow query, different plans Tom Lane 06:26

Aug. 6, 2012

Thread Author Time
Postgres Upgrade from 8.4 to 9.1 Rajiv Kasera 05:38
Re: Postgres 9.1.4 - high stats collector IO usage Magnus Hagander 14:10
Re: Postgres 9.1.4 - high stats collector IO usage Pavel Stehule 14:16
Re: Postgres 9.1.4 - high stats collector IO usage Magnus Hagander 14:18
Re: Postgres 9.1.4 - high stats collector IO usage Pavel Stehule 14:43
Sequential scan instead of index scan Ioannis Anagnostopoulos 15:08
Re: Sequential scan instead of index scan David Barton 15:16
Re: Sequential scan instead of index scan Ioannis Anagnostopoulos 15:24
Re: Sequential scan instead of index scan Tom Lane 15:34
Re: slow query, different plans Midge Brown 17:43
Re: slow query, different plans Midge Brown 18:36
Re: Sequential scan instead of index scan Ioannis Anagnostopoulos 22:04

Aug. 7, 2012

Thread Author Time
Re: Sequential scan instead of index scan Tom Lane 03:13
Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller 12:01
Re: Sequential scan instead of index scan Ioannis Anagnostopoulos 12:15
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Tomas Vondra 12:16
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller 12:22
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Tomas Vondra 13:56
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Craig James 14:37
Re: Sequential scan instead of index scan Jeff Janes 16:00
Re: Sequential scan instead of index scan Ioannis Anagnostopoulos 16:06
Re: Sequential scan instead of index scan Jeff Janes 17:42
Is drop/restore trigger transactional? Craig James 18:48
Re: Is drop/restore trigger transactional? Merlin Moncure 20:15
Re: Is drop/restore trigger transactional? Scott Marlowe 20:39
Re: Is drop/restore trigger transactional? Jeff Janes 20:45
Re: Is drop/restore trigger transactional? Merlin Moncure 21:21
Re: Is drop/restore trigger transactional? Craig James 21:39
Re: Is drop/restore trigger transactional? Samuel Gendler 22:01
Re: Is drop/restore trigger transactional? Merlin Moncure 22:02
Re: Is drop/restore trigger transactional? Jeff Janes 22:22
Re: Is drop/restore trigger transactional? Craig James 22:46

Aug. 8, 2012

Thread Author Time
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller 00:07
Re: Is drop/restore trigger transactional? Craig Ringer 00:29
Re: Is drop/restore trigger transactional? Merlin Moncure 00:42
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Jeff Janes 00:50
Re: Postgresql - performance of using array in big database Craig Ringer 06:33
Re: Postgres Upgrade from 8.4 to 9.1 Craig Ringer 06:50

Aug. 9, 2012

Thread Author Time
Re: Postgresql - performance of using array in big database Ondrej Ivanič 00:18
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller 11:00
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Jeff Janes 16:17
Re: DELETE vs TRUNCATE explanation Jeff Janes 18:06

Aug. 10, 2012

Thread Author Time
Increasing WAL usage followed by sudden drop Joseph Marlin 17:35
Re: query overhead Jeff Janes 18:19
Index Bloat Problem Strahinja Kustudić 22:15

Aug. 11, 2012

Thread Author Time
Re: Index Bloat Problem hubert depesz lubaczewski 09:30
Re: Is drop/restore trigger transactional? Matheus de Oliveira 14:16
Improve DB Size / Performance with Table Refactoring Anthony Presley 14:23

Aug. 12, 2012

Thread Author Time
Re: Postgres 9.1.4 - high stats collector IO usage Jeff Janes 21:23
Re: Deferred constraints performance impact ? Jeff Davis 22:42

Aug. 13, 2012

Thread Author Time
Re: Postgres 9.1.4 - high stats collector IO usage David Barton 02:17
Re: Deferred constraints performance impact ? Robert Klemme 08:33
Re: Postgres 9.1.4 - high stats collector IO usage Jeff Janes 19:40
Re: Index Bloat Problem Mark Kirkwood 22:52

Aug. 14, 2012

Thread Author Time
Re: Increasing WAL usage followed by sudden drop Josh Berkus 01:09
7k records into Sort node, 4.5m out? Christophe Pettus 01:15
Re: 7k records into Sort node, 4.5m out? Tomas Vondra 01:35
Re: 7k records into Sort node, 4.5m out? Christophe Pettus 01:48
Re: 7k records into Sort node, 4.5m out? Tom Lane 02:11
Re: Index Bloat Problem Jeff Janes 04:14
cluster on conditional index? Doug Hunley 15:27
Re: cluster on conditional index? Jeff Janes 17:10
Re: cluster on conditional index? [email protected] 17:29

Aug. 15, 2012

Thread Author Time
Re: cluster on conditional index? Doug Hunley 13:43
Re: 7k records into Sort node, 4.5m out? Christophe Pettus 19:13
Re: 7k records into Sort node, 4.5m out? Tom Lane 20:51
Re: 7k records into Sort node, 4.5m out? Josh Berkus 21:02
Re: cluster on conditional index? Josh Berkus 21:05
Re: cluster on conditional index? Bosco Rama 21:19
Re: 7k records into Sort node, 4.5m out? Tom Lane 21:44

Aug. 16, 2012

Thread Author Time
Re: 7k records into Sort node, 4.5m out? Josh Berkus 00:25
High Disk write and space taken by PostgreSQL J Ramesh Kumar 03:23
Re: High Disk write and space taken by PostgreSQL David Barton 03:36
Re: High Disk write and space taken by PostgreSQL J Ramesh Kumar 04:30
Re: High Disk write and space taken by PostgreSQL Scott Marlowe 04:39
Re: High Disk write and space taken by PostgreSQL J Ramesh Kumar 05:40
Re: High Disk write and space taken by PostgreSQL Claudio Freire 05:41
Re: High Disk write and space taken by PostgreSQL Ondrej Ivanič 05:48
Re: High Disk write and space taken by PostgreSQL Claudio Freire 05:50
Re: 7k records into Sort node, 4.5m out? Tom Lane 06:01
Re: High Disk write and space taken by PostgreSQL Bruce Momjian 14:53
Re: High Disk write and space taken by PostgreSQL Bruce Momjian 14:56
Re: cluster on conditional index? Doug Hunley 15:25
Re: High Disk write and space taken by PostgreSQL Scott Marlowe 15:49
Re: cluster on conditional index? Jeff Janes 16:04
Re: High Disk write and space taken by PostgreSQL [email protected] 16:07
Re: Odd blocking (or massively latent) issue - even with EXPLAIN Jim Vanns 16:14
Re: cluster on conditional index? Jeff Janes 16:16
Re: High Disk write and space taken by PostgreSQL Bruce Momjian 16:23
Re: Increasing WAL usage followed by sudden drop delongboy 16:31
Re: Increasing WAL usage followed by sudden drop Kevin Grittner 16:39
Re: Index Bloat Problem Strahinja Kustudić 19:57
best practice to avoid table bloat? Anibal David Acosta 20:33
Re: best practice to avoid table bloat? Andrew Dunstan 20:48
Re: best practice to avoid table bloat? Kevin Grittner 20:52
Re: best practice to avoid table bloat? Anibal David Acosta 21:10
Re: High Disk write and space taken by PostgreSQL Merlin Moncure 21:16
Re: best practice to avoid table bloat? Kevin Grittner 21:39

Aug. 17, 2012

Thread Author Time
Re: Increasing WAL usage followed by sudden drop Joshua Berkus 15:01
Re: Increasing WAL usage followed by sudden drop delongboy 17:53
Re: Increasing WAL usage followed by sudden drop Jeff Janes 18:42

Aug. 18, 2012

Thread Author Time
Re: Index Bloat Problem Jeff Janes 02:33
Re: Index Bloat Problem Greg Williamson 08:01

Aug. 19, 2012

Thread Author Time
Re: 7k records into Sort node, 4.5m out? Josh Berkus 19:53

Aug. 20, 2012

Thread Author Time
Re: 7k records into Sort node, 4.5m out? Tom Lane 15:40
Re: 7k records into Sort node, 4.5m out? Josh Berkus 17:47
Re: Increasing WAL usage followed by sudden drop delongboy 20:51
Does setval(nextval()+N) generate unique blocks of IDs? Craig James 23:32

Aug. 21, 2012

Thread Author Time
Re: Does setval(nextval()+N) generate unique blocks of IDs? Tom Lane 00:10
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe 00:59
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe 01:06
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe 07:41
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe 07:45
Re: Does setval(nextval()+N) generate unique blocks of IDs? Merlin Moncure 14:12
Re: Does setval(nextval()+N) generate unique blocks of IDs? Craig James 14:36
Re: Does setval(nextval()+N) generate unique blocks of IDs? Craig James 15:32
Re: Does setval(nextval()+N) generate unique blocks of IDs? Merlin Moncure 17:53
average query performance measuring Rick Otten 18:35
Re: average query performance measuring Stephen Frost 18:53
Re: average query performance measuring Karl Denninger 19:48
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe 20:03
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe 20:04
Re: average query performance measuring Stephen Frost 20:27
Re: Does setval(nextval()+N) generate unique blocks of IDs? Craig James 20:59
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe 21:06
Re: average query performance measuring Tomas Vondra 21:08
Re: average query performance measuring Peter Geoghegan 21:51
Performance of Seq Scan from buffer cache Matt Daw 22:57
Re: Performance of Seq Scan from buffer cache Matt Daw 23:59

Aug. 22, 2012

Thread Author Time
Re: average query performance measuring Rick Otten 14:04

Aug. 23, 2012

Thread Author Time
Re: Increasing WAL usage followed by sudden drop Jeff Janes 00:28
Re: Performance of Seq Scan from buffer cache Merlin Moncure 13:32
Re: Increasing WAL usage followed by sudden drop delongboy 14:43

Aug. 24, 2012

Thread Author Time
Slow Performance on a XEON E5504 Felix Schubert 09:47
Loose Index Scans by Planner? Shaun Thomas 16:20
NOTIFY performance Artur Zając 18:46
Re: NOTIFY performance Merlin Moncure 19:12
Re: Loose Index Scans by Planner? Kevin Grittner 19:40
Re: NOTIFY performance Artur Zając 21:11
Re: Loose Index Scans by Planner? Shaun Thomas 21:22

Aug. 25, 2012

Thread Author Time
Re: Loose Index Scans by Planner? Jeff Janes 03:42
Slow Performance on a XEON E5504 Felix Schubert 12:07
Re: Slow Performance on a XEON E5504 Scott Marlowe 12:42
Re: Slow Performance on a XEON E5504 Felix Schubert 12:53
Re: Slow Performance on a XEON E5504 Scott Marlowe 12:59
Re: Slow Performance on a XEON E5504 Scott Marlowe 13:04
Re: Loose Index Scans by Planner? Shaun Thomas 14:39
Re: Slow Performance on a XEON E5504 Felix Schubert 21:26
Re: Slow Performance on a XEON E5504 Scott Marlowe 21:47

Aug. 26, 2012

Thread Author Time
Investigating the reason for a very big TOAST table size Liron Shiri 12:46
Investigating the reason for a very big TOAST table size Liron Shiri 12:51

Aug. 27, 2012

Thread Author Time
Execution from java - slow Jayadevan M 12:37
Re: Execution from java - slow Albe Laurenz 12:47
Re: Investigating the reason for a very big TOAST table size Daniel Farina 16:42

Aug. 28, 2012

Thread Author Time
Vacuum problems with 9.1 Nimesh Satam 04:33
Re: Investigating the reason for a very big TOAST table size Liron Shiri 06:24
Re: Vacuum problems with 9.1 Pavan Deolasee 06:33
Re: Vacuum problems with 9.1 Craig Ringer 06:53
Re: Execution from java - slow Pavan Deolasee 07:11
pg_trgm and slow bitmap index scan plan 📎 Mathieu De Zutter 07:39
Re: Investigating the reason for a very big TOAST table size Daniel Farina 08:57
Re: Investigating the reason for a very big TOAST table size 📎 Daniel Farina 08:59

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 30 31