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

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

• Guidance Requested - Bulk Inserting + Queries Benjamin Johnson (Wed 30 15:27)
• <Possible follow-ups>
• Re: Guidance Requested - Bulk Inserting + Queries Leonardo Francalanci (Wed 30 16:17)
• Re: Guidance Requested - Bulk Inserting + Queries Benjamin Johnson (Thu 01 02:01)
• vacuum internals and performance affect MirrorX (Tue 29 17:12)
• Re: vacuum internals and performance affect Josh Berkus (Wed 30 21:19)
• Re: vacuum internals and performance affect MirrorX (Wed 30 21:34)
• Re: WAL in RAM Marcus Engene (Tue 29 16:59)
• PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld (Mon 28 16:42)
• Re: PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld (Mon 28 16:58)
• Re: PostgreSQL 9.1 : why is this query slow? Kevin Grittner (Mon 28 17:05)
• Re: PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld (Mon 28 17:23)
• Re: PostgreSQL 9.1 : why is this query slow? Kevin Grittner (Mon 28 17:32)
• Re: PostgreSQL 9.1 : why is this query slow? Kevin Grittner (Mon 28 17:37)
• Re: PostgreSQL 9.1 : why is this query slow? Joost Kraaijeveld (Tue 29 15:40)
• Re: PostgreSQL 9.1 : why is this query slow? Tomas Vondra (Mon 28 19:32)
• query uses index but takes too much time? MirrorX (Thu 24 17:20)
• Re: query uses index but takes too much time? Aidan Van Dyk (Thu 24 17:51)
• Re: query uses index but takes too much time? Cédric Villemain (Thu 24 19:25)
• Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Maxim Boguk (Thu 24 02:57)
• Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Tom Lane (Thu 24 17:05)
• Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Maxim Boguk (Thu 24 22:54)
• Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Craig Ringer (Sun 27 22:51)
• Re: Some question about lazy subquery/procedures execution in SELECT ... ORDER BY... LIMIT N queries Maxim Boguk (Mon 28 00:06)
• Seq Scan used instead of Index Scan Gary Warner (Wed 23 22:24)
• Re: Seq Scan used instead of Index Scan Claudio Freire (Wed 23 22:43)
• Re: Seq Scan used instead of Index Scan Mark Kirkwood (Thu 24 01:30)
• Re: Seq Scan used instead of Index Scan Tom Lane (Thu 24 03:06)
• Autovacuum Issue J Ramesh Kumar (Wed 23 05:55)
• Re: Autovacuum Issue Raghavendra (Wed 23 06:11)
• SSD endurance calculations Christiaan Willemsen (Mon 21 21:04)
• Re: SSD endurance calculations Edgardo Portal (Tue 22 17:15)
• Re: SSD endurance calculations Greg Smith (Wed 23 15:19)
• Re: Problems with FTS Rauan Maemirov (Mon 21 05:54)
• Re: Problems with FTS Robert Haas (Wed 30 20:58)
• Benchmarking tools, methods CSS (Fri 18 09:56)
• Re: Benchmarking tools, methods Tomas Vondra (Fri 18 11:59)
• Re: Benchmarking tools, methods Cédric Villemain (Fri 18 12:45)
• Re: Benchmarking tools, methods Scott Marlowe (Fri 18 17:39)
• Re: Benchmarking tools, methods Greg Smith (Sat 19 16:21)
• Re: Benchmarking tools, methods CSS (Mon 28 22:33)
• Re: SSD options, small database, ZFS CSS (Fri 18 03:45)
• Re: SSD options, small database, ZFS Arjen van der Meijden (Fri 18 07:02)
• Re: SSD options, small database, ZFS Greg Smith (Fri 18 10:09)
• Re: SSD options, small database, ZFS Scott Marlowe (Fri 18 16:17)
• Re: SSD options, small database, ZFS Tomas Vondra (Fri 18 16:31)
• Re: SSD options, small database, ZFS Amitabh Kant (Fri 18 17:20)
• Re: SSD options, small database, ZFS Bruce Momjian (Tue 22 18:11)
• Re: SSD options, small database, ZFS Amitabh Kant (Wed 23 11:34)
• Re: SSD options, small database, ZFS Bruce Momjian (Tue 22 18:10)
• index usage for min() vs. "order by asc limit 1" Ben Chobot (Fri 18 01:12)
• Re: index usage for min() vs. "order by asc limit 1" Steve Atkins (Fri 18 01:20)
• Re: index usage for min() vs. "order by asc limit 1" Ben Chobot (Fri 18 01:23)
• Re: index usage for min() vs. "order by asc limit 1" MirrorX (Fri 18 14:16)
• probably cause (and fix) for floating-point assist faults on itanium Greg Matthews (Fri 18 01:08)
• Re: probably cause (and fix) for floating-point assist faults on itanium Claudio Freire (Fri 18 14:22)
• Re: probably cause (and fix) for floating-point assist faults on itanium Tom Lane (Fri 18 16:11)
• Re: probably cause (and fix) for floating-point assist faults on itanium Greg Matthews (Fri 18 16:38)
• Re: probably cause (and fix) for floating-point assist faults on itanium Tom Lane (Sat 19 05:39)
• external sort performance Jon Nelson (Thu 17 17:11)
• Re: external sort performance Claudio Freire (Thu 17 17:17)
• Re: external sort performance Jon Nelson (Thu 17 19:33)
• Re: external sort performance Jon Nelson (Thu 17 20:12)
• Re: external sort performance Tom Lane (Fri 18 00:34)
• Re: external sort performance Josh Berkus (Fri 18 00:46)
• Re: external sort performance Craig James (Thu 17 17:28)
• Re: external sort performance Tom Lane (Thu 17 17:55)
• Re: external sort performance Jeremy Harris (Sun 20 13:56)
• Re: external sort performance Jon Nelson (Sun 20 15:01)
• Re: external sort performance Jeremy Harris (Sun 20 16:12)
• Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (Wed 16 22:53)
• Re: Performance question 83 GB Table 150 million rows, distinct select Alan Hodgson (Wed 16 23:28)
• Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe (Wed 16 23:32)
• Re: Performance question 83 GB Table 150 million rows, distinct select Samuel Gendler (Wed 16 23:52)
• Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe (Thu 17 01:59)
• Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra (Thu 17 00:00)
• Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (Thu 17 00:45)
• Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe (Thu 17 01:58)
• Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra (Thu 17 02:27)
• Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (Thu 17 02:43)
• Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe (Thu 17 03:03)
• Re: Performance question 83 GB Table 150 million rows, distinct select Scott Marlowe (Thu 17 03:04)
• Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (Thu 17 03:16)
• Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra (Thu 17 03:47)
• Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (Thu 17 05:23)
• Re: Performance question 83 GB Table 150 million rows, distinct select Aidan Van Dyk (Thu 17 14:17)
• Re: Performance question 83 GB Table 150 million rows, distinct select Tomas Vondra (Thu 17 16:06)
• Re: Performance question 83 GB Table 150 million rows, distinct select Claudio Freire (Thu 17 16:56)
• Re: Performance question 83 GB Table 150 million rows, distinct select Josh Berkus (Thu 17 05:19)
• Re: Performance question 83 GB Table 150 million rows, distinct select Tory M Blue (Thu 17 05:33)
• Re: Performance question 83 GB Table 150 million rows, distinct select Andy Colson (Thu 17 02:11)
• Large number of short lived connections - could a connection pool help? Cody Caughlan (Tue 15 00:42)
• Re: Large number of short lived connections - could a connection pool help? Ben Chobot (Tue 15 01:06)
• Re: Large number of short lived connections - could a connection pool help? Cody Caughlan (Tue 15 01:04)
• Re: Large number of short lived connections - could a connection pool help? Mario Weilguni (Tue 15 08:12)
• Query planner suggestion, for indexes with similar but not exact ordering. Andrew Barnham (Mon 14 22:31)
• Re: Query planner suggestion, for indexes with similar but not exact ordering. Robert Haas (Wed 30 20:51)
• Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan (Mon 14 18:17)
• Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (Mon 14 19:23)
• Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan (Mon 14 22:06)
• Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (Mon 14 23:06)
• Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan (Tue 15 00:14)
• Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (Wed 16 00:13)
• Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (Wed 16 00:19)
• Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan (Wed 16 01:23)
• Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (Wed 16 02:16)
• Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (Wed 16 16:52)
• Re: Slow queries / commits, mis-configuration or hardware issues? Cody Caughlan (Wed 16 17:32)
• Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (Wed 16 18:17)
• Re: Slow queries / commits, mis-configuration or hardware issues? Greg Smith (Wed 16 04:27)
• Re: Slow queries / commits, mis-configuration or hardware issues? Tomas Vondra (Wed 16 16:34)
• What's the state of postgresql on ext4 now? Alexandru (Mon 14 10:00)
• Re: What's the state of postgresql on ext4 now? Maciek Sakrejda (Tue 15 07:41)
• Re: What's the state of postgresql on ext4 now? Josh Berkus (Tue 15 20:49)
• Re: What's the state of postgresql on ext4 now? Scott Marlowe (Tue 15 20:54)
• Re: What's the state of postgresql on ext4 now? Greg Smith (Wed 16 03:48)
• Re: What's the state of postgresql on ext4 now? Scott Marlowe (Wed 16 03:55)
• Re: What's the state of postgresql on ext4 now? Aidan Van Dyk (Wed 16 04:01)
• Re: What's the state of postgresql on ext4 now? Greg Smith (Wed 16 06:51)
• Using incrond for archiving Shaun Thomas (Fri 11 22:21)
• Re: Using incrond for archiving Shaun Thomas (Mon 14 21:41)
• Re: Using incrond for archiving Kevin Grittner (Mon 14 21:47)
• Re: Using incrond for archiving Shaun Thomas (Mon 14 22:07)
• unlogged tables Anibal David Acosta (Fri 11 20:14)
• Re: unlogged tables Stephen Frost (Fri 11 20:18)
• Re: unlogged tables Sergey Konoplev (Mon 14 08:11)
• Re: unlogged tables Richard Huxton (Mon 14 08:58)
• Re: unlogged tables Sergey Konoplev (Mon 14 10:09)
• Re: unlogged tables Richard Huxton (Mon 14 10:18)
• Re: unlogged tables Sergey Konoplev (Mon 14 10:39)
• Re: unlogged tables Anibal David Acosta (Mon 14 17:11)
• Re: unlogged tables Kevin Grittner (Mon 14 17:27)
• Re: unlogged tables Anibal David Acosta (Mon 14 17:38)
• Re: unlogged tables Kevin Grittner (Mon 14 17:50)
• Re: unlogged tables Josh Berkus (Tue 15 20:51)
• where clause + function, execution order Sorin Dudui (Fri 11 15:38)
• Re: where clause + function, execution order Julius Tuskenis (Fri 11 15:54)
• Re: where clause + function, execution order Richard Huxton (Fri 11 16:00)
• Re: where clause + function, execution order Sorin Dudui (Fri 11 16:28)
• Re: where clause + function, execution order Richard Huxton (Fri 11 16:55)
• Re: where clause + function, execution order Tom Lane (Fri 11 16:00)
• avoiding seq scans when two columns are very correlated Ruslan Zakirov (Fri 11 15:01)
• Re: avoiding seq scans when two columns are very correlated Tom Lane (Fri 11 15:36)
• Re: avoiding seq scans when two columns are very correlated Ruslan Zakirov (Fri 11 16:39)
• Re: avoiding seq scans when two columns are very correlated Stuart Bishop (Tue 15 07:16)
• Re: avoiding seq scans when two columns are very correlated Ruslan Zakirov (Tue 15 15:04)
• IMMUTABLE STABLE functions, daily updates Sorin Dudui (Thu 10 13:06)
• Re: IMMUTABLE STABLE functions, daily updates Thom Brown (Thu 10 13:26)
• Re: IMMUTABLE STABLE functions, daily updates Craig Ringer (Thu 10 14:28)
• : bg_writer overloaded ? Venkat Balaji (Wed 09 09:25)
• Re: : bg_writer overloaded ? Scott Marlowe (Wed 09 14:46)
• Re: : bg_writer overloaded ? Venkat Balaji (Mon 14 05:54)
• STRICT SQL functions never inline Josh Berkus (Tue 08 23:29)
• Re: STRICT SQL functions never inline Andres Freund (Wed 09 00:25)
• Re: STRICT SQL functions never inline Tom Lane (Wed 09 00:31)
• Trying to understand Stats/Query planner issue Strange, John W (Tue 08 22:39)
• Re: Trying to understand Stats/Query planner issue Tom Lane (Sun 13 16:17)
• WAL partition filling up after high WAL activity Richard Yen (Mon 07 22:25)
• Re: WAL partition filling up after high WAL activity Greg Smith (Wed 09 16:06)
• Re: WAL partition filling up after high WAL activity Rafael Martinez (Fri 11 09:54)
• Re: WAL partition filling up after high WAL activity Greg Smith (Sat 12 06:31)
• Subquery in a JOIN not getting restricted? Jay Levitt (Mon 07 21:25)
• Re: Subquery in a JOIN not getting restricted? Tom Lane (Mon 07 21:41)
• Re: Subquery in a JOIN not getting restricted? Kevin Grittner (Mon 07 21:53)
• Re: Subquery in a JOIN not getting restricted? Kevin Grittner (Mon 07 22:52)
• Re: Subquery in a JOIN not getting restricted? Jay Levitt (Mon 07 23:19)
• Re: Subquery in a JOIN not getting restricted? Jay Levitt (Tue 08 01:56)
• Re: Subquery in a JOIN not getting restricted? Kevin Grittner (Wed 09 15:16)
• Re: Subquery in a JOIN not getting restricted? Merlin Moncure (Wed 09 19:50)
• Re: Subquery in a JOIN not getting restricted? Kevin Grittner (Wed 09 20:20)
• Re: Subquery in a JOIN not getting restricted? Jay Levitt (Thu 10 13:52)
• Re: Subquery in a JOIN not getting restricted? Tom Lane (Thu 10 15:23)
• Re: Subquery in a JOIN not getting restricted? Jay Levitt (Thu 10 15:43)
• Re: Subquery in a JOIN not getting restricted? Jay Levitt (Wed 16 14:06)
• Re: Subquery in a JOIN not getting restricted? Jay Levitt (Wed 09 20:39)
• Re: Subquery in a JOIN not getting restricted? Gavin Flower (Sat 12 09:29)
• PostgreSQL perform poorly on VMware ESXi Lucas Mocellin (Mon 07 10:36)
• Re: PostgreSQL perform poorly on VMware ESXi Tomas Vondra (Mon 07 10:54)
• Re: PostgreSQL perform poorly on VMware ESXi ktm(at)rice(dot)edu (Mon 07 14:16)
• Re: PostgreSQL perform poorly on VMware ESXi Ivan Voras (Mon 07 15:36)
• Re: Heavy contgnous load kzsolt (Fri 04 21:36)

---

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

---

Mail converted by MHonArc