Skip site navigation (1)
Skip section navigation (2)
382 messages
14 May 2008
poor row estimates with multi-column joins Robert Treat (22:35)
Re: I/O on select count(*) Kevin Grittner (22:11)
Re: I/O on select count(*) Doug Eck (21:23)
Re: I/O on select count(*) Merlin Moncure (20:38)
I/O on select count(*) Doug Eck (20:11)
Re: Regexps - never completing join. Rusty Conover (15:37)
Re: postgres overall performance seems to degrade when large SELECT are requested PFC (11:04)
postgres overall performance seems to degrade when large SELECT are requested Valentin Bogdanov (10:07)
Re: can I move sort to first outer join ? PFC (09:52)
Re: Regexps - never completing join. Rusty Conover (07:08)
Regexps - never completing join. Rusty Conover (06:11)
Re: Problem with 11 M records table Ramasubramanian G (06:09)
can I move sort to first outer join ? fernando castano (04:53)
13 May 2008
Re: RAID controllers for Postgresql on large setups James Mansion (20:09)
Re: Problem with 11 M records table Scott Marlowe (18:02)
Re: Problem with 11 M records table Craig James (17:57)
Re: Problem with 11 M records table Craig James (17:17)
Re: Problem with 11 M records table salman (17:09)
Re: Problem with 11 M records table Bill Moran (17:05)
Problem with 11 M records table idc danny (16:57)
Re: RAID controllers for Postgresql on large setups Vivek Khera (15:09)
Re: RAID controllers for Postgresql on large setups Vivek Khera (15:08)
Re: Installation Steps to migrate to Postgres 8.3.1 Scott Marlowe (14:50)
Re: Installation Steps to migrate to Postgres 8.3.1 Knight, Doug (12:15)
Re: RAID controllers for Postgresql on large setups Merlin Moncure (12:10)
Re: RAID controllers for Postgresql on large setups Francisco Reyes (12:01)
Re: RAID controllers for Postgresql on large setups PFC (09:54)
Re: Installation Steps to migrate to Postgres 8.3.1 Scott Marlowe (08:25)
Re: RAID controllers for Postgresql on large setups Scott Marlowe (08:17)
Re: Installation Steps to migrate to Postgres 8.3.1 Claus Guttesen (06:49)
Installation Steps to migrate to Postgres 8.3.1 Gauri Kanekar (06:02)
Re: RAID controllers for Postgresql on large setups Greg Smith (05:59)
Re: RAID controllers for Postgresql on large setups Joshua D. Drake (04:42)
Re: RAID controllers for Postgresql on large setups Joshua D. Drake (04:40)
Re: RAID controllers for Postgresql on large setups Chris Ruprecht (04:10)
Re: Partitioning: INSERT 0 0 but want INSERT 0 1 Nikolas Everett (03:57)
Re: RAID controllers for Postgresql on large setups Francisco Reyes (03:31)
Re: RAID controllers for Postgresql on large setups Joshua D. Drake (02:11)
RAID controllers for Postgresql on large setups Francisco Reyes (02:04)
12 May 2008
Partitioning: INSERT 0 0 but want INSERT 0 1 Nikolas Everett (16:19)
11 May 2008
Re: Re: Re: Re: Query Optimization with Kruskal’s Algorithm Tom Lane (00:37)
10 May 2008
Re: Re: Re: Query Optimization with Kruskal’s Algorithm Tom Lane (21:12)
Re: Re: Query Optimization with Kruskal’s Algorithm Jonah H. Harris (20:27)
Re: Query Optimization with Kruskal’s Algorithm Rauan Maemirov (18:00)
Re: plan difference between set-returning function with ROWS within IN() and a plain join Merlin Moncure (11:42)
09 May 2008
"append" takes a lot of time in a query Frank Dekervel (08:21)
Re: multiple joins + Order by + LIMIT query performance issue Scott Marlowe (07:53)
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux (07:19)
Re: Creating indexes Rauan Maemirov (06:00)
08 May 2008
Re: Creating a foreign key PFC (20:24)
Re: Creating indexes Asche (20:24)
Re: Creating indexes Alan Hodgson (20:22)
Creating indexes Rauan Maemirov (19:30)
Re: Creating a foreign key Campbell, Lance (18:13)
Re: Creating a foreign key Shaun Thomas (17:19)
Re: Creating a foreign key Joshua D. Drake (16:59)
Creating a foreign key Campbell, Lance (16:53)
Re: [GENERAL] Ubuntu question Justin (07:50)
Re: [GENERAL] Ubuntu question Justin (07:48)
07 May 2008
Query Optimization with Kruskal’s Algorithm Tarcizio Bini (16:28)
Re: Possible Redundancy/Performance Solution Dennis Muhlestein (16:00)
Re: RAID 10 Benchmark with different I/O schedulers Matthew Wakeling (10:46)
Re: multiple joins + Order by + LIMIT query performance issue Matthew Wakeling (10:42)
Re: RAID 10 Benchmark with different I/O schedulers Albe Laurenz *EXTERN* (07:33)
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux (07:24)
Re: pgfouine - commit details? Josh Cole (05:37)
Re: Possible Redundancy/Performance Solution Greg Smith (02:37)
Re: Possible Redundancy/Performance Solution Scott Marlowe (01:58)
Re: Seqscan problem Vlad Arkhipov (00:48)
Re: pgfouine - commit details? Guillaume Smet (00:32)
06 May 2008
pgfouine - commit details? Josh Cole (21:23)
Re: RAID 10 Benchmark with different I/O schedulers Craig James (20:44)
Re: Possible Redundancy/Performance Solution Greg Smith (20:35)
Re: RAID 10 Benchmark with different I/O schedulers Greg Smith (20:21)
Re: Possible Redundancy/Performance Solution Dennis Muhlestein (18:59)
Re: RAID 10 Benchmark with different I/O schedulers Craig James (18:30)
Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas (18:24)
Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas (18:14)
Re: multiple joins + Order by + LIMIT query performance issue Heikki Linnakangas (18:07)
Re: multiple joins + Order by + LIMIT query performance issue Heikki Linnakangas (18:04)
Re: multiple joins + Order by + LIMIT query performance issue Tom Lane (17:59)
Re: need to speed up query Justin (17:42)
Re: Possible Redundancy/Performance Solution Greg Smith (17:39)
Re: What constitutes a complex query Scott Marlowe (17:38)
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux (17:24)
Re: What constitutes a complex query Justin (17:23)
Re: need to speed up query Justin (17:22)
Possible Redundancy/Performance Solution Dennis Muhlestein (16:59)
Re: What constitutes a complex query Richard Broersma (16:58)
Re: What constitutes a complex query Steve Atkins (16:56)
Re: need to speed up query Shaun Thomas (16:50)
Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas (16:49)
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux (16:42)
Re: What constitutes a complex query Scott Marlowe (16:41)
Re: need to speed up query PFC (16:36)
Re: What constitutes a complex query Craig James (16:27)
What constitutes a complex query Justin (15:45)
Re: multiple joins + Order by + LIMIT query performance issue Guillaume Smet (15:38)
multiple joins + Order by + LIMIT query performance issue Antoine Baudoux (15:33)
Re: plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt (15:27)
Re: Seqscan problem Tom Lane (14:22)
Re: plan difference between set-returning function with ROWS within IN() and a plain join Tom Lane (14:17)
Re: need to speed up query Justin (13:22)
Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Jeff (12:26)
Re: plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt (11:55)
Seqscan problem Vlad Arkhipov (11:19)
Re: plan difference between set-returning function with ROWS within IN() and a plain join PFC (09:47)
plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt (08:39)
Re: need to speed up query PFC (06:57)
Re: need to speed up query Justin (05:48)
Re: need to speed up query Justin (05:37)
Re: need to speed up query Gregory Williamson (04:41)
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 Scott Marlowe (03:27)
Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Scott Marlowe (03:16)
need to speed up query Justin (01:03)
Re: Very slow INFORMATION_SCHEMA Tom Lane (00:56)
05 May 2008
Re: Backup causing poor performance - suggestions Scott Marlowe (22:04)
Re: Backup causing poor performance - suggestions Greg Smith (20:11)
Re: Backup causing poor performance - suggestions Greg Smith (20:04)
Re: Backup causing poor performance - suggestions Scott Marlowe (19:44)
Re: Backup causing poor performance - suggestions Simon Riggs (17:42)
Re: Backup causing poor performance - suggestions Scott Marlowe (17:06)
Re: Backup causing poor performance - suggestions Craig James (16:10)
Re: Backup causing poor performance - suggestions Scott Marlowe (15:54)
Re: Backup causing poor performance - suggestions Campbell, Lance (15:11)
Re: Backup causing poor performance - suggestions Scott Marlowe (15:05)
Backup causing poor performance - suggestions Campbell, Lance (15:00)
Re: Very slow INFORMATION_SCHEMA Mario Weilguni (11:39)
Re: Fastest way / best practice to calculate "next birthdays" Shane Ambler (06:24)
04 May 2008
Re: Fastest way / best practice to calculate "next birthdays" Hannes Dorbath (17:59)
Re: Fastest way / best practice to calculate "next birthdays" Joshua D. Drake (16:11)
Fastest way / best practice to calculate "next birthdays" Hannes Dorbath (12:59)
Re: pgPool query cache Hannes Dorbath (11:29)
Re: Vacuum statistics Mark Kirkwood (04:59)
Re: Vacuum statistics Francisco Reyes (02:15)
03 May 2008
Re: two memory-consuming postgres processes Matthew Wakeling (09:25)
02 May 2008
Re: two memory-consuming postgres processes Kevin Grittner (22:29)
Re: Very slow INFORMATION_SCHEMA Tom Lane (22:21)
Re: two memory-consuming postgres processes Kevin Grittner (21:44)
Re: two memory-consuming postgres processes Alexy Khrabrov (21:30)
Very slow INFORMATION_SCHEMA Ernesto (21:30)
Re: two memory-consuming postgres processes PFC (21:25)
Re: two memory-consuming postgres processes Greg Smith (21:23)
Re: two memory-consuming postgres processes Alexy Khrabrov (21:09)
Re: two memory-consuming postgres processes Craig James (21:02)
Re: two memory-consuming postgres processes Alexy Khrabrov (20:51)
Re: two memory-consuming postgres processes Scott Marlowe (20:40)
Re: two memory-consuming postgres processes Alexy Khrabrov (20:35)
Re: two memory-consuming postgres processes Alexy Khrabrov (20:28)
Re: two memory-consuming postgres processes Alexy Khrabrov (20:27)
Re: two memory-consuming postgres processes Greg Smith (20:22)
Re: two memory-consuming postgres processes Tom Lane (20:13)
Peripheral Links
Header And Logo
|
Site Navigation
pgsql-performance 2008-05 Chronological Index (2/3)
Last updated: Wed Jan 18 04:15:59 2012382 messages
- 15 May 2008
- Re: which ext3 fs type should I use for postgresql david (12:15)
- Re: which ext3 fs type should I use for postgresql Matthew Wakeling (11:29)
- which ext3 fs type should I use for postgresql Philippe Amelant (10:40)
- Re: I/O on select count(*) Tom Lane (08:00)
- Re: I/O on select count(*) Tom Lane (07:54)
- Re: I/O on select count(*) Tino Wildenhain (06:14)
- Re: I/O on select count(*) Joshua D. Drake (03:14)
- Re: I/O on select count(*) Greg Smith (03:07)
- Re: I/O on select count(*) Luke Lonergan (02:53)
- Re: I/O on select count(*) Pavan Deolasee (02:41)
- Re: I/O on select count(*) Jan de Visser (02:38)
- Re: I/O on select count(*) Greg Smith (02:21)
- Re: I/O on select count(*) Alvaro Herrera (02:06)
- Re: I/O on select count(*) Greg Smith (01:40)
- Update performance degrades over time Subbiah Stalin-XCGF84 (22:38)
- Re: Partitioning: INSERT 0 0 but want INSERT 0 1 Neil Peter Braggio (22:28)
- Re: Re: Query Optimization with Krusk al’s Algorithm Michael Glaesemann (04:53)
- Re: Re: Re: Query Optimization with Kruskal’s Algorithm Jonah H. Harris (21:17)
- Re: "append" takes a lot of time in a query Tom Lane (14:12)
- Re: Creating indexes PFC (20:24)
- Re: Query Optimization with Kruskal’s Algorithm Alexander Staubo (20:09)
- Re: Possible Redundancy/Performance Solution Dennis Muhlestein (21:59)
- Re: Fastest way / best practice to calculate "next birthdays" Zoltan Boszormenyi (19:05)
- Re: two memory-consuming postgres processes Merlin Moncure (15:07)
- Re: two memory-consuming postgres processes Alexy Khrabrov (22:31)