pgsql-performance - June 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 4 5 6 7 8 9 10 11 12 13 14 15 18 19 20 21 22 25 26 27 28

June 1, 2012

Thread Author Time
Re: Trouble with plan statistics for behaviour for query. Craig James 00:08
Re: Trouble with plan statistics for behaviour for query. Vitalii Tymchyshyn 09:06
Select from sequence in slow query log Chris Rimmer 13:13
Re: Select from sequence in slow query log Tom Lane 13:47
Re: does the query planner consider work_mem? Tom Lane 15:15
Re: Trouble with plan statistics for behaviour for query. Maciek Sakrejda 15:38
Re: Select from sequence in slow query log Chris Rimmer 15:41

June 2, 2012

Thread Author Time
Re: High load average in 64-core server , no I/O wait and CPU is idle Kevin Grittner 02:54
Array fundamentals idc danny 17:05
Re: [PERFORM] Array fundamentals Jeff Davis 17:21

June 4, 2012

Thread Author Time
Re: Recover rows deleted Alejandro Carrillo 16:14
Re: Recover rows deleted Shaun Thomas 16:43
Re: Recover rows deleted Alejandro Carrillo 16:47
Re: Recover rows deleted Merlin Moncure 17:04
Re: Recover rows deleted Alejandro Carrillo 17:46
Re: Recover rows deleted Merlin Moncure 18:23
Re: Recover rows deleted Alejandro Carrillo 18:37
Re: Recover rows deleted Kevin Grittner 18:46

June 5, 2012

Thread Author Time
Re: Trouble with plan statistics for behaviour for query. Trevor Campbell 01:25
Re: Trouble with plan statistics for behaviour for query. Trevor Campbell 03:49
Sequencial scan in a JOIN Andrew Jaimes 12:48
Re: Sequencial scan in a JOIN Shaun Thomas 13:15
Re: Sequencial scan in a JOIN Andrew Jaimes 13:31
Re: Sequencial scan in a JOIN Shaun Thomas 14:02
Re: Sequencial scan in a JOIN Shaun Thomas 14:57
Missing block Magic Alejandro Carrillo 16:12
Re: Missing block Magic Tom Lane 17:00
Re: Missing block Magic Alejandro Carrillo 18:51

June 6, 2012

Thread Author Time
pg 9.1 brings host machine down Konstantin Mikhailov 12:05
Re: pg 9.1 brings host machine down Vitalii Tymchyshyn 12:25
Re: pg 9.1 brings host machine down Patric Bechtel 12:40
Re: pg 9.1 brings host machine down 📎 Julien Cigar 12:55

June 7, 2012

Thread Author Time
Multiple Concurrent Updates of Shared Resource Counter Nir Zilberman 07:53
Re: Multiple Concurrent Updates of Shared Resource Counter Robert Klemme 11:48

June 8, 2012

Thread Author Time
Tablespaces and query planning Albe Laurenz 08:15
Re: Seqscan slowness and stored procedures Albe Laurenz 09:58
Re: Tablespaces and query planning Cédric Villemain 10:36
Re: Multiple Concurrent Updates of Shared Resource Counter Cédric Villemain 10:59
Re: Seqscan slowness and stored procedures Ivan Voras 11:00
non index use on LIKE on a non pattern string Guillaume Cottenceau 11:11
Re: non index use on LIKE on a non pattern string Cédric Villemain 11:51
how to change the index chosen in plan? Rural Hunter 13:33
Re: non index use on LIKE on a non pattern string Tom Lane 13:57
Re: how to change the index chosen in plan? Tom Lane 14:10
Re: how to change the index chosen in plan? Rural Hunter 14:23
Re: non index use on LIKE on a non pattern string Cédric Villemain 14:31
Re: how to change the index chosen in plan? Kevin Grittner 14:37
Re: how to change the index chosen in plan? Rural Hunter 16:23
Re: how to change the index chosen in plan? Kevin Grittner 16:39
Re: pg 9.1 brings host machine down Konstantin Mikhailov 17:52

June 9, 2012

Thread Author Time
Re: how to change the index chosen in plan? Rural Hunter 02:08
Re: how to change the index chosen in plan? Kevin Grittner 14:39
Re: how to change the index chosen in plan? Kevin Grittner 15:38
partitioning performance question Kevin Kempter 17:58

June 10, 2012

Thread Author Time
Re: pg 9.1 brings host machine down Craig Ringer 03:26
Performance of CLUSTER Mark Thornton 08:20
Re: partitioning performance question Robert Klemme 11:16
Re: pg_dump and thousands of schemas Jeff Janes 23:47

June 11, 2012

Thread Author Time
Re: how to change the index chosen in plan? Rural Hunter 04:46
Re: Tablespaces and query planning Albe Laurenz 07:01
Re: how to change the index chosen in plan? Kevin Grittner 12:07
Re: how to change the index chosen in plan? Rural Hunter 12:55
Re: Performance of CLUSTER Shaun Thomas 13:42
postgres clustering interactions with pg_dump Fitch, Britt 13:55
Re: Performance of CLUSTER Mark Thornton 14:02
Re: Performance of CLUSTER Shaun Thomas 14:14
Re: Performance of CLUSTER Shaun Thomas 14:44
Re: pg_dump and thousands of schemas Jeff Janes 16:32
Re: Performance of CLUSTER Jeff Davis 23:53

June 12, 2012

Thread Author Time
Re: pg_dump and thousands of schemas Tatsuo Ishii 08:54
Performance of pg_basebackup Shaun Thomas 14:54
Re: Performance of pg_basebackup Magnus Hagander 14:57
Re: Performance of pg_basebackup Shaun Thomas 15:00
Re: pg_dump and thousands of schemas 📎 Jeff Janes 15:33

June 13, 2012

Thread Author Time
Re: pg_dump and thousands of schemas Tatsuo Ishii 01:45

June 14, 2012

Thread Author Time
High CPU Usage Siddharth Shah 15:15

June 15, 2012

Thread Author Time
Expected performance of querying 5k records from 4 million records? Anish Kejariwal 16:17
Re: Expected performance of querying 5k records from 4 million records? Josh Berkus 17:44
Re: Expected performance of querying 5k records from 4 million records? Jeff Janes 18:20
Update blocking a select count(*)? Benedict Holland 18:22
Re: Update blocking a select count(*)? Peter Geoghegan 18:32
Re: Update blocking a select count(*)? Kevin Grittner 18:41
Re: Update blocking a select count(*)? Kevin Grittner 18:43
Re: Update blocking a select count(*)? Benedict Holland 18:46
Re: Update blocking a select count(*)? Benedict Holland 18:46
Re: Update blocking a select count(*)? Kevin Grittner 18:54
Re: Update blocking a select count(*)? Kevin Grittner 19:03
Re: Update blocking a select count(*)? 📎 Benedict Holland 19:04
Re: Update blocking a select count(*)? Benedict Holland 19:12
Re: Update blocking a select count(*)? Benedict Holland 19:27
Re: Update blocking a select count(*)? Kevin Grittner 19:32
Re: Update blocking a select count(*)? Benedict Holland 19:45
Re: Update blocking a select count(*)? Kevin Grittner 19:51
Re: Update blocking a select count(*)? Benedict Holland 19:58
Re: Update blocking a select count(*)? Kevin Grittner 20:00
Re: Update blocking a select count(*)? Benedict Holland 20:29
Re: Update blocking a select count(*)? Kevin Grittner 20:38

June 18, 2012

Thread Author Time
correlated exists with join is slow. Віталій Тимчишин 13:47
Re: correlated exists with join is slow. Tom Lane 14:52
Re: correlated exists with join is slow. Kevin Grittner 14:58
Re: correlated exists with join is slow. Віталій Тимчишин 15:02
Re: Expected performance of querying 5k records from 4 million records? Anish Kejariwal 16:39
Re: Expected performance of querying 5k records from 4 million records? Samuel Gendler 16:49
Re: Expected performance of querying 5k records from 4 million records? Josh Berkus 19:08

June 19, 2012

Thread Author Time
pgbouncer - massive overhead? Strange, John W 16:00
Why is a hash join being used? Tim Jacobs 21:34

June 20, 2012

Thread Author Time
index-only scan is missing the INCLUDE feature Eyal Wilde 04:46
Re: scale up (postgresql vs mssql) Eyal Wilde 06:01
Re: Why is a hash join being used? Sergey Konoplev 13:36
Re: scale up (postgresql vs mssql) Andy Colson 13:43
Re: index-only scan is missing the INCLUDE feature Craig Ringer 14:11
SSD, Postgres and safe write cache Michal Szymanski 14:51
Re: scale up (postgresql vs mssql) Merlin Moncure 14:55
Re: pgbouncer - massive overhead? Steve Crawford 15:27
Re: index-only scan is missing the INCLUDE feature Shaun Thomas 15:32
random char or text variable in pgbench philippe.beaudoin 19:51
moving tables Midge Brown 22:27

June 21, 2012

Thread Author Time
Re: moving tables Josh Berkus 00:28
Re: index-only scan is missing the INCLUDE feature Craig Ringer 02:45
Re: moving tables Albe Laurenz 08:34
Can I do better than this heapscan and sort? Andy Halsall 20:07

June 22, 2012

Thread Author Time
Performance of a large array access by position (tested version 9.1.3) Maxim Boguk 07:02
Re: Why is a hash join being used? Kevin Grittner 15:59
Drop statistics? David Kerr 17:07
Re: Drop statistics? Tom Lane 17:27
Re: Drop statistics? David Kerr 18:04
"global/pgstat.stat" corrupt David Kerr 18:46
Re: "global/pgstat.stat" corrupt Tom Lane 19:49
Re: "global/pgstat.stat" corrupt David Kerr 20:11

June 25, 2012

Thread Author Time
Re: index-only scan is missing the INCLUDE feature Cédric Villemain 15:22
Postgres delete performance problem Frits Jalvingh 15:42
Re: Postgres delete performance problem Vitalii Tymchyshyn 15:52
Re: SSD, Postgres and safe write cache Yeb Havinga 16:05
MemSQL the "world's fastest database"? Craig James 16:25
Re: MemSQL the "world's fastest database"? Shaun Thomas 17:03
Re: MemSQL the "world's fastest database"? Kevin Grittner 17:23
Re: MemSQL the "world's fastest database"? Josh Berkus 17:41
Re: MemSQL the "world's fastest database"? gnuoytr 18:02
Re: Postgres delete performance problem Alejandro Carrillo 19:14
Re: MemSQL the "world's fastest database"? Tom Lane 20:15

June 26, 2012

Thread Author Time
Re: Performance of a large array access by position (tested version 9.1.3) Jesper Krogh 05:03
Re: Performance of a large array access by position (tested version 9.1.3) Marc Mamin 07:53
Re: Performance of a large array access by position (tested version 9.1.3) Pavel Stehule 08:04
Re: Performance of a large array access by position (tested version 9.1.3) Marc Mamin 08:19
Re: Performance of a large array access by position (tested version 9.1.3) Pavel Stehule 08:22
Re: Performance of a large array access by position (tested version 9.1.3) Pavel Stehule 09:03
Re: Can I do better than this heapscan and sort? Merlin Moncure 13:36
Re: Can I do better than this heapscan and sort? Merlin Moncure 13:42
[performance] fast reads on a busy server Willy-Bas Loos 22:16

June 27, 2012

Thread Author Time
Re: [performance] fast reads on a busy server Hannu Krosing 07:34
Re: [performance] fast reads on a busy server Willy-Bas Loos 10:01
Re: [performance] fast reads on a busy server Willy-Bas Loos 11:28
Re: [performance] fast reads on a busy server Willy-Bas Loos 11:58
Re: [PERFORM] [performance] fast reads on a busy server Ants Aasma 12:58
Re: [PERFORM] [performance] fast reads on a busy server Willy-Bas Loos 13:23
Re: Can I do better than this heapscan and sort? Merlin Moncure 16:49

June 28, 2012

Thread Author Time
Re: Performance of a large array access by position (tested version 9.1.3) Cédric Villemain 10:22

Browse Archives

Prev | Next
Jump to day: 1 2 4 5 6 7 8 9 10 11 12 13 14 15 18 19 20 21 22 25 26 27 28