pgsql-performance - July 2009

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 13 14 15 16 17 18 19 20 21 22 23 24 26 27 28 29 30 31

July 1, 2009

Thread Author Time
Re: random slow query Scott Carey 00:11
Re: random slow query Mike Ivanov 00:58
- Slow Query Rui Carvalho 09:40
Re: - Slow Query Mike Ivanov 16:39
Re: - Slow Query justin 16:41
Re: - Slow Query Mike Ivanov 17:12
Re: - Slow Query Rui Carvalho 17:37
Re: - Slow Query Scott Marlowe 17:42
Re: - Slow Query Tom Lane 17:52
Re: - Slow Query Mike Ivanov 17:53
Re: - Slow Query Scott Marlowe 18:00
Re: - Slow Query Tom Lane 18:07

July 2, 2009

Thread Author Time
regression ? 8.4 do not apply One-Time Filter to subquery Sergey Burladyan 00:08
Re: slow DELETE on 12 M row table Janet Jacobsen 22:48

July 3, 2009

Thread Author Time
Re: slow DELETE on 12 M row table Scott Marlowe 00:21
Most effective insert or replace Sergei Politov 11:06
Re: Most effective insert or replace Matthew Wakeling 11:20
Re: - Slow Query Віталій Тимчишин 11:22
Re: - Slow Query Віталій Тимчишин 11:29

July 4, 2009

Thread Author Time
Six PostgreSQL questions from a pokerplayer Patvs 18:51

July 6, 2009

Thread Author Time
Re: Six PostgreSQL questions from a pokerplayer Craig Ringer 05:33
Bundling postgreSQL with my Java application Saurabh Dave 05:48
Re: Bundling postgreSQL with my Java application Mark Mielke 06:00
Re: Six PostgreSQL questions from a pokerplayer Mark Kirkwood 06:13
Re: Bundling postgreSQL with my Java application Guillaume Cottenceau 07:07
Re: Bundling postgreSQL with my Java application Saurabh Dave 07:17
Re: Bundling postgreSQL with my Java application Mark Mielke 08:27
Re: Six PostgreSQL questions from a pokerplayer Scott Carey 08:43
Re: Six PostgreSQL questions from a pokerplayer Scott Carey 08:47
Re: Six PostgreSQL questions from a pokerplayer Greg Stark 09:40
Re: Six PostgreSQL questions from a pokerplayer Stephen Frost 10:23
Re: Six PostgreSQL questions from a pokerplayer Greg Smith 13:26
Re: Six PostgreSQL questions from a pokerplayer Dave Page 13:48
Re: Six PostgreSQL questions from a pokerplayer Mark Mielke 19:27
Re: Bundling postgreSQL with my Java application 📎 justin 23:16

July 7, 2009

Thread Author Time
Re: Six PostgreSQL questions from a pokerplayer Craig Ringer 04:51
Re: Bundling postgreSQL with my Java application Saurabh Dave 05:11
Re: Six PostgreSQL questions from a pokerplayer Scott Marlowe 05:51
Re: Bundling postgreSQL with my Java application Scott Marlowe 05:59
Re: Speeding up a query. Simon Riggs 09:38
Re: Speeding up a query. Hartman, Matthew 12:32
Re: Bundling postgreSQL with my Java application Kevin Grittner 13:40

July 8, 2009

Thread Author Time
Re: [PERFORM] Postgres Clustering Tim Uckun 02:26
Performance difference between IN(...) and ANY(...) operator Gnanam 06:50
Maximum size of an XML document Franclin Foping 16:27

July 9, 2009

Thread Author Time
Data caching Martin Chlupac 10:29
Re: Data caching Richard Huxton 10:52
Sorting by an arbitrary criterion Craig James 16:26
embedded sql regression from 8.2.4 to 8.3.7 Haszlakiewicz, Eric 16:31
Re: Sorting by an arbitrary criterion Grzegorz Jaśkiewicz 16:35
Huge difference in query performance between 8.3 and 8.4 (possibly) Robin Houston 16:35
Re: Sorting by an arbitrary criterion Tom Lane 16:38
Re: Sorting by an arbitrary criterion Kevin Grittner 16:39
Re: Sorting by an arbitrary criterion Alexander Staubo 16:39
Re: Huge difference in query performance between 8.3 and 8.4 (possibly) Alvaro Herrera 17:02
Re: Huge difference in query performance between 8.3 and 8.4 (possibly) Tom Lane 17:09
Re: Huge difference in query performance between 8.3 and 8.4 (possibly) Hartman, Matthew 17:36
Re: Sorting by an arbitrary criterion hubert depesz lubaczewski 18:11
Re: Sorting by an arbitrary criterion Hartman, Matthew 18:13
Re: Sorting by an arbitrary criterion Grzegorz Jaśkiewicz 20:25
Poor query performance Alex 21:34
Re: Poor query performance Alex 21:35

July 10, 2009

Thread Author Time
Re: embedded sql regression from 8.2.4 to 8.3.7 Albe Laurenz 09:05
Cost performace question paulo matadr 14:39
Re: Cost performace question Kevin Grittner 14:51
Re: autovacuum hung? Brian Cox 18:11
Res: Cost performace question paulo matadr 19:33

July 13, 2009

Thread Author Time
Performance comparison between Postgres and Greenplum Suvankar Roy 11:23
Re: Res: Cost performace question Matthew Wakeling 12:21
Very big insert/join performance problem (bacula) Marc Cousin 13:40
Re: Very big insert/join performance problem (bacula) SystemManagement 14:37
Re: Very big insert/join performance problem (bacula) Marc Cousin 14:51
Re: Very big insert/join performance problem (bacula) Andres Freund 15:06
Re: embedded sql regression from 8.2.4 to 8.3.7 Haszlakiewicz, Eric 15:51
Re: embedded sql regression from 8.2.4 to 8.3.7 Haszlakiewicz, Eric 18:24
Poor overall performance unless regular VACUUM FULL Wayne Conrad 19:31
Odd performance / query plan with bitmasked field as opposed to equality Frank Joerdens 20:46

July 14, 2009

Thread Author Time
Re: Very big insert/join performance problem (bacula) Marc Cousin 05:54
Re: Very big insert/join performance problem (bacula) Richard Huxton 08:15
Re: Very big insert/join performance problem (bacula) Richard Huxton 08:23
Re: Very big insert/join performance problem (bacula) Marc Cousin 09:16
Re: Very big insert/join performance problem (bacula) Marc Cousin 09:22
Re: embedded sql regression from 8.2.4 to 8.3.7 Albe Laurenz 09:39
BUG #4919: CREATE USER command slows down system performance Lauris Ulmanis 12:39
CREATE USER command slows down when user count per server reaches up to 500 000 Lauris Ulmanis 13:14
Re: BUG #4919: CREATE USER command slows down system performance Heikki Linnakangas 15:09

July 15, 2009

Thread Author Time
Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning 03:10
Re: Performance comparison between Postgres and Greenplum Scott Marlowe 03:40
Re: Poor overall performance unless regular VACUUM FULL Scott Marlowe 04:52
Re: Poor overall performance unless regular VACUUM FULL David Wilson 04:53
Re: Performance comparison between Postgres and Greenplum Suvankar Roy 05:33
Re: Poor query performance Greg Stark 06:52
Re: Poor query performance Alex 07:50
Re: Poor query performance Greg Stark 08:22
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Craig Ringer 08:26
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Craig Ringer 08:27
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Greg Stark 08:37
Re: Poor query performance Alex 08:42
Strange memory behavior with rails - caching in connection? Alex 08:44
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning 08:51
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning 09:05
Re: Performance comparison between Postgres and Greenplum Scott Marlowe 09:30
Re: Performance comparison between Postgres and Greenplum Suvankar Roy 09:39
Re: BUG #4919: CREATE USER command slows down system performance Lauris Ulmanis 10:31
Re: Very big insert/join performance problem (bacula) Marc Cousin 11:37
Re: Performance comparison between Postgres and Greenplum Alex Goncharov 12:37
Re: Poor overall performance unless regular VACUUM FULL Wayne Conrad 12:51
Re: Performance comparison between Postgres and Greenplum Suvankar Roy 13:02
Re: Performance comparison between Postgres and Greenplum Alex Goncharov 13:18
Re: Very big insert/join performance problem (bacula) Alvaro Herrera 13:45
Re: Very big insert/join performance problem (bacula) Marc Cousin 13:53
Re: BUG #4919: CREATE USER command slows down system performance Alvaro Herrera 14:02
Re: BUG #4919: CREATE USER command slows down system performance toruvinn 14:21
Re: Poor overall performance unless regular VACUUM FULL Scott Marlowe 14:30
Re: BUG #4919: CREATE USER command slows down system performance Alvaro Herrera 14:47
Re: BUG #4919: CREATE USER command slows down system performance Tom Lane 14:59
Re: cluster index on a table Ibrahim Harrani 15:04
Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Marko Kreen 15:10
Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance David Wilson 15:16
Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Tom Lane 15:30
Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Marko Kreen 15:31
Re: Performance comparison between Postgres and Greenplum Scott Mead 15:33
Re: CREATE USER command slows down when user count per server reaches up to 500 000 Haszlakiewicz, Eric 21:38
Re: Poor overall performance unless regular VACUUM FULL Wayne Conrad 22:03
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Mike Ivanov 22:37
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Andres Freund 22:51
Re: Very big insert/join performance problem (bacula) Devin Ben-Hur 23:56

July 16, 2009

Thread Author Time
Re: Poor overall performance unless regular VACUUM FULL Scott Carey 00:30
Re: cluster index on a table Scott Carey 00:33
Re: Poor overall performance unless regular VACUUM FULL Scott Marlowe 00:40
Re: Very big insert/join performance problem (bacula) Scott Carey 00:43
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning 00:53
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning 01:11
Re: Performance comparison between Postgres and Greenplum Greg Smith 01:14
Re: Performance comparison between Postgres and Greenplum Greg Smith 01:17
Re: cluster index on a table Justin Pitts 02:17
Concurrency issue under very heay loads Raji Sridar (raji) 04:59
Re: [PERFORM] Concurrency issue under very heay loads ramasubramanian 05:19
Re: Very big insert/join performance problem (bacula) Marc Cousin 05:20
Re: Concurrency issue under very heay loads Greenhorn 05:30
Re: Concurrency issue under very heay loads John R Pierce 05:34
Re: [PERFORM] Concurrency issue under very heay loads Scott Marlowe 06:11
Re: Very big insert/join performance problem (bacula) Marc Cousin 07:41
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Andres Freund 07:45
Re: [PERFORM] Concurrency issue under very heay loads Albe Laurenz 09:15
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning 09:30
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Andres Freund 09:33
Re: [PERFORM] Concurrency issue under very heay loads Allan Kamau 09:44
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning 09:46
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Andres Freund 09:52
Re: Concurrency issue under very heay loads Bill Moran 11:11
Re: BUG #4919: CREATE USER command slows down systemperformance Lauris Ulmanis 11:49
Re: cluster index on a table Scott Mead 12:34
Re: cluster index on a table Scara Maccai 13:33
Re: Poor overall performance unless regular VACUUM FULL Wayne Conrad 15:00
Re: cluster index on a table Scott Carey 17:35
Re: cluster index on a table Justin Pitts 17:52
Incr/Decr Integer William Scott Jordan 17:56
Re: cluster index on a table Scott Carey 18:21
Re: [PERFORM] Incr/Decr Integer Andres Freund 18:30
Re: cluster index on a table Justin Pitts 18:35
Re: Incr/Decr Integer Richard Huxton 18:46
Re: cluster index on a table Kevin Grittner 19:15
Re: cluster index on a table Scott Carey 19:18
Re: Incr/Decr Integer Kevin Grittner 19:19
Re: cluster index on a table Greg Stark 19:46
Re: cluster index on a table Scott Carey 20:06
Re: Very big insert/join performance problem (bacula) Kevin Grittner 20:07
Re: cluster index on a table Kevin Grittner 20:14
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Dimitri Fontaine 20:43
Re: cluster index on a table Greg Stark 20:49
Re: Very big insert/join performance problem (bacula) Marc Cousin 20:50
Re: cluster index on a table Greg Stark 21:01
Re: Concurrency issue under very heay loads Greg Smith 21:03
Re: [PERFORM] Incr/Decr Integer William Scott Jordan 21:11
Re: cluster index on a table Ibrahim Harrani 21:16
Re: [PERFORM] Incr/Decr Integer William Scott Jordan 21:20
Re: [PERFORM] Incr/Decr Integer Andres Freund 21:27
Re: Very big insert/join performance problem (bacula) Kevin Grittner 21:54
Re: Very big insert/join performance problem (bacula) Marc Cousin 22:03
Re: Very big insert/join performance problem (bacula) Devin Ben-Hur 22:29
Re: Very big insert/join performance problem (bacula) Kevin Grittner 22:30

July 17, 2009

Thread Author Time
Re: cluster index on a table Scott Carey 00:02
Re: cluster index on a table Greg Stark 00:27
Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Mike Ivanov 01:25
Re: cluster index on a table Scott Carey 03:07
Re: Performance comparison between Postgres and Greenplum Scott Marlowe 06:24
Re: cluster index on a table Scara Maccai 06:45
Re: cluster index on a table Scara Maccai 07:22
Re: Strange memory behavior with rails - caching in connection? Scott Marlowe 09:06
Re: cluster index on a table [email protected] 13:25
Calling conventions Matthew Wakeling 13:40
Re: cluster index on a table Kevin Grittner 14:14
Re: Concurrency issue under very heay loads Craig Ringer 14:29
Re: [PERFORM] Concurrency issue under very heay loads Craig Ringer 14:32
Re: cluster index on a table Scara Maccai 14:36
Re: cluster index on a table Kevin Grittner 15:26
Re: Calling conventions Peter Eisentraut 15:32
Re: Calling conventions Matthew Wakeling 16:09
Re: Calling conventions Tom Lane 16:34

Browse Archives

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