Home > mailing lists

Mailing lists [pgsql-performance]

2 January 2018

19:27 Restoring a table is ten times slower on Ubuntu 14.04 than on Ubuntu16.04 Hans Braxmeier
19:30 Re: Restoring a table is ten times slower on Ubuntu 14.04 than onUbuntu 16.04 Vasilis Ventirozos
20:02 primary key hash index Rick Otten
20:09 Re: primary key hash index Magnus Hagander

5 January 2018

02:01 Re: primary key hash index Jeff Janes
20:30 GEQO and join_collapse_limit correlation Juan José Santamaría Flecha
22:16 Re: GEQO and join_collapse_limit correlation Tom Lane

6 January 2018

02:17 Re: GEQO and join_collapse_limit correlation Juan José Santamaría Flecha
02:29 Re: GEQO and join_collapse_limit correlation Tom Lane
17:31 Re: GEQO and join_collapse_limit correlation Juan José Santamaría Flecha

8 January 2018

15:21 seeing lag in postgresql replication Rambabu V
16:31 Re: seeing lag in postgresql replication Mariel Cherkassky

9 January 2018

12:53 Need Help on wal_compression Rambabu V
18:18 Re: Updating a large table Timokhin Maxim
18:53 Re: Updating a large table Sergei Kornilov
22:31 Re: Updating a large table Timokhin Maxim
22:53 Re: Need Help on wal_compression Claudio Freire

10 January 2018

01:45 Re: Batch insert heavily affecting query performance. Claudio Freire
02:39 Re: Need Help on wal_compression Scott Marlowe
03:18 Performance of a Query Kumar, Virendra
03:32 View preformance oracle to postgresql Reddygari, Pavan
03:33 Re: Need Help on wal_compression Jeff Janes
04:08 Re: Performance of a Query Scott Marlowe
04:25 RE: Performance of a Query Kumar, Virendra
04:54 PG 9.5 2 tables same DDL with diff size ghiureai
04:59 Re: Performance of a Query Scott Marlowe
05:09 RE: Performance of a Query Kumar, Virendra
05:25 Re: Performance of a Query Scott Marlowe
07:24 Re: Need Help on wal_compression Michael Paquier
09:29 RE: Performance of a Query Danylo Hlynskyi
14:51 Re: Performance of a Query Laurenz Albe
15:01 Unable to connect Postgres using psql while postgres is alreadyrunning. Dinesh Chandra 12108
15:10 Re: Unable to connect Postgres using psql while postgres is alreadyrunning. Laurenz Albe
16:41 Re: View preformance oracle to postgresql Laurenz Albe
17:59 Query is slow when run for first time; subsequent execution is fast Nandakumar M
18:42 RE: Re: Unable to connect Postgres using psql while postgres is alreadyrunning. Dinesh Chandra 12108
19:58 Re: View preformance oracle to postgresql Merlin Moncure
21:14 RE: PG 9.5 2 tables same DDL with diff size Igor Neyman
21:48 RE: PG 9.5 2 tables same DDL with diff size Isabella Ghiurea
22:10 RE: PG 9.5 2 tables same DDL with diff size Igor Neyman

11 January 2018

00:49 Re: PG 9.5 2 tables same DDL with diff size ghiureai
01:34 Re: Query is slow when run for first time; subsequent execution is fast Jeff Janes
14:19 Slow queries after Windows startup POUSSEL, Guillaume
15:01 Re: Slow queries after Windows startup Robert Zenz
15:06 RE: Slow queries after Windows startup POUSSEL, Guillaume
15:54 Re: Slow queries after Windows startup Robert Zenz
22:30 Disjunctions and sequential scans Ronuk Raval

12 January 2018

03:08 RE: Slow queries after Windows startup Éric Fontaine
10:55 PGadmin error while connecting with database. Dinesh Chandra 12108
14:03 Re: Query is slow when run for first time; subsequent execution is fast Nandakumar M
14:44 Re: PGadmin error while connecting with database. Mariel Cherkassky
16:04 Re: Query is slow when run for first time; subsequent execution is fast Pavel Stehule

14 January 2018

10:10 Re: Re: PGadmin error while connecting with database. Dinesh Chandra 12108

15 January 2018

02:44 HDD vs SSD without explanation Neto pr
03:40 Re: HDD vs SSD without explanation Justin Pryzby
05:59 Re: HDD vs SSD without explanation Neto pr
08:25 Re: HDD vs SSD without explanation Neto pr
08:36 Re: HDD vs SSD without explanation Neto pr
09:09 Re: HDD vs SSD without explanation Justin Pryzby
17:04 Re: HDD vs SSD without explanation Neto pr
18:35 Re: HDD vs SSD without explanation Neto pr

16 January 2018

00:32 Re: HDD vs SSD without explanation Georg H.
01:46 Re: HDD vs SSD without explanation Brian Busch
01:55 Re: HDD vs SSD without explanation Fernando Hevia
05:10 Re: HDD vs SSD without explanation Neto pr
05:25 Re: HDD vs SSD without explanation Neto pr
06:18 Re: HDD vs SSD without explanation Fernando Hevia
07:19 Re: HDD vs SSD without explanation Neto pr
07:58 Re: HDD vs SSD without explanation Justin Pryzby
08:25 Re: HDD vs SSD without explanation Neto pr
10:04 Re: HDD vs SSD without explanation Mark Kirkwood
16:14 Re: HDD vs SSD without explanation Neto pr
17:46 Fwd: Re: Query is slow when run for first time; subsequent executionis fast Nandakumar M
18:20 Re: Query is slow when run for first time; subsequent execution isfast Thomas Kellerer
21:08 Re: HDD vs SSD without explanation Nicolas Charles

17 January 2018

03:24 Re: HDD vs SSD without explanation Mark Kirkwood
11:18 Re: Query is slow when run for first time; subsequent execution is fast Jeff Janes
13:25 RE: Query is slow when run for first time; subsequent execution isfast POUSSEL, Guillaume
16:09 RE: Query is slow when run for first time; subsequent execution is fast Nandakumar M

18 January 2018

07:55 Re: Query is slow when run for first time; subsequent execution isfast Michael Paquier
18:12 pgaudit and create postgis extension logs a lot inserts Svensson Peter
21:25 need help on memory allocation Rambabu V
22:54 Re: pgaudit and create postgis extension logs a lot inserts Joe Conway

19 January 2018

16:07 Re: need help on memory allocation Laurenz Albe
17:03 SV: pgaudit and create postgis extension logs a lot inserts Svensson Peter
17:05 Re: pgaudit and create postgis extension logs a lot inserts Magnus Hagander
18:24 RE: pgaudit and create postgis extension logs a lot inserts Karen Stone
19:41 Re: pgaudit and create postgis extension logs a lot inserts David Steele
19:51 Re: pgaudit and create postgis extension logs a lot inserts David Steele
22:48 Performance impact of lowering max_files_per_process Thomas Kellerer

20 January 2018

19:05 Re: pgaudit and create postgis extension logs a lot inserts Magnus Hagander

22 January 2018

00:43 query execution time (with cache) Neto pr
12:09 Re: 8.2 Autovacuum BUG ? pavan95
14:20 SV: pgaudit and create postgis extension logs a lot inserts Svensson Peter
15:41 Re: 8.2 Autovacuum BUG ? Sergei Kornilov
16:21 Re: 8.2 Autovacuum BUG ? pavan95
17:47 Re: 8.2 Autovacuum BUG ? Andreas Kretschmer

23 January 2018

00:43 PG 9.6 Slow inserts with long-lasting LWLocks Pavel Suderevsky
13:04 Re: 8.2 Autovacuum BUG ? pavan95
17:51 Re: 8.2 Autovacuum BUG ? pavan95
18:03 Bad plan Laurent Martelli
19:59 Re: need help on memory allocation Rambabu V
20:08 Re: need help on memory allocation Andreas Kretschmer
20:08 RE: Inefficient full seq scan on pg_largeobject instead of indexscan Jean-Marc Lessard
20:17 Re: 8.2 Autovacuum BUG ? Andreas Kretschmer
20:39 Re: 8.2 Autovacuum BUG ? Pavan Teja
20:45 Re: 8.2 Autovacuum BUG ? David G. Johnston
20:57 Re: 8.2 Autovacuum BUG ? Andreas Kretschmer
21:18 Re: Bad plan Justin Pryzby
21:20 Re: 8.2 Autovacuum BUG ? Pavan Teja
21:26 Re: 8.2 Autovacuum BUG ? Andreas Kretschmer
21:38 Re: Bad plan Laurent Martelli
21:59 Re: Bad plan Laurent Martelli
22:07 Re: 8.2 Autovacuum BUG ? Claudio Freire
22:16 Re: 8.2 Autovacuum BUG ? Pavan Teja
23:18 Re: Bad plan Matthew Bellew

24 January 2018

00:36 Re: need help on memory allocation Laurenz Albe
04:36 Re: need help on memory allocation Jeff Janes
04:59 Re: 8.2 Autovacuum BUG ? Claudio Freire
11:54 Re: need help on memory allocation pavan95
12:54 Re: 8.2 Autovacuum BUG ? pavan95
13:09 Re: Performance impact of lowering max_files_per_process Thomas Kellerer
13:15 Re: need help on memory allocation Michael Paquier
13:34 Re: need help on memory allocation pavan95
13:42 Re: 8.2 Autovacuum BUG ? Claudio Freire
14:03 Re: need help on memory allocation Vitaliy Garnashevich
17:48 pg_xlog unbounded growth Stefan Petrea
17:50 Re: 8.2 Autovacuum BUG ? pavan95
20:27 Re: 8.2 Autovacuum BUG ? Claudio Freire
20:48 Re: 8.2 Autovacuum BUG ? Pavan Teja
20:57 Re: 8.2 Autovacuum BUG ? David G. Johnston
21:19 Re: 8.2 Autovacuum BUG ? Alvaro Herrera

25 January 2018

09:47 Re: 8.2 Autovacuum BUG ? pavan95
22:57 Re: pg_xlog unbounded growth Laurenz Albe

26 January 2018

03:30 Re: 8.2 Autovacuum BUG ? Alvaro Herrera
03:36 Re: pg_xlog unbounded growth Tomas Vondra
06:32 Re: 8.2 Autovacuum BUG ? Pavan Teja
13:43 Re: Query is slow when run for first time; subsequent execution is fast Nandakumar M
14:18 Re: pg_xlog unbounded growth Andreas Kretschmer
16:58 PG 10 hash index create times Rick Otten

28 January 2018

15:11 copy csv into partitioned table with unique index Mariel Cherkassky
16:55 Re: copy csv into partitioned table with unique index legrand legrand
17:57 SV: copy csv into partitioned table with unique index Lars Aksel Opsahl
18:04 SV: copy csv into partitioned table with unique index Lars Aksel Opsahl
23:32 Query Slow After 2018 Nur Agus
23:51 Re: Query Slow After 2018 Justin Pryzby

29 January 2018

03:40 Re: Query Slow After 2018 David G. Johnston
05:53 Re: [PERFORM] performance drop after upgrade (9.6 > 10) Bruce Momjian
10:46 Re: 8.2 Autovacuum BUG ? Pavan Teja
16:30 PostgreSQL 10.1 partitions and indexes Mariel Cherkassky
22:19 dsa_allocate() faliure Rick Otten
22:37 Re: dsa_allocate() faliure Tom Lane

30 January 2018

02:52 Re: dsa_allocate() faliure Thomas Munro
03:35 Re: dsa_allocate() faliure Rick Otten
19:55 Re: 8.2 Autovacuum BUG ? pavan95
21:26 Re: SV: pgaudit and create postgis extension logs a lot inserts Bruce Momjian
22:13 Re: 8.2 Autovacuum BUG ? Claudio Freire

31 January 2018

12:37 Nested Loops Kumar, Virendra
14:42 Re: Nested Loops Laurenz Albe
18:03 effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich
19:01 Re: effective_io_concurrency on EBS/gp2 Rick Otten
19:15 Re: effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich
19:24 Re: effective_io_concurrency on EBS/gp2 Pavel Stehule
19:46 RE: effective_io_concurrency on EBS/gp2 Gary Doades
22:57 Re: effective_io_concurrency on EBS/gp2 Vitaliy Garnashevich