Home > mailing lists

Mailing lists [pgsql-performance]

1 February 2018

01:34 Re: effective_io_concurrency on EBS/gp2 Claudio Freire
02:29 Re: effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich
03:00 Re: effective_io_concurrency on EBS/gp2 Jeff Janes
12:18 Re: 8.2 Autovacuum BUG ? pavan95
16:42 bad plan using nested loops Johan Fredriksson
20:30 Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used Nandakumar M
21:00 Re: bad plan using nested loops Tom Lane

2 February 2018

00:39 Re: effective_io_concurrency on EBS/gp2 Claudio Freire
02:34 SV: bad plan using nested loops Johan Fredriksson
15:02 Re: SV: bad plan using nested loops Johan Fredriksson
15:36 Re: Query optimiser is not using 'not null' constraint when 'orderby nulls last' clause is used Laurenz Albe
17:46 Re: effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich
20:04 Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used Nandakumar M
21:00 Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used Tom Lane
21:49 Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used Nandakumar M
21:58 Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used David G. Johnston
23:01 Re: Query optimiser is not using 'not null' constraint when 'order bynulls last' clause is used Nandakumar M

4 February 2018

05:05 Re: effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich
15:23 postgresql 10.1 scanning all partitions instead of 1 Mariel Cherkassky
15:28 Re: postgresql 10.1 scanning all partitions instead of 1 Mariel Cherkassky
16:14 postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky
18:03 Re: postgresql 10.1 wrong plan in when using partitions bug Tomas Vondra
18:15 Re: postgresql 10.1 wrong plan in when using partitions bug Rick Otten
18:19 Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky
19:19 Re: postgresql 10.1 wrong plan in when using partitions bug legrand legrand
19:22 Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky
19:29 Re: postgresql 10.1 wrong plan in when using partitions bug legrand legrand
19:38 Re: postgresql 10.1 wrong plan in when using partitions bug Rick Otten
19:43 Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky
20:41 Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky
20:54 Re: postgresql 10.1 wrong plan in when using partitions bug Andreas Kretschmer
21:06 Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky
21:25 Re: postgresql 10.1 wrong plan in when using partitions bug Justin Pryzby
21:28 Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky
21:35 Re: postgresql 10.1 wrong plan in when using partitions bug Tom Lane
21:39 Re: postgresql 10.1 wrong plan in when using partitions bug Tom Lane
21:42 Re: postgresql 10.1 wrong plan in when using partitions bug Mariel Cherkassky
22:04 Re: postgresql 10.1 wrong plan in when using partitions bug Rick Otten

5 February 2018

08:27 Re: effective_io_concurrency on EBS/gp2 Claudio Freire
17:26 Re: effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich
19:14 OT: Performance of VM Thomas Güttler
19:26 Re: OT: Performance of VM Andreas Kretschmer
22:22 Re: OT: Performance of VM Andrew Kerber
22:33 Re: OT: Performance of VM Andreas Kretschmer

6 February 2018

01:15 Re: SV: bad plan using nested loops Tomas Vondra
01:19 Re: postgresql 10.1 wrong plan in when using partitions bug Justin Pryzby
02:14 Re: effective_io_concurrency on EBS/gp2 Claudio Freire
20:31 Details after Load Peak was: OT: Performance of VM Thomas Güttler
21:30 Re: Details after Load Peak was: OT: Performance of VM Alan Hodgson

7 February 2018

00:18 Re: failing to use index on UNION of matviews (Re: postgresql 10.1wrong plan in when using partitions bug) Justin Pryzby
02:02 Re: failing to use index on UNION of matviews (Re: postgresql 10.1wrong plan in when using partitions bug) Rick Otten
02:03 Re: failing to use index on UNION of matviews (Re: postgresql 10.1wrong plan in when using partitions bug) Rick Otten
11:42 Re: effective_io_concurrency on EBS/gp2 Justin Pryzby
23:11 RE: pg_xlog unbounded growth Alex Ignatov

8 February 2018

17:04 Re: failing to use index on UNION of matviews (Re: postgresql 10.1wrong plan in when using partitions bug) Rick Otten
22:05 Re: effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich
22:40 Re: effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich

9 February 2018

17:56 Same plans different performance? Elias Panagiotidis

10 February 2018

17:20 Re: OT: Performance of VM Robert Klemme
20:58 Re: OT: Performance of VM Andrew Kerber

13 February 2018

19:28 Efficiently searching for the most recent rows where a columnmatches any result from a different query

14 February 2018

03:13 Re: Efficiently searching for the most recent rows where a columnmatches any result from a different query Hellmuth Vargas
03:15 Re: Details after Load Peak was: OT: Performance of VM Gunnar \"Nick\" Bluth
03:55 Re: Details after Load Peak was: OT: Performance of VM Micky Gough
09:43 Re: OT: Performance of VM Mark Kirkwood

15 February 2018

18:18 Re: Efficiently searching for the most recent rows where a columnmatches any result from a different query

18 February 2018

21:19 pgpool 2 rotate logs Mariel Cherkassky

19 February 2018

07:03 Re: pgpool 2 rotate logs Tatsuo Ishii
16:04 Re: Efficiently searching for the most recent rows where a columnmatches any result from a different query Nandakumar M
16:10 Re: Efficiently searching for the most recent rows where a columnmatches any result from a different query Nandakumar M

21 February 2018

21:53 blending fast and temp space volumes Rick Otten
22:04 Re: blending fast and temp space volumes Tom Lane

22 February 2018

01:22 Re: blending fast and temp space volumes Craig James
01:50 Re: blending fast and temp space volumes Peter Geoghegan
02:07 Re: blending fast and temp space volumes Claudio Freire
02:09 Re: blending fast and temp space volumes Peter Geoghegan
17:30 Re: blending fast and temp space volumes Claudio Freire

23 February 2018

20:42 need advice to tune postgresql Darius Pėža
21:03 Re: need advice to tune postgresql MichaelDBA
21:23 Re: effective_io_concurrency on EBS/gp2 Rick Otten
21:26 Re: need advice to tune postgresql Laurenz Albe
21:35 Re: effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich

24 February 2018

01:29 Performance Daulat Ram
01:31 Please help Daulat Ram
03:20 Re: Performance Andreas Kretschmer
03:23 Re: Please help Andreas Kretschmer
05:27 Updating large tables without dead tuples ldh@laurent-hasson.com
06:09 Re: Updating large tables without dead tuples Stephen Frost
14:45 Re: Bitmap scan is undercosted? Vitaliy Garnashevich
23:19 RE: Updating large tables without dead tuples ldh@laurent-hasson.com

25 February 2018

02:56 Re: Updating large tables without dead tuples Stephen Frost
02:58 Re: Please help PropAAS DBA
14:08 Re: Performance phb07

26 February 2018

11:27 check_postgres via Nagios daulat sagar