pgsql-performance 2008-05 Thread Index (2/3)

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

Peripheral Links

Text Size: Normal / Large
Donate
Contact

Header And Logo

PostgreSQL

|

The world's most advanced open source database.

Site Navigation

pgsql-performance 2008-05 Thread Index (2/3)

Last updated: Wed Jan 18 04:15:59 2012
382 messages

Re: I/O on select count(*), (continued)
- Re: I/O on select count(*) Doug Eck (Wed 14 21:23)
- Re: I/O on select count(*) Luke Lonergan (Fri 23 03:49)
postgres overall performance seems to degrade when large SELECT are requested Valentin Bogdanov (Wed 14 10:07)

Re: postgres overall performance seems to degrade when large SELECT are requested PFC (Wed 14 11:04)

Regexps - never completing join. Rusty Conover (Wed 14 06:11)

Re: Regexps - never completing join. Rusty Conover (Wed 14 07:08)

Re: Regexps - never completing join. Rusty Conover (Wed 14 15:37)

Re: Regexps - never completing join. Scott Marlowe (Fri 16 20:35)

Re: Regexps - never completing join. Rusty Conover (Fri 16 21:37)

Re: Regexps - never completing join. Scott Marlowe (Fri 16 21:44)

Problem with 11 M records table idc danny (Tue 13 16:57)

Re: Problem with 11 M records table Bill Moran (Tue 13 17:05)
Re: Problem with 11 M records table salman (Tue 13 17:09)
Re: Problem with 11 M records table Craig James (Tue 13 17:17)
Re: Problem with 11 M records table Scott Marlowe (Tue 13 18:02)
can I move sort to first outer join ? fernando castano (Wed 14 04:53)

Re: can I move sort to first outer join ? PFC (Wed 14 09:52)

<Possible follow-ups>
Re: Problem with 11 M records table Craig James (Tue 13 17:57)
Re: Problem with 11 M records table Ramasubramanian G (Wed 14 06:09)

Installation Steps to migrate to Postgres 8.3.1 Gauri Kanekar (Tue 13 06:02)

Re: Installation Steps to migrate to Postgres 8.3.1 Claus Guttesen (Tue 13 06:49)
Re: Installation Steps to migrate to Postgres 8.3.1 Scott Marlowe (Tue 13 08:25)

Re: Installation Steps to migrate to Postgres 8.3.1 Knight, Doug (Tue 13 12:15)

Re: Installation Steps to migrate to Postgres 8.3.1 Scott Marlowe (Tue 13 14:50)

RAID controllers for Postgresql on large setups Francisco Reyes (Tue 13 02:04)

Re: RAID controllers for Postgresql on large setups Joshua D. Drake (Tue 13 02:11)

Re: RAID controllers for Postgresql on large setups Francisco Reyes (Tue 13 03:31)

Re: RAID controllers for Postgresql on large setups Joshua D. Drake (Tue 13 04:42)
Re: RAID controllers for Postgresql on large setups Vivek Khera (Tue 13 15:09)

Re: RAID controllers for Postgresql on large setups Chris Ruprecht (Tue 13 04:10)

Re: RAID controllers for Postgresql on large setups Joshua D. Drake (Tue 13 04:40)

Re: RAID controllers for Postgresql on large setups Greg Smith (Tue 13 05:59)
Re: RAID controllers for Postgresql on large setups Scott Marlowe (Tue 13 08:17)
Re: RAID controllers for Postgresql on large setups PFC (Tue 13 09:54)

Re: RAID controllers for Postgresql on large setups Francisco Reyes (Tue 13 12:01)

Re: RAID controllers for Postgresql on large setups Merlin Moncure (Tue 13 12:10)
Re: RAID controllers for Postgresql on large setups PFC (Tue 13 20:39)

Re: RAID controllers for Postgresql on large setups James Mansion (Tue 13 20:09)
Re: RAID controllers for Postgresql on large setups Marinos Yannikos (Mon 26 23:14)

Re: RAID controllers for Postgresql on large setups Vivek Khera (Tue 13 15:08)

Partitioning: INSERT 0 0 but want INSERT 0 1 Nikolas Everett (Mon 12 16:19)

Re: Partitioning: INSERT 0 0 but want INSERT 0 1 Neil Peter Braggio (Mon 12 22:28)

Re: Partitioning: INSERT 0 0 but want INSERT 0 1 Nikolas Everett (Tue 13 03:57)

"append" takes a lot of time in a query Frank Dekervel (Fri 09 08:21)

Re: "append" takes a lot of time in a query Tom Lane (Fri 09 14:12)

Message not available
- Re: "append" takes a lot of time in a query Frank Dekervel (Wed 21 10:38)

Creating indexes Rauan Maemirov (Thu 08 19:30)

Re: Creating indexes Alan Hodgson (Thu 08 20:22)
Re: Creating indexes Asche (Thu 08 20:24)

Re: Creating indexes Rauan Maemirov (Fri 09 06:00)

Re: Creating indexes PFC (Thu 08 20:24)

Creating a foreign key Campbell, Lance (Thu 08 16:53)

Re: Creating a foreign key Joshua D. Drake (Thu 08 16:59)
Re: Creating a foreign key Shaun Thomas (Thu 08 17:19)

Re: Creating a foreign key Campbell, Lance (Thu 08 18:13)

Re: Creating a foreign key PFC (Thu 08 20:24)

Re: [GENERAL] Ubuntu question Justin (Thu 08 07:48)

Re: [GENERAL] Ubuntu question Justin (Thu 08 07:50)

Query Optimization with Kruskal’s Algorithm Tarcizio Bini (Wed 07 16:28)

Re: Query Optimization with Kruskal’s Algorithm Alexander Staubo (Wed 07 20:09)

Re: Query Optimization with Kruskal’s Algorithm Rauan Maemirov (Sat 10 18:00)

Re: Re: Query Optimization with Kruskal’s Algorithm Jonah H. Harris (Sat 10 20:27)

Re: Re: Re: Query Optimization with Kruskal’s Algorithm Tom Lane (Sat 10 21:12)

Re: Re: Re: Query Optimization with Kruskal’s Algorithm Jonah H. Harris (Sat 10 21:17)
Re: Re: Re: Re: Query Optimization with Kruskal’s Algorithm Tom Lane (Sun 11 00:37)

Re: Re: Query Optimization with Krusk al’s Algorithm Michael Glaesemann (Sun 11 04:53)

pgfouine - commit details? Josh Cole (Tue 06 21:23)

Re: pgfouine - commit details? Guillaume Smet (Wed 07 00:32)

Re: pgfouine - commit details? Josh Cole (Wed 07 05:37)

Possible Redundancy/Performance Solution Dennis Muhlestein (Tue 06 16:59)

Re: Possible Redundancy/Performance Solution Greg Smith (Tue 06 17:39)

Re: Possible Redundancy/Performance Solution Dennis Muhlestein (Tue 06 18:59)

Re: Possible Redundancy/Performance Solution Greg Smith (Tue 06 20:35)

Re: Possible Redundancy/Performance Solution Dennis Muhlestein (Tue 06 21:59)

Re: Possible Redundancy/Performance Solution Scott Marlowe (Wed 07 01:58)
Re: Possible Redundancy/Performance Solution Greg Smith (Wed 07 02:37)
Re: Possible Redundancy/Performance Solution Dennis Muhlestein (Wed 07 16:00)

What constitutes a complex query Justin (Tue 06 15:45)

Re: What constitutes a complex query Craig James (Tue 06 16:27)

Re: What constitutes a complex query Justin (Tue 06 17:23)

Re: What constitutes a complex query Scott Marlowe (Tue 06 17:38)

Re: What constitutes a complex query Scott Marlowe (Tue 06 16:41)

Re: What constitutes a complex query Richard Broersma (Tue 06 16:58)

Re: What constitutes a complex query Steve Atkins (Tue 06 16:56)

multiple joins + Order by + LIMIT query performance issue Antoine Baudoux (Tue 06 15:33)

Re: multiple joins + Order by + LIMIT query performance issue Guillaume Smet (Tue 06 15:38)

Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux (Tue 06 16:42)

Re: multiple joins + Order by + LIMIT query performance issue Heikki Linnakangas (Tue 06 18:04)
Re: multiple joins + Order by + LIMIT query performance issue Heikki Linnakangas (Tue 06 18:07)

Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas (Tue 06 16:49)

Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux (Tue 06 17:24)

Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas (Tue 06 18:24)

Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux (Fri 09 07:19)

Re: multiple joins + Order by + LIMIT query performance issue Scott Marlowe (Fri 09 07:53)

Re: multiple joins + Order by + LIMIT query performance issue Tom Lane (Tue 06 17:59)

Re: multiple joins + Order by + LIMIT query performance issue Shaun Thomas (Tue 06 18:14)
Re: multiple joins + Order by + LIMIT query performance issue Antoine Baudoux (Wed 07 07:24)
Re: multiple joins + Order by + LIMIT query performance issue Matthew Wakeling (Wed 07 10:42)

Seqscan problem Vlad Arkhipov (Tue 06 11:19)

Re: Seqscan problem Tom Lane (Tue 06 14:22)

Re: Seqscan problem Vlad Arkhipov (Wed 07 00:48)

plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt (Tue 06 08:39)

Re: plan difference between set-returning function with ROWS within IN() and a plain join PFC (Tue 06 09:47)

Re: plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt (Tue 06 11:55)

Re: plan difference between set-returning function with ROWS within IN() and a plain join Tom Lane (Tue 06 14:17)

Re: plan difference between set-returning function with ROWS within IN() and a plain join Frank van Vugt (Tue 06 15:27)

Re: plan difference between set-returning function with ROWS within IN() and a plain join Merlin Moncure (Sat 10 11:42)

need to speed up query Justin (Tue 06 01:03)

Re: need to speed up query Scott Marlowe (Tue 06 03:27)

Re: need to speed up query Justin (Tue 06 05:37)

Re: need to speed up query Gregory Williamson (Tue 06 04:41)

Re: need to speed up query Justin (Tue 06 05:48)

Re: need to speed up query PFC (Tue 06 06:57)

Re: need to speed up query Justin (Tue 06 13:22)
Message not available
- Re: need to speed up query PFC (Tue 06 16:36)

Re: need to speed up query Shaun Thomas (Tue 06 16:50)

Re: need to speed up query Justin (Tue 06 17:22)

RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Craig James (Mon 05 23:33)

Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Scott Marlowe (Tue 06 03:16)
Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Greg Smith (Tue 06 03:59)

Re: RAID 10 Benchmark with different I/O schedulers Craig James (Tue 06 18:30)

Re: RAID 10 Benchmark with different I/O schedulers Greg Smith (Tue 06 20:21)

Re: RAID 10 Benchmark with different I/O schedulers Craig James (Tue 06 20:44)

Re: RAID 10 Benchmark with different I/O schedulers Albe Laurenz *EXTERN* (Wed 07 07:33)

Re: RAID 10 Benchmark with different I/O schedulers Matthew Wakeling (Wed 07 10:46)

Re: RAID 10 Benchmark with different I/O schedulers (was: Performance increase with elevator=deadline) Jeff (Tue 06 12:26)

Backup causing poor performance - suggestions Campbell, Lance (Mon 05 15:00)

Re: Backup causing poor performance - suggestions Scott Marlowe (Mon 05 15:05)

Re: Backup causing poor performance - suggestions Campbell, Lance (Mon 05 15:11)

Re: Backup causing poor performance - suggestions Scott Marlowe (Mon 05 15:54)

Message not available
- Re: Backup causing poor performance - suggestions Scott Marlowe (Mon 05 17:06)
- Message not available
- Re: Backup causing poor performance - suggestions Scott Marlowe (Mon 05 19:44)
- Re: Backup causing poor performance - suggestions Greg Smith (Mon 05 20:11)

Re: Backup causing poor performance - suggestions Craig James (Mon 05 16:10)

Re: Backup causing poor performance - suggestions Simon Riggs (Mon 05 17:42)

Re: Backup causing poor performance - suggestions Greg Smith (Mon 05 20:04)

Re: Backup causing poor performance - suggestions Scott Marlowe (Mon 05 22:04)

Fastest way / best practice to calculate "next birthdays" Hannes Dorbath (Sun 04 12:59)

Re: Fastest way / best practice to calculate "next birthdays" Joshua D. Drake (Sun 04 16:11)

Re: Fastest way / best practice to calculate "next birthdays" Hannes Dorbath (Sun 04 17:59)

Re: Fastest way / best practice to calculate "next birthdays" Zoltan Boszormenyi (Sun 04 19:05)
Re: Fastest way / best practice to calculate "next birthdays" Shane Ambler (Mon 05 06:24)

Re: pgPool query cache Hannes Dorbath (Sun 04 11:29)
Very slow INFORMATION_SCHEMA Ernesto (Fri 02 21:30)

Re: Very slow INFORMATION_SCHEMA Tom Lane (Fri 02 22:21)

Re: Very slow INFORMATION_SCHEMA Mario Weilguni (Mon 05 11:39)

Re: Very slow INFORMATION_SCHEMA Tom Lane (Tue 06 00:56)

two memory-consuming postgres processes Alexy Khrabrov (Fri 02 19:24)

Re: two memory-consuming postgres processes Scott Marlowe (Fri 02 19:30)

Re: two memory-consuming postgres processes Alexy Khrabrov (Fri 02 19:38)

Re: two memory-consuming postgres processes Scott Marlowe (Fri 02 19:54)

Re: two memory-consuming postgres processes Tom Lane (Fri 02 20:13)

Re: two memory-consuming postgres processes Alexy Khrabrov (Fri 02 20:27)
Re: two memory-consuming postgres processes Scott Marlowe (Fri 02 20:40)
Re: two memory-consuming postgres processes Alexy Khrabrov (Fri 02 20:51)
Re: two memory-consuming postgres processes Merlin Moncure (Sat 03 15:07)
Re: two memory-consuming postgres processes Craig James (Fri 02 21:02)
Re: two memory-consuming postgres processes Alexy Khrabrov (Fri 02 21:09)
Re: two memory-consuming postgres processes Greg Smith (Fri 02 21:23)
Re: two memory-consuming postgres processes Alexy Khrabrov (Fri 02 21:30)
Re: two memory-consuming postgres processes Kevin Grittner (Fri 02 21:44)
Re: two memory-consuming postgres processes Alexy Khrabrov (Fri 02 22:31)
Re: two memory-consuming postgres processes Kevin Grittner (Fri 02 22:29)
Re: two memory-consuming postgres processes PFC (Fri 02 21:25)
Re: two memory-consuming postgres processes Matthew Wakeling (Sat 03 09:25)

Re: two memory-consuming postgres processes Greg Smith (Fri 02 20:22)

Re: two memory-consuming postgres processes Alexy Khrabrov (Fri 02 20:28)

Mail converted by MHonArc

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group