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

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

• gist indexes for distance calculations Marcelo Zabani (Thu 30 18:33)
• Re: gist indexes for distance calculations Tom Lane (Thu 30 19:16)
• Message not available
  • Message not available
    • Re: gist indexes for distance calculations Marcelo Zabani (Fri 01 02:50)
• Performance improvements/regressions from 8.4 to 9.0? Andy (Thu 30 00:02)
• Re: Performance improvements/regressions from 8.4 to 9.0? Greg Smith (Thu 30 05:15)
• Wrong index choice Fabrício dos Anjos Silva (Wed 29 16:55)
• Re: Wrong index choice Kevin Grittner (Wed 29 21:00)
• How does PG know if data is in memory? Fabrício dos Anjos Silva (Wed 29 16:31)
• Re: How does PG know if data is in memory? Kevin Grittner (Wed 29 16:37)
• Re: How does PG know if data is in memory? Samuel Gendler (Wed 29 17:08)
• Running 9 in production? Sticking with 8.4.4 for a while? Tory M Blue (Tue 28 19:22)
• Re: Running 9 in production? Sticking with 8.4.4 for a while? Michael Gould (Tue 28 20:09)
• Re: Running 9 in production? Sticking with 8.4.4 for a while? Greg Smith (Tue 28 20:45)
• Re: Running 9 in production? Sticking with 8.4.4 for a while? Guy Rouillier (Tue 28 22:46)
• Re: Running 9 in production? Sticking with 8.4.4 for a while? Tory M Blue (Tue 28 22:53)
• Clean up of archived Xlogs in postgres-9. Nimesh Satam (Tue 28 10:01)
• Re: Clean up of archived Xlogs in postgres-9. Erik Rijkers (Tue 28 12:29)
• Odd behaviour with redundant CREATE statement Dave Crooke (Mon 27 18:50)
• Re: Odd behaviour with redundant CREATE statement Gurjeet Singh (Mon 27 19:28)
• postgresql-9.0 Windows service stops after database transaction adrian . kitchingman (Fri 24 04:55)
• Re: postgresql-9.0 Windows service stops after database transaction Thom Brown (Fri 24 07:05)
• Re: postgresql-9.0 Windows service stops after database transaction adrian . kitchingman (Sun 26 23:19)
• Re: postgresql-9.0 Windows service stops after database transaction adrian . kitchingman (Mon 27 00:06)
• Re: postgresql-9.0 Windows service stops after database transaction Craig Ringer (Tue 28 09:12)
• Re: postgresql-9.0 Windows service stops after database transaction adrian . kitchingman (Thu 30 06:00)
• Memory usage - indexes Tobias Brox (Thu 23 21:51)
• Re: Memory usage - indexes Mark Kirkwood (Thu 23 22:13)
• Re: Memory usage - indexes Tobias Brox (Fri 24 16:53)
• Re: Memory usage - indexes Tobias Brox (Fri 24 20:00)
• Re: Memory usage - indexes Kevin Grittner (Fri 24 14:17)
• Re: Memory usage - indexes Bob Lunney (Fri 24 16:23)
• Re: Memory usage - indexes Tobias Brox (Fri 24 16:46)
• Re: Memory usage - indexes Brad Nicholson (Fri 24 17:16)
• Re: Memory usage - indexes Tobias Brox (Fri 24 17:41)
• Re: Memory usage - indexes Kevin Grittner (Fri 24 17:51)
• Re: Memory usage - indexes Greg Smith (Fri 24 18:05)
• Re: Memory usage - indexes Brad Nicholson (Fri 24 18:34)
• Re: Memory usage - indexes Bob Lunney (Fri 24 19:06)
• Re: Memory usage - indexes Brad Nicholson (Fri 24 19:25)
• Re: Memory usage - indexes Tobias Brox (Fri 24 20:08)
• Re: Memory usage - indexes Tobias Brox (Fri 24 19:59)
• Re: Memory usage - indexes Greg Smith (Fri 24 18:01)
• Re: Memory usage - indexes Tobias Brox (Fri 24 20:50)
• Re: Memory usage - indexes Greg Smith (Fri 24 22:00)
• Re: Memory usage - indexes Tobias Brox (Sat 25 10:30)
• Re: Memory usage - indexes Tobias Brox (Wed 29 06:42)
• Re: Memory usage - indexes Mark Kirkwood (Wed 29 08:03)
• Re: Memory usage - indexes Tobias Brox (Wed 29 12:10)
• Re: Memory usage - indexes Mark Kirkwood (Thu 30 21:01)
• how to enforce index sub-select over filter+seqscan Dmitry Teslenko (Thu 23 14:26)
• Re: how to enforce index sub-select over filter+seqscan Kevin Grittner (Thu 23 15:43)
• Re: how to enforce index sub-select over filter+seqscan Merlin Moncure (Thu 23 19:41)
• Re: how to enforce index sub-select over filter+seqscan Robert Haas (Mon 27 17:30)
• Re: slow DDL creation Robert Haas (Tue 21 19:39)
• Re: Using Between Robert Haas (Tue 21 19:35)
• Re: Using Between Ozer, Pam (Tue 21 20:14)
• Re: Using Between Robert Haas (Wed 22 10:52)
• Re: Using Between Ozer, Pam (Wed 22 15:19)
• Re: Using Between Robert Haas (Wed 22 16:27)
• Re: Using Between Ozer, Pam (Wed 22 16:28)
• Re: Using Between mark (Thu 23 00:51)
• Re: GPU Accelerated Sorting Robert Haas (Tue 21 19:28)
• Query much faster with enable_seqscan=0 Ogden (Tue 21 17:39)
• Re: Query much faster with enable_seqscan=0 Kenneth Marshall (Tue 21 18:15)
• Re: Query much faster with enable_seqscan=0 Ogden (Tue 21 18:22)
• Re: Query much faster with enable_seqscan=0 Jesper Krogh (Tue 21 18:51)
• Re: Query much faster with enable_seqscan=0 Ogden (Tue 21 19:02)
• Re: Query much faster with enable_seqscan=0 Joshua D. Drake (Tue 21 19:07)
• Re: Query much faster with enable_seqscan=0 Greg Smith (Tue 21 19:17)
• Re: Query much faster with enable_seqscan=0 Ogden (Tue 21 19:34)
• Re: Query much faster with enable_seqscan=0 Ogden (Wed 22 13:36)
• Re: Query much faster with enable_seqscan=0 Scott Carey (Fri 24 17:33)
• Re: Query much faster with enable_seqscan=0 Robert Haas (Tue 28 16:03)
• Re: Query much faster with enable_seqscan=0 Tom Lane (Tue 21 23:25)
• Re: Query much faster with enable_seqscan=0 Tom Lane (Tue 21 23:30)
• Memory speed testing Greg Smith (Tue 21 04:20)
• Re: Memory speed testing Greg Smith (Mon 27 16:53)
• Auto ANALYZE criteria Joe Miller (Mon 20 20:38)
• Re: Auto ANALYZE criteria Kevin Grittner (Mon 20 22:29)
• Re: Auto ANALYZE criteria Joe Miller (Tue 21 14:59)
• Re: Auto ANALYZE criteria Tom Lane (Tue 21 02:12)
• Re: Auto ANALYZE criteria Joe Miller (Tue 21 13:33)
• Re: Auto ANALYZE criteria Tom Lane (Tue 21 20:44)
• Need PostgreSQL data warehousing user, on the record Josh Berkus (Mon 20 18:48)
• cleanup on pg_ system tables? mark (Mon 20 17:25)
• Re: cleanup on pg_ system tables? Josh Kupershmidt (Mon 20 19:24)
• Performance degradation, index bloat and planner estimates Daniele Varrazzo (Mon 20 11:59)
• Re: Performance degradation, index bloat and planner estimates Craig Ringer (Wed 22 04:10)
• Re: Performance degradation, index bloat and planner estimates Tom Lane (Wed 22 04:20)
• 3ware trivia overload Greg Smith (Sat 18 07:50)
• Re: 3ware trivia overload George Sexton (Mon 20 22:03)
• Re: 3ware trivia overload David Rees (Mon 20 22:10)
• Is disableing nested_loops a bad idea ? Franck Routier (Thu 16 08:31)
• Re: Is disableing nested_loops a bad idea ? Samuel Gendler (Thu 16 10:03)
• Re: Is disableing nested_loops a bad idea ? Kevin Grittner (Thu 16 13:50)
• Re: Is disableing nested_loops a bad idea ? Franck Routier (Thu 16 14:13)
• Re: Is disableing nested_loops a bad idea ? Kevin Grittner (Thu 16 14:25)
• Re: Is disableing nested_loops a bad idea ? Robert Haas (Sun 26 04:02)
• Re: turn off caching for performance test Merlin Moncure (Wed 15 21:10)
• <Possible follow-ups>
• Re: turn off caching for performance test Robert Haas (Sun 26 03:36)
• Re: turn off caching for performance test Willy-Bas Loos (Thu 30 16:42)
• POSTGRES error Timothy.Noonan (Wed 15 11:31)
• Re: POSTGRES error Kevin Grittner (Wed 15 13:38)
• locking issue on simple selects? Tobias Brox (Wed 15 10:06)
• Re: locking issue on simple selects? Tom Lane (Wed 15 13:43)
• Re: locking issue on simple selects? Tobias Brox (Wed 15 19:09)
• Re: locking issue on simple selects? Tom Lane (Wed 15 19:21)
• Re: locking issue on simple selects? Greg Smith (Wed 15 19:28)
• Re: locking issue on simple selects? Tobias Brox (Wed 15 21:33)
• Re: locking issue on simple selects? Greg Smith (Thu 16 00:32)
• Re: locking issue on simple selects? Brad Nicholson (Wed 15 19:33)
• Re: locking issue on simple selects? Tobias Brox (Thu 23 20:47)
• Re: locking issue on simple selects? Kevin Grittner (Thu 23 20:56)
• Re: locking issue on simple selects? Tobias Brox (Thu 23 22:26)
• Re: locking issue on simple selects? Kevin Grittner (Thu 23 22:50)
• Performance problem with joined aggregate query Anssi Kääriäinen (Wed 15 06:19)
• Re: Performance problem with joined aggregate query Merlin Moncure (Wed 15 22:37)
• Re: Performance problem with joined aggregate query Anssi Kääriäinen (Thu 16 05:39)
• Re: Performance problem with joined aggregate query Merlin Moncure (Thu 16 14:53)
• Held idle connections vs use of a Pooler mark (Tue 14 16:10)
• Re: Held idle connections vs use of a Pooler Joshua D. Drake (Tue 14 16:59)
• Re: Held idle connections vs use of a Pooler Merlin Moncure (Tue 14 17:01)
• Re: Held idle connections vs use of a Pooler Craig James (Tue 14 17:14)
• Where does data in pg_stat_user_tables come from? Josh Berkus (Mon 13 23:06)
• Re: Where does data in pg_stat_user_tables come from? Joshua D. Drake (Mon 13 23:42)
• Re: Where does data in pg_stat_user_tables come from? Josh Berkus (Mon 13 23:48)
• Re: Where does data in pg_stat_user_tables come from? Joshua D. Drake (Tue 14 00:12)
• Re: Where does data in pg_stat_user_tables come from? Josh Berkus (Tue 14 00:54)
• Re: Where does data in pg_stat_user_tables come from? Alvaro Herrera (Tue 14 03:57)
• Re: Where does data in pg_stat_user_tables come from? Josh Berkus (Thu 16 18:39)
• Re: Where does data in pg_stat_user_tables come from? Guillaume Lelarge (Thu 16 19:02)
• Re: Where does data in pg_stat_user_tables come from? Tom Lane (Thu 16 19:15)
• Re: Where does data in pg_stat_user_tables come from? Josh Berkus (Thu 16 19:34)
• Re: Where does data in pg_stat_user_tables come from? Tom Lane (Tue 14 01:41)
• Useless sort by Gaetano Mendola (Mon 13 09:53)
• Re: Useless sort by Tom Lane (Mon 13 14:45)
• Re: Useless sort by Gaetano Mendola (Mon 13 16:24)
• Re: Useless sort by Tom Lane (Mon 13 16:48)
• Re: Useless sort by Gaetano Mendola (Mon 13 17:09)
• Re: Useless sort by Maciek Sakrejda (Mon 13 19:02)
• Re: Useless sort by Scott Marlowe (Mon 13 19:08)
• Re: Useless sort by Robert Haas (Thu 23 00:54)
• Re: Useless sort by gnuoytr (Thu 23 03:05)
• Re: Useless sort by Greg Smith (Thu 23 04:01)
• Re: Useless sort by Scott Marlowe (Thu 23 04:18)
• Re: Useless sort by Robert Haas (Thu 23 04:46)
• Re: Useless sort by Heikki Linnakangas (Tue 14 07:10)
• Re: Useless sort by Maciek Sakrejda (Tue 14 15:09)
• Re: Useless sort by Dave Crooke (Tue 14 16:15)
• Re: Useless sort by Gaetano Mendola (Tue 14 17:07)
• <Possible follow-ups>
• Re: Useless sort by gnuoytr (Thu 23 13:51)
• Re: Useless sort by Scott Marlowe (Thu 23 17:11)
• Problem with mergejoin performance azajac (Mon 13 05:49)
• Re: Problem with mergejoin performance Tom Lane (Mon 13 14:26)
• Message not available
  • Re: Problem with mergejoin performance Tom Lane (Mon 13 15:16)
• Problem with mergejoin performance (some bug?) azajac (Sun 12 18:16)
• Slow SQL lookup due to every field being listed in SORT KEY Mason Harding (Fri 10 22:35)
• Re: Slow SQL lookup due to every field being listed in SORT KEY Stephen Frost (Sat 11 01:59)
• Re: Slow SQL lookup due to every field being listed in SORT KEY Tom Lane (Sat 11 02:00)
• Re: Slow SQL lookup due to every field being listed in SORT KEY Stephen Frost (Sat 11 02:03)
• Re: Slow SQL lookup due to every field being listed in SORT KEY Mason Harding (Mon 13 16:32)
• pgbench could not send data to client: Broken pipe David Kerr (Wed 08 17:46)
• Re: pgbench could not send data to client: Broken pipe Tom Lane (Wed 08 19:10)
• Re: pgbench could not send data to client: Broken pipe Greg Smith (Wed 08 19:27)
• Re: pgbench could not send data to client: Broken pipe Tom Lane (Wed 08 19:44)
• Re: pgbench could not send data to client: Broken pipe David Kerr (Wed 08 19:58)
• Re: pgbench could not send data to client: Broken pipe David Kerr (Wed 08 19:57)
• Re: pgbench could not send data to client: Broken pipe Tom Lane (Wed 08 20:35)
• Re: pgbench could not send data to client: Broken pipe David Kerr (Wed 08 20:44)
• Re: pgbench could not send data to client: Broken pipe Kevin Grittner (Wed 08 20:56)
• Re: pgbench could not send data to client: Broken pipe David Kerr (Wed 08 21:21)
• Re: pgbench could not send data to client: Broken pipe Kevin Grittner (Wed 08 21:51)
• Re: pgbench could not send data to client: Broken pipe David Kerr (Wed 08 22:00)
• Re: pgbench could not send data to client: Broken pipe Kevin Grittner (Wed 08 22:27)
• Re: pgbench could not send data to client: Broken pipe David Kerr (Wed 08 22:30)
• Re: pgbench could not send data to client: Broken pipe Alvaro Herrera (Thu 09 14:38)
• Re: pgbench could not send data to client: Broken pipe David Kerr (Thu 09 15:12)
• Re: pgbench could not send data to client: Broken pipe Greg Smith (Thu 09 16:05)
• Re: pgbench could not send data to client: Broken pipe Kevin Grittner (Thu 09 17:24)
• Re: pgbench could not send data to client: Broken pipe Greg Smith (Thu 09 18:07)

---

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

---

Mail converted by MHonArc