Mailing lists [pgsql-performance]

1 August 2019

• 06:10   PSQL performance - TPS Shital A
• 08:15   Re: PSQL performance - TPS Gavin Flower
• 08:18   Re: PSQL performance - TPS Shital A
• 20:21   Re: PSQL performance - TPS Andres Freund
• 21:06   Re: PSQL performance - TPS Purav Chovatia
• 21:14   Re: PSQL performance - TPS Andres Freund
• 21:27   Re: PSQL performance - TPS Rick Otten

2 August 2019

• 07:59   Re: PSQL performance - TPS Shital A
• 14:04   Re: PSQL performance - TPS Imre Samu
• 16:58   Strange runtime partition pruning behaviour with 11.4 Thomas Kellerer

3 August 2019

• 16:16   Re: Strange runtime partition pruning behaviour with 11.4 MichaelDBA
• 16:42   Re: Strange runtime partition pruning behaviour with 11.4 Andreas Kretschmer
• 17:06   Re: Strange runtime partition pruning behaviour with 11.4 Thomas Kellerer
• 18:18   Re: Strange runtime partition pruning behaviour with 11.4 Andreas Kretschmer
• 19:05   Re: Strange runtime partition pruning behaviour with 11.4 Tom Lane
• 19:49   Re: Strange runtime partition pruning behaviour with 11.4 MichaelDBA

5 August 2019

• 10:29   Re: Strange runtime partition pruning behaviour with 11.4 Thomas Kellerer
• 23:47   improving windows functions performance Mariel Cherkassky

6 August 2019

• 00:15   Re: improving windows functions performance Andreas Kretschmer

8 August 2019

• 15:02   Postgres not using correct indices for views. Thomas Rosenstein
• 19:05   Re: Postgres not using correct indices for views. Tom Lane
• 23:04   Re: Postgres not using correct indices for views. Thomas Rosenstein
• 23:30   Re: Postgres not using correct indices for views. Thomas Rosenstein

9 August 2019

• 01:45   Re: Postgres not using correct indices for views. Tom Lane
• 11:41   Bitmap heap scan performance Rob Emery
• 15:30   Re: Bitmap heap scan performance Jeff Janes
• 18:16   Re: Postgres not using correct indices for views. Tom Lane

10 August 2019

• 13:05   Re: Postgres not using correct indices for views. Thomas Rosenstein
• 14:11   Re: Postgres not using correct indices for views. Michaeldba@sqlexec.com

11 August 2019

• 23:31   Re: Postgres not using correct indices for views. Tom Lane

12 August 2019

• 15:37   Planner performance in partitions Piotr Włodarczyk
• 16:00   Re: Bitmap heap scan performance Rob Emery
• 16:29   Re: Bitmap heap scan performance Jeremy Finzel
• 22:05   Re: Planner performance in partitions Michael Lewis
• 22:24   Re: Planner performance in partitions MichaelDBA
• 23:03   ODP: Planner performance in partitions Piotr Włodarczyk
• 23:25   Re: Planner performance in partitions Michael Lewis
• 23:57   Last event per user Luís Roberto Weck

13 August 2019

• 00:56   Re: Last event per user Michael Lewis
• 01:25   Re: Planner performance in partitions David Rowley
• 01:28   Re: Last event per user Luís Roberto Weck
• 01:35   Re: Last event per user Michael Lewis
• 01:37   Re: Planner performance in partitions Michael Lewis
• 01:43   Re: Luís Roberto Weck
• 01:53   Re: Michael Lewis
• 02:03   Re: Last event per user Luís Roberto Weck
• 02:09   Re: Last event per user Michael Lewis
• 09:29   ODP: Planner performance in partitions Piotr Włodarczyk
• 10:02   Re: Strange runtime partition pruning behaviour with 11.4 Sverre Boschman
• 11:23   ORA-24345: A Truncation or null fetch error occurred -ora2pg Daulat Ram
• 11:23   ORA-24345: A Truncation or null fetch error occurred -ora2pg Daulat Ram
• 14:08   Re: zabbix on postgresql - very slow delete of events Kristian Ejvind
• 14:34   Re: Last event per user Luís Roberto Weck
• 17:15   performance bottlenecks on lock transactionid 王若楠
• 18:02   Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg Luca Ferrari
• 18:02   Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg Luca Ferrari
• 20:34   RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg Daulat Ram
• 20:34   RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg Daulat Ram
• 20:57   Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg Adrian Klaver
• 20:57   Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg Adrian Klaver

14 August 2019

• 10:31   Re: performance bottlenecks on lock transactionid Laurenz Albe
• 10:57   re:Re: performance bottlenecks on lock transactionid 王若楠
• 12:39   RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg Daulat Ram
• 12:39   RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg Daulat Ram
• 13:25   Re: Re: performance bottlenecks on lock transactionid Laurenz Albe
• 19:18   Continuous Performance Test Jean Baro
• 20:56   Continuous Performance Test Jean Baro
• 23:57   Re: Continuous Performance Test Nasby, Jim
• 23:59   Re: [UNVERIFIED SENDER] Re: Continuous Performance Test Nasby, Jim

16 August 2019

• 04:33   Re: [UNVERIFIED SENDER] Re: Continuous Performance Test Jean Baro

18 August 2019

• 09:56   UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE Mariel Cherkassky
• 11:41   Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE Pavel Stehule

19 August 2019

• 15:32   pg11 list partitions vs hash partitions Mariel Cherkassky

20 August 2019

• 16:54   Erratically behaving query needs optimization Barbu Paul - Gheorghe
• 17:58   Re: Erratically behaving query needs optimization Luís Roberto Weck
• 18:07   Re: Erratically behaving query needs optimization MichaelDBA
• 18:11   Extremely slow HashAggregate in simple UNION query Felix Geisendörfer
• 19:19   Re: Extremely slow HashAggregate in simple UNION query Michael Lewis
• 19:57   Re: Extremely slow HashAggregate in simple UNION query Pavel Stehule
• 20:32   Re: Extremely slow HashAggregate in simple UNION query Andres Freund
• 20:55   Re: Extremely slow HashAggregate in simple UNION query Felix Geisendörfer
• 21:27   Re: Extremely slow HashAggregate in simple UNION query Andres Freund

21 August 2019

• 10:30   Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe
• 14:30   Re: Erratically behaving query needs optimization Luís Roberto Weck
• 21:26   Re: Extremely slow HashAggregate in simple UNION query Jeff Janes

22 August 2019

• 08:08   Re: Extremely slow HashAggregate in simple UNION query Pavel Stehule
• 12:06   Re: Extremely slow HashAggregate in simple UNION query Felix Geisendörfer
• 14:51   Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe
• 15:10   Re: Erratically behaving query needs optimization Luís Roberto Weck
• 15:22   Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe
• 15:44   Extremely slow count (simple query, with index) Marco Colli
• 15:49   Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe
• 16:19   Re: Extremely slow count (simple query, with index) Justin Pryzby
• 16:25   Re: Extremely slow count (simple query, with index) Ravikumar Reddy
• 16:25   Re: Extremely slow count (simple query, with index) MichaelDBA
• 20:37   Re: Extremely slow count (simple query, with index) Michael Lewis
• 20:43   Re: Erratically behaving query needs optimization legrand legrand
• 20:54   Re: Extremely slow count (simple query, with index) Marco Colli
• 21:04   Re: Extremely slow count (simple query, with index) Justin Pryzby

23 August 2019

• 16:17   Re: Out of Memory errors are frustrating as heck! Gunther
• 17:19   Re: Out of Memory errors are frustrating as heck! Gunther
• 17:20   Re: Out of Memory errors are frustrating as heck! Tom Lane

24 August 2019

• 06:24   pg_basebackup is taking an unusually long time with Postgres 11.3 andy andy
• 06:24   pg_basebackup is taking an unusually long time with Postgres 11.3 andy andy
• 06:24   pg_basebackup is taking an unusually long time with Postgres 11.3 andy andy
• 18:40   Re: Out of Memory errors are frustrating as heck! Gunther
• 22:16   Re: Extremely slow HashAggregate in simple UNION query Jeff Janes
• 22:41   Re: Extremely slow HashAggregate in simple UNION query Tom Lane
• 22:54   Re: Extremely slow HashAggregate in simple UNION query Andres Freund

25 August 2019

• 17:50   Re: Erratically behaving query needs optimization Jeff Janes

26 August 2019

• 11:25   Re: Erratically behaving query needs optimization Barbu Paul - Gheorghe
• 14:51   Re: Erratically behaving query needs optimization Justin Pryzby