Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2012-02 Chronological Index (1/2)
Last updated: Thu Mar 01 02:20:06 2012
278 messages
28 February 2012
Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Claudio Freire (23:43)
Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Jon Nelson (23:01)
Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Claudio Freire (22:47)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire (22:41)
Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Tom Lane (21:55)
Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Kääriäinen Anssi (21:49)
Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Jon Nelson (21:38)
Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Tom Lane (20: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 (20:49)
Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Jon Nelson (19:34)
Re: problems with set_config, work_mem, maintenance_work_mem, and sorting Tom Lane (19:28)
problems with set_config, work_mem, maintenance_work_mem, and sorting Jon Nelson (19:17)
Re: Very long deletion time on a 200 GB database David Kerr (17:06)
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 (16:42)
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 (16:05)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes (15:22)
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 (15:15)
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 (14:24)
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 (14:16)
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 (13:52)
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 (13:39)
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 (13:08)
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 (08:31)
Re: Index condition in a Nested Loop Tom Lane (00:17)
27 February 2012
Re: set autovacuum=off Filippos Kalamidas (22:00)
Re: set autovacuum=off Filippos Kalamidas (21:55)
Re: Very long deletion time on a 200 GB database Scott Marlowe (21:28)
Re: Very long deletion time on a 200 GB database Samuel Gendler (21:14)
Re: Very long deletion time on a 200 GB database Claudio Freire (19:01)
Re: Very long deletion time on a 200 GB database Lew (17:14)
Re: Joining tables by UUID field - very slow Tom Lane (15:25)
Re: Very long deletion time on a 200 GB database Shaun Thomas (15:14)
Re: Very long deletion time on a 200 GB database Shaun Thomas (15:01)
Re: Very long deletion time on a 200 GB database Reuven M. Lerner (15:00)
Re: Very long deletion time on a 200 GB database Andrew Dunstan (14:54)
Re: Joining tables by UUID field - very slow Merlin Moncure (14:53)
Re: Very long deletion time on a 200 GB database Shaun Thomas (14:46)
回复: [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 (12:46)
Re: Very long deletion time on a 200 GB database Reuven M. Lerner (08:08)
Re: Very long deletion time on a 200 GB database lephongvu (04:33)
26 February 2012
Re: Index condition in a Nested Loop Tom Lane (21:00)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (20:56)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (20:38)
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 (19:36)
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 (19:36)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andy Colson (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 (19:11)
Re: : Cost calculation for EXPLAIN output Venkat Balaji (17:23)
Re: : Cost calculation for EXPLAIN output Venkat Balaji (17:15)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andy Colson (15:21)
Index condition in a Nested Loop Mark Hills (14:17)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stephen Frost (13:55)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Thomas Kellerer (11:46)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (10:56)
Re: Very long deletion time on a 200 GB database Reuven M. Lerner (10:47)
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 (08:52)
Re: Very long deletion time on a 200 GB database Reuven M. Lerner (07:34)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes (02:14)
PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (00:16)
25 February 2012
24 February 2012
Re: Very long deletion time on a 200 GB database Steve Crawford (17:20)
Re: Very long deletion time on a 200 GB database Shaun Thomas (15:17)
Re: Very long deletion time on a 200 GB database Reuven M. Lerner (14:54)
Re: Very long deletion time on a 200 GB database Shaun Thomas (14:34)
Re: Very long deletion time on a 200 GB database Claudio Freire (13:07)
Re: Very long deletion time on a 200 GB database Reuven M. Lerner (12:38)
Re: Very long deletion time on a 200 GB database Samuel Gendler (08:22)
Re: Very long deletion time on a 200 GB database Reuven M. Lerner (06:40)
23 February 2012
Re: set autovacuum=off Alessandro Gagliardi (22:30)
Re: set autovacuum=off Steve Crawford (21:38)
Re: set autovacuum=off Peter van Hardenberg (21:11)
Re: set autovacuum=off Alessandro Gagliardi (21:08)
Re: set autovacuum=off Andy Colson (20:57)
Re: set autovacuum=off Alessandro Gagliardi (20:41)
Re: set autovacuum=off Alessandro Gagliardi (20:28)
Re: Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8 Tom Lane (20:20)
Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8 Jayashankar K B (20:14)
Re: Very long deletion time on a 200 GB database Jesper Krogh (19:48)
Re: set autovacuum=off Steve Crawford (19:27)
Re: set autovacuum=off Andy Colson (19:07)
Re: Very long deletion time on a 200 GB database Tom Lane (19:04)
Re: set autovacuum=off Peter van Hardenberg (18:42)
Re: set autovacuum=off Alessandro Gagliardi (18:38)
Re: Very long deletion time on a 200 GB database Tom Lane (18:31)
Re: Very long deletion time on a 200 GB database Greg Spiegelberg (18:13)
Re: Very long deletion time on a 200 GB database Andy Colson (18:11)
Re: Very long deletion time on a 200 GB database Shaun Thomas (18:05)
Re: set autovacuum=off Steve Crawford (18:01)
Re: set autovacuum=off Alessandro Gagliardi (17:58)
Re: Very long deletion time on a 200 GB database Greg Spiegelberg (17:56)
Re: set autovacuum=off Thom Brown (17:46)
Re: set autovacuum=off Alessandro Gagliardi (17:35)
Re: : Cost calculation for EXPLAIN output Shaun Thomas (16:56)
Re: : Cost calculation for EXPLAIN output Kevin Grittner (16:51)
Re: Very long deletion time on a 200 GB database Shaun Thomas (16:37)
Re: Very long deletion time on a 200 GB database Steve Crawford (15:47)
Re: Very long deletion time on a 200 GB database Lew (15:44)
Re: Very long deletion time on a 200 GB database ktm(at)rice(dot)edu (15:29)
Re: Very long deletion time on a 200 GB database Reuven M. Lerner (15:26)
Re: set autovacuum=off Andy Colson (15:18)
Re: Very long deletion time on a 200 GB database Andrew Dunstan (14:25)
Re: Very long deletion time on a 200 GB database Claudio Freire (14:07)
Re: set autovacuum=off Thom Brown (12:35)
: Cost calculation for EXPLAIN output Venkat Balaji (12:21)
Re: Very long deletion time on a 200 GB database Richard Huxton (11:23)
Re: Very long deletion time on a 200 GB database Marcin Mańk (10:08)
Re: Very long deletion time on a 200 GB database Glyn Astill (09:50)
Very long deletion time on a 200 GB database Reuven M. Lerner (08:40)
22 February 2012
Re: Indexes and Primary Keys on Rapidly Growing Tables Alessandro Gagliardi (00:11)
21 February 2012
Re: Indexes and Primary Keys on Rapidly Growing Tables Alessandro Gagliardi (17:59)
20 February 2012
Indexes and Primary Keys on Rapidly Growing Tables Alessandro Gagliardi (22:06)
Re: Why so slow? Alessandro Gagliardi (21:14)
Re: Insertions slower than Updates? Ofer Israeli (20:17)
Re: Insertions slower than Updates? Ofer Israeli (20:17)
Re: Insertions slower than Updates? Steve Horn (19:32)
Re: Insertions slower than Updates? Kevin Grittner (19:30)
Re: Insertions slower than Updates? Ofer Israeli (19:21)
Re: Insertions slower than Updates? Kevin Grittner (19:13)
Insertions slower than Updates? Ofer Israeli (18:59)
Re: Query slow as function Merlin Moncure (17:32)
18 February 2012
Re: Query slow as Function Tom Lane (17:20)
Re: Query slow as Function Steve Horn (17:15)
Re: Query slow as Function Andrew Dunstan (16:41)
Re: Query slow as Function Tom Lane (16:37)
Re: Query slow as Function Andreas Kretschmer (16:03)
Query slow as Function Steve Horn (15:04)
Query slow as function Steve Horn (14:50)
Re: Why so slow? Ants Aasma (05:29)
17 February 2012
Re: Why so slow? Steve Crawford (19:22)
Why so slow? Alessandro Gagliardi (18:35)
16 February 2012
Re: Fwd: [HACKERS] client performance v.s. server statistics Han Zhou (01:45)
15 February 2012
Optimizer is not choosing index Markus Innerebner (22:40)
Re: UPDATE on NOT JOIN Marti Raudsepp (19:12)
UPDATE on NOT JOIN Gabriel Biberian (18:34)
Re: Fwd: [HACKERS] client performance v.s. server statistics Andres Freund (11:36)
Re: Fwd: [HACKERS] client performance v.s. server statistics Han Zhou (11:33)
Re: Fwd: [HACKERS] client performance v.s. server statistics Han Zhou (11:03)
Re: Fwd: [HACKERS] client performance v.s. server statistics Andres Freund (10:55)
Fwd: [HACKERS] client performance v.s. server statistics Zhou Han (10:19)
Fwd: [HACKERS] client performance v.s. server statistics Zhou Han (09:38)
13 February 2012
Re: rough benchmarks, sata vs. ssd CSS (21:50)
12 February 2012
Re: random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (22:29)
Re: random_page_cost = 2.0 on Heroku Postgres Joshua Berkus (20:02)
Re: random_page_cost = 2.0 on Heroku Postgres Jeff Janes (19:49)
Re: Inserts or Updates Ofer Israeli (18:32)
Re: Inserts or Updates Frank Lanitz (18:29)
Re: Inserts or Updates Ofer Israeli (10:49)
11 February 2012
Re: random_page_cost = 2.0 on Heroku Postgres Jeff Janes (16:26)
Re: rough benchmarks, sata vs. ssd CSS (06:35)
Re: random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (02:13)
Re: random_page_cost = 2.0 on Heroku Postgres Josh Berkus (01:40)
10 February 2012