Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2011-09 Chronological Index (1/3)
Last updated: Wed Jan 18 04:12:07 2012
446 messages
29 September 2011
Re: : Create table taking time Merlin Moncure (16:52)
Re: the number of child tables --table partitioning Kevin Grittner (15:09)
the number of child tables --table partitioning Jian Shi (14:30)
Re: Select se bloquea Claudio Freire (14:21)
Re: : Create table taking time Kevin Grittner (13:49)
Select se bloquea Numael Vacca Duran (12:43)
Re: : Create table taking time Venkat Balaji (08:02)
28 September 2011
Re: : Create table taking time Josh Berkus (18:55)
Re: : Looking for PG Books Josh Berkus (18:54)
: Looking for PG Books Venkat Balaji (17:17)
: Create table taking time Venkat Balaji (17:07)
Re: PostgreSQL-9.0 Monitoring System to improve performance Tomas Vondra (12:21)
Re: PostgreSQL-9.0 Monitoring System to improve performance Greg Smith (07:10)
Re: : Tracking Full Table Scans Venkat Balaji (06:13)
Re: : Tracking Full Table Scans Venkat Balaji (06:09)
Re: overzealous sorting? anthony . shipman (05:13)
Re: : Tracking Full Table Scans Craig Ringer (00:55)
Re: postgres constraint triggers Craig Ringer (00:37)
27 September 2011
Re: : Tracking Full Table Scans Venkat Balaji (16:45)
PostgreSQL-9.0 Monitoring System to improve performance Venkat Balaji (16:44)
Re: : Tracking Full Table Scans Venkat Balaji (16:35)
Re: [PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges (16:12)
Re: overzealous sorting? Marc Cousin (15:00)
Re: : Tracking Full Table Scans Kevin Grittner (14:32)
Re: Ineffective autovacuum Royce Ausburn (14:27)
Re: Ineffective autovacuum Scott Marlowe (14:00)
Re: Ineffective autovacuum Tom Lane (13:49)
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett (13:01)
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett (12:46)
: Tracking Full Table Scans Venkat Balaji (12:36)
Re: : Performance Improvement Strategy Venkat Balaji (12:31)
Re: : Performance Improvement Strategy Venkat Balaji (12:29)
Re: Ineffective autovacuum Marti Raudsepp (10:57)
Re: overzealous sorting? Mark Kirkwood (09:29)
Re: overzealous sorting? anthony . shipman (09:05)
Re: overzealous sorting? Marc Cousin (08:54)
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Samuel Gendler (06:14)
Re: Ineffective autovacuum Royce Ausburn (05:08)
Re: postgres constraint triggers Ben Chobot (05:00)
Re: Ineffective autovacuum Tom Lane (04:21)
Ineffective autovacuum Royce Ausburn (03:55)
Re: overzealous sorting? anthony . shipman (02:45)
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane (00:39)
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Craig Ringer (00:09)
26 September 2011
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Timothy Garnett (21:19)
Re: slow query on tables with new columns added. M. D. (21:14)
Re: [PERFORMANCE] Insights: fseek OR read_cluster? Marti Raudsepp (19:07)
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane (17:35)
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Craig James (17:24)
postgres constraint triggers Maria L. Wilson (17:17)
Re: Performance Anomaly with "col in (A,B)" vs. "col = A OR col = B" ver. 9.0.3 Tom Lane (17:08)
Re: How to find record having % as part of data. Biswa (14:45)
How to find record having % as part of data. Biswa (13:36)
Re: [PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges (12:51)
Re: overzealous sorting? Marc Cousin (09:44)
Re: [PERFORMANCE] Insights: fseek OR read_cluster? Craig Ringer (08:26)
overzealous sorting? anthony . shipman (06:53)
Re: Query optimization using order by and limit Tom Lane (01:24)
Re: Query optimization using order by and limit Stephen Frost (00:40)
25 September 2011
24 September 2011
[PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges (06:49)
Re: slow query on tables with new columns added. Filip Rembiałkowski (06:10)
23 September 2011
[PERFORMANCE] Insights: fseek OR read_cluster? Antonio Rodriges (20:04)
slow query on tables with new columns added. M. D. (19:47)
Re: IN or EXISTS Jeff Davis (01:32)
22 September 2011
Re: Query optimization using order by and limit Stephen Frost (23:15)
Re: Optimizing Trigram searches in PG 9.1 Dave Crooke (23:04)
Re: Query optimization using order by and limit Michael Viscuso (22:55)
Optimizing Trigram searches in PG 9.1 Jonathan Bartlett (16:40)
Re: Query optimization using order by and limit Stephen Frost (14:53)
Re: Query optimization using order by and limit Michael Viscuso (13:55)
Re: Query optimization using order by and limit ktm(at)rice(dot)edu (13:41)
Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions Gunnlaugur Þór Briem (10:00)
Re: Query optimization using order by and limit Tom Lane (03:23)
Re: Query optimization using order by and limit Michael Viscuso (03:17)
Re: Query optimization using order by and limit Tom Lane (02:09)
Re: Query optimization using order by and limit Greg Smith (01:48)
21 September 2011
Re: : Performance Improvement Strategy Kevin Grittner (18:41)
Re: : Performance Improvement Strategy Venkat Balaji (18:26)
Re: : Performance Improvement Strategy Greg Smith (17:58)
Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions Tom Lane (17:11)
Re: Prepared statements and suboptimal plans Royce Ausburn (17:08)
Re: Prepared statements and suboptimal plans Merlin Moncure (16:39)
Re: REINDEX not working for wastedspace Shaun Thomas (16:30)
Re: REINDEX not working for wastedspace Venkat Balaji (16:20)
Re: : Performance Improvement Strategy Venkat Balaji (16:14)
Re: Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace] Greg Smith (16:13)
Re: Slow query with self-join, group by, 100m rows Tom Lane (15:02)
Re: REINDEX not working for wastedspace Shaun Thomas (14:56)
Re: Slow query with self-join, group by, 100m rows Robert Klemme (14:51)
Re: Prepared statements and suboptimal plans Grzegorz Jaśkiewicz (14:50)
Re: [PERFORM] parámetros de postgres y linux en maq uinas virtuales Claudio Freire (14:19)
Re: REINDEX not working for wastedspace Andy Lester (14:15)
Re: REINDEX not working for wastedspace Tom Lane (14:13)
Re: : Performance Improvement Strategy Kevin Grittner (13:57)
parámetros de postgres y linux en maquinas virtuale s Hellmuth Vargas (13:32)
Re: REINDEX not working for wastedspace Shaun Thomas (13:30)
Re: : Performance Improvement Strategy Shaun Thomas (13:03)
Re: PG 9 adminstrations Shaun Thomas (12:48)
Show_database_bloat reliability? [was: Re: REINDEX not working for wastedspace] Guillaume Cottenceau (12:43)
Re: REINDEX not working for wastedspace Reid Thompson (12:21)
Re: REINDEX not working for wastedspace AI Rumman (07:10)
Re: REINDEX not working for wastedspace Venkat Balaji (07:07)
Re: REINDEX not working for wastedspace Guillaume Lelarge (07:07)
REINDEX not working for wastedspace AI Rumman (07:01)
Re: : Performance Improvement Strategy Venkat Balaji (05:59)
Re: : Performance Improvement Strategy Venkat Balaji (05:38)
Re: PG 9 adminstrations Hany ABOU-GHOURY (04:29)
Re: PG 9 adminstrations Derrick Rice (04:16)
PG 9 adminstrations Hany ABOU-GHOURY (03:57)
Re: Prepared statements and suboptimal plans Tom Lane (03:43)
Re: Prepared statements and suboptimal plans Stephen Frost (02:38)
Re: Prepared statements and suboptimal plans Stephen Frost (02:36)
Re: Prepared statements and suboptimal plans Tom Lane (01:00)
Re: Prepared statements and suboptimal plans Andy Lester (00:42)
Re: Prepared statements and suboptimal plans Tom Lane (00:36)
Re: Prepared statements and suboptimal plans Royce Ausburn (00:20)
20 September 2011
Prepared statements and suboptimal plans Royce Ausburn (23:27)
Prepared statements and suboptimal plans Royce Ausburn (22:55)
Re: : Performance Improvement Strategy Mark Kirkwood (22:10)
Re: : Performance Improvement Strategy Mark Kirkwood (22:05)
Re: : Performance Improvement Strategy Josh Berkus (18:09)
Re: : Performance Improvement Strategy Marcin Mirosław (17:59)
Slow query with self-join, group by, 100m rows Thomas Kappler (17:43)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tom Lane (16:25)
: Performance Improvement Strategy Venkat Balaji (16:22)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure (16:11)
Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions Gunnlaugur Þór Briem (09:30)
Re: Postgres INSERT performance and scalability Craig Ringer (05:05)
Re: where is max_fsm_pages in PG9.0? Scott Marlowe (04:49)
where is max_fsm_pages in PG9.0? Anibal David Acosta (04:28)
Re: Postgres INSERT performance and scalability Stephen Frost (01:32)
Re: Postgres INSERT performance and scalability Jon Nelson (01:29)
Re: Postgres INSERT performance and scalability Stephen Frost (01:15)
Re: Postgres INSERT performance and scalability Igor Chudov (01:12)
Re: Postgres INSERT performance and scalability Stephen Frost (00:53)
19 September 2011
Postgres INSERT performance and scalability Igor Chudov (22:11)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire (18:53)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure (18:43)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Jeff Janes (16:15)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Claudio Freire (16:14)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Vitalii Tymchyshyn (15:54)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Tom Lane (15:35)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Vitalii Tymchyshyn (15:29)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Robert Klemme (15:19)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it? Merlin Moncure (14:04)
Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) Ivan Voras (13:25)