pgsql-performance - December 2005

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