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

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

• Performance of SQL Function versus View Igor Schtein (Wed 29 20:38)
• Inefficient min/max against partition (ver 9.1.1) McGehee, Robert (Wed 29 17:32)
• Large insert and delete batches Anssi Kääriäinen (Wed 29 10:16)
• problems with set_config, work_mem, maintenance_work_mem, and sorting Jon Nelson (Tue 28 19:17)
• Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Tom Lane (Tue 28 19:28)
• Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Jon Nelson (Tue 28 19:34)
• Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Tom Lane (Tue 28 20:52)
• Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Jon Nelson (Tue 28 21:38)
• Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Tom Lane (Tue 28 21:55)
• Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Claudio Freire (Tue 28 22:47)
• Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Jon Nelson (Tue 28 23:01)
• Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Claudio Freire (Tue 28 23:43)
• Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Ants Aasma (Wed 29 07:30)
• Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Kääriäinen Anssi (Tue 28 21:49)
• Index condition in a Nested Loop Mark Hills (Sun 26 14:17)
• Re: Index condition in a Nested Loop Tom Lane (Sun 26 21:00)
• Re: Index condition in a Nested Loop Mark Hills (Mon 27 23:14)
• Re: Index condition in a Nested Loop Tom Lane (Tue 28 00:17)
• PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (Sun 26 00:16)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes (Sun 26 02:14)
• Re： [PERFORM] PG as in-memory db? How to wa rm up and re-populate buffers? How to read in all tuples into memory? Wales Wang (Sun 26 08:52)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (Sun 26 10:56)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stephen Frost (Sun 26 13:55)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes (Sun 26 22:34)
• 回复： [PERFORM] PG as in-memory db? How t o warm up and re-populate buffers? How to rea d in all tuples into memory? Wales Wang (Mon 27 12:46)
• Re: 回复： [PERFORM] PG as in-memory db? How to w arm up and re-populate buffers? How to read in all tuples in to memory? Stefan Keller (Tue 28 08:31)
• Re: [PERFORM] Re: 回复： [PERFORM] PG as in-memor y db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire (Tue 28 13:08)
• Re: [PERFORM] Re: [PERFORM] Re: 回复： [PE RFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tupl es into memory? Tomas Vondra (Tue 28 13:39)
• Re: [PERFORM] Re: [PERFORM] Re: 回复： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire (Tue 28 13:52)
• Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: 回复： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to re ad in all tuples into memory? Tomas Vondra (Tue 28 14:16)
• Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: 回复 ： [PERFORM] PG as in-memory db? How to warm up and re-popu late buffers? How to read in all tuples into memory? Claudio Freire (Tue 28 14:24)
• Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: 回复： [PERFORM] PG as in-m emory db? How to warm up and re-populate buff ers? How to read in all tuples into memory? Tomas Vondra (Tue 28 16:05)
• Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: [PERFO RM] Re: 回复： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into m emory? Claudio Freire (Tue 28 16:42)
• Re: 回复： [PERFORM] PG as in-memory db? How to w arm up and re-populate buffers? How to read in all tuples in to memory? Jeff Janes (Tue 28 15:15)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Thomas Kellerer (Sun 26 11:46)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andy Colson (Sun 26 15:21)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (Sun 26 19:11)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andy Colson (Sun 26 19:21)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (Sun 26 20:38)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes (Tue 28 15:22)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (Tue 28 20:49)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire (Tue 28 22:41)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (Tue 28 23:46)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes (Wed 29 15:16)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire (Wed 29 15:18)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (Wed 29 15:24)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (Wed 29 15:28)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Cédric Villemain (Sun 26 19:36)
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (Sun 26 20:56)
• <Possible follow-ups>
• Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Cédric Villemain (Sun 26 19:36)
• Joining tables by UUID field - very slow Cherio (Fri 24 22:46)
• Re: Joining tables by UUID field - very slow Merlin Moncure (Mon 27 14:53)
• Re: Joining tables by UUID field - very slow Tom Lane (Mon 27 15:25)
• Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8 Jayashankar K B (Thu 23 20:14)
• Re: Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8 Tom Lane (Thu 23 20:20)
• : Cost calculation for EXPLAIN output Venkat Balaji (Thu 23 12:21)
• Re: : Cost calculation for EXPLAIN output Kevin Grittner (Thu 23 16:51)
• Re: : Cost calculation for EXPLAIN output Venkat Balaji (Sun 26 17:15)
• Re: : Cost calculation for EXPLAIN output Shaun Thomas (Thu 23 16:56)
• Re: : Cost calculation for EXPLAIN output Venkat Balaji (Sun 26 17:23)
• Very long deletion time on a 200 GB database Reuven M. Lerner (Thu 23 08:40)
• Re: Very long deletion time on a 200 GB database Glyn Astill (Thu 23 09:50)
• Re: Very long deletion time on a 200 GB database Reuven M. Lerner (Fri 24 06:40)
• Re: Very long deletion time on a 200 GB database Samuel Gendler (Fri 24 08:22)
• Re: Very long deletion time on a 200 GB database Reuven M. Lerner (Fri 24 12:38)
• Re: Very long deletion time on a 200 GB database Claudio Freire (Fri 24 13:07)
• Re: Very long deletion time on a 200 GB database lephongvu (Mon 27 04:33)
• Re: Very long deletion time on a 200 GB database Shaun Thomas (Fri 24 14:34)
• Re: Very long deletion time on a 200 GB database Reuven M. Lerner (Fri 24 14:54)
• Re: Very long deletion time on a 200 GB database Shaun Thomas (Fri 24 15:17)
• Re: Very long deletion time on a 200 GB database Reuven M. Lerner (Sun 26 10:47)
• Re: Very long deletion time on a 200 GB database Marcin Mańk (Thu 23 10:08)
• Re: Very long deletion time on a 200 GB database Andrew Dunstan (Thu 23 14:25)
• Re: Very long deletion time on a 200 GB database Reuven M. Lerner (Thu 23 15:26)
• Re: Very long deletion time on a 200 GB database ktm(at)rice(dot)edu (Thu 23 15:29)
• Re: Very long deletion time on a 200 GB database Lew (Thu 23 15:44)
• Re: Very long deletion time on a 200 GB database Greg Spiegelberg (Thu 23 17:56)
• Re: Very long deletion time on a 200 GB database Shaun Thomas (Thu 23 18:05)
• Re: Very long deletion time on a 200 GB database Andy Colson (Thu 23 18:11)
• Re: Very long deletion time on a 200 GB database Greg Spiegelberg (Thu 23 18:13)
• Re: Very long deletion time on a 200 GB database Tom Lane (Thu 23 18:31)
• Re: Very long deletion time on a 200 GB database Richard Huxton (Thu 23 11:23)
• Re: Very long deletion time on a 200 GB database Claudio Freire (Thu 23 14:07)
• Re: Very long deletion time on a 200 GB database Steve Crawford (Thu 23 15:47)
• Re: Very long deletion time on a 200 GB database Shaun Thomas (Thu 23 16:37)
• Re: Very long deletion time on a 200 GB database Tom Lane (Thu 23 19:04)
• Re: Very long deletion time on a 200 GB database Jesper Krogh (Thu 23 19:48)
• Re: Very long deletion time on a 200 GB database Steve Crawford (Fri 24 17:20)
• Re: Very long deletion time on a 200 GB database Reuven M. Lerner (Mon 27 08:08)
• Re: Very long deletion time on a 200 GB database Shaun Thomas (Mon 27 14:46)
• Re: Very long deletion time on a 200 GB database Andrew Dunstan (Mon 27 14:54)
• Re: Very long deletion time on a 200 GB database Shaun Thomas (Mon 27 15:01)
• Re: Very long deletion time on a 200 GB database Claudio Freire (Mon 27 19:01)
• Re: Very long deletion time on a 200 GB database Reuven M. Lerner (Mon 27 15:00)
• Re: Very long deletion time on a 200 GB database Shaun Thomas (Mon 27 15:14)
• Re: Very long deletion time on a 200 GB database Lew (Mon 27 17:14)
• Re: Very long deletion time on a 200 GB database Samuel Gendler (Mon 27 21:14)
• Re: Very long deletion time on a 200 GB database Scott Marlowe (Mon 27 21:28)
• Re: Very long deletion time on a 200 GB database David Kerr (Tue 28 17:06)
• Re: Very long deletion time on a 200 GB database Gavin Flower (Wed 29 05:31)
• Re: Very long deletion time on a 200 GB database Jeff Janes (Sat 25 19:18)
• Re: Very long deletion time on a 200 GB database Reuven M. Lerner (Sun 26 07:34)
• set autovacuum=off Alessandro Gagliardi (Wed 22 23:51)
• Re: set autovacuum=off Thom Brown (Thu 23 12:35)
• Re: set autovacuum=off Andy Colson (Thu 23 15:18)
• Re: set autovacuum=off Alessandro Gagliardi (Thu 23 17:35)
• Re: set autovacuum=off Thom Brown (Thu 23 17:46)
• Re: set autovacuum=off Alessandro Gagliardi (Thu 23 17:58)
• Re: set autovacuum=off Steve Crawford (Thu 23 18:01)
• Re: set autovacuum=off Alessandro Gagliardi (Thu 23 18:38)
• Re: set autovacuum=off Peter van Hardenberg (Thu 23 18:42)
• Re: set autovacuum=off Alessandro Gagliardi (Thu 23 20:28)
• Re: set autovacuum=off Andy Colson (Thu 23 19:07)
• Re: set autovacuum=off Alessandro Gagliardi (Thu 23 20:41)
• Re: set autovacuum=off Andy Colson (Thu 23 20:57)
• Re: set autovacuum=off Steve Crawford (Thu 23 19:27)
• Re: set autovacuum=off Alessandro Gagliardi (Thu 23 21:08)
• Re: set autovacuum=off Peter van Hardenberg (Thu 23 21:11)
• Re: set autovacuum=off Alessandro Gagliardi (Thu 23 22:54)
• Re: set autovacuum=off Filippos Kalamidas (Mon 27 21:55)
• Re: set autovacuum=off Filippos Kalamidas (Mon 27 22:00)
• Re: set autovacuum=off Steve Crawford (Thu 23 21:38)
• Re: set autovacuum=off Alessandro Gagliardi (Thu 23 22:30)
• Indexes and Primary Keys on Rapidly Growing Tables Alessandro Gagliardi (Mon 20 22:06)
• Re: Indexes and Primary Keys on Rapidly Growing Tables Josh Berkus (Mon 20 23:30)
• Re: Indexes and Primary Keys on Rapidly Growing Tables Alessandro Gagliardi (Tue 21 17:59)
• Re: Indexes and Primary Keys on Rapidly Growing Tables Samuel Gendler (Tue 21 23:53)
• Re: Indexes and Primary Keys on Rapidly Growing Tables Alessandro Gagliardi (Wed 22 00:11)
• Insertions slower than Updates? Ofer Israeli (Mon 20 18:59)
• Re: Insertions slower than Updates? Kevin Grittner (Mon 20 19:13)
• Re: Insertions slower than Updates? Ofer Israeli (Mon 20 19:21)
• Re: Insertions slower than Updates? Kevin Grittner (Mon 20 19:30)
• Re: Insertions slower than Updates? Steve Horn (Mon 20 19:32)
• Re: Insertions slower than Updates? Ofer Israeli (Mon 20 20:17)
• Re: Insertions slower than Updates? Ofer Israeli (Mon 20 20:17)
• Query slow as function Steve Horn (Sat 18 14:50)
• Re: Query slow as function Merlin Moncure (Mon 20 17:32)
• <Possible follow-ups>
• Query slow as Function Steve Horn (Sat 18 15:04)
• Re: Query slow as Function Andreas Kretschmer (Sat 18 16:03)
• Re: Query slow as Function Tom Lane (Sat 18 16:37)
• Re: Query slow as Function Andrew Dunstan (Sat 18 16:41)
• Re: Query slow as Function Tom Lane (Sat 18 17:20)
• Re: Query slow as Function Steve Horn (Sat 18 17:15)
• Re: Query slow as Function Andreas Kretschmer (Sat 18 17:33)
• Why so slow? Alessandro Gagliardi (Fri 17 18:35)
• Re: Why so slow? Steve Crawford (Fri 17 19:22)
• Re: Why so slow? Alessandro Gagliardi (Fri 17 22:20)
• Re: Why so slow? Ants Aasma (Sat 18 05:29)
• Re: Why so slow? Alessandro Gagliardi (Mon 20 21:14)
• Optimizer is not choosing index Markus Innerebner (Wed 15 22:40)
• Re: Optimizer is not choosing index Tom Lane (Wed 15 23:11)
• Re: Optimizer is not choosing index Markus Innerebner (Thu 16 06:54)
• UPDATE on NOT JOIN Gabriel Biberian (Wed 15 18:34)
• Re: UPDATE on NOT JOIN Marti Raudsepp (Wed 15 19:12)
• Fwd: [HACKERS] client performance v.s. server statistics Zhou Han (Wed 15 09:38)
• Fwd: [HACKERS] client performance v.s. server statistics Zhou Han (Wed 15 10:19)
• Re: Fwd: [HACKERS] client performance v.s. server statistics Andres Freund (Wed 15 10:55)
• Re: Fwd: [HACKERS] client performance v.s. server statistics Han Zhou (Wed 15 11:03)
• Re: Fwd: [HACKERS] client performance v.s. server statistics Han Zhou (Wed 15 11:33)
• Re: Fwd: [HACKERS] client performance v.s. server statistics Andres Freund (Wed 15 11:36)
• Re: Fwd: [HACKERS] client performance v.s. server statistics Han Zhou (Thu 16 01:45)
• timestamp with time zone Alessandro Gagliardi (Thu 09 18:42)
• Re: timestamp with time zone Tom Lane (Thu 09 19:46)
• Re: timestamp with time zone Alessandro Gagliardi (Thu 09 20:01)
• Re: timestamp with time zone Kevin Grittner (Thu 09 20:15)
• Re: timestamp with time zone Alessandro Gagliardi (Thu 09 20:38)
• Re: timestamp with time zone Tom Lane (Fri 10 06:20)
• Re: timestamp with time zone Alessandro Gagliardi (Fri 10 19:54)
• Re: pl/pgsql functions outperforming sql ones? Robert Haas (Wed 08 20:33)
• Vacuuming problems on TOAST table Ofer Israeli (Wed 08 19:34)
• Re: Vacuuming problems on TOAST table Tom Lane (Wed 08 19:44)
• Re: Vacuuming problems on TOAST table Ofer Israeli (Wed 08 20:00)
• Re: Vacuuming problems on TOAST table Robert Haas (Wed 29 18:45)
• Performance on large, append-only tables David Yeu (Wed 08 18:03)
• Re: Performance on large, append-only tables Merlin Moncure (Fri 10 15:19)
• Re: Performance on large, append-only tables Claudio Freire (Fri 10 15:33)
• Re: Performance on large, append-only tables Marti Raudsepp (Fri 10 15:35)
• Re: Performance on large, append-only tables Tom Lane (Fri 10 15:36)
• Re: Performance on large, append-only tables Kevin Grittner (Fri 10 15:44)
• <Possible follow-ups>
• Re: Performance on large, append-only tables David Yeu (Fri 10 16:20)

---

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

---

Mail converted by MHonArc