pgsql-performance - January 2014

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

Jan. 2, 2014

Thread	Author	Time
Re: DATE_TRUNC() and GROUP BY?	Dave Johansen	18:39
Re: DATE_TRUNC() and GROUP BY?	Dave Johansen	19:36
Re: DATE_TRUNC() and GROUP BY?	Dave Johansen	19:47
window function induces full table scan	Thomas Mayer	21:32
Re: window function induces full table scan	Tom Lane	21:52
Re: window function induces full table scan	Jeff Janes	22:26
Re: window function induces full table scan	Tom Lane	22:43
Re: window function induces full table scan	Thomas Mayer	22:45
Re: window function induces full table scan	Thomas Mayer	23:12
Re: window function induces full table scan	Tom Lane	23:55

Jan. 3, 2014

Thread	Author	Time
Re: window function induces full table scan	Thomas Mayer	00:13
Re: window function induces full table scan	Thomas Mayer	04:37
Re: window function induces full table scan	Tom Lane	14:54
Re: window function induces full table scan	Thomas Mayer	17:44
Re: window function induces full table scan	Tom Lane	18:04
Re: window function induces full table scan	Thomas Mayer	18:25

Jan. 6, 2014

Thread	Author	Time
Wrong rows count estimation in query with simple UNION ALL leads to drammatically slow plan	Michael Kolomeitsev	05:50
Re: query plan not optimal	Marc Cousin	14:41

Jan. 9, 2014

Thread	Author	Time
Issue with query scanning through all data even with indexes	Kai Sellgren	21:36

Jan. 10, 2014

Thread	Author	Time
PostgreSQL query for cache performance counters?	ambilalmca	09:46

Jan. 13, 2014

Thread	Author	Time
Slow counting on v9.3	Kai Sellgren	21:57

Jan. 14, 2014

Thread	Author	Time
COMMIT stuck for days after bulk delete 📎	Josh Kupershmidt	16:51
Re: COMMIT stuck for days after bulk delete	Tom Lane	17:36
Re: COMMIT stuck for days after bulk delete	Josh Kupershmidt	18:24

Jan. 16, 2014

Thread	Author	Time
Re: Slow counting on v9.3	Mehmet Çakoğlu	08:37
Re: Slow counting on v9.3	Guillaume Cottenceau	08:42
Re: Issue with query scanning through all data even with indexes	Igor Neyman	15:41

Jan. 17, 2014

Thread	Author	Time
Wrong index selection	Piotr Gasidło	22:57

Jan. 18, 2014

Thread	Author	Time
Re: Wrong index selection	Tom Lane	00:33

Jan. 20, 2014

Thread	Author	Time
Time of query result delivery	ARCEnergo	13:55

Jan. 21, 2014

Thread	Author	Time
Increasing query time after updates	Katharina Koobs	06:26
Re: Increasing query time after updates	Heikki Linnakangas	08:06
Re: Increasing query time after updates	Katharina Koobs	08:37
Re: Increasing query time after updates	Mark Kirkwood	08:45
Re: Increasing query time after updates	Tomas Vondra	10:57
Re: Increasing query time after updates	Mark Kirkwood	18:53
Re: Time of query result delivery	Josh Berkus	18:55

Jan. 22, 2014

Thread	Author	Time
Re: Time of query result delivery	Josh Berkus	20:01

Jan. 23, 2014

Thread	Author	Time
Removing nulls with 6NF	Robert DiFalco	16:34

Jan. 24, 2014

Thread	Author	Time
PostgreSQL 9.3.2 Performance issues 📎	fburgess	16:23
Re: PostgreSQL 9.3.2 Performance issues	Kevin Grittner	20:43
pg_repack solves alter table set tablespace lock	Ying He	20:48
Re: pg_repack solves alter table set tablespace lock	Josh Kupershmidt	21:42

Jan. 25, 2014

Thread	Author	Time
PostgreSQL 9.3.2 Performance tuning for 32 GB server	RAMAKRISHNAN KANDASAMY	06:32

Jan. 27, 2014

Thread	Author	Time
self join, parameterized base/join rel path row estimation and generally...	Bongseo Jang	05:58
Re: pg_repack solves alter table set tablespace lock	Ying He	14:15
Re: pg_repack solves alter table set tablespace lock	Alvaro Herrera	14:24
Slow query (wrong index used maybe)	Stelian Iancu	14:44
Re: Slow query (wrong index used maybe)	Tom Lane	15:06
Re: Slow query (wrong index used maybe)	salah jubeh	17:20
Re: Slow query (wrong index used maybe)	Stelian Iancu	17:33
Re: Slow query (wrong index used maybe)	Stelian Iancu	17:37
Re: Slow query (wrong index used maybe)	bobJobS	19:10
Re: Slow query (wrong index used maybe)	Gavin Flower	19:43
Select hangs and there are lots of files in table and index directories.	Peter Blair	22:06
Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6 📎	Dattaram Porob	22:27
Fwd: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6 📎	Dattaram Porob	22:31

Jan. 28, 2014

Thread	Author	Time
Re: Select hangs and there are lots of files in table and index directories.	Tom Lane	00:43
Re: Slow query (wrong index used maybe)	Stelian Iancu	08:29
Re: Slow query (wrong index used maybe)	bobJobS	13:39
Re: Select hangs and there are lots of files in table and index directories.	Peter Blair	14:47
Slow query on join with Date >=	Jim Treinen	22:01

Jan. 29, 2014

Thread	Author	Time
Re: Select hangs and there are lots of files in table and index directories.	Peter Blair	19:12
WHERE with ORDER not using the best index	jugnooken	21:19
Re: Select hangs and there are lots of files in table and index directories.	Tom Lane	22:03
Re: WHERE with ORDER not using the best index	Tom Lane	23:15
trick the query optimiser to skip some optimisations	Дмитрий Шалашов	23:38
Re: trick the query optimiser to skip some optimisations	Jeff Janes	23:50

Jan. 30, 2014

Thread	Author	Time
Re: trick the query optimiser to skip some optimisations	Дмитрий Шалашов	00:17
Re: WHERE with ORDER not using the best index	jugnooken	01:47
Re: WHERE with ORDER not using the best index	Tom Lane	16:00
Re: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6 📎	Dattaram Porob	17:43
Re: trick the query optimiser to skip some optimisations	Sergey Konoplev	20:36
Re: trick the query optimiser to skip some optimisations	Jeff Janes	22:03

Jan. 31, 2014

Thread	Author	Time
Re: PostgreSQL 9.3.2 Performance tuning for 32 GB server	Julien Cigar	13:55

Browse Archives

Prev | Next