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

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

• Re: application of KNN code to US zipcode searches? Mark Stosberg (Sat 29 14:46)
• Strange query plan Sorbara, Giorgio (CIOK) (Fri 28 17:37)
• Re: Strange query plan Tomas Vondra (Fri 28 18:10)
• Re: Strange query plan Sorbara, Giorgio (CIOK) (Mon 31 13:52)
• WAL in RAM Marcus Engene (Fri 28 15:35)
• Re: WAL in RAM Kevin Grittner (Fri 28 15:46)
• Re: WAL in RAM Marcus Engene (Sat 29 17:54)
• Re: WAL in RAM Scott Marlowe (Sat 29 20:11)
• Re: WAL in RAM Merlin Moncure (Fri 28 16:11)
• Re: WAL in RAM Tomas Vondra (Fri 28 18:26)
• Re: WAL in RAM Merlin Moncure (Fri 28 18:40)
• Re: WAL in RAM Tomas Vondra (Fri 28 19:07)
• Re: WAL in RAM David Boreham (Fri 28 19:55)
• Re: WAL in RAM Tomas Vondra (Fri 28 19:03)
• Re: WAL in RAM Claudio Freire (Fri 28 19:09)
• SSL encryption makes bytea transfer slow Albe Laurenz (Fri 28 11:03)
• Re: SSL encryption makes bytea transfer slow Heikki Linnakangas (Sat 29 08:51)
• Re: SSL encryption makes bytea transfer slow Albe Laurenz (Mon 31 15:35)
• Re: SSL encryption makes bytea transfer slow Merlin Moncure (Mon 31 18:50)
• Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim (Fri 28 07:02)
• Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Gregg Jaskiewicz (Fri 28 07:58)
• Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim (Fri 28 08:21)
• Re: [GENERAL] Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Alban Hertroys (Fri 28 11:37)
• Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim (Sat 29 04:10)
• function slower than the same code in an sql file CS DBA (Fri 28 05:02)
• Re: function slower than the same code in an sql file Tom Lane (Fri 28 05:10)
• Re: function slower than the same code in an sql file CS DBA (Fri 28 13:39)
• Re: function slower than the same code in an sql file Pavel Stehule (Fri 28 05:11)
• Re: Shortcutting too-large offsets? Robert Haas (Thu 27 18:47)
• backups blocking everything Samuel Gendler (Thu 27 17:23)
• Re: backups blocking everything Merlin Moncure (Thu 27 17:39)
• Re: backups blocking everything Nicholson, Brad (Toronto, ON, CA) (Thu 27 22:12)
• Re: backups blocking everything Samuel Gendler (Thu 27 21:21)
• Re: backups blocking everything Samuel Gendler (Thu 27 23:29)
• Re: backups blocking everything Merlin Moncure (Fri 28 21:20)
• Re: backups blocking everything Samuel Gendler (Fri 28 23:51)
• PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler (Wed 26 15:57)
• Re: PostgreSQL 9.0.4 blocking in lseek? Gregg Jaskiewicz (Thu 27 07:42)
• Re: PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler (Thu 27 12:04)
• Re: PostgreSQL 9.0.4 blocking in lseek? Claudio Freire (Thu 27 14:55)
• Re: PostgreSQL 9.0.4 blocking in lseek? Tom Lane (Fri 28 00:33)
• Re: PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler (Mon 31 14:20)
• Re: PostgreSQL 9.0.4 blocking in lseek? Tom Lane (Mon 31 15:28)
• Re: PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler (Mon 31 16:17)
• Re: PostgreSQL 9.0.4 blocking in lseek? Josh Berkus (Fri 28 02:42)
• Re: PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler (Mon 31 13:56)
• Slow cursor Cezariusz Marek (Wed 26 12:43)
• Re: Slow cursor Gregg Jaskiewicz (Wed 26 12:49)
• Re: Slow cursor Cezariusz Marek (Wed 26 12:57)
• Re: Slow cursor Andres Freund (Wed 26 13:10)
• Anti join miscalculates row number? Jens Reufsteck (Wed 26 11:45)
• Re: Anti join miscalculates row number? Tom Lane (Wed 26 15:43)
• Re: Anti join miscalculates row number? Jens Reufsteck (Mon 31 17:14)
• Re: Anti join miscalculates row number? Julius Tuskenis (Thu 27 07:03)
• CTE vs Subquery Linos (Tue 25 16:22)
• Re: CTE vs Subquery Tom Lane (Tue 25 16:43)
• Re: CTE vs Subquery Linos (Tue 25 16:48)
• Re: CTE vs Subquery Merlin Moncure (Tue 25 17:14)
• Re: CTE vs Subquery Linos (Wed 26 09:00)
• Re: CTE vs Subquery Merlin Moncure (Wed 26 12:23)
• Re: CTE vs Subquery Linos (Wed 26 12:55)
• how to use explain analyze alan (Tue 25 14:36)
• Re: how to use explain analyze Julius Tuskenis (Wed 26 07:48)
• sub Cezariusz Marek (Tue 25 13:31)
• Query running a lot faster with enable_nestloop=false Mohanaraj Gopala Krishnan (Tue 25 09:09)
• Re: Query running a lot faster with enable_nestloop=false Robins Tharakan (Tue 25 09:41)
• Re: Tsearch2 - bad performance with concatenated ts-vectors Robert Haas (Mon 24 19:31)
• Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Amitabh Kant (Mon 24 16:43)
• Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (Mon 24 16:54)
• Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Merlin Moncure (Mon 24 21:31)
• Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Claudio Freire (Mon 24 22:47)
• Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (Tue 25 02:37)
• Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Claudio Freire (Tue 25 14:55)
• Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (Tue 25 15:00)
• Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (Mon 24 23:18)
• Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Amitabh Kant (Fri 28 06:40)
• Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (Fri 28 13:22)
• Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Thilo Raufeisen (Tue 25 07:48)
• Usage of pg_stat_database Amitabh Kant (Mon 24 16:39)
• Re: Usage of pg_stat_database Jeff Davis (Fri 28 05:54)
• Re: Usage of pg_stat_database Amitabh Kant (Fri 28 06:38)
• hstore query: Any better idea than adding more memory? Stefan Keller (Sat 22 23:33)
• Re: hstore query: Any better idea than adding more memory? Stephen Frost (Sun 23 23:25)
• Re: hstore query: Any better idea than adding more memory? Stefan Keller (Mon 24 00:20)
• Re: hstore query: Any better idea than adding more memory? Stephen Frost (Mon 24 00:41)
• explain workload Radhya sahal (Sat 22 01:11)
• Re: explain workload Robins Tharakan (Sun 23 10:45)
• Re: explain workload Tom Lane (Sun 23 15:45)
• 8.4.4, 9.0, and 9.1 Planner Differences Anthony Presley (Fri 21 23:40)
• Re: 8.4.4, 9.0, and 9.1 Planner Differences Tom Lane (Sat 22 15:58)
• Re: 8.4.4, 9.0, and 9.1 Planner Differences Anthony Presley (Sat 22 23:12)
• Re: 8.4.4, 9.0, and 9.1 Planner Differences Tom Lane (Sun 23 02:32)
• does update of column with no relation imply a relation check of other column? Anibal David Acosta (Wed 19 15:51)
• Re: does update of column with no relation imply a relation check of other column? Greg Jaskiewicz (Wed 19 16:43)
• Re: does update of column with no relation imply a relation check of other column? Robert Haas (Mon 31 18:19)
• Re: does update of column with no relation imply a relation check of other column? Tom Lane (Mon 31 19:55)
• disused indexes and performance? Elisa (Wed 19 15:33)
• Re: disused indexes and performance? Scott Marlowe (Thu 20 02:01)
• delete/recreate indexes alan (Wed 19 15:03)
• Re: delete/recreate indexes Jeff Davis (Thu 20 02:51)
• Re: delete/recreate indexes Bort, Paul (Thu 20 13:37)
• Re: delete/recreate indexes alan (Mon 24 16:36)
• Inner Join - Explicit vs Implicit Join Performance Gnanakumar (Wed 19 10:47)
• Re: Inner Join - Explicit vs Implicit Join Performance Pavel Stehule (Wed 19 11:15)
• How many Cluster database on a single server d(dot)davolio(at)mastertraining(dot)it (Wed 19 10:14)
• Re: How many Cluster database on a single server Craig James (Wed 19 14:14)
• Re: How many Cluster database on a single server d(dot)davolio(at)mastertraining(dot)it (Wed 19 15:03)
• Re: How many Cluster database on a single server Kevin Grittner (Wed 19 15:13)
• Re: How many Cluster database on a single server d(dot)davolio(at)mastertraining(dot)it (Fri 21 06:57)
• Re: How many Cluster database on a single server Scott Marlowe (Wed 19 15:44)
• Re: How many Cluster database on a single server Craig Ringer (Thu 20 03:34)
• Heavy contgnous load kzsolt (Tue 18 12:29)
• Re: Heavy contgnous load Kevin Grittner (Tue 18 20:40)
• Re: Heavy contgnous load kzsolt (Wed 19 19:04)
• Re: Heavy contgnous load Craig Ringer (Wed 19 00:56)
• Re: Heavy contgnous load kzsolt (Wed 19 18:55)
• Re: Heavy contgnous load Craig Ringer (Thu 20 03:44)
• Re: Heavy contgnous load Jeff Janes (Thu 20 15:55)
• Re: Heavy contgnous load kzsolt (Thu 20 20:10)
• Optimize the database performance Micka (Mon 17 09:48)
• Re: Optimize the database performance MirrorX (Mon 17 10:39)
• Re: Optimize the database performance Andy Colson (Mon 17 18:35)
• Re: Optimize the database performance Cédric Villemain (Mon 17 20:31)
• Bad plan by Planner (Already resolved?) Robins Tharakan (Mon 17 06:35)
• Re: Bad plan by Planner (Already resolved?) Kevin Grittner (Mon 17 16:02)
• Re: Bad plan by Planner (Already resolved?) Robins Tharakan (Tue 18 05:58)
• Re: Bad plan by Planner (Already resolved?) Mark Kirkwood (Tue 18 06:18)
• <Possible follow-ups>
• Re: Bad plan by Planner (Already resolved?) Kevin Grittner (Tue 18 12:46)
• Re: Bad plan by Planner (Already resolved?) Robins Tharakan (Tue 25 10:53)
• Re: Bad plan by Planner (Already resolved?) Tom Lane (Wed 26 19:57)
• Re: Bad plan by Planner (Already resolved?) Robins Tharakan (Sat 29 14:42)
• SSD options, small database, ZFS CSS (Fri 14 08:31)
• Re: SSD options, small database, ZFS Arjen van der Meijden (Fri 14 10:41)
• Re: Slow query when using ORDER BY *and* LIMIT davidsarmstrong (Thu 13 19:51)
• Re: Slow query when using ORDER BY *and* LIMIT Michael Viscuso (Sat 15 22:17)
• Tablespace files deleted automatically. Vishnu S. (Thu 13 12:52)
• Re: Tablespace files deleted automatically. Josh Berkus (Fri 14 18:19)
• Re: Tablespace files deleted automatically. Robert Klemme (Mon 17 12:04)
• Join over two tables of 50K records takes 2 hours Svetlin Manavski (Wed 12 08:55)
• Re: Join over two tables of 50K records takes 2 hours Tom Lane (Fri 14 04:37)
• Re: Join over two tables of 50K records takes 2 hours Svetlin Manavski (Fri 14 08:36)
• Re: Join over two tables of 50K records takes 2 hours Scott Marlowe (Fri 14 09:42)
• Re: Join over two tables of 50K records takes 2 hours Scott Marlowe (Fri 14 04:38)
• Composite keys Carlo Stonebanks (Tue 11 23:11)
• Re: Composite keys Claudio Freire (Wed 12 00:52)
• Re: Composite keys Dave Crooke (Wed 12 01:28)
• Re: Composite keys Carlo Stonebanks (Wed 12 04:39)
• Re: Composite keys Greg Smith (Wed 12 10:26)
• Re: Composite keys Robert Haas (Mon 31 17:08)
• Re: Composite keys Claudio Freire (Mon 31 17:52)
• Re: Composite keys Robert Haas (Mon 31 18:24)
• Re: Composite keys Claudio Freire (Mon 31 18:34)
• Re: Composite keys Robert Haas (Mon 31 18:42)
• Re: Composite keys Tom Lane (Mon 31 18:59)
• postgresql query runtime Radhya sahal (Tue 11 19:08)
• Re: postgresql query runtime Pavel Stehule (Tue 11 19:12)
• Re: postgresql query runtime Szymon Guz (Tue 11 19:13)
• Re: postgresql query runtime Szymon Guz (Tue 11 19:14)
• Re: postgresql query runtime Kevin Grittner (Tue 11 19:16)
• Re: postgresql query runtime Radhya sahal (Tue 11 21:36)
• Re: postgresql query runtime Kevin Grittner (Tue 11 21:43)
• Re: should i expected performance degradation over time Anibal David Acosta (Tue 11 18:28)
• Re: should i expected performance degradation over time Robert Haas (Fri 28 19:03)
• Query tuning help CS DBA (Tue 11 17:59)
• Re: Query tuning help Pavel Stehule (Tue 11 18:03)
• Re: Query tuning help CS DBA (Tue 11 18:14)
• Re: Query tuning help Pavel Stehule (Tue 11 19:00)
• Re: Query tuning help Szymon Guz (Tue 11 18:03)
• Re: Query tuning help CS DBA (Tue 11 18:37)
• Rapidly finding maximal rows James Cranch (Mon 10 21:59)
• Re: Rapidly finding maximal rows Tom Lane (Fri 14 04:26)
• <Possible follow-ups>
• Rapidly finding maximal rows James Cranch (Tue 11 10:16)
• Re: Rapidly finding maximal rows bricklen (Tue 11 23:22)
• Re: Rapidly finding maximal rows James Cranch (Wed 12 11:42)
• Re: Rapidly finding maximal rows Dave Crooke (Wed 12 01:05)
• Re: Rapidly finding maximal rows James Cranch (Wed 12 11:41)
• Re: Rapidly finding maximal rows Merlin Moncure (Wed 19 14:55)
• Adding more memory = hugh cpu load alexandre - aldeia digital (Mon 10 13:26)
• Re: Adding more memory = hugh cpu load Kevin Grittner (Mon 10 13:51)
• Re: Adding more memory = hugh cpu load Shaun Thomas (Mon 10 14:20)

---

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

---

Mail converted by MHonArc