Mailing lists [pgsql-performance]

3 June 2017

• 14:37   Re: [PERFORM] Monitoring tool for Postgres Database Nikolay Samokhvalov

4 June 2017

• 01:23   Re: [PERFORM] join estimate of subqueries with range conditions andconstraint exclusion David G. Johnston

6 June 2017

• 03:02   Re: [PERFORM] Re: join estimate of subqueries with range conditions and constraint exclusion Tom Lane

7 June 2017

• 17:33   [PERFORM] Rollback table data. Dinesh Chandra 12108
• 18:42   Re: [PERFORM] Rollback table data. Moreno Andreo
• 18:48   Re: [PERFORM] Rollback table data. Andreas Kretschmer
• 19:23   Re: [PERFORM] Rollback table data. Anthony Sotolongo

8 June 2017

• 06:15   Re: [PERFORM] Rollback table data. Scott Marlowe
• 20:47   Re: [PERFORM] index of only not null, use function index? Merlin Moncure
• 20:58   Re: [PERFORM] index of only not null, use function index? Tom Lane
• 22:05   Re: [PERFORM] Re: join under-estimates with ineq conditions Justin Pryzby
• 22:05   Re: [PERFORM] index of only not null, use function index? Jeremy Finzel

9 June 2017

• 01:57   Re: [PERFORM] index of only not null, use function index? Merlin Moncure
• 19:04   [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 19:20   Re: [PERFORM] Client Server performance & UDS Kevin.Hughes@uk.fujitsu.com
• 19:24   Re: [PERFORM] Improving PostgreSQL insert performance Andreas Kretschmer
• 19:28   Re: [PERFORM] Improving PostgreSQL insert performance Kenneth Marshall
• 19:56   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 20:33   Re: [PERFORM] Improving PostgreSQL insert performance Scott Marlowe
• 20:36   Re: [PERFORM] Improving PostgreSQL insert performance Kenneth Marshall
• 20:39   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 20:46   Re: [PERFORM] Improving PostgreSQL insert performance Sunkara, Amrutha
• 20:53   Re: [PERFORM] Improving PostgreSQL insert performance Kenneth Marshall
• 20:55   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 20:57   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 21:05   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 21:08   Re: [PERFORM] Improving PostgreSQL insert performance John Gorman
• 21:12   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 21:16   Re: [PERFORM] Improving PostgreSQL insert performance Scott Marlowe
• 21:22   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 21:33   Re: [PERFORM] Improving PostgreSQL insert performance Kenneth Marshall
• 21:37   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 23:07   Re: [PERFORM] Improving PostgreSQL insert performance Jeff Janes

10 June 2017

• 04:08   Re: [PERFORM] Improving PostgreSQL insert performance Vladimir Sitnikov
• 04:43   Re: [PERFORM] [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Michael Paquier
• 13:04   Re: [PERFORM] Rollback table data. phb07
• 17:12   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh

11 June 2017

• 02:12   Re: [PERFORM] Improving PostgreSQL insert performance Nicolas Paris
• 02:37   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 08:32   Re: [PERFORM] Improving PostgreSQL insert performance Alvaro Herrera
• 10:15   Re: [PERFORM] Improving PostgreSQL insert performance Joe Conway
• 14:44   Re: [PERFORM] Improving PostgreSQL insert performance Frits Jalvingh
• 15:30   Re: [PERFORM] Improving PostgreSQL insert performance Vladimir Sitnikov
• 18:36   Re: [PERFORM] Improving PostgreSQL insert performance Alvaro Herrera

12 June 2017

• 23:27   Re: [PERFORM] [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Jeff Janes

13 June 2017

• 03:25   Re: [PERFORM] [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Michael Paquier
• 15:34   Re: [PERFORM] [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Michael Paquier

14 June 2017

• 02:38   Re: [PERFORM] [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64 Michael Paquier

15 June 2017

• 14:06   [PERFORM] Using array instead of sub table (storage and speed) Lutz Fischer
• 19:37   Re: [PERFORM] Using array instead of sub table (storage and speed) Stephen Frost
• 20:53   [PERFORM] Sudden drastic change in performance ldh@laurent-hasson.com
• 21:09   Re: [PERFORM] Sudden drastic change in performance Tom Lane
• 21:14   Re: [PERFORM] Sudden drastic change in performance Andreas Kretschmer

16 June 2017

• 08:53   Re: [PERFORM] Re: join under-estimates with ineq conditions Justin Pryzby
• 16:37   Re: [PERFORM] Using array instead of sub table (storage and speed) Lutz Fischer
• 18:05   Re: [PERFORM] Using array instead of sub table (storage and speed) Stephen Frost

20 June 2017

• 17:51   [PERFORM] substring index what is better way to query Tieson Molly
• 20:19   Re: [PERFORM] substring index what is better way to query Tom Lane
• 20:40   Re: [PERFORM] substring index what is better way to query Tieson Molly
• 20:45   Re: [PERFORM] substring index what is better way to query Tom Lane

23 June 2017

• 06:40   [PERFORM] Dataset is fetched from cache but still takes same time to fetchrecords as first run Sumeet Shukla
• 06:54   Re: [PERFORM] Dataset is fetched from cache but still takes same timeto fetch records as first run Dave Stibrany
• 10:35   Re: [PERFORM] Dataset is fetched from cache but still takes same timeto fetch records as first run Sumeet Shukla
• 10:50   Re: [PERFORM] Dataset is fetched from cache but still takes same time to fetch records as first run Tom Lane
• 13:52   Re: [PERFORM] Dataset is fetched from cache but still takes sametime to fetch records as first run Glyn Astill
• 16:31   [PERFORM] Inappropriate inner table for nested loop join Akihiko Odaki
• 17:20   Re: [PERFORM] Inappropriate inner table for nested loop join Albe Laurenz
• 17:36   Re: [PERFORM] Inappropriate inner table for nested loop join Akihiko Odaki
• 17:54   Re: [PERFORM] Inappropriate inner table for nested loop join Akihiko Odaki
• 18:09   Re: [PERFORM] Dataset is fetched from cache but still takes same timeto fetch records as first run Adam Brusselback
• 19:05   Re: [PERFORM] Inappropriate inner table for nested loop join Albe Laurenz
• 22:55   Re: [PERFORM] Dataset is fetched from cache but still takes same timeto fetch records as first run ldh@laurent-hasson.com

24 June 2017

• 02:09   [PERFORM] Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each Chris Wilson
• 04:58   [PERFORM] Efficiently merging and sorting collections of sorted rows Clint Miller
• 05:32   Re: [PERFORM] Efficiently merging and sorting collections of sorted rows Peter Geoghegan
• 05:33   Re: [PERFORM] Efficiently merging and sorting collections of sorted rows Tom Lane
• 08:01   [PERFORM] Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rowseach Karl Czajkowski
• 13:28   [PERFORM] slow delete due to reference Rikard Pavelic
• 22:14   Re: [PERFORM] slow delete due to reference Tom Lane

26 June 2017

• 14:55   Re: [PERFORM] Inappropriate inner table for nested loop join Albe Laurenz
• 21:43   Re: [PERFORM] Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each Chris Wilson
• 23:01   [PERFORM] Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rowseach Karl Czajkowski

27 June 2017

• 02:32   [PERFORM] Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rowseach Karl Czajkowski
• 03:22   Re: [PERFORM] Fwd: Slow query from ~7M rows, joined to two tables of~100 rows each Jeff Janes
• 19:15   [PERFORM] Fwd: Stalled post to pgsql-performance Chris Wilson

28 June 2017

• 05:57   [PERFORM] Performance of information_schema with many schemata and tables Ulf Lohbrügge
• 07:31   Re: [PERFORM] Performance of information_schema with many schemataand tables Pritam Baral
• 12:47   [PERFORM]  Yevhenii Kurtov
• 13:12   Re: [PERFORM] Pavel Stehule
• 13:28   Re: [PERFORM] Yevhenii Kurtov
• 13:43   Re: [PERFORM] Pavel Stehule
• 15:38   Re: [PERFORM] Performance of information_schema with many schemataand tables Ulf Lohbrügge
• 19:08   Re: [PERFORM] Gerardo Herzig
• 19:10   Re: [PERFORM] Brad DeJong
• 19:13   Re: [PERFORM] Efficiently merging and sorting collections of sorted rows Merlin Moncure
• 20:25   Re: [PERFORM] Performance of information_schema with many schemataand tables Ulf Lohbrügge

29 June 2017

• 11:17   Re: [PERFORM] Yevhenii Kurtov
• 21:50   Re: [PERFORM] Pavel Stehule

30 June 2017

• 00:11   Re: [PERFORM] Jeff Janes
• 01:11   Re: [PERFORM] Yevhenii Kurtov
• 03:28   Re: [PERFORM] Alvaro Herrera
• 09:09   Re: [PERFORM] Scott Marlowe
• 23:46   Re: [PERFORM] Jeff Janes