Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-performance - January 2012
Prev | Next
Jan. 1, 2012
- Cost estimate vs. actual - do I care? Jay Levitt (18:59)
- Re: Cost estimate vs. actual - do I care? Mark Mielke (20:00)
Jan. 2, 2012
- Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Miguel Silva (11:44)
- Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Miguel Silva (11:57)
Jan. 3, 2012
- Re: Slow nested loop execution on larger server Strange, John W (18:23)
Jan. 4, 2012
- Re: Postgresql Replication Performance Saurabh (10:41)
- Re: Postgresql Replication Performance Aleksej Trofimov (11:42)
Jan. 6, 2012
- Duplicate deletion optimizations antoine (14:35)
- Re: Duplicate deletion optimizations antoine (15:21)
- Re: Duplicate deletion optimizations Samuel Gendler (20:02)
- Re: Duplicate deletion optimizations Marc Eberhard (20:22)
- Re: Duplicate deletion optimizations Samuel Gendler (20:38)
- Re: Duplicate deletion optimizations Marc Eberhard (22:20)
Jan. 7, 2012
- Re: Duplicate deletion optimizations Strange, John W (00:02)
- Re: Duplicate deletion optimizations Misa Simic (03:28)
- Re: Duplicate deletion optimizations Jochen Erwied (11:57)
- Re: Duplicate deletion optimizations Pierre C (12:20)
- Re: Duplicate deletion optimizations Marc Mamin (12:21)
- Re: Duplicate deletion optimizations Misa Simic (14:02)
- Re: Duplicate deletion optimizations Jochen Erwied (14:17)
- Re: Duplicate deletion optimizations Jochen Erwied (14:18)
- Re: Duplicate deletion optimizations Pierre C (15:31)
- Re: Duplicate deletion optimizations Jeff Janes (18:54)
- Re: Duplicate deletion optimizations Misa Simic (20:16)
- Re: Duplicate deletion optimizations Marc Eberhard (22:54)
Jan. 8, 2012
- Re: Duplicate deletion optimizations Pierre C (18:09)
Jan. 9, 2012
- Re: Duplicate deletion optimizations antoine (12:59)
Jan. 10, 2012
- Query planner doesn't use index scan on tsvector GIN index if LIMIT is specified darklow (11:30)
- Query planner doesn't use index scan on tsvector GIN index if LIMIT is specifiedQuery planner doesn't use index scan on tsvector GIN index if LIMIT is specified darklow (12:30)
- Partitioning by status? Mike Blackwell (16:57)
- Re: Query planner doesn't use index scan on tsvector GIN index if LIMIT is specifiedQuery planner doesn't use index scan on tsvector GIN index if LIMIT is specified Tom Lane (17:04)
- Re: Partitioning by status? Andreas Kretschmer (17:09)
- Re: pg_upgrade failure "contrib" issue? Robert Haas (21:21)
- Re: Query planner doesn't use index scan on tsvector GIN index if LIMIT is specifiedQuery planner doesn't use index scan on tsvector GIN index if LIMIT is specified Jesper Krogh (21:42)
Jan. 11, 2012
- Re: Subquery flattening causing sequential scan Robert Haas (00:19)
- Re: partitioned table: differents plans, slow on some situations Robert Haas (01:53)
- Re: partitioned table: differents plans, slow on some situations Matteo Sgalaberni (11:57)
Jan. 12, 2012
- Re: Partitioning by status? Josh Berkus (18:24)
- wal_level=archive gives better performance than minimal - why? Tomas Vondra (23:17)
Jan. 13, 2012
- Re: Partitioning by status? alexandre - aldeia digital (10:44)
- auto vacuum, not working? Anibal David Acosta (12:08)
- Re: auto vacuum, not working? Mario Weilguni (14:26)
- Re: auto vacuum, not working? Kevin Grittner (14:50)
- Discovering the most searched values for a field alexandre - aldeia digital (18:08)
- Re: Partitioning by status? Josh Berkus (19:05)
- Re: Discovering the most searched values for a field Josh Berkus (19:08)
Jan. 15, 2012
- Re: auto vacuum, not working? Greg Smith (12:09)
Jan. 16, 2012
- Re: wal_level=archive gives better performance than minimal - why? Greg Smith (22:35)
Jan. 17, 2012
- Re: wal_level=archive gives better performance than minimal - why? Tomas Vondra (00:29)
Jan. 20, 2012
- when benchmarking insert , can there be caching effects? Willy-Bas Loos (15:36)
- Re: when benchmarking insert , can there be caching effects? Kevin Grittner (17:53)
Jan. 22, 2012
- Re: wal_level=archive gives better performance than minimal - why? Tomas Vondra (23:07)
- spikes in pgbench read-only results Tomas Vondra (23:17)
Jan. 23, 2012
- Re: spikes in pgbench read-only results Merlin Moncure (17:03)
- Re: Partitioning by status? alexandre - aldeia digital (17:22)
- Re: Discovering the most searched values for a field alexandre - aldeia digital (17:26)
- Re: spikes in pgbench read-only results Tomas Vondra (17:39)
Jan. 24, 2012
- Can lots of small writes badly hamper reads from other tables? Dave Crooke (20:16)
- Cursor fetch performance issue Tony Capobianco (20:41)
- Re: Cursor fetch performance issue Pavel Stehule (20:47)
- Re: Cursor fetch performance issue Tony Capobianco (20:57)
- Re: Can lots of small writes badly hamper reads from other tables? Andy Colson (21:06)
- Re: Can lots of small writes badly hamper reads from other tables? Tomas Vondra (21:09)
- Re: Cursor fetch performance issue Andy Colson (21:11)
- Re: Cursor fetch performance issue Pavel Stehule (21:11)
- Re: Cursor fetch performance issue Pavel Stehule (21:17)
- Re: Cursor fetch performance issue Tom Lane (21:28)
- Re: Cursor fetch performance issue Tony Capobianco (21:34)
- Re: Can lots of small writes badly hamper reads from other tables? Dave Crooke (21:36)
- Re: Can lots of small writes badly hamper reads from other tables? Tomas Vondra (23:46)
Jan. 25, 2012
- Re: Cursor fetch performance issue Heikki Linnakangas (08:58)
- Re: PostgreSQL Parallel Processing ! sridhar bamandlapally (09:18)
- Re: PostgreSQL Parallel Processing ! Claudio Freire (13:43)
- Re: PostgreSQL Parallel Processing ! sridhar bamandlapally (16:18)
- Re: Can lots of small writes badly hamper reads from other tables? Jeff Janes (16:19)
- Re: PostgreSQL Parallel Processing ! Merlin Moncure (20:16)
- Re: PostgreSQL Parallel Processing ! Claudio Freire (20:54)
Jan. 27, 2012
- pl/pgsql functions outperforming sql ones? Carlo Stonebanks (00:09)
- Re: PostgreSQL Parallel Processing ! sridhar bamandlapally (04:31)
- Re: PostgreSQL Parallel Processing ! Marti Raudsepp (09:06)
- Re: PostgreSQL Parallel Processing ! Vitalii Tymchyshyn (09:19)
- Re: PostgreSQL Parallel Processing ! Tomas Vondra (09:46)
- Re: PostgreSQL Parallel Processing ! Thomas Kellerer (09:52)
- Re: PostgreSQL Parallel Processing ! sridhar bamandlapally (12:16)
- Re: PostgreSQL Parallel Processing ! Tomas Vondra (12:43)
- Postgress is taking lot of CPU on our embedded hardware. Jayashankar K B (13:34)
- Re: PostgreSQL Parallel Processing ! Cédric Villemain (14:38)
- Re: pl/pgsql functions outperforming sql ones? Merlin Moncure (15:47)
- Re: Postgress is taking lot of CPU on our embedded hardware. Heikki Linnakangas (16:47)
- Re: Postgress is taking lot of CPU on our embedded hardware. Andy Colson (17:14)
- regarding CLUSTER and HUGE work_mem / maintenance_work_mem Jon Nelson (17:43)
- Re: regarding CLUSTER and HUGE work_mem / maintenance_work_mem Heikki Linnakangas (18:05)
- Re: Postgress is taking lot of CPU on our embedded hardware. Jayashankar K B (18:30)
- Re: pl/pgsql functions outperforming sql ones? Carlo Stonebanks (18:36)
- Re: pl/pgsql functions outperforming sql ones? Deron (19:29)
- Re: Postgress is taking lot of CPU on our embedded hardware. Heikki Linnakangas (19:56)
- Re: pl/pgsql functions outperforming sql ones? Carlo Stonebanks (19:59)
- Re: pl/pgsql functions outperforming sql ones? A.M. (20:09)
Jan. 28, 2012
- Re: Postgress is taking lot of CPU on our embedded hardware. Claudio Freire (02:23)
- Re: regarding CLUSTER and HUGE work_mem / maintenance_work_mem Jon Nelson (02:34)
- Re: regarding CLUSTER and HUGE work_mem / maintenance_work_mem Scott Marlowe (03:04)
- Re: Postgress is taking lot of CPU on our embedded hardware. Scott Marlowe (03:07)
- Re: pl/pgsql functions outperforming sql ones? Pavel Stehule (06:37)
- Re: Postgress is taking lot of CPU on our embedded hardware. Jayashankar K B (17:11)
- Re: Postgress is taking lot of CPU on our embedded hardware. Jayashankar K B (17:21)
- Re: Postgress is taking lot of CPU on our embedded hardware. Deron (17:56)
- Re: Postgress is taking lot of CPU on our embedded hardware. Jeff Janes (18:16)
- Re: Postgress is taking lot of CPU on our embedded hardware. Claudio Freire (19:37)
- Re: Postgress is taking lot of CPU on our embedded hardware. Mark Kirkwood (23:58)
Jan. 29, 2012
- Re: pl/pgsql functions outperforming sql ones? Carlo Stonebanks (04:20)
- Re: Postgress is taking lot of CPU on our embedded hardware. Jose Ildefonso Camargo Tolosa (14:46)
- Having I/O problems in simple virtualized environment Ron Arts (22:48)
- Re: Having I/O problems in simple virtualized environment Claudio Freire (23:01)
- Re: pl/pgsql functions outperforming sql ones? Carlo Stonebanks (23:04)
Jan. 30, 2012
- Re: Having I/O problems in simple virtualized environment Jose Ildefonso Camargo Tolosa (01:52)
- Re: Having I/O problems in simple virtualized environment Ron Arts (07:41)
- Re: pl/pgsql functions outperforming sql ones? Pavel Stehule (07:56)
- How to improve insert speed with index on text column Saurabh (09:27)
- Re: Postgress is taking lot of CPU on our embedded hardware. Marti Raudsepp (10:06)
- Re: How to improve insert speed with index on text column Claudio Freire (14:10)
- Re: How to improve insert speed with index on text column Jeff Janes (15:24)
- Re: How to improve insert speed with index on text column Saurabh (17:46)
- Re: How to improve insert speed with index on text column Claudio Freire (18:20)
- Re: How to improve insert speed with index on text column Andy Colson (18:33)
- Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi (19:13)
- Re: Why should such a simple query over indexed columns be so slow? Claudio Freire (19:24)
- Re: How to improve insert speed with index on text column Jeff Janes (20:32)
- Re: Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi (20:35)
- Re: Why should such a simple query over indexed columns be so slow? Claudio Freire (20:50)
- Re: Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi (20:55)
- Re: Why should such a simple query over indexed columns be so slow? Claudio Freire (20:59)
- Re: Why should such a simple query over indexed columns be so slow? Fernando Hevia (21:13)
- Re: Why should such a simple query over indexed columns be so slow? Josh Berkus (21:25)
- Re: Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi (21:39)
- Re: Why should such a simple query over indexed columns be so slow? Scott Marlowe (21:45)
- Re: Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi (21:45)
- Re: Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi (21:55)
- Re: Why should such a simple query over indexed columns be so slow? Scott Marlowe (22:19)
- Re: Why should such a simple query over indexed columns be so slow? Scott Marlowe (22:24)
- Re: Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi (22:26)
- Re: pl/pgsql functions outperforming sql ones? Carlo Stonebanks (23:15)
Jan. 31, 2012
- Re: Why should such a simple query over indexed columns be so slow? Josh Berkus (00:42)
- Re: pl/pgsql functions outperforming sql ones? Pavel Stehule (04:56)
- rough benchmarks, sata vs. ssd CSS (08:07)
- Re: How to improve insert speed with index on text column Saurabh (09:29)
- Re: How to improve insert speed with index on text column Tomas Vondra (11:21)
- How to remove a table statistics ? Marc Mamin (11:50)
- Re: How to remove a table statistics ? Josh Berkus (18:44)
- Re: How to improve insert speed with index on text column Josh Berkus (18:46)
- Re: How to remove a table statistics ? Marc Mamin (19:36)
- Re: How to improve insert speed with index on text column Merlin Moncure (20:20)
- Re: Having I/O problems in simple virtualized environment Jose Ildefonso Camargo Tolosa (21:13)
- From Simple to Complex Alessandro Gagliardi (21:22)
- Re: From Simple to Complex Alessandro Gagliardi (22:10)
- Re: From Simple to Complex Alessandro Gagliardi (22:53)
- Re: From Simple to Complex Alessandro Gagliardi (23:43)