Mailing lists [pgsql-performance]

2 January 2014

• 21:39   Re: DATE_TRUNC() and GROUP BY? Dave Johansen
• 22:36   Re: DATE_TRUNC() and GROUP BY? Dave Johansen
• 22:47   Re: DATE_TRUNC() and GROUP BY? Dave Johansen

3 January 2014

• 00:32   window function induces full table scan Thomas Mayer
• 00:53   Re: window function induces full table scan Tom Lane
• 01:26   Re: window function induces full table scan Jeff Janes
• 01:43   Re: window function induces full table scan Tom Lane
• 01:46   Re: window function induces full table scan Thomas Mayer
• 02:14   Re: window function induces full table scan Thomas Mayer
• 02:56   Re: window function induces full table scan Tom Lane
• 03:13   Re: window function induces full table scan Thomas Mayer
• 07:37   Re: window function induces full table scan Thomas Mayer
• 17:54   Re: window function induces full table scan Tom Lane
• 20:44   Re: window function induces full table scan Thomas Mayer
• 21:04   Re: window function induces full table scan Tom Lane
• 21:25   Re: window function induces full table scan Thomas Mayer

6 January 2014

• 08:50   Wrong rows count estimation in query with simple UNION ALL leads to drammatically slow plan Michael Kolomeitsev
• 17:41   Re: query plan not optimal Marc Cousin

14 January 2014

• 19:52   COMMIT stuck for days after bulk delete Josh Kupershmidt
• 20:36   Re: COMMIT stuck for days after bulk delete Tom Lane
• 21:25   Re: COMMIT stuck for days after bulk delete Josh Kupershmidt

16 January 2014

• 09:19   Issue with query scanning through all data even with indexes Kai Sellgren
• 09:19   PostgreSQL query for cache performance counters? ambilalmca
• 09:19   Slow counting on v9.3 Kai Sellgren
• 11:38   Re: Slow counting on v9.3 Mehmet Çakoğlu
• 11:43   Re: Slow counting on v9.3 Guillaume Cottenceau
• 18:41   Re: Issue with query scanning through all data even with indexes Igor Neyman

18 January 2014

• 01:58   Wrong index selection Piotr Gasidło
• 03:33   Re: Wrong index selection Tom Lane

20 January 2014

• 16:56   Time of query result delivery ARCEnergo

21 January 2014

• 09:26   Increasing query time after updates Katharina Koobs
• 11:06   Re: Increasing query time after updates Heikki Linnakangas
• 11:37   Re: Increasing query time after updates Katharina Koobs
• 11:45   Re: Increasing query time after updates Mark Kirkwood
• 13:57   Re: Increasing query time after updates Tomas Vondra
• 21:53   Re: Increasing query time after updates Mark Kirkwood
• 21:55   Re: Time of query result delivery Josh Berkus

22 January 2014

• 23:01   Re: Time of query result delivery Josh Berkus

23 January 2014

• 19:34   Removing nulls with 6NF Robert DiFalco

24 January 2014

• 19:23   PostgreSQL 9.3.2 Performance issues 
• 23:43   Re: PostgreSQL 9.3.2 Performance issues Kevin Grittner
• 23:48   pg_repack solves alter table set tablespace lock Ying He

25 January 2014

• 00:43   Re: pg_repack solves alter table set tablespace lock Josh Kupershmidt

27 January 2014

• 08:58   self join, parameterized base/join rel path row estimation and generally... Bongseo Jang
• 17:15   Re: pg_repack solves alter table set tablespace lock Ying He
• 17:25   Re: pg_repack solves alter table set tablespace lock Alvaro Herrera
• 17:44   Slow query (wrong index used maybe) Stelian Iancu
• 18:06   Re: Slow query (wrong index used maybe) Tom Lane
• 20:21   Re: Slow query (wrong index used maybe) salah jubeh
• 20:33   Re: Slow query (wrong index used maybe) Stelian Iancu
• 20:38   Re: Slow query (wrong index used maybe) Stelian Iancu
• 22:11   Re: Slow query (wrong index used maybe) bobJobS
• 22:43   Re: Slow query (wrong index used maybe) Gavin Flower

28 January 2014

• 01:07   Select hangs and there are lots of files in table and index directories. Peter Blair
• 01:31   Fwd: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6 Dattaram Porob
• 03:43   Re: Select hangs and there are lots of files in table and index directories. Tom Lane
• 11:30   Re: Slow query (wrong index used maybe) Stelian Iancu
• 16:40   Re: Slow query (wrong index used maybe) bobJobS
• 17:47   Re: Select hangs and there are lots of files in table and index directories. Peter Blair

29 January 2014

• 22:12   Re: Select hangs and there are lots of files in table and index directories. Peter Blair

30 January 2014

• 00:19   WHERE with ORDER not using the best index jugnooken
• 01:03   Re: Select hangs and there are lots of files in table and index directories. Tom Lane
• 02:16   Re: WHERE with ORDER not using the best index Tom Lane
• 02:38   trick the query optimiser to skip some optimisations Дмитрий Шалашов
• 02:50   Re: trick the query optimiser to skip some optimisations Jeff Janes
• 03:17   Re: trick the query optimiser to skip some optimisations Дмитрий Шалашов
• 04:47   Re: WHERE with ORDER not using the best index jugnooken
• 05:10   PostgreSQL 9.3.2 Performance tuning for 32 GB server RAMAKRISHNAN KANDASAMY
• 05:10   Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6 Dattaram Porob
• 05:10   Slow query on join with Date >= Jim Treinen
• 19:00   Re: WHERE with ORDER not using the best index Tom Lane
• 23:36   Re: trick the query optimiser to skip some optimisations Sergey Konoplev

31 January 2014

• 01:03   Re: trick the query optimiser to skip some optimisations Jeff Janes
• 16:55   Re: PostgreSQL 9.3.2 Performance tuning for 32 GB server Julien Cigar