pgsql-performance - May 2008

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 28 29 30 31

May 1, 2008

Thread Author Time
Re: Understanding histograms Gregory Stark 00:53
Please ignore ... Marc G. Fournier 04:16
Re: Understanding histograms Tom Lane 04:41
Re: Please ignore ... D'Arcy J.M. Cain 05:23
Re: Please ignore ... Greg Smith 06:55
Re: Please ignore ... Justin 07:21
Re: Please ignore ... Tino Wildenhain 07:35
Re: Postgres replication Fujii Masao 09:33
Re: Please ignore ... D'Arcy J.M. Cain 12:35
Re: Benchmarks WAS: Sun Talks about MySQL Jignesh K. Shah 14:21

May 2, 2008

Thread Author Time
Pros and Cons of 8.3.1 Gauri Kanekar 07:31
Re: Pros and Cons of 8.3.1 Claus Guttesen 07:51
Re: Vacuum statistics chirag.dave 14:09
Re: Please ignore ... Alvaro Herrera 14:29
Re: Pros and Cons of 8.3.1 Joshua D. Drake 16:30
Re: Pros and Cons of 8.3.1 Kevin Grittner 16:35
Re: Pros and Cons of 8.3.1 Kevin Grittner 16:46
Re: Pros and Cons of 8.3.1 Kevin Grittner 16:54
Re: Pros and Cons of 8.3.1 Justin 17:11
two memory-consuming postgres processes Alexy Khrabrov 19:24
Re: two memory-consuming postgres processes Scott Marlowe 19:30
Re: two memory-consuming postgres processes Alexy Khrabrov 19:38
Re: two memory-consuming postgres processes Scott Marlowe 19:53
Re: two memory-consuming postgres processes Tom Lane 20:13
Re: two memory-consuming postgres processes Greg Smith 20:22
Re: two memory-consuming postgres processes Alexy Khrabrov 20:26
Re: two memory-consuming postgres processes Alexy Khrabrov 20:28
Re: two memory-consuming postgres processes Alexy Khrabrov 20:35
Re: two memory-consuming postgres processes Scott Marlowe 20:40
Re: two memory-consuming postgres processes Alexy Khrabrov 20:51
Re: two memory-consuming postgres processes Craig James 21:02
Very slow INFORMATION_SCHEMA Ernesto 21:07
Re: two memory-consuming postgres processes Alexy Khrabrov 21:09
Re: two memory-consuming postgres processes Greg Smith 21:23
Re: two memory-consuming postgres processes Alexy Khrabrov 21:30
Re: two memory-consuming postgres processes PFC 21:30
Re: two memory-consuming postgres processes Kevin Grittner 21:43
Re: two memory-consuming postgres processes Alexy Khrabrov 22:03
Re: Very slow INFORMATION_SCHEMA Tom Lane 22:20
Re: two memory-consuming postgres processes Kevin Grittner 22:29

May 3, 2008

Thread Author Time
Re: two memory-consuming postgres processes Matthew Wakeling 09:25
Re: two memory-consuming postgres processes Merlin Moncure 15:07

May 4, 2008

Thread Author Time
Re: Vacuum statistics Francisco Reyes 02:15
Re: Vacuum statistics Mark Kirkwood 04:43
Re: pgPool query cache Hannes Dorbath 11:13
Fastest way / best practice to calculate "next birthdays" Hannes Dorbath 12:29
Re: Fastest way / best practice to calculate "next birthdays" Joshua D. Drake 16:11
Re: Fastest way / best practice to calculate "next birthdays" Hannes Dorbath 17:50
Re: Fastest way / best practice to calculate "next birthdays" Zoltan Boszormenyi 19:05

May 5, 2008

Thread Author Time
Re: Fastest way / best practice to calculate "next birthdays" Shane Ambler 05:41
Re: Very slow INFORMATION_SCHEMA Mario Weilguni 11:30
Backup causing poor performance - suggestions Campbell, Lance 14:59
Re: Backup causing poor performance - suggestions Scott Marlowe 15:05
Re: Backup causing poor performance - suggestions Campbell, Lance 15:10
Re: Backup causing poor performance - suggestions Scott Marlowe 15:54
Re: Backup causing poor performance - suggestions Craig James 16:10
Re: Backup causing poor performance - suggestions Scott Marlowe 17:05
Re: Backup causing poor performance - suggestions Simon Riggs 17:43
Re: Backup causing poor performance - suggestions Scott Marlowe 19:44
Re: Backup causing poor performance - suggestions Greg Smith 20:03
Re: Backup causing poor performance - suggestions Greg Smith 20:11
Re: Backup causing poor performance - suggestions Scott Marlowe 21:50
RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Craig James 23:33

May 6, 2008

Thread Author Time
Re: Very slow INFORMATION_SCHEMA Tom Lane 00:56
need to speed up query Justin 02:01
Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Scott Marlowe 03:15
Re: need to speed up query Scott Marlowe 03:27
Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Greg Smith 03:59
Re: need to speed up query Gregory Williamson 04:08
Re: need to speed up query Justin 05:36
Re: need to speed up query Justin 05:48
Re: need to speed up query PFC 07:02
plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt 08:21
Re: plan difference between set-returning function with ROWS within IN() and a plain join PFC 09:53
Seqscan problem Vlad Arkhipov 11:14
Re: plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt 11:55
Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Jeff 12:26
Re: need to speed up query Justin 13:22
Re: plan difference between set-returning function with ROWS within IN() and a plain join Tom Lane 14:17
Re: Seqscan problem Tom Lane 14:22
multiple joins + Order by + LIMIT query performance issue Antoine Baudoux 15:03
Re: plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt 15:27
Re: multiple joins + Order by + LIMIT query performance issue Guillaume Smet 15:38
What constitutes a complex query Justin 15:45
Re: What constitutes a complex query Craig James 16:26
Possible Redundancy/Performance Solution Dennis Muhlestein 16:33
Re: need to speed up query PFC 16:35
Re: What constitutes a complex query Scott Marlowe 16:41
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux 16:42
Re: need to speed up query Shaun Thomas 16:43
Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas 16:43
Re: What constitutes a complex query Steve Atkins 16:56
Re: What constitutes a complex query Richard Broersma 16:58
Re: need to speed up query Justin 17:22
Re: What constitutes a complex query Justin 17:23
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux 17:24
Re: What constitutes a complex query Scott Marlowe 17:37
Re: Possible Redundancy/Performance Solution Greg Smith 17:39
Re: need to speed up query Justin 17:41
Re: multiple joins + Order by + LIMIT query performance issue Tom Lane 17:59
Re: multiple joins + Order by + LIMIT query performance issue Heikki Linnakangas 18:04
Re: multiple joins + Order by + LIMIT query performance issue Heikki Linnakangas 18:06
Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas 18:14
Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas 18:24
Re: RAID 10 Benchmark with different I/O schedulers Craig James 18:30
Re: Possible Redundancy/Performance Solution Dennis Muhlestein 18:31
Re: RAID 10 Benchmark with different I/O schedulers Greg Smith 20:21
Re: Possible Redundancy/Performance Solution Greg Smith 20:35
Re: RAID 10 Benchmark with different I/O schedulers Craig James 20:43
pgfouine - commit details? Josh Cole 21:10
Re: Possible Redundancy/Performance Solution Dennis Muhlestein 21:39

May 7, 2008

Thread Author Time
Re: pgfouine - commit details? Guillaume Smet 00:31
Re: Seqscan problem Vlad Arkhipov 00:48
Re: Possible Redundancy/Performance Solution Scott Marlowe 01:57
Re: Possible Redundancy/Performance Solution Greg Smith 02:37
Re: pgfouine - commit details? Josh Cole 05:29
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux 07:23
Re: RAID 10 Benchmark with different I/O schedulers Albe Laurenz *EXTERN* 07:29
Re: multiple joins + Order by + LIMIT query performance issue Matthew Wakeling 10:42
Re: RAID 10 Benchmark with different I/O schedulers Matthew Wakeling 10:46
Re: Possible Redundancy/Performance Solution Dennis Muhlestein 15:36
Query Optimization with Kruskal’s Algorithm Tarcizio Bini 16:28
Backup/Restore of single table in multi TB database John Smith 20:02
Re: Query Optimization with Kruskal’s Algorithm Alexander Staubo 20:09
Re: Backup/Restore of single table in multi TB database David Wilson 20:09
Re: Backup/Restore of single table in multi TB database Joshua D. Drake 20:11
Re: Backup/Restore of single table in multi TB database Joshua D. Drake 20:16
Re: Backup/Restore of single table in multi TB database Simon Riggs 21:28
Re: Backup/Restore of single table in multi TB database Tom Lane 21:41
Re: Backup/Restore of single table in multi TB database John Smith 22:24

May 8, 2008

Thread Author Time
Re: Backup/Restore of single table in multi TB database Simon Riggs 06:25
Ubuntu question Q Master 06:52
Re: Ubuntu question Martijn van Oosterhout 07:01
Re: [GENERAL] Ubuntu question Justin 07:47
Re: Ubuntu question Justin 07:48
Re: [GENERAL] Ubuntu question Justin 07:49
Creating a foreign key Campbell, Lance 16:52
Re: Creating a foreign key Joshua D. Drake 17:00
Re: Creating a foreign key Shaun Thomas 17:18
Re: Creating a foreign key Campbell, Lance 18:11
Creating indexes Rauan Maemirov 19:00
Re: Creating indexes Asche 19:49
Re: Creating indexes Alan Hodgson 19:52
Re: Creating a foreign key PFC 20:02
Re: Creating indexes PFC 20:08

May 9, 2008

Thread Author Time
Re: Creating indexes Rauan Maemirov 05:41
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux 07:18
Re: multiple joins + Order by + LIMIT query performance issue Scott Marlowe 07:53
"append" takes a lot of time in a query Frank Dekervel 08:09
Re: "append" takes a lot of time in a query Tom Lane 14:12

May 10, 2008

Thread Author Time
Re: plan difference between set-returning function with ROWS within IN() and a plain join Merlin Moncure 11:42
Re: Query Optimization with Kruskal’s Algorithm Rauan Maemirov 17:31
Re: Re: Query Optimization with Kruskal’s Algorithm Michael Glaesemann 18:26
Re: Re: Query Optimization with Kruskal’s Algorithm Jonah H. Harris 20:27
Re: Re: Re: Query Optimization with Kruskal’s Algorithm Tom Lane 21:12
Re: Re: Re: Query Optimization with Kruskal’s Algorithm Jonah H. Harris 21:17

May 11, 2008

Thread Author Time
Re: Re: Re: Re: Query Optimization with Kruskal’s Algorithm Tom Lane 00:30

May 12, 2008

Thread Author Time
Partitioning: INSERT 0 0 but want INSERT 0 1 📎 Nikolas Everett 16:18
Re: Partitioning: INSERT 0 0 but want INSERT 0 1 Neil Peter Braggio 22:27

May 13, 2008

Thread Author Time
RAID controllers for Postgresql on large setups Francisco Reyes 02:04
Re: RAID controllers for Postgresql on large setups Joshua D. Drake 02:11
Re: RAID controllers for Postgresql on large setups Chris Ruprecht 02:56
Re: RAID controllers for Postgresql on large setups Francisco Reyes 03:24
Re: Partitioning: INSERT 0 0 but want INSERT 0 1 Nikolas Everett 03:46
Re: RAID controllers for Postgresql on large setups Joshua D. Drake 04:40
Re: RAID controllers for Postgresql on large setups Joshua D. Drake 04:42
Installation Steps to migrate to Postgres 8.3.1 Gauri Kanekar 05:40
Re: RAID controllers for Postgresql on large setups Greg Smith 05:58
Re: Installation Steps to migrate to Postgres 8.3.1 Claus Guttesen 06:42
Re: RAID controllers for Postgresql on large setups Scott Marlowe 08:17
Re: Installation Steps to migrate to Postgres 8.3.1 Scott Marlowe 08:25
Re: RAID controllers for Postgresql on large setups PFC 09:48
Re: RAID controllers for Postgresql on large setups Francisco Reyes 12:00
Re: Installation Steps to migrate to Postgres 8.3.1 Knight, Doug 12:00
Re: RAID controllers for Postgresql on large setups Merlin Moncure 12:07
Re: Installation Steps to migrate to Postgres 8.3.1 Scott Marlowe 14:37
Re: RAID controllers for Postgresql on large setups Vivek Khera 15:01
Re: RAID controllers for Postgresql on large setups Vivek Khera 15:02
Problem with 11 M records table idc danny 16:57
Re: Problem with 11 M records table Bill Moran 17:03
Re: Problem with 11 M records table salman 17:09
Re: Problem with 11 M records table Craig James 17:17
Re: Problem with 11 M records table Craig James 17:57
Re: Problem with 11 M records table Scott Marlowe 18:02
Re: RAID controllers for Postgresql on large setups James Mansion 20:12
Re: RAID controllers for Postgresql on large setups PFC 20:46

May 14, 2008

Thread Author Time
can I move sort to first outer join ? fernando castano 04:40
Regexps - never completing join. Rusty Conover 05:45
Re: Problem with 11 M records table Ramasubramanian G 05:58
Re: Regexps - never completing join. Rusty Conover 07:08
Re: can I move sort to first outer join ? PFC 09:58
postgres overall performance seems to degrade when large SELECT are requested Valentin Bogdanov 10:00
Re: postgres overall performance seems to degrade when large SELECT are requested PFC 11:10
Re: Regexps - never completing join. Rusty Conover 15:33
I/O on select count(*) Doug Eck 20:09
Re: I/O on select count(*) Merlin Moncure 20:38
Re: I/O on select count(*) Doug Eck 21:23
Re: I/O on select count(*) Kevin Grittner 22:11
Update performance degrades over time Subbiah Stalin-XCGF84 22:31
poor row estimates with multi-column joins Robert Treat 22:34

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 28 29 30 31