Mailing lists [pgsql-performance]

1 March 2017

• 20:02   Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Sven R. Kunze
• 23:04   Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Jeff Janes

2 March 2017

• 04:00   [PERFORM] anti-join with small table via text/varchar cannot estimate rowscorrectly Stefan Andreatta
• 04:12   Re: [PERFORM] anti-join with small table via text/varchar cannotestimate rows correctly David G. Johnston
• 06:24   Re: [PERFORM] anti-join with small table via text/varchar cannotestimate rows correctly Jeff Janes
• 06:28   Re: [PERFORM] anti-join with small table via text/varchar cannotestimate rows correctly David G. Johnston
• 07:06   Re: [PERFORM] anti-join with small table via text/varchar cannot estimate rows correctly Tom Lane
• 11:14   Re: [PERFORM] anti-join with small table via text/varchar cannotestimate rows correctly Stefan Andreatta
• 18:05   Re: [PERFORM] How Can I check PostgreSQL backup is successfully ornot ? Dinesh Chandra 12108
• 19:14   Re: [PERFORM] How Can I check PostgreSQL backup is successfully ornot ? Rick Otten
• 19:19   Re: [PERFORM] How Can I check PostgreSQL backup is successfully ornot ? Dinesh Chandra 12108
• 22:26   Re: [PERFORM] How Can I check PostgreSQL backup is successfully ornot ? ldh@laurent-hasson.com
• 22:32   Re: [PERFORM] How Can I check PostgreSQL backup is successfully ornot ? Dinesh Chandra 12108
• 22:50   Re: [PERFORM] How Can I check PostgreSQL backup is successfully ornot ? Gustavo Vargas

3 March 2017

• 03:19   Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Sven R. Kunze
• 03:51   Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Pietro Pugni
• 16:29   [PERFORM] Performance issue in PostgreSQL server... Dinesh Chandra 12108
• 18:23   Re: [PERFORM] Performance issue in PostgreSQL server... Nur Agus
• 18:44   Re: [PERFORM] Performance issue in PostgreSQL server... Dinesh Chandra 12108
• 21:03   Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10) Merlin Moncure
• 21:19   Re: [PERFORM] Performance issue in PostgreSQL server... Tom Lane

6 March 2017

• 10:23   Re: [PERFORM] Performance issue in PostgreSQL server... Jeff Janes
• 10:25   Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Jeff Janes
• 11:24   Re: [PERFORM] Performance issue in PostgreSQL server... Justin Pryzby
• 18:17   Re: [PERFORM] Performance issue in PostgreSQL server... Dinesh Chandra 12108
• 19:20   [PERFORM] Performance issue after upgrading from 9.4 to 9.6 Piotr Gasidło
• 20:22   [PERFORM] Huge difference between ASC and DESC ordering twoflower
• 22:19   Re: [PERFORM] Huge difference between ASC and DESC ordering Jeff Janes
• 22:46   Re: [PERFORM] Huge difference between ASC and DESC ordering twoflower
• 23:11   Re: [PERFORM] Huge difference between ASC and DESC ordering Jeff Janes

7 March 2017

• 03:10   Re: [PERFORM] Speeding up JSON + TSQUERY + GIN Sven R. Kunze
• 14:40   Re: [PERFORM] Huge difference between ASC and DESC ordering twoflower

8 March 2017

• 08:26   [PERFORM] Please help with a slow query: there are millions of records, whatcan we do? Pat Maddox
• 16:05   Re: [PERFORM] Please help with a slow query: there are millions ofrecords, what can we do? Albe Laurenz

9 March 2017

• 00:00   Re: [PERFORM] Please help with a slow query: there are millions ofrecords, what can we do? Jeff Janes

20 March 2017

• 19:38   [PERFORM] Auto generate number in Postgres-9.1. Dinesh Chandra 12108
• 19:43   Re: [PERFORM] Auto generate number in Postgres-9.1. Josh Berkus
• 19:48   Re: [PERFORM] Auto generate number in Postgres-9.1. Andreas Karlsson
• 19:50   Re: [PERFORM] Auto generate number in Postgres-9.1. John Gorman
• 20:08   Re: [PERFORM] Auto generate number in Postgres-9.1. Dinesh Chandra 12108
• 21:40   Re: [PERFORM] Auto generate number in Postgres-9.1. Andreas Karlsson

22 March 2017

• 01:24   [PERFORM] Optimizing around retained tuples James Parks
• 07:56   Re: [PERFORM] Optimizing around retained tuples Claudio Freire
• 07:58   Re: [PERFORM] Optimizing around retained tuples Claudio Freire
• 21:07   Re: [PERFORM] Please help with a slow query: there are millions ofrecords, what can we do? Pat Maddox

24 March 2017

• 15:58   [PERFORM] Postgres not using all RAM (Huge Page activated on a 96GB RAM system) Pietro Pugni
• 20:00   Re: Postgres not using all RAM (Huge Page activated on a96GB RAM system) Andrew Kerber
• 22:00   Re: Optimizing around retained tuples Brad DeJong

25 March 2017

• 01:47   Re: Postgres not using all RAM (Huge Page activated on a96GB RAM system) Scott Marlowe
• 02:16   Re: Postgres not using all RAM (Huge Page activated on a96GB RAM system) Álvaro Hernández Tortosa
• 07:27   Re: Postgres not using all RAM (Huge Page activated on a96GB RAM system) Shaun Thomas
• 07:56   Re: Postgres not using all RAM (Huge Page activated on a96GB RAM system) trafdev

27 March 2017

• 01:33   self join estimate and constraint exclusion Justin Pryzby
• 19:21   Re: Performance issue after upgrading from 9.4 to 9.6 Merlin Moncure
• 19:27   Re: Postgres not using all RAM (Huge Page activated on a96GB RAM system) Merlin Moncure

28 March 2017

• 05:43   Best design for performance Riaan Stander
• 06:42   Re: Best design for performance Claudio Freire
• 07:17   Re: Best design for performance Riaan Stander
• 08:22   Re: Best design for performance Claudio Freire
• 18:41   Re: Best design for performance Riaan Stander
• 23:15   Re: Best design for performance Claudio Freire

29 March 2017

• 04:51   Re: Best design for performance Riaan Stander