Home > mailing lists

Mailing lists [pgsql-performance]

1 May 2015

10:54 Index Scan Backward Slow David Osborne
10:59 Re: Index Scan Backward Slow Evgeniy Shishkin
11:06 Re: Index Scan Backward Slow David Osborne

2 May 2015

08:49 Re: Index Scan Backward Slow Robert Klemme

3 May 2015

21:23 optimization join on random value Anton Bushmelev
21:28 Re: optimization join on random value Heikki Linnakangas

13 May 2015

01:08 How to clean/truncate / VACUUM FULL pg_largeobject without (much) downtime? Muthusamy, Sivaraman

21 May 2015

01:14 Re: Fastest way / best practice to calculate "next birthdays" er.tejaspatel88@gmail.com
03:22 Re: Fastest way / best practice to calculate "next birthdays" David G. Johnston
10:41 union all and filter / index scan -> seq scan Florian Lohoff
15:09 Re: union all and filter / index scan -> seq scan Vitalii Tymchyshyn
15:28 Re: union all and filter / index scan -> seq scan Tom Lane
16:15 Re: Fastest way / best practice to calculate "next birthdays" Bosco Rama
16:50 Re: Fastest way / best practice to calculate "next birthdays" David G. Johnston
18:54 Re: PostgreSQL disk fragmentation causes performance problems on Windows Josh Berkus
20:39 Re: PostgreSQL disk fragmentation causes performance problems on Windows Andres Freund
23:16 Re: PostgreSQL disk fragmentation causes performance problems on Windows Vitalii Tymchyshyn

22 May 2015

17:34 Re: PostgreSQL disk fragmentation causes performance problems on Windows Josh Berkus
21:18 Re: How to clean/truncate / VACUUM FULL pg_largeobject without (much) downtime? Jim Nasby
21:23 Re: Fastest way / best practice to calculate "next birthdays" Jim Nasby
22:27 MAX() and multi-column index on a partitioned table? Dave Johansen
22:42 Re: MAX() and multi-column index on a partitioned table? Tom Lane
23:53 Re: MAX() and multi-column index on a partitioned table? Dave Johansen

23 May 2015

01:16 Re: MAX() and multi-column index on a partitioned table? Tom Lane

27 May 2015

07:50 ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881 Tory M Blue
20:24 Fastest Backup & Restore for perf testing Wes Vaske (wvaske)
20:37 Re: Fastest Backup & Restore for perf testing Andrew Dunstan
20:39 Re: Fastest Backup & Restore for perf testing Steve Atkins
22:02 Re: ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881 Josh Berkus

28 May 2015

14:31 Partitioning and performance Ravi Krishna
14:41 Re: Partitioning and performance Ravi Krishna
17:40 Re: Fastest Backup & Restore for perf testing Jim Nasby
18:05 Re: Partitioning and performance Jim Nasby

29 May 2015

08:55 Different plan for very similar queries Peter J. Holzer
09:51 Re: Different plan for very similar queries Peter J. Holzer
17:57 Fwd: Postgres is using 100% CPU Ashik S L
18:10 Postgres is using 100% CPU Ashik S L
18:30 Re: Postgres is using 100% CPU Yves Dorfsman
19:20 Re: Postgres is using 100% CPU Tomas Vondra
23:47 Re: Different plan for very similar queries Tomas Vondra

30 May 2015

13:46 Re: Postgres is using 100% CPU Ashik S L
14:20 Re: Postgres is using 100% CPU Tomas Vondra
19:04 Re: Different plan for very similar queries Tom Lane
19:57 Postmaster eating up all my cpu birimblongas
20:45 Re: Postmaster eating up all my cpu Tomas Vondra

31 May 2015

11:00 Re: Different plan for very similar queries Peter J. Holzer
13:05 Re: Postgres is using 100% CPU Jean-David Beyer
14:23 Re: Postgres is using 100% CPU Yves Dorfsman
15:51 Re: Different plan for very similar queries Tom Lane
16:06 Re: Different plan for very similar queries Tomas Vondra
16:22 Re: Different plan for very similar queries Tom Lane
16:39 Re: Different plan for very similar queries Tomas Vondra