• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Community
• Contributors
• Mailing Lists
  • Subscribe
  • User lists
    • pgsql-admin
    • pgsql-advocacy
    • pgsql-announce
    • pgsql-bugs
    • pgsql-docs
    • pgsql-general
    • pgsql-jobs
    • pgsql-novice
    • pgsql-performance
    • pgsql-php
    • pgsql-sql
    • pgsql-students
  • Developer lists
  • Regional lists
  • Associations
  • User groups
  • Project lists
  • Inactive lists
• IRC
• Featured Users
• International Sites
• Propaganda
• Resources
• Weekly News
• Community login
  • Profile
  • Lost password

pgsql-performance 2009-02 Chronological Index (1/2)

• Thread Index
• [Prev Page]
• [Next Page]

• 01 March 2009
  • Re: Bad plan for nested loop + limit Robert Haas (03:33)
  • Re: "slow" queries Robert Haas (03:15)
  • "slow" queries Brian Cox (02:51)
• 28 February 2009
  • Re: Bad plan for nested loop + limit Alexander Staubo (16:20)
• 27 February 2009
  • Re: Bad plan for nested loop + limit Robert Haas (22:54)
  • Re: Bad plan for nested loop + limit Alexander Staubo (20:18)
• 26 February 2009
  • Re: Abnormal performance difference between Postgres and MySQL Steve Clark (19:23)
  • Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe (19:16)
  • Re: Abnormal performance difference between Postgres and MySQL Kevin Grittner (18:10)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (17:51)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (17:21)
  • Re: Abnormal performance difference between Postgres and MySQL Akos Gabriel (08:38)
  • Re: Abnormal performance difference between Postgres and MySQL Claus Guttesen (08:01)
  • Re: Abnormal performance difference between Postgres and MySQL Robert Haas (01:00)
  • Re: Abnormal performance difference between Postgres and MySQL Scott Carey (00:07)
• 25 February 2009
  • Re: Abnormal performance difference between Postgres and MySQL Kevin Grittner (23:12)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (22:29)
  • Re: Abnormal performance difference between Postgres and MySQL Kevin Grittner (22:10)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (22:08)
  • Re: Abnormal performance difference between Postgres and MySQL Akos Gabriel (22:04)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (21:57)
  • Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe (21:55)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (21:43)
  • Re: Abnormal performance difference between Postgres and MySQL Robert Haas (21:40)
  • Re: Abnormal performance difference between Postgres and MySQL Claus Guttesen (21:40)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (21:38)
  • Re: Abnormal performance difference between Postgres and MySQL Robert Haas (21:36)
  • Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe (21:36)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (21:32)
  • Re: Abnormal performance difference between Postgres and MySQL Robert Haas (21:30)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Rodrigo E . De León Plicet (20:52)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (20:44)
  • Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe (20:28)
  • Re: Abnormal performance difference between Postgres and MySQL Robert Haas (19:52)
  • Re: PostgreSQL block size for SSD RAID setup? Scott Carey (19:23)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (19:05)
  • Re: Abnormal performance difference between Postgres and MySQL Robert Haas (18:58)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (18:53)
  • Re: PostgreSQL block size for SSD RAID setup? PFC (18:32)
  • Re: full text search - dictionary caching Tom Lane (16:36)
  • Re: PostgreSQL block size for SSD RAID setup? henk de wit (16:13)
  • Re: PostgreSQL block size for SSD RAID setup? Gregory Stark (15:42)
  • PostgreSQL block size for SSD RAID setup? henk de wit (14:59)
  • full text search - dictionary caching Tomasz Myrta (10:48)
  • Re: Abnormal performance difference between Postgres and MySQL Robert Haas (02:21)
• 24 February 2009
  • Re: Abnormal performance difference between Postgres and MySQL Claus Guttesen (20:55)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (19:52)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (19:51)
  • Re: LIMIT confuses the planner Kouber Saparev (17:09)
  • Re: TCP network cost Ross J. Reedstrom (17:02)
  • will 8.4 be able to optmize rank() windows ? Grzegorz Jaśkiewicz (15:07)
  • Re: planner's midjudge number of rows resulting, despite pretty obvious join Pavel Stehule (14:43)
  • planner's midjudge number of rows resulting, despite pretty obvious join Grzegorz Jaśkiewicz (14:34)
  • Re: Abnormal performance difference between Postgres and MySQL Claus Guttesen (07:28)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (04:56)
  • Re: Abnormal performance difference between Postgres and MySQL Tom Lane (02:19)
  • Re: Abnormal performance difference between Postgres and MySQL Tom Lane (02:01)
  • Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe (01:53)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (01:24)
• 23 February 2009
  • Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe (23:38)
  • Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe (23:37)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (23:35)
  • Re: postgreSQL performance 8.2.6 vs 8.3.3 Scott Marlowe (23:33)
  • Re: Abnormal performance difference between Postgres and MySQL Guillaume Smet (23:33)
  • Re: Abnormal performance difference between Postgres and MySQL Farhan Husain (23:33)
  • Re: Abnormal performance difference between Postgres and MySQL Scott Marlowe (23:27)
  • Re: Abnormal performance difference between Postgres and MySQL Gregory Stark (23:27)
  • Abnormal performance difference between Postgres and MySQL Farhan Husain (23:16)
  • Re: TCP network cost Tom Lane (21:17)
  • Re: postgreSQL performance 8.2.6 vs 8.3.3 david (21:02)
  • Re: TCP network cost Ross J. Reedstrom (19:43)
  • Re: TCP network cost Ross J. Reedstrom (19:42)
  • Re: LIMIT confuses the planner Kouber Saparev (18:44)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez (18:29)
  • Re: LIMIT confuses the planner Tom Lane (18:01)
  • Re: LIMIT confuses the planner Kouber Saparev (17:53)
  • Re: LIMIT confuses the planner Tom Lane (15:10)
  • Re: LIMIT confuses the planner Robert Haas (14:53)
  • Re: LIMIT confuses the planner Richard Huxton (13:27)
  • LIMIT confuses the planner Kouber Saparev (12:31)
• 22 February 2009
  • Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong (23:03)
  • Re: not in(subselect) in 8.4 Grzegorz Jaśkiewicz (19:10)
  • Re: not in(subselect) in 8.4 Robert Haas (04:39)
  • Re: not in(subselect) in 8.4 Tom Lane (03:41)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris (02:04)
• 21 February 2009
  • Re: not in(subselect) in 8.4 Scott Carey (19:29)
  • Re: not in(subselect) in 8.4 Tom Lane (17:43)
  • Re: not in(subselect) in 8.4 Grzegorz Jaśkiewicz (17:10)
  • Re: not in(subselect) in 8.4 Tom Lane (16:56)
  • Re: Partial index usage decibel (15:56)
  • Re: not in(subselect) in 8.4 Grzegorz Jaśkiewicz (11:49)
  • Re: how the hdd read speed is related to the query execution speed. Andreas Kretschmer (08:36)
  • how the hdd read speed is related to the query execution speed. sathiya psql (07:14)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Denis Lussier (01:40)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez (00:30)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez (00:04)
  • Re: not in(subselect) in 8.4 Rodrigo E . De León Plicet (00:03)
• 20 February 2009
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Mark Kirkwood (23:17)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Scott Marlowe (21:57)
  • Re: postgreSQL performance 8.2.6 vs 8.3.3 Scott Marlowe (21:56)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Robert Haas (21:55)
  • Re: postgreSQL performance 8.2.6 vs 8.3.3 David Rees (21:46)
  • Re: postgreSQL performance 8.2.6 vs 8.3.3 Kenneth Marshall (21:45)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris (21:35)
  • postgreSQL performance 8.2.6 vs 8.3.3 Battle Mage (21:34)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Merlin Moncure (20:40)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris (19:55)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris (19:51)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris (19:48)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Robert Haas (19:35)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez (19:15)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Jonah H. Harris (17:39)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez (16:57)
  • Re: Benchmark comparing PostgreSQL, MySQL and Oracle Alan Hodgson (16:36)
  • Benchmark comparing PostgreSQL, MySQL and Oracle Sergio Lopez (16:29)
  • Re: not in(subselect) in 8.4 Grzegorz Jaśkiewicz (15:40)
  • Re: not in(subselect) in 8.4 Tom Lane (15:34)
  • Re: SSD performance Matthew Wakeling (15:26)
  • Re: not in(subselect) in 8.4 marcin mank (13:07)
  • Re: not in(subselect) in 8.4 Grzegorz Jaśkiewicz (12:57)
  • not in(subselect) in 8.4 Grzegorz Jaśkiewicz (09:56)
• 19 February 2009
  • Re: TCP network cost PFC (13:13)
• 18 February 2009
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah (20:14)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey (19:27)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey (19:23)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey (19:10)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Grzegorz Jaśkiewicz (14:05)
  • Re: TCP network cost Gregory Stark (13:44)
  • Re: Call of function inside trigger much slower than explicit function call Alexander Gorban (10:24)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah (09:03)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Grzegorz Jaśkiewicz (08:57)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe (08:51)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah (08:45)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Marlowe (08:31)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah (07:56)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah (07:52)
  • Re: Call of function inside trigger much slower than explicit function call ivo nascimento (00:43)
• 17 February 2009
  • Re: TCP network cost Aaron Turner (23:05)
  • Re: TCP network cost Ross J. Reedstrom (22:30)
  • Re: TCP network cost Ross J. Reedstrom (21:15)
  • Re: TCP network cost Rusty Conover (21:00)
  • Re: TCP network cost Ross J. Reedstrom (20:04)
  • Re: Call of function inside trigger much slower than explicit function call Robert Haas (19:31)
  • Re: Query composite index range in an efficient way Havasvölgyi Ottó (18:55)
  • Re: TCP network cost Aaron Turner (18:13)
  • Re: Call of function inside trigger much slower than explicit function call Alexander Gorban (17:46)
  • Re: Call of function inside trigger much slower than explicit function call Robert Haas (17:25)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Scott Carey (16:19)
  • Call of function inside trigger much slower than explicit function call Alexander Gorban (16:17)
  • Re: Query composite index range in an efficient way Kevin Grittner (16:16)
  • Re: Query composite index range in an efficient way Tom Lane (15:53)
  • Cannot interpret EXPLAIN Jörg Kiegeland (15:00)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah (13:25)
  • Re: Query composite index range in an efficient way Gregory Stark (13:18)
  • Re: Query composite index range in an efficient way Matthew Wakeling (12:57)
  • Query composite index range in an efficient way Havasvölgyi Ottó (12:44)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Matthew Wakeling (11:45)
  • Re: TCP network cost david (07:29)
  • Re: TCP network cost Rusty Conover (07:20)
  • TCP network cost Ross J. Reedstrom (07:12)
• 16 February 2009
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah (20:36)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Rajesh Kumar Mallah (20:34)
  • Re: Partial index usage Craig Ringer (15:08)
  • Re: I/O increase after upgrading to 8.3.5 Alexander Staubo (14:59)
  • Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller Gregory Stark (13:31)
  • Partial index usage Laszlo Nagy (09:12)
• 15 February 2009
  • Re: I/O increase after upgrading to 8.3.5 Greg Smith (17:38)
  • Re: I/O increase after upgrading to 8.3.5 Greg Smith (17:35)
  • Re: Bad plan for nested loop + limit Alexander Staubo (16:45)
  • Re: Bad plan for nested loop + limit David Wilson (04:29)
• 14 February 2009
  • Bad plan for nested loop + limit Alexander Staubo (22:25)
  • Re: Slow queries from information schema Octavio Alvarez (20:15)
  • Re: I/O increase after upgrading to 8.3.5 Alexander Staubo (20:04)
  • Re: Slow queries from information schema Tom Lane (20:02)
  • Re: I/O increase after upgrading to 8.3.5 Tom Lane (19:23)
  • Re: I/O increase after upgrading to 8.3.5 Alexander Staubo (18:27)
  • Re: I/O increase after upgrading to 8.3.5 Alexander Staubo (18:26)
  • Slow queries from information schema Octavio Alvarez (18:13)
  • Retrieving data from PostgreSQL to .NET application – performance test – surprising results Peter G. (16:11)
  • Re: scheduling autovacuum at lean hours only. Rajesh Kumar Mallah (11:58)

• Thread Index
• [Prev Page]
• [Next Page]