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

Dec. 1, 2005

Thread Author Time
Re: RES: pg_dump slow Ron 01:14
Query is 800 times slower when running in function! Ralph Mason 01:17
Re: Query is 800 times slower when running in function! Tom Lane 04:58
About the relation between fragmentation of file and VACUUM Tatsumi Abe 05:50
Re: About the relation between fragmentation of file and Richard Huxton 09:59
Re: About the relation between fragmentation of file and Michael Stone 12:00
Re: About the relation between fragmentation of file and David Lang 12:11
pg_dump slow Franklin Haut 12:29
slow insert into very large table Wolfgang Gehner 12:33
Re: About the relation between fragmentation of file and VACUUM Bill McGonigle 12:44
15,000 tables Michael Riess 13:42
Re: slow insert into very large table Andreas Pflug 14:00
Re: 15,000 tables David Lang 14:16
Re: 15,000 tables Michael Riess 14:51
Re: 15,000 tables Michael Riess 14:56
filesystem performance with lots of files David Lang 15:09
Re: [PERFORM] 15,000 tables Ing. Jhon Carrillo // Caracas, Venezuela 15:45
Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 15:49
Re: slow insert into very large table Tom Lane 15:50
Re: 15,000 tables Tom Lane 16:03
Re: 15,000 tables Michael Riess 16:04
Re: 15,000 tables Jaime Casanova 16:15
Re: pg_dump slow Merlin Moncure 16:15
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane 16:26
Re: 15,000 tables Michael Riess 16:28
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 16:30
Re: 15,000 tables Guido Neitzer 16:30
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane 16:34
Re: 15,000 tables me 17:07
Re: 15,000 tables Chris Browne 17:09
pg_stat* values ... Marc G. Fournier 17:31
Insert performance slows down in large batch Jeremy Haile 17:49
COPY into table too slow with index Rick Schumeyer 17:58
Re: filesystem performance with lots of files Qingqing Zhou 18:03
Re: 15,000 tables Gavin M. Roy 18:07
Re: 15,000 tables Tino Wildenhain 18:40
Re: 15,000 tables Ron 18:48
Re: 15,000 tables Gavin M. Roy 18:49
Re: 15,000 tables Tom Lane 18:57
Re: 15,000 tables Gavin M. Roy 19:08
Re: Insert performance slows down in large batch Tom Lane 19:19
Re: 15,000 tables Michael Riess 19:34
Re: 15,000 tables Jaime Casanova 19:40
Re: 15,000 tables Merlin Moncure 20:28
Re: 15,000 tables Scott Marlowe 21:15
Re: 15,000 tables Alvaro Herrera 21:16
Re: COPY into table too slow with index: now an I/O question Rick Schumeyer 22:18

Dec. 2, 2005

Thread Author Time
Database restore speed Steve Oualline 00:27
Re: COPY into table too slow with index: now an I/O Luke Lonergan 02:26
Re: COPY into table too slow with index: now an I/O Tom Lane 03:10
Re: COPY into table too slow with index: now an I/O question Rick Schumeyer 03:26
Re: 15,000 tables Craig A. James 03:47
Re: COPY into table too slow with index: now an I/O Luke Lonergan 05:15
Re: Database restore speed Luke Lonergan 06:11
Re: filesystem performance with lots of files David Lang 07:07
Re: Open request for benchmarking input (fwd) David Lang 07:35
Re: 15,000 tables David Lang 07:46
Re: Database restore speed David Lang 07:49
Re: filesystem performance with lots of files Qingqing Zhou 07:49
Re: filesystem performance with lots of files David Lang 08:04
Re: Database restore speed Luke Lonergan 08:06
Re: 15,000 tables Ron 08:15
Re: 15,000 tables Michael Stone 13:02
Re: COPY into table too slow with index: now an I/O Michael Stone 13:04
Network permormance under windows Teracat 13:05
Re: 15,000 tables Alex Stapleton 14:16
Re: 15,000 tables Alex Stapleton 14:20
Re: 15,000 tables Jan Wieck 15:16
Re: Network permormance under windows Merlin Moncure 16:13
Re: pg_dump slow Merlin Moncure 16:28
Re: pg_dump slow Merlin Moncure 16:33
Re: Open request for benchmarking input (fwd) Qingqing Zhou 17:19
Re: Network permormance under windows Josep Maria Pinyol Fontseca 17:24
two disks - best way to use them? Rick Schumeyer 18:58
Re: two disks - best way to use them? Ron 20:05
Re: Database restore speed Stephen Frost 20:18
Re: Network permormance under windows me 20:26
Re: Network permormance under windows Qingqing Zhou 20:43
Re: Database restore speed Luke Lonergan 20:48
Re: Network permormance under windows Josep Maria Pinyol Fontseca 21:08
Re: 15,000 tables Andrew Sullivan 21:08
Re: Database restore speed Stephen Frost 21:19
Re: Database restore speed Luke Lonergan 21:24
Re: Database restore speed Luke Lonergan 21:29
Re: Database restore speed Michael Stone 21:46
Re: 15,000 tables Francisco Reyes 23:00
Re: Database restore speed Tom Lane 23:00
15,000 tables - next step Michael Riess 23:01
Re: Database restore speed Luke Lonergan 23:02
Small table or partial index? Francisco Reyes 23:28

Dec. 3, 2005

Thread Author Time
Re: Database restore speed Mitch Skinner 03:26
Re: Database restore speed Luke Lonergan 04:03
Re: Database restore speed David Lang 09:07
Re: Database restore speed David Lang 09:12
Re: Database restore speed David Lang 09:22
Re: Database restore speed David Lang 09:32
Re: Database restore speed David Lang 09:38
Re: Database restore speed Simon Riggs 12:38
Re: 15,000 tables - next step Jan Wieck 15:51
Re: 15,000 tables - next step Michael Riess 16:20
Re: 15,000 tables - next step Alvaro Herrera 16:26
Re: 15,000 tables - next step Michael Riess 16:41
Re: 15,000 tables - next step Jaime Casanova 18:45
Re: 15,000 tables - next step Jan Wieck 19:32
Re: Database restore speed Luke Lonergan 19:42
Re: Database restore speed Tom Lane 20:32
Re: Database restore speed Luke Lonergan 21:29
Faster db architecture for a twisted table. Rodrigo Madera 23:00
Re: Database restore speed Mitch Skinner 23:29
Re: Faster db architecture for a twisted table. Andreas Pflug 23:57

Dec. 4, 2005

Thread Author Time
Re: Faster db architecture for a twisted table. Mitchell Skinner 00:02
Re: Database restore speed David Lang 01:17
Re: Faster db architecture for a twisted table. Hélder M. Vieira 01:33
Re: Very slow queries - please help Thomas F. O'Connell 06:40
Re: 15,000 tables - next step William Yu 09:21
Re: 15,000 tables - next step Michael Riess 09:33
Re: Faster db architecture for a twisted table. Andreas Pflug 11:56
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 13:24
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane 18:31
Re: Faster db architecture for a twisted table. Klint Gore 22:24
Dividing up a single 250GB RAID10 server for postgres Rory Campbell-Lange 23:49

Dec. 5, 2005

Thread Author Time
Query Fails with error calloc - Cannot alocate memory Howard Oblowitz 07:42
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 10:28
BLCKSZ Olleg Samoylov 13:47
Re: two disks - best way to use them? Olleg Samoylov 13:56
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane 14:32
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 14:44
Re: BLCKSZ Tom Lane 15:02
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane 15:11
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 15:40
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny 15:45
Re: two disks - best way to use them? Thomas Harold 15:48
Re: two disks - best way to use them? David Lang 16:15
Re: Best hardware Mirjam (sent by Nabble.com) 16:24
Re: two disks - best way to use them? Thomas Harold 16:45
Performance degradation after successive UPDATE's Assaf Yaari 17:05
Re: Performance degradation after successive UPDATE's Bruno Wolff III 20:36
Re: BLCKSZ Olleg 21:32
Missed index opportunity for outer join? rm_pg 22:13
Re: Missed index opportunity for outer join? Tom Lane 22:38
Re: Missed index opportunity for outer join? rm_pg 23:05

Dec. 6, 2005

Thread Author Time
Re: BLCKSZ Alvaro Herrera 00:07
Re: BLCKSZ Ron 01:21
Re: 15,000 tables - next step Jan Wieck 03:07
Re: two disks - best way to use them? David Lang 03:54
Re: BLCKSZ Tom Lane 05:51
Re: two disks - best way to use them? Thomas Harold 05:52
Re: two disks - best way to use them? Ron 08:12
need help Jenny 08:38
Re: need help Tino Wildenhain 08:54
Re: Performance degradation after successive UPDATE's Assaf Yaari 09:08
Memory Leakage Problem Kathy Lo 09:22
LVM and Postgres Rory Campbell-Lange 09:38
need help (not anymore) Jenny 09:41
Can this query go faster??? Joost Kraaijeveld 09:43
Re: Can this query go faster??? Michael Riess 09:51
Re: Performance degradation after successive UPDATE's Pandurangan R S 09:52
Re: Can this query go faster??? Csaba Nagy 09:52
Re: Can this query go faster??? Markus Wollny 09:54
Re: Can this query go faster??? Joost Kraaijeveld 10:21
Re: Can this query go faster??? Tino Wildenhain 10:32
Re: BLCKSZ Olleg 10:40
Re: need help Alban Hertroys 10:45
Re: BLCKSZ Steinar H. Gunderson 10:59
Re: Can this query go faster??? Joost Kraaijeveld 11:21
Re: Can this query go faster??? Tino Wildenhain 11:36
Re: BLCKSZ David Lang 11:39
Re: Can this query go faster??? Joost Kraaijeveld 12:20
Re: Can this query go faster??? Tino Wildenhain 12:30
Re: Can this query go faster??? Csaba Nagy 12:32
Re: Performance degradation after successive UPDATE's Jan Wieck 12:34
Re: Can this query go faster??? Ron 13:41
Re: Can this query go faster??? Merlin Moncure 13:58
Re: Memory Leakage Problem Tom Lane 14:45
Re: two disks - best way to use them? Thomas Harold 16:00
postgresql performance tuning Ameet Kini 16:14
Re: 8.1 count(*) distinct: IndexScan/SeqScan Pailloncy Jean-Gerard 16:19
TSearch2 vs. Apache Lucene Joshua Kramer 16:47
Re: Missed index opportunity for outer join? Tom Lane 16:57
Re: TSearch2 vs. Apache Lucene Michael Riess 16:59
Re: TSearch2 vs. Apache Lucene Russell Garrett 17:00
Re: TSearch2 vs. Apache Lucene Oleg Bartunov 17:14
Re: TSearch2 vs. Apache Lucene Bruce Momjian 17:27
postgresql performance tuning Ameet Kini 17:44
Re: Memory Leakage Problem Scott Marlowe 17:48
Re: TSearch2 vs. Apache Lucene Tom Lane 18:02
Re: postgresql performance tuning Tom Lane 18:03
Re: TSearch2 vs. Apache Lucene Michael Riess 18:28
Re: TSearch2 vs. Apache Lucene Bruce Momjian 18:32
Re: postgresql performance tuning Vivek Khera 18:33
Re: High context switches occurring Anjan Dave 19:04
Re: High context switches occurring Vivek Khera 19:25
Re: postgresql performance tuning Vivek Khera 20:07
Re: LVM and Postgres August Zajonc 20:12
Re: Missed index opportunity for outer join? Ron Mayer 20:17
Join the same row Edison Azzi 20:22
Re: Missed index opportunity for outer join? Tom Lane 20:33
Re: Performance degradation after successive UPDATE's Bruno Wolff III 20:44
Re: postgresql performance tuning Alan Stange 20:48
Re: Can this query go faster??? Bruno Wolff III 20:50

Browse Archives

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