• 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 Thread Index (1/2)

• Main Index
• [Prev Page]
• [Next Page]

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

---

• Main Index
• [Prev Page]
• [Next Page]

---

Mail converted by MHonArc