Home > mailing lists

Mailing lists [pgsql-performance]

2 April 2020

11:46 Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10and system performance is not so good Julien Rouhaud
13:22 Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 andsystem performance is not so good Tejaswini GC
14:04 Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10and system performance is not so good Julien Rouhaud
14:09 Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 andsystem performance is not so good Tejaswini GC

3 April 2020

19:03 slow query dangal
19:07 Re: slow query Justin Pryzby
19:18 Re: slow query dangal

4 April 2020

00:46 Re: Increasing work_mem slows down query, why? Silvio Moioli
09:27 Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 andsystem performance is not so good Tejaswini GC
10:06 Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10and system performance is not so good Julien Rouhaud

5 April 2020

20:48 Postgresql 12, 512 partition by hash. Slow select Arya F
21:41 Re: Postgresql 12, 512 partition by hash. Slow select Andreas Kretschmer
21:55 Re: Postgresql 12, 512 partition by hash. Slow select Tom Lane
22:50 Re: Postgresql 12, 512 partition by hash. Slow select Arya F
23:48 Re: Postgresql 12, 512 partition by hash. Slow select Neil

6 April 2020

17:19 Postgres not using index on views Rick Vincent

7 April 2020

07:59 Re: Postgres not using index on views Justin Pryzby
08:09 Re: Postgres not using index on views Tom Lane
09:42 Re: Postgres not using index on views Laurenz Albe
10:53 RE: Postgres not using index on views Rick Vincent
12:08 RE: Postgres not using index on views Rick Vincent
12:18 Re: Postgres not using index on views Thomas Kellerer
12:24 Re: Postgres not using index on views Thomas Kellerer
13:20 Re: slow query Michael Christofides
14:50 PostgreSQL DBA consulting daya airody
14:56 Re: PostgreSQL DBA consulting Justin Pryzby

9 April 2020

17:51 High insert rate server, unstable insert latency and load peaks withbuffer_content and XidGenLock LWlocks with Postgresql 12 version Maxim Boguk
18:16 Re: High insert rate server, unstable insert latency and load peakswith buffer_content and XidGenLock LWlocks with Postgresql 12 version Justin Pryzby
18:29 Re: High insert rate server, unstable insert latency and load peakswith buffer_content and XidGenLock LWlocks with Postgresql 12 version Maxim Boguk

13 April 2020

17:34 High kswapd Don Seiler
17:42 Re: High kswapd Justin Pryzby
17:46 Re: High kswapd Don Seiler
17:58 Re: High kswapd Justin Pryzby
18:04 Re: PostgreSQL DBA consulting Amol Tarte
18:08 Re: High kswapd Don Seiler

15 April 2020

22:55 Duplicate WHERE condition changes performance and plan singh400@gmail.com

16 April 2020

01:53 Using unlogged tables for web sessions Stephen Carboni
02:57 Re: Duplicate WHERE condition changes performance and plan David Rowley

17 April 2020

17:28 RE: Postgres not using index on views Rick Vincent
17:55 Postgres not using index on views David G. Johnston
18:12 RE: Postgres not using index on views Rick Vincent

20 April 2020

03:50 Re: Duplicate WHERE condition changes performance and plan singh400@gmail.com
05:33 Re: Duplicate WHERE condition changes performance and plan Justin Pryzby
14:10 RE: Postgres not using index on views Rick Vincent

23 April 2020

14:36 PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso
14:43 Re: PostgreSQL does not choose my indexes well Thomas Kellerer
16:57 Re: PostgreSQL does not choose my indexes well David G. Johnston
18:29 Re: PostgreSQL does not choose my indexes well Tom Lane
19:20 Re: PostgreSQL does not choose my indexes well Michael Lewis
19:31 Re: PostgreSQL does not choose my indexes well Tom Lane
19:50 Re: PostgreSQL does not choose my indexes well David G. Johnston
20:18 Re: PostgreSQL does not choose my indexes well Stephen Frost
20:20 Re: PostgreSQL does not choose my indexes well Stephen Frost
20:56 Re: PostgreSQL does not choose my indexes well Tom Lane
23:01 Re: PostgreSQL does not choose my indexes well Stephen Frost
23:33 Re: PostgreSQL does not choose my indexes well Tom Lane
23:36 Re: PostgreSQL does not choose my indexes well David G. Johnston
23:45 Re: PostgreSQL does not choose my indexes well Tom Lane

24 April 2020

00:01 Re: PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso
19:33 Re: Duplicate WHERE condition changes performance and plan singh400@gmail.com
21:26 Re: PostgreSQL does not choose my indexes well Jeff Janes
21:33 Re: PostgreSQL does not choose my indexes well Stephen Frost
22:39 Re: PostgreSQL does not choose my indexes well Tom Lane

25 April 2020

00:11 The query plan get all columns but I'm using only one column. Moises Lopez
01:59 Re: PostgreSQL does not choose my indexes well Jeff Janes
15:02 Re: PostgreSQL does not choose my indexes well Stephen Frost
17:24 Re: The query plan get all columns but I'm using only one column. Tom Lane
22:47 Re: PostgreSQL does not choose my indexes well Arcadio Ortega Reinoso
23:40 Re: The query plan get all columns but I'm using only one column. Michael Lewis

27 April 2020

20:49 Recursive query slow on strange conditions Jean-Christophe Boggio
21:10 Re: Recursive query slow on strange conditions Justin Pryzby
22:37 Re: Recursive query slow on strange conditions Andreas Joseph Krogh
23:22 Re: Recursive query slow on strange conditions Jean-Christophe Boggio

29 April 2020

09:54 NUMA settings Marc Rechté
11:50 Re: NUMA settings Laurenz Albe
22:21 Re: The query plan get all columns but I'm using only one column. Moises Lopez
22:36 Re: The query plan get all columns but I'm using only one column. Michael Lewis

30 April 2020

18:52 Re: The query plan get all columns but I'm using only one column. Michael Lewis
19:26 Re: The query plan get all columns but I'm using only one column. Moises Lopez