Mailing lists [pgsql-performance]

1 January 2012

• 17:59   Cost estimate vs. actual - do I care? Jay Levitt
• 19:00   Re: Cost estimate vs. actual - do I care? Mark Mielke

2 January 2012

• 10:45   Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Miguel Silva
• 10:57   Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Miguel Silva

4 January 2012

• 10:01   Re: Postgresql Replication Performance Saurabh
• 10:42   Re: Postgresql Replication Performance Aleksej Trofimov

5 January 2012

• 12:52   Re: Slow nested loop execution on larger server Strange, John W

6 January 2012

• 13:36   Duplicate deletion optimizations antoine@inaps.org
• 14:21   Re: Duplicate deletion optimizations antoine@inaps.org
• 19:02   Re: Duplicate deletion optimizations Samuel Gendler
• 19:23   Re: Duplicate deletion optimizations Marc Eberhard
• 19:38   Re: Duplicate deletion optimizations Samuel Gendler
• 21:20   Re: Duplicate deletion optimizations Marc Eberhard

7 January 2012

• 02:28   Re: Duplicate deletion optimizations Misa Simic
• 10:28   Re: Duplicate deletion optimizations Misa Simic
• 10:58   Re: Duplicate deletion optimizations Jochen Erwied
• 11:20   Re: Duplicate deletion optimizations Pierre C
• 11:51   Re: Duplicate deletion optimizations Marc Mamin
• 13:02   Re: Duplicate deletion optimizations Misa Simic
• 13:18   Re: Duplicate deletion optimizations Jochen Erwied
• 14:31   Re: Duplicate deletion optimizations Pierre C
• 17:55   Re: Duplicate deletion optimizations Jeff Janes
• 19:16   Re: Duplicate deletion optimizations Misa Simic
• 21:02   Re: Duplicate deletion optimizations Misa Simic
• 21:54   Re: Duplicate deletion optimizations Marc Eberhard

8 January 2012

• 03:16   Re: Duplicate deletion optimizations Misa Simic
• 17:10   Re: Duplicate deletion optimizations Pierre C

9 January 2012

• 06:42   Re: Duplicate deletion optimizations Strange, John W
• 06:42   Re: Duplicate deletion optimizations Jochen Erwied
• 12:00   Re: Duplicate deletion optimizations antoine@inaps.org

10 January 2012

• 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
• 15:38   Query planner doesn't use index scan on tsvector GIN index if LIMIT is specified darklow
• 15:57   Partitioning by status? Mike Blackwell
• 16:04   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
• 16:09   Re: Partitioning by status? Andreas Kretschmer
• 20:21   Re: pg_upgrade failure "contrib" issue? Robert Haas
• 20:43   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
• 23:19   Re: Subquery flattening causing sequential scan Robert Haas

11 January 2012

• 00:53   Re: partitioned table: differents plans, slow on some situations Robert Haas
• 10:56   Re: partitioned table: differents plans, slow on some situations Matteo Sgalaberni

12 January 2012

• 17:24   Re: Partitioning by status? Josh Berkus
• 22:17   wal_level=archive gives better performance than minimal - why? Tomas Vondra

13 January 2012

• 09:44   Re: Partitioning by status? alexandre - aldeia digital
• 11:08   auto vacuum, not working? Anibal David Acosta
• 13:26   Re: auto vacuum, not working? Mario Weilguni
• 13:50   Re: auto vacuum, not working? Kevin Grittner
• 17:09   Discovering the most searched values for a field alexandre - aldeia digital
• 18:21   Re: Partitioning by status? Josh Berkus
• 18:22   Re: Discovering the most searched values for a field Josh Berkus

15 January 2012

• 11:10   Re: auto vacuum, not working? Greg Smith

16 January 2012

• 21:36   Re: wal_level=archive gives better performance than minimal - why? Greg Smith
• 23:30   Re: wal_level=archive gives better performance than minimal - why? Tomas Vondra

20 January 2012

• 14:36   when benchmarking insert , can there be caching effects? Willy-Bas Loos
• 16:54   Re: when benchmarking insert , can there be caching effects? Kevin Grittner

22 January 2012

• 22:07   Re: wal_level=archive gives better performance than minimal - why? Tomas Vondra
• 22:17   spikes in pgbench read-only results Tomas Vondra

23 January 2012

• 16:03   Re: spikes in pgbench read-only results Merlin Moncure
• 16:23   Re: Partitioning by status? alexandre - aldeia digital
• 16:28   Re: Discovering the most searched values for a field alexandre - aldeia digital
• 16:39   Re: spikes in pgbench read-only results Tomas Vondra

24 January 2012

• 19:16   Can lots of small writes badly hamper reads from other tables? Dave Crooke
• 19:41   Cursor fetch performance issue Tony Capobianco
• 19:48   Re: Cursor fetch performance issue Pavel Stehule
• 19:57   Re: Cursor fetch performance issue Tony Capobianco
• 20:06   Re: Can lots of small writes badly hamper reads from other tables? Andy Colson
• 20:09   Re: Can lots of small writes badly hamper reads from other tables? Tomas Vondra
• 20:12   Re: Cursor fetch performance issue Pavel Stehule
• 20:12   Re: Cursor fetch performance issue Andy Colson
• 20:18   Re: Cursor fetch performance issue Pavel Stehule
• 20:28   Re: Cursor fetch performance issue Tom Lane
• 20:34   Re: Cursor fetch performance issue Tony Capobianco
• 20:36   Re: Can lots of small writes badly hamper reads from other tables? Dave Crooke
• 22:46   Re: Can lots of small writes badly hamper reads from other tables? Tomas Vondra

25 January 2012

• 07:58   Re: Cursor fetch performance issue Heikki Linnakangas
• 08:19   Re: PostgreSQL Parallel Processing ! sridhar bamandlapally
• 12:43   Re: PostgreSQL Parallel Processing ! Claudio Freire
• 15:19   Re: PostgreSQL Parallel Processing ! sridhar bamandlapally
• 15:19   Re: Can lots of small writes badly hamper reads from other tables? Jeff Janes
• 19:17   Re: PostgreSQL Parallel Processing ! Merlin Moncure
• 19:54   Re: PostgreSQL Parallel Processing ! Claudio Freire

26 January 2012

• 23:09   pl/pgsql functions outperforming sql ones? Carlo Stonebanks

27 January 2012

• 03:31   Re: PostgreSQL Parallel Processing ! sridhar bamandlapally
• 08:07   Re: PostgreSQL Parallel Processing ! Marti Raudsepp
• 08:19   Re: PostgreSQL Parallel Processing ! Vitalii Tymchyshyn
• 08:46   Re: PostgreSQL Parallel Processing ! Tomas Vondra
• 08:52   Re: PostgreSQL Parallel Processing ! Thomas Kellerer
• 11:16   Re: PostgreSQL Parallel Processing ! sridhar bamandlapally
• 11:44   Re: PostgreSQL Parallel Processing ! Tomas Vondra
• 12:34   Postgress is taking lot of CPU on our embedded hardware. Jayashankar K B
• 13:39   Re: PostgreSQL Parallel Processing ! Cédric Villemain
• 14:47   Re: pl/pgsql functions outperforming sql ones? Merlin Moncure
• 15:48   Re: Postgress is taking lot of CPU on our embedded hardware. Heikki Linnakangas
• 16:15   Re: Postgress is taking lot of CPU on our embedded hardware. Andy Colson
• 16:43   regarding CLUSTER and HUGE work_mem / maintenance_work_mem Jon Nelson
• 17:05   Re: regarding CLUSTER and HUGE work_mem / maintenance_work_mem Heikki Linnakangas
• 17:31   Re: Postgress is taking lot of CPU on our embedded hardware. Jayashankar K B
• 17:37   Re: pl/pgsql functions outperforming sql ones? Carlo Stonebanks
• 18:29   Re: pl/pgsql functions outperforming sql ones? Deron
• 18:57   Re: Postgress is taking lot of CPU on our embedded hardware. Heikki Linnakangas
• 18:59   Re: pl/pgsql functions outperforming sql ones? Carlo Stonebanks
• 19:09   Re: pl/pgsql functions outperforming sql ones? A.M.

28 January 2012

• 01:24   Re: Postgress is taking lot of CPU on our embedded hardware. Claudio Freire
• 01:34   Re: regarding CLUSTER and HUGE work_mem / maintenance_work_mem Jon Nelson
• 02:04   Re: regarding CLUSTER and HUGE work_mem / maintenance_work_mem Scott Marlowe
• 02:07   Re: Postgress is taking lot of CPU on our embedded hardware. Scott Marlowe
• 05:38   Re: pl/pgsql functions outperforming sql ones? Pavel Stehule
• 16:12   Re: Postgress is taking lot of CPU on our embedded hardware. Jayashankar K B
• 16:22   Re: Postgress is taking lot of CPU on our embedded hardware. Jayashankar K B
• 16:57   Re: Postgress is taking lot of CPU on our embedded hardware. Deron
• 17:16   Re: Postgress is taking lot of CPU on our embedded hardware. Jeff Janes
• 18:37   Re: Postgress is taking lot of CPU on our embedded hardware. Claudio Freire
• 22:58   Re: Postgress is taking lot of CPU on our embedded hardware. Mark Kirkwood

29 January 2012

• 13:46   Re: Postgress is taking lot of CPU on our embedded hardware. Jose Ildefonso Camargo Tolosa
• 21:49   Having I/O problems in simple virtualized environment Ron Arts
• 22:01   Re: Having I/O problems in simple virtualized environment Claudio Freire
• 22:05   Re: pl/pgsql functions outperforming sql ones? Carlo Stonebanks

30 January 2012

• 00:52   Re: Having I/O problems in simple virtualized environment Jose Ildefonso Camargo Tolosa
• 06:42   Re: Having I/O problems in simple virtualized environment Ron Arts
• 06:57   Re: pl/pgsql functions outperforming sql ones? Pavel Stehule
• 08:43   How to improve insert speed with index on text column Saurabh
• 09:07   Re: Postgress is taking lot of CPU on our embedded hardware. Marti Raudsepp
• 13:10   Re: How to improve insert speed with index on text column Claudio Freire
• 13:18   Re: pl/pgsql functions outperforming sql ones? Carlo Stonebanks
• 14:24   Re: How to improve insert speed with index on text column Jeff Janes
• 17:13   Re: How to improve insert speed with index on text column Saurabh
• 17:20   Re: How to improve insert speed with index on text column Claudio Freire
• 17:33   Re: How to improve insert speed with index on text column Andy Colson
• 18:13   Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi
• 18:25   Re: Why should such a simple query over indexed columns be so slow? Claudio Freire
• 19:32   Re: How to improve insert speed with index on text column Jeff Janes
• 19:38   Re: Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi
• 19:50   Re: Why should such a simple query over indexed columns be so slow? Claudio Freire
• 19:55   Re: Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi
• 19:59   Re: Why should such a simple query over indexed columns be so slow? Claudio Freire
• 20:13   Re: Why should such a simple query over indexed columns be so slow? Fernando Hevia
• 20:25   Re: Why should such a simple query over indexed columns be so slow? Josh Berkus
• 20:39   Re: Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi
• 20:45   Re: Why should such a simple query over indexed columns be so slow? Scott Marlowe
• 20:46   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? Alessandro Gagliardi
• 21:19   Re: Why should such a simple query over indexed columns be so slow? Scott Marlowe
• 21:24   Re: Why should such a simple query over indexed columns be so slow? Scott Marlowe
• 21:27   Re: Why should such a simple query over indexed columns be so slow? Alessandro Gagliardi
• 22:15   Re: pl/pgsql functions outperforming sql ones? Carlo Stonebanks
• 23:42   Re: Why should such a simple query over indexed columns be so slow? Josh Berkus

31 January 2012

• 03:57   Re: pl/pgsql functions outperforming sql ones? Pavel Stehule
• 07:08   rough benchmarks, sata vs. ssd CSS
• 09:14   Re: How to improve insert speed with index on text column Saurabh
• 10:21   Re: How to improve insert speed with index on text column Tomas Vondra
• 10:50   How to remove a table statistics ? Marc Mamin
• 17:44   Re: How to remove a table statistics ? Josh Berkus
• 17:46   Re: How to improve insert speed with index on text column Josh Berkus
• 18:37   Re: How to remove a table statistics ? Marc Mamin
• 19:21   Re: How to improve insert speed with index on text column Merlin Moncure
• 20:13   Re: Having I/O problems in simple virtualized environment Jose Ildefonso Camargo Tolosa
• 20:22   From Simple to Complex Alessandro Gagliardi
• 21:10   Re: From Simple to Complex Alessandro Gagliardi
• 21:54   Re: From Simple to Complex Alessandro Gagliardi
• 22:43   Re: From Simple to Complex Alessandro Gagliardi