Mailing lists [pgsql-performance]

1 February 2013

• 20:11   Fighting the planner >:-( Casey Allen Shobe
• 20:54   Re: Fighting the planner >:-( Casey Allen Shobe
• 21:50   Re: Fighting the planner >:-( Richard Huxton
• 22:18   Re: Fighting the planner >:-( Casey Allen Shobe

2 February 2013

• 00:02   Re: Fighting the planner >:-( Casey Allen Shobe
• 00:12   Re: Fighting the planner >:-( Виктор Егоров
• 00:18   Re: Fighting the planner >:-( Casey Allen Shobe
• 00:55   Re: Fighting the planner >:-( Виктор Егоров
• 01:03   Re: Fighting the planner >:-( Casey Allen Shobe
• 01:17   Re: Fighting the planner >:-( Виктор Егоров
• 19:39   Re: Simple join doesn't use index Jeff Janes

5 February 2013

• 00:15   Re: Simple join doesn't use index Dan Fairs
• 00:52   numerical primary key vs alphanumerical primary key Anne Rosset
• 00:58   Re: numerical primary key vs alphanumerical primary key Виктор Егоров
• 06:46   Slow Query Help Will Platnick
• 16:58   Re: Slow Query Help Heikki Linnakangas

6 February 2013

• 01:02   postgresql.conf recommendations Johnny Tan
• 01:37   Re: postgresql.conf recommendations Josh Krupka
• 02:46   Re: postgresql.conf recommendations Johnny Tan
• 07:24   Re: postgresql.conf recommendations Josh Krupka
• 09:00   Re: postgresql.conf recommendations Pavan Deolasee
• 09:18   Re: postgresql.conf recommendations ac@hsk.hk
• 11:51   Re: Slow Query Help Pavan Deolasee
• 15:49   Re: postgresql.conf recommendations Kevin Grittner
• 16:17   Re: Slow Query Help Will Platnick
• 18:42   Re: postgresql.conf recommendations David Whittaker
• 19:22   Re: Slow Query Help Kevin Grittner
• 19:24   Re: Slow Query Help Will Platnick
• 19:28   Re: Slow Query Help Pavan Deolasee
• 21:20   Re: postgresql.conf recommendations Josh Krupka
• 22:14   Re: postgresql.conf recommendations David Whittaker
• 22:33   Re: postgresql.conf recommendations Johnny Tan
• 22:45   Re: postgresql.conf recommendations Johnny Tan
• 22:48   Re: postgresql.conf recommendations Johnny Tan
• 23:12   Re: postgresql.conf recommendations Jeff Janes
• 23:28   Re: postgresql.conf recommendations Josh Krupka

7 February 2013

• 00:12   Re: postgresql.conf recommendations Kevin Grittner
• 15:07   Re: postgresql.conf recommendations Strahinja Kustudić
• 17:41   Re: postgresql.conf recommendations Charles Gomes
• 20:29   Re: postgresql.conf recommendations Johnny Tan
• 20:50   Re: postgresql.conf recommendations Josh Krupka

8 February 2013

• 03:52   FTS performance issue probably due to wrong planner estimate of detoasting Stefan Keller
• 08:46   Re: FTS performance issue probably due to wrong planner estimate of detoasting Pavel Stehule
• 09:56   Re: FTS performance issue probably due to wrong planner estimate of detoasting Jesper Krogh
• 15:37   Slow query even with aggressive auto analyze Karolis Pocius
• 20:30   Re: FTS performance issue probably due to wrong planner estimate of detoasting Stefan Keller
• 23:53   temp tablespaces and SSDs, etc.. Jon Nelson

9 February 2013

• 01:14   Query Time is Slow Foster, Kristian B (HSC)
• 01:46   Re: Query Time is Slow Kevin Grittner
• 16:19   Re: postgresql.conf recommendations Johnny Tan
• 16:24   Re: postgresql.conf recommendations Johnny Tan
• 17:51   Re: postgresql.conf recommendations Scott Marlowe
• 22:37   Re: postgresql.conf recommendations Josh Krupka
• 23:16   Re: postgresql.conf recommendations Jeff Janes

10 February 2013

• 00:03   Re: postgresql.conf recommendations Scott Marlowe
• 07:03   Re: postgresql.conf recommendations Jeff Janes
• 09:52   Re: Slow query even with aggressive auto analyze Amit kapila

11 February 2013

• 15:52   Is it correct to optimize a query with subselect in the "where"? Alexandre Riveira
• 17:57   Re: postgresql.conf recommendations Charles Gomes
• 18:30   Re: Partition insert trigger using C language Ali Pouya

12 February 2013

• 01:10   Re: postgresql.conf recommendations Johnny Tan
• 01:57   Re: postgresql.conf recommendations Scott Marlowe
• 02:29   Re: postgresql.conf recommendations Will Platnick
• 16:07   Re: numerical primary key vs alphanumerical primary key Julien Cigar
• 18:05   Re: numerical primary key vs alphanumerical primary key Grant Johnson
• 18:14   Re: numerical primary key vs alphanumerical primary key Florent Guillaume
• 19:26   Re: numerical primary key vs alphanumerical primary key Claudio Freire
• 20:26   High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan
• 22:59   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan

13 February 2013

• 04:28   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan
• 14:00   Re: Partition insert trigger using C language Matheus de Oliveira
• 16:48   connection poolers' db connections Yetkin Öztürk
• 17:56   Re: connection poolers' db connections Kevin Grittner
• 18:35   Re: connection poolers' db connections Yetkin Öztürk
• 22:24   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus

14 February 2013

• 03:26   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 04:30   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan
• 13:28   700K Inserts in transaction Asmir Mustafic
• 13:49   PG_XLOG 27028 files running out of space Tory M Blue
• 14:01   Re: PG_XLOG 27028 files running out of space Ian Lawrence Barwick
• 14:06   Re: PG_XLOG 27028 files running out of space Tory M Blue
• 14:09   Re: PG_XLOG 27028 files running out of space Heikki Linnakangas
• 14:09   Re: PG_XLOG 27028 files running out of space Albe Laurenz
• 14:11   Re: PG_XLOG 27028 files running out of space Tory M Blue
• 14:51   Re: 700K Inserts in transaction nik9000@gmail.com
• 17:07   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Merlin Moncure
• 18:35   Surprising no use of indexes - low performance Nicolas Charles
• 20:27   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan
• 21:26   Re: Surprising no use of indexes - low performance Ireneusz Pluta
• 21:38   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 22:27   Re: Surprising no use of indexes - low performance Jeff Janes
• 23:41   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan

15 February 2013

• 02:58   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 07:32   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan
• 07:47   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe
• 11:47   Re: Partition insert trigger using C language Ali Pouya
• 12:00   Re: Surprising no use of indexes - low performance Nicolas Charles
• 17:31   Very slow update statement on 40mio rows Florian Schröck
• 17:59   Re: Very slow update statement on 40mio rows Kevin Grittner
• 18:32   Re: Very slow update statement on 40mio rows Florian Schröck
• 21:04   Re: Surprising no use of indexes - low performance Jeff Janes
• 21:26   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 21:52   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe
• 22:13   Re: postgresql.conf recommendations Scott Marlowe

16 February 2013

• 00:27   Re: Surprising no use of indexes - low performance Merlin Moncure
• 03:32   Re: temp tablespaces and SSDs, etc.. Bruce Momjian
• 12:25   Re: Surprising no use of indexes - low performance Nicolas Charles

18 February 2013

• 19:45   slow query plans caused by under-estimation of CTE cardinality John Lumby
• 23:40   Re: slow query plans caused by under-estimation of CTE cardinality Vitalii Tymchyshyn

19 February 2013

• 02:26   Re: slow query plans caused by under-estimation of CTE cardinality John Lumby
• 03:19   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 03:40   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 03:47   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Jon Nelson
• 03:52   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 06:41   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe
• 07:23   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood
• 09:35   Speed of exist Bastiaan Olij
• 10:31   Re: Speed of exist Andy
• 10:36   Re: Speed of exist Bastiaan Olij
• 10:40   Re: Speed of exist Pavel Stehule
• 13:09   Re: slow query plans caused by under-estimation of CTE cardinality Tom Lane
• 13:19   Re: Speed of exist Bastiaan Olij
• 20:51   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 23:04   Re: Very slow update statement on 40mio rows Merlin Moncure

20 February 2013

• 02:12   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood
• 02:24   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 02:33   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood
• 06:15   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe

21 February 2013

• 01:44   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 06:14   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus
• 12:59   Poor performance after update from SLES11 SP1 to SP2 Mark Smith
• 13:25   Re: Poor performance after update from SLES11 SP1 to SP2 Vasilis Ventirozos
• 13:36   Re: Poor performance after update from SLES11 SP1 to SP2 Scott Marlowe
• 19:23   Re: Poor performance after update from SLES11 SP1 to SP2 Sergey Konoplev
• 19:57   Are bitmap index scans slow to start? Carlo Stonebanks
• 21:19   Re: Are bitmap index scans slow to start? Jeff Janes

22 February 2013

• 11:25   BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Markus Schulz
• 16:36   Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Heikki Linnakangas
• 16:38   Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Stephen Frost
• 19:36   Avoiding Recheck Cond when using Select Distinct jackrg
• 20:19   Re: Avoiding Recheck Cond when using Select Distinct Jeff Janes
• 20:51   Re: Are bitmap index scans slow to start? Carlo Stonebanks
• 20:51   Re: Are bitmap index scans slow to start? Carlo Stonebanks
• 20:59   Re: Avoiding Recheck Cond when using Select Distinct Vitalii Tymchyshyn
• 21:10   Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Markus Schulz
• 21:22   Bad query plan with high-cardinality column Alexander Staubo
• 22:05   Re: Are bitmap index scans slow to start? Nikolas Everett
• 22:06   Re: Avoiding Recheck Cond when using Select Distinct Maciek Sakrejda
• 23:05   Re: Are bitmap index scans slow to start? Carlo Stonebanks
• 23:33   Re: Bad query plan with high-cardinality column Tom Lane
• 23:48   Re: Bad query plan with high-cardinality column Kevin Grittner

23 February 2013

• 00:31   Re: Bad query plan with high-cardinality column Alexander Staubo
• 00:34   Re: Bad query plan with high-cardinality column Alexander Staubo
• 01:17   Re: Bad query plan with high-cardinality column Kevin Grittner
• 13:10   Re: Bad query plan with high-cardinality column Tom Lane
• 18:58   Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Heikki Linnakangas
• 19:14   Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Tom Lane
• 19:15   Are bitmap index scans slow to start? Jeff Janes
• 20:45   Re: Are bitmap index scans slow to start? Jeff Janes

24 February 2013

• 02:53   Re: Avoiding Recheck Cond when using Select Distinct Jeff Janes
• 17:08   Server stalls, all CPU 100% system time Andre
• 17:13   Re: Server stalls, all CPU 100% system time Bèrto ëd Sèra
• 17:39   Re: Server stalls, all CPU 100% system time Andre
• 17:46   Re: Server stalls, all CPU 100% system time Tom Lane
• 19:43   Re: Server stalls, all CPU 100% system time Scott Marlowe

25 February 2013

• 20:05   Re: Are bitmap index scans slow to start? Carlo Stonebanks
• 21:11   Re: Avoiding Recheck Cond when using Select Distinct Maciek Sakrejda
• 21:48   Re: Avoiding Recheck Cond when using Select Distinct Jeff Janes

26 February 2013

• 01:30   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Jeff Frost
• 11:01   Re: Very slow update statement on 40mio rows Florian Schröck
• 15:53   Re: Server stalls, all CPU 100% system time Andre
• 21:12   Re: Are bitmap index scans slow to start? Jeff Janes
• 22:36   Estimation question... Matt Daw

27 February 2013

• 00:30   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Jeff Janes
• 00:46   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe
• 02:29   Re: Server stalls, all CPU 100% system time Josh Berkus
• 03:33   Re: Are bitmap index scans slow to start? Carlo Stonebanks
• 04:02   Re: Server stalls, all CPU 100% system time Scott Marlowe
• 13:03   seqscan on UNION'ed views Dmitry Karasik
• 13:52   Re: Server stalls, all CPU 100% system time Andre
• 17:21   Re: seqscan on UNION'ed views Tom Lane
• 20:08   Re: Estimation question... Matt Daw
• 21:03   Re: Are bitmap index scans slow to start? Jeff Janes

28 February 2013

• 00:38   Re: Are bitmap index scans slow to start? Carlo Stonebanks
• 02:07   Re: Server stalls, all CPU 100% system time Josh Berkus
• 08:12   Re: Are bitmap index scans slow to start? Carlo Stonebanks
• 18:11   SELECT is slow on smaller table? Ao Jianwang
• 18:20   Re: SELECT is slow on smaller table? Julien Cigar
• 19:31   Re: Estimation question... Matt Daw
• 20:00   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe
• 20:01   Wrong actual number of rows in the Query Plan Vahe Evoyan
• 20:07   pgbench intriguing results: better tps figures for larger scale factor Costin Oproiu
• 20:07   Re: Are bitmap index scans slow to start? Gavin Flower
• 20:08   xmlconcat performance Davide Berra
• 20:08   Using a window function in a view Chris Hanks
• 20:11   Bad query plan with high-cardinality column Alexander Staubo
• 20:12   Re: Are bitmap index scans slow to start? Marc Mamin
• 20:13   Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Glyn Astill
• 20:20   Re: pgbench intriguing results: better tps figures for larger scale factor Pavan Deolasee
• 20:48   Re: xmlconcat performance Merlin Moncure
• 20:58   Re: Wrong actual number of rows in the Query Plan Tom Lane
• 23:14   Re: Are bitmap index scans slow to start? Carlo Stonebanks