Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2010-02 Chronological Index (1/3)
Last updated: Wed Jan 18 04:14:02 2012
404 messages
28 February 2010
Re: [HACKERS] full text search index scan query plan changed in 8.4.2? Josh Berkus (22:42)
Re: partitioned tables query not using indexes Kenneth Marshall (21:49)
Re: partitioned tables query not using indexes Josh Berkus (20:29)
Estimation issue with partitioned tables Josh Berkus (20:20)
Re: How to troubleshoot high mem usage by postgres? Tom Lane (16:42)
Re: SSD + RAID Greg Smith (05:06)
Re: SSD + RAID Ron Mayer (04:05)
Re: How to troubleshoot high mem usage by postgres? Chris (01:22)
27 February 2010
Re: How to troubleshoot high mem usage by postgres? Tom Lane (22:39)
Re: How to troubleshoot high mem usage by postgres? Craig Ringer (22:39)
Re: How to troubleshoot high mem usage by postgres? Ben Chobot (22:39)
How to troubleshoot high mem usage by postgres? Chris (22:29)
Re: SSD + RAID Bruce Momjian (20:16)
Re: SSD + RAID Greg Smith (19:38)
Re: SSD + RAID Bruce Momjian (01:40)
26 February 2010
Re: bgwriter, checkpoints, curious (seeing delays) Fernando Hevia (20:00)
Re: bgwriter, checkpoints, curious (seeing delays) Jorge Montero (19:52)
Re: bgwriter, checkpoints, curious (seeing delays) Tory M Blue (19:02)
Re: bgwriter, checkpoints, curious (seeing delays) Tory M Blue (18:52)
Re: bgwriter, checkpoints, curious (seeing delays) Ben Chobot (18:25)
Re: bgwriter, checkpoints, curious (seeing delays) Tory M Blue (18:23)
Re: Multiple data base on same server Ing. Marcos Ortiz Valmaseda (14:49)
Re: Multiple data base on same server elias ghanem (14:43)
Re: Multiple data base on same server Craig James (14:34)
Re: Multiple data base on same server elias ghanem (13:16)
Re: bgwriter, checkpoints, curious (seeing delays) Kevin Grittner (13:09)
Re: Multiple data base on same server Richard Huxton (13:03)
Re: Multiple data base on same server Richard Huxton (11:44)
Multiple data base on same server elias ghanem (11:34)
Re: bgwriter, checkpoints, curious (seeing delays) Greg Smith (09:24)
Re: bgwriter, checkpoints, curious (seeing delays) Devrim GÜNDÜZ (07:21)
Re: bgwriter, checkpoints, curious (seeing delays) Tory M Blue (07:04)
Re: bgwriter, checkpoints, curious (seeing delays) Tory M Blue (07:01)
Re: bgwriter, checkpoints, curious (seeing delays) Devrim GÜNDÜZ (06:43)
Re: bgwriter, checkpoints, curious (seeing delays) Jochen Erwied (06:29)
Re: bgwriter, checkpoints, curious (seeing delays) Tory M Blue (06:20)
bgwriter, checkpoints, curious (seeing delays) Tory M Blue (06:12)
Re: No hash join across partitioned tables? Tom Lane (00:05)
25 February 2010
Re: GiST index performance Bruce Momjian (23:45)
Re: GiST index performance Bruce Momjian (23:43)
Re: dbt2 performance Yu-Ju Hong (23:30)
Re: dbt2 performance Greg Smith (22:48)
dbt2 performance Yu-Ju Hong (21:27)
Re: Extracting superlatives - SQL design philosophy Tom Lane (14:42)
Re: Extracting superlatives - SQL design philosophy Julien Theulier (09:21)
Re: Extracting superlatives - SQL design philosophy Pierre C (08:36)
Re: Extracting superlatives - SQL design philosophy Richard Huxton (08:10)
24 February 2010
Re: Extracting superlatives - SQL design philosophy Richard Huxton (23:12)
Re: Extracting superlatives - SQL design philosophy Craig James (22:50)
Re: Extracting superlatives - SQL design philosophy Dave Crooke (22:48)
Re: Extracting superlatives - SQL design philosophy George Sexton (22:00)
Re: Extracting superlatives - SQL design philosophy George Sexton (21:58)
Re: Extracting superlatives - SQL design philosophy Garrett Murphy (21:55)
Re: Extracting superlatives - SQL design philosophy Mose (21:50)
Extracting superlatives - SQL design philosophy Dave Crooke (21:31)
Re: partitioned tables query not using indexes Kevin Kempter (15:19)
Re: partitioned tables query not using indexes A. Kretschmer (14:55)
Re: Internal operations when the planner makes a hash join. Igor Neyman (14:46)
partitioned tables query not using indexes Kevin Kempter (14:36)
Re: SSD + RAID Dave Crooke (08:32)
23 February 2010
Thx and additional Q's ..... Dave Crooke (23:37)
Re: Internal operations when the planner makes a hash join. Kevin Grittner (23:03)
Re: Internal operations when the planner makes a hash join. negora (22:53)
Re: moving pg_xlog -- yeah, it's worth it! Ben Chobot (22:14)
Re: Internal operations when the planner makes a hash join. Kevin Grittner (21:45)
Re: Internal operations when the planner makes a hash join. negora (21:33)
Re: SSD + RAID Mark Mielke (21:32)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (21:24)
Re: SSD + RAID david (21:24)
Re: SSD + RAID Aidan Van Dyk (20:35)
Re: SSD + RAID david (20:05)
Re: Internal operations when the planner makes a hash join. Scott Carey (18:50)
Re: SSD + RAID Scott Carey (18:38)
Re: Internal operations when the planner makes a hash join. Alvaro Herrera (16:53)
Re: Internal operations when the planner makes a hash join. negora (16:40)
Re: Internal operations when the planner makes a hash join. Kevin Grittner (15:30)
Internal operations when the planner makes a hash join. negora (14:47)
Internal operations when the planner makes a hash join. negora (14:45)
Re: Slow query: table iteration (8.3) Yeb Havinga (12:18)
Re: SSD + RAID Nikolas Everett (12:07)
Re: SSD + RAID Pierre C (11:51)
Re: SSD + RAID david (08:24)
Re: Advice requested on structuring aggregation queries Joe Conway (05:23)
Advice requested on structuring aggregation queries Dave Crooke (03:01)
Re: Planner question - "bit" data types Bruce Momjian (02:47)
Re: SSD + RAID Scott Marlowe (02:23)
Re: SSD + RAID Scott Marlowe (02:21)
Re: SSD + RAID Greg Smith (01:40)
Re: SSD + RAID Greg Smith (01:15)
Re: SSD + RAID Mark Mielke (01:11)
Re: SSD + RAID Greg Smith (01:05)
22 February 2010
Re: plpgsql plan cache Pierre C (22:16)
Re: plpgsql plan cache Nikolas Everett (21:30)
Re: plpgsql plan cache Tom Lane (21:21)
Re: plpgsql plan cache Joel Jacobson (20:29)
Re: plpgsql plan cache Pierre C (19:43)
plpgsql plan cache Joel Jacobson (19:29)
Re: SSD + RAID Ron Mayer (18:00)
Re: shared_buffers Kevin Grittner (15:23)
shared_buffers George Sexton (15:05)
Re: SSD + RAID Bruce Momjian (14:40)
Re: SSD + RAID Bruce Momjian (14:37)
Re: AutoVacuum_NapTime Alvaro Herrera (12:44)
Re: SSD + RAID Arjen van der Meijden (07:11)
Re: SSD + RAID Greg Smith (05:39)
21 February 2010
Re: SSD + RAID Ron Mayer (15:01)
Re: SSD + RAID Bruce Momjian (14:11)
Re: SSD + RAID Scott Carey (09:35)
Re: can we optimize STACK_DEPTH_SLOP terry (05:45)
Re: can we optimize STACK_DEPTH_SLOP Tom Lane (03:25)
can we optimize STACK_DEPTH_SLOP terry (03:08)
can we optimize STACK_DEPTH_SLOP terry (03:05)
Re: AutoVacuum_NapTime George Sexton (01:30)
Re: AutoVacuum_NapTime Tom Lane (01:15)
AutoVacuum_NapTime George Sexton (01:03)
20 February 2010
Re: SSD + RAID Dan Langille (23:16)
Re: SSD + RAID Bruce Momjian (18:29)
18 February 2010
Re: index usage in not like A. Kretschmer (12:44)
Re: index usage in not like Thom Brown (12:40)
Re: index usage in not like Kenneth Marshall (12:24)
Re: index usage in not like A. Kretschmer (12:18)
Re: index usage in not like Thom Brown (12:14)
Re: index usage in not like Thom Brown (12:02)
index usage in not like AI Rumman (11:56)
Michael Clemmons wants to stay in touch on LinkedIn Michael Clemmons (01:04)
17 February 2010
Re: bgwriter tunables vs pg_stat_bgwriter Brad Nicholson (20:01)
Re: disk space usage unexpected Rose Zhou (19:58)
Re: disk space usage unexpected Ben Chobot (19:57)
bgwriter tunables vs pg_stat_bgwriter Jeff (13:31)
Re: Dell PERC H700/H800 Stefan Kaltenbrunner (13:08)
Re: 8.1 -> 8.4 regression Tom Lane (05:34)
16 February 2010
Re: Linux I/O tuning: CFQ vs. deadline Jeff Davis (21:33)
another 8.1->8.4 regression Ben Chobot (21:30)
Re: Almost infinite query -> Different Query Plan when changing where clause value lionel duboeuf (16:47)
Re: Almost infinite query -> Different Query Plan when changing where clause value lionel duboeuf (16:39)
Re: Why index is not using here? Kevin Grittner (14:56)
Re: Dell PERC H700/H800 Bruce Momjian (14:12)
Re: Almost infinite query -> Different Query Plan when changing where clause value Kevin Grittner (12:46)
Re: Why index is not using here? AI Rumman (11:44)
Why index is not using here? AI Rumman (11:43)
Re: Almost infinite query -> Different Query Plan when changing where clause value lionel duboeuf (10:26)
Re: Almost infinite query -> Different Query Plan when changing where clause value lionel duboeuf (10:26)
Re: disk space usage unexpected Joshua D. Drake (01:25)
15 February 2010
Re: disk space usage unexpected Ben Chobot (21:16)
Auto Vacuum out of memory Rose Zhou (20:20)
disk space usage unexpected Rose Zhou (20:00)
Re: 8.1 -> 8.4 regression Ben Chobot (17:35)
Re: 8.1 -> 8.4 regression Tom Lane (17:26)
Re: Almost infinite query -> Different Query Plan when changing where clause value Scott Marlowe (17:24)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Robert Haas (16:42)
Re: 8.1 -> 8.4 regression Ben Chobot (16:16)
Re: 8.1 -> 8.4 regression Kevin Grittner (16:00)
Re: Why primary key index are not using in joining? Tom Lane (15:32)
Re: PostgreSQL on SMP Architectures Kevin Grittner (14:33)
Re: Almost infinite query -> Different Query Plan when changing where clause value Kevin Grittner (14:19)
Re: Why primary key index are not using in joining? Yeb Havinga (11:11)
Re: 8.1 -> 8.4 regression Dennis Björklund (10:02)
Re: Almost infinite query -> Different Query Plan when changing where clause value lionel duboeuf (09:53)
Re: Why primary key index are not using in joining? Scott Marlowe (09:50)
Why primary key index are not using in joining? AI Rumman (09:35)
14 February 2010
Re: PostgreSQL on SMP Architectures Reydan Cankur (18:46)
8.1 -> 8.4 regression Ben Chobot (18:39)
Re: PostgreSQL on SMP Architectures Scott Marlowe (18:25)
Re: PostgreSQL on SMP Architectures Arjen van der Meijden (17:12)
PostgreSQL on SMP Architectures Reydan Cankur (16:36)