pgsql-performance - June 2007

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

June 1, 2007

Thread	Author	Time
Seq Scan	Tyler Durden	16:48
Re: Seq Scan	Dan Harris	16:59
Re: Seq Scan	Michael Glaesemann	17:03
Autodetect of software RAID1+0 fails	Craig James	17:57
Re: Autodetect of software RAID1+0 fails	Dimitri	18:51
PostgreSQL not fully utilizing system resources?	Gregory Stewart	19:40
Re: Autodetect of software RAID1+0 fails	Luke Lonergan	19:54
Re: Autodetect of software RAID1+0 fails	Steinar H. Gunderson	21:35

June 2, 2007

Thread	Author	Time
Re: Autodetect of software RAID1+0 fails	mark	00:23
Re: Autodetect of software RAID1+0 fails	Luke Lonergan	05:41
upgraded to pgsql 8.2.4, getting worse performance then 7.4.x 📎	Douglas J Hunley	13:13
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Michael Fuhr	15:21
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Rafael Martinez	15:21
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Tom Lane	15:25
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Stefan Kaltenbrunner	15:31
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Kenneth Marshall	15:45
Re: Append table	Hanu Kurubar	15:52
Re: Append table	Arjen van der Meijden	16:04
Re: Append table	Gregory Stark	16:36
Re: Postgres Benchmark Results	Josh Berkus	19:44
Re: Append table	Hanu Kurubar	19:49

June 3, 2007

Thread	Author	Time
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Douglas J Hunley	17:24
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Douglas J Hunley	17:29
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Luke Lonergan	20:39
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Greg Smith	22:30

June 4, 2007

Thread	Author	Time
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Tom Lane	03:17
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Douglas J Hunley	12:40
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Heikki Linnakangas	12:44
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Luke Lonergan	12:51
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Reid Thompson	14:28
dbt2 NOTPM numbers	Markus Schiltknecht	15:00
Re: dbt2 NOTPM numbers	Heikki Linnakangas	15:09
Re: dbt2 NOTPM numbers	Markus Schiltknecht	15:26
Re: dbt2 NOTPM numbers	PFC	16:47
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x 📎	Douglas J Hunley	17:05
Thousands of tables versus on table?	Thomas Andrews	17:40
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Alvaro Herrera	18:08
Re: Thousands of tables versus on table?	Mark Lewis	18:15
Re: Thousands of tables versus on table? 📎	Thomas Andrews	18:45
Re: Thousands of tables versus on table? 📎	Thomas Andrews	18:46
Re: dbt2 NOTPM numbers 📎	Markus Schiltknecht	18:56
Re: Thousands of tables versus on table?	Gregory Stark	19:43
Re: Thousands of tables versus on table?	Thomas Andrews	19:57
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x 📎	Douglas J Hunley	20:01
Re: Thousands of tables versus on table?	Y Sidhu	20:08
Re: Thousands of tables versus on table?	Thomas Andrews	20:14
Re: Thousands of tables versus on table?	Gregory Stark	20:18
Re: Thousands of tables versus on table?	Scott Marlowe	20:20
Re: Thousands of tables versus on table?	PFC	20:21
Re: dbt2 NOTPM numbers	Heikki Linnakangas	20:22
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Gregory Stark	21:11
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Heikki Linnakangas	21:17
Re: Thousands of tables versus on table?	david	23:33
Re: PostgreSQL not fully utilizing system resources?	Bill Moran	23:50

June 5, 2007

Thread	Author	Time
Re: PostgreSQL not fully utilizing system resources?	Greg Smith	00:57
postgresql running on a virtual cluster	Dave Cramer	02:00
Question about SQL performance	Jason Lustig	03:18
Re: Question about SQL performance	mark	05:23
Re: Question about SQL performance	PFC	05:52
Re: Question about SQL performance	Richard Huxton	08:50
Performance Problem	Gauri Kanekar	09:26
Performance Problem	Gauri Kanekar	09:53
Re: Performance Problem	Steinar H. Gunderson	13:16
Re: Performance Problem	Gregory Stark	13:32
Re: dbt2 NOTPM numbers	Markus Schiltknecht	14:16
Re: dbt2 NOTPM numbers	Heikki Linnakangas	14:21
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Douglas J Hunley	14:25
Re: dbt2 NOTPM numbers	Markus Schiltknecht	14:25
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Douglas J Hunley	14:34
Re: dbt2 NOTPM numbers	Greg Smith	14:42
Re: Thousands of tables versus on table?	Scott Marlowe	16:48
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x 📎	Hanu Kurubar	17:01
Re: Thousands of tables versus on table?	Thomas Andrews	17:04
Re: Thousands of tables versus on table?	Scott Marlowe	17:09
Re: Thousands of tables versus on table?	Gregory Stark	18:55
Re: Thousands of tables versus on table?	Scott Marlowe	19:34
Re: Append table	Chander Ganesan	20:11
Re: Thousands of tables versus on table?	david	20:33
Re: performance drop on 8.2.4, reverting to 8.1.4	Steven Flatt	21:30
Re: performance drop on 8.2.4, reverting to 8.1.4	Steinar H. Gunderson	21:38
Re: Thousands of tables versus on table?	Tom Lane	21:59
Re: Thousands of tables versus on table?	Steinar H. Gunderson	22:06
Re: performance drop on 8.2.4, reverting to 8.1.4	Tom Lane	22:08
Re: Thousands of tables versus on table?	david	22:31
Re: Thousands of tables versus on table?	david	22:58

June 6, 2007

Thread	Author	Time
weird query plan	weiping	03:45
Re: weird query plan	weiping	03:59
different query plan because different limit # (Re: weird query plan)	weiping	07:24
Re: Thousands of tables versus on table?	Heikki Linnakangas	07:29
Re: different query plan because different limit # (Re: weird query plan)	weiping	07:40
Re: different query plan because different limit # (Re: weird query plan)	Gregory Stark	09:21
Re: upgraded to pgsql 8.2.4, getting worse performance then 7.4.x	Douglas J Hunley	14:35
Re: weird query plan	Tom Lane	14:40
Re: Thousands of tables versus on table?	Scott Marlowe	15:07
Re: Thousands of tables versus on table?	Scott Marlowe	15:17
Re: Thousands of tables versus on table?	Craig James	16:23
Re: Thousands of tables versus on table?	Scott Marlowe	16:49
Re: Thousands of tables versus on table?	Craig James	17:32
Re: Thousands of tables versus on table?	Jonah H. Harris	18:01
Re: Thousands of tables versus on table?	Jonah H. Harris	18:15
VERY slow queries at random	Gunther Mayer	19:20
Re: Thousands of tables versus on table?	Andrew Sullivan	19:23
Re: Thousands of tables versus on table?	Andrew Sullivan	19:32
Re: Thousands of tables versus on table?	Jonah H. Harris	19:40
control of benchmarks (was: Thousands of tables)	Andrew Sullivan	19:40
Re: VERY slow queries at random	Andrew Sullivan	19:56
Re: control of benchmarks (was: Thousands of tables)	Jonah H. Harris	19:57
Re: Thousands of tables versus on table?	Craig James	20:13
Re: Thousands of tables versus on table?	Jonah H. Harris	20:20
Is this true?	Chris Hoover	20:58
Re: VERY slow queries at random	Scott Marlowe	21:27
Re: Is this true?	Jeff Davis	21:37
reclaiming disk space after major updates	Dan Harris	22:04
Re: LIKE search and performance	James Mansion	22:23
Weird 8.2.4 performance	Kurt Overberg	23:27

June 7, 2007

Thread	Author	Time
Re: Weird 8.2.4 performance	Mark Kirkwood	00:01
Re: Weird 8.2.4 performance	Michael Glaesemann	00:14
Re: LIKE search and performance	mark	03:33
Re: Thousands of tables versus on table?	david	05:22
Re: VERY slow queries at random	Kristo Kaiv	07:09
copy from performance on large tables with indexes	Marc Mamin	09:17
Re: Weird 8.2.4 performance	Richard Huxton	09:23
Re: Weird 8.2.4 performance	Steinar H. Gunderson	09:35
Re: Weird 8.2.4 performance	Steinar H. Gunderson	09:43
Re: Weird 8.2.4 performance	Mark Kirkwood	11:12
Re: Weird 8.2.4 performance	Kurt Overberg	11:18
Re: Weird 8.2.4 performance	Steinar H. Gunderson	11:28
Re: Weird 8.2.4 performance	Tom Lane	13:32
Re: {Spam} Re: Weird 8.2.4 performance	Dimitri Fontaine	13:54
Re: VERY slow queries at random	Gunther Mayer	14:22
Re: VERY slow queries at random	Gunther Mayer	15:32
Re: VERY slow queries at random	Gunther Mayer	15:38
Re: VERY slow queries at random	Andrew Sullivan	15:45
Re: VERY slow queries at random	Alvaro Herrera	15:58
How Are The Variables Related?	Y Sidhu	16:47
Re: performance drop on 8.2.4, reverting to 8.1.4	Steven Flatt	17:11
Getting Slow	Joe Lester	17:48
Re: Getting Slow	Andrew Sullivan	18:37
Re: Getting Slow	Steinar H. Gunderson	18:50
Re: Getting Slow	Alvaro Herrera	18:58
Re: reclaiming disk space after major updates	Andrew Sullivan	19:20
Re: Getting Slow	Greg Smith	19:26
Re: VERY slow queries at random	Greg Smith	19:42
Best way to delete unreferenced rows?	Tyrrill, Ed	20:02
Re: reclaiming disk space after major updates	Dan Harris	21:26
Re: Best way to delete unreferenced rows?	Craig James	22:50
Re: Weird 8.2.4 performance	Mark Kirkwood	23:04
Re: Weird 8.2.4 performance	Joshua D. Drake	23:09

June 8, 2007

Thread	Author	Time
Re: performance drop on 8.2.4, reverting to 8.1.4	Tom Lane	01:11
Re: performance drop on 8.2.4, reverting to 8.1.4	Alvaro Herrera	01:22
Re: performance drop on 8.2.4, reverting to 8.1.4	Tom Lane	01:31
Re: Getting Slow	Tom Lane	01:46
Re: Getting Slow	Alvaro Herrera	02:24
Database size	choksi	08:22
Re: VERY slow queries at random	Kristo Kaiv	08:27
Re: reclaiming disk space after major updates	Andrew Sullivan	14:03
Re: [ADMIN] reclaiming disk space after major updates	Dan Harris	14:29
Re: [ADMIN] reclaiming disk space after major updates	Andrew Sullivan	15:10
Please help me understand these numbers	Chris Hoover	15:44
Re: Please help me understand these numbers	Bill Moran	16:09
How much ram is too much	Dave Cramer	16:31
Re: Best way to delete unreferenced rows? 📎	Tyrrill, Ed	16:45
Re: How much ram is too much	Guy Rouillier	16:46
Re: How much ram is too much	Ben	16:52
Re: dbt2 NOTPM numbers	Mark Wong	17:01
Re: Please help me understand these numbers	Chris Hoover	17:05
Re: How much ram is too much	Dave Cramer	17:08
Re: How much ram is too much	david	17:30
Re: Please help me understand these numbers	Bill Moran	17:37
Re: How much ram is too much	Joshua D. Drake	17:38
[OT] Re: How much ram is too much	Zoltan Boszormenyi	17:38
Re: Please help me understand these numbers	Chris Hoover	17:52
Re: [OT] Re: How much ram is too much	Joshua D. Drake	18:10
Re: [OT] Re: How much ram is too much	Dave Cramer	18:52
Re: [OT] Re: How much ram is too much	Zoltan Boszormenyi	18:54
Re: [OT] Re: How much ram is too much	mark	19:00
Re: [OT] Re: How much ram is too much	Zoltan Boszormenyi	19:14
Re: How much ram is too much	Guy Rouillier	19:41
Re: [OT] Re: How much ram is too much	Andreas Kostyrka	21:43

June 11, 2007

Thread	Author	Time
Re: Vacuum takes forever	Jim Nasby	02:51
Re: dbt2 NOTPM numbers	Jim Nasby	03:08
Re: How much ram is too much	Jim Nasby	03:11
pg_statistic doesnt contain details for specific table	Nimesh Satam	08:50
Re: pg_statistic doesnt contain details for specific table	Heikki Linnakangas	08:54
Re: pg_statistic doesnt contain details for specific table	Nimesh Satam	08:58
Re: How much ram is too much	Dave Cramer	10:55
Variable (degrading) perfomance 📎	Vladimir Stankovic	13:04
Re: pg_statistic doesnt contain details for specific table	Michael Fuhr	13:29
Re: pg_statistic doesnt contain details for specific table	Nimesh Satam	13:52
Re: pg_statistic doesnt contain details for specific table	Michael Fuhr	14:34
Re: How much ram is too much	Dave Cramer	15:09
test / live environment, major performance difference	Christo Du Preez	15:10
Re: dbt2 NOTPM numbers	Markus Schiltknecht	15:30
Re: How much ram is too much	Andrew Sullivan	15:34
Re: dbt2 NOTPM numbers	Heikki Linnakangas	15:34
Re: dbt2 NOTPM numbers	Markus Schiltknecht	15:44
Re: Best way to delete unreferenced rows?	Craig James	15:44
Re: test / live environment, major performance difference	Ansgar -59cobalt- Wiechers	15:58
Re: test / live environment, major performance difference	Dave Dutcher	16:16
Variable (degrading) performance 📎	Vladimir Stankovic	17:21

Browse Archives

Prev | Next