Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - May 2008

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

2008-05-01

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)

2008-05-02

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)

2008-05-03

Re: two memory-consuming postgres processes Matthew Wakeling (09:25)
Re: two memory-consuming postgres processes Merlin Moncure (15:07)

2008-05-04

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)

2008-05-05

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)

2008-05-06

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 performanceissue 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 performanceissue Shaun Thomas (18:14)
Re: multiple joins + Order by + LIMIT query performanceissue 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)

2008-05-07

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)

2008-05-08

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)

2008-05-09

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)

2008-05-10

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)

2008-05-11

Re: Re: Re: Re: Query Optimization with Kruskal’s Algorithm Tom Lane (00:30)

2008-05-12

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)

2008-05-13

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)

2008-05-14

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)

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group