Mailing lists [pgsql-performance]

1 March 2018

• 17:09   Performance degrade in Planning Time to find appropriate Partial Index Meenatchi Sandanam
• 19:03   Re: Performance degrade in Planning Time to find appropriatePartial Index Laurenz Albe
• 20:16   Re: Performance degrade in Planning Time to find appropriate Partial Index Michael Loftis

2 March 2018

• 19:49   Re: Performance degrade in Planning Time to find appropriate Partial Index Nandakumar M
• 20:29   Re: Performance degrade in Planning Time to find appropriate Partial Index Pavel Stehule
• 20:32   Re: Performance degrade in Planning Time to find appropriate Partial Index Pavel Stehule
• 22:29   why does this query not use a parallel query Dave Cramer
• 22:44   Re: why does this query not use a parallel query Tom Lane

3 March 2018

• 07:55   Re: Updating large tables without dead tuples Vik Fearing

5 March 2018

• 21:45   Slow index scan backward. John van Breda
• 22:18   GIST index (polygon, point) ghiureai

6 March 2018

• 14:01   Please help Daulat Ram
• 15:59   Re: GIST index (polygon, point) Laurenz Albe
• 17:35   by mistake dropped physical file dropped for one table. Rambabu V
• 17:38   need meta data table/command to find query log Rambabu V
• 17:46   Re: Please help Tomas Vondra
• 19:21   Re: by mistake dropped physical file dropped for one table. Stephen Frost
• 19:24   Re: need meta data table/command to find query log Stephen Frost
• 19:27   Re: by mistake dropped physical file dropped for one table. Rambabu V

11 March 2018

• 05:42   RE: Updating large tables without dead tuples ldh@laurent-hasson.com
• 18:48   Memory size dangal
• 19:49   Sv: Memory size Andreas Joseph Krogh
• 19:57   Re: Sv: Memory size dangal
• 22:59   Re: Memory size Jeff Janes
• 23:33   Re: Memory size dangal

12 March 2018

• 00:12   Re: Memory size Tomas Vondra
• 01:11   Re: Memory size dangal
• 03:45   Sv: Re: Sv: Memory size Andreas Joseph Krogh
• 05:16   Re: Memory size Jeff Janes
• 07:43   Re: Memory size dangal
• 21:08   Re: Memory size dangal

14 March 2018

• 08:31   Too many .history file in pg_xlog takes lots of space 彭昱傑
• 11:56   Re: Too many .history file in pg_xlog takes lots of space Laurenz Albe
• 12:12   Re: Too many .history file in pg_xlog takes lots of space 彭昱傑
• 13:04   Re: Too many .history file in pg_xlog takes lots of space Michael Paquier
• 19:49   Re: Too many .history file in pg_xlog takes lots of space Alvaro Herrera
• 21:29   Re: Too many .history file in pg_xlog takes lots of space Tom Lane

15 March 2018

• 16:22   Re: Too many .history file in pg_xlog takes lots of space 彭昱傑
• 16:29   RE: PG 9.6 Slow inserts with long-lasting LWLocks Pavel Suderevsky

16 March 2018

• 19:42   Re: PG 9.6 Slow inserts with long-lasting LWLocks MichaelDBA

17 March 2018

• 02:37   Irrelevant columns cause massive performance change Craig James
• 02:50   Re: Irrelevant columns cause massive performance change Andres Freund
• 03:06   Re: Irrelevant columns cause massive performance change Craig James

19 March 2018

• 21:13   Slow performance after restoring a dump David Osborne
• 21:35   Re: Slow performance after restoring a dump Tom Lane
• 21:43   Re: Slow performance after restoring a dump David Osborne
• 22:22   Re: Slow performance after restoring a dump Tom Lane
• 22:33   Re: Slow performance after restoring a dump David Osborne
• 23:26   RE: PG 9.6 Slow inserts with long-lasting LWLocks Pavel Suderevsky

21 March 2018

• 18:03   badly scaling performance with appending to bytea Gary Cowell
• 18:12   Re: badly scaling performance with appending to bytea Rick Otten
• 18:56   Re: badly scaling performance with appending to bytea Pavel Stehule
• 18:59   Re: badly scaling performance with appending to bytea Pavel Stehule
• 19:04   Re: badly scaling performance with appending to bytea Gary Cowell
• 19:09   Re: badly scaling performance with appending to bytea Pavel Stehule

23 March 2018

• 13:59   DB corruption Akshay Ballarpure
• 14:04   Re: DB corruption Michael Paquier
• 16:03   Should from_collapse be switched off? (queries 10 times faster) Peter
• 17:39   Re: Should from_collapse be switched off? (queries 10 times faster) Thomas Kellerer
• 17:41   Re: Should from_collapse be switched off? (queries 10 times faster) Laurenz Albe
• 20:14   Re: Should from_collapse be switched off? (queries 10 times faster) Tom Lane
• 20:30   Re: Should from_collapse be switched off? (queries 10 times faster) Peter
• 20:30   Re: Should from_collapse be switched off? (queries 10 times faster) Peter
• 21:08   Re: DB corruption Tom Lane
• 23:36   Re: Should from_collapse be switched off? (queries 10 times faster) Peter

24 March 2018

• 02:28   Slow planning time for custom function bk@e8s.de
• 07:27   functions: VOLATILE performs better than STABLE Peter
• 07:35   Re: Slow planning time for custom function Andres Freund
• 07:52   Re: Slow planning time for custom function David Rowley

25 March 2018

• 11:00   Re: functions: VOLATILE performs better than STABLE Laurenz Albe
• 11:12   Re: Should from_collapse be switched off? (queries 10 times faster) Laurenz Albe
• 18:24   Re: functions: VOLATILE performs better than STABLE David Rowley

26 March 2018

• 00:18   Re: Slow planning time for custom function bk@e8s.de
• 16:36   Re: Should from_collapse be switched off? (queries 10 times faster) Peter
• 23:13   Re: Should from_collapse be switched off? (queries 10 times faster) Laurenz Albe

27 March 2018

• 20:14   Slow query on partitioned table. Glenn Pierce
• 20:43   Re: Slow query on partitioned table. Justin Pryzby

28 March 2018

• 03:00   Re: Slow query on partitioned table. Justin Pryzby