gmane.comp.db.postgresql.performance archive

391 archived articles, newest first (page 4 of 4). Latest articles →

Re: Optimising a two column OR check
Sat, 12 Oct 2019 16:16:50 +0100
Andrew Gierth <[email protected]> • #44325
Re: Optimising a two column OR check
Sat, 12 Oct 2019 09:43:36 -0500
Justin Pryzby <[email protected]> • #44324
Optimising a two column OR check
Sat, 12 Oct 2019 16:39:56 +0200
Ivan Voras <[email protected]> • #44323
Re: Modification of data in base folder and very large tables
Thu, 10 Oct 2019 21:08:54 -0400
Jeff Janes <[email protected]> • #44322
Re: Modification of data in base folder and very large tables
Thu, 10 Oct 2019 13:05:24 +0100
Andrew Gierth <[email protected]> • #44321
Re: Modification of data in base folder and very large tables
Wed, 9 Oct 2019 22:01:35 -0700
Ogden Brash <[email protected]> • #44320
Re: Modification of data in base folder and very large tables
Wed, 09 Oct 2019 18:05:20 -0500
Jerry Sievers <[email protected]> • #44319
Re: Query slow again after adding an `OR` operation (was: Slow PostgreSQL 10.6 query)
Thu, 10 Oct 2019 11:06:25 +1300
David Rowley <[email protected]> • #44318
Re: Would SSD improve Index Only Scan performance by a lot?
Wed, 9 Oct 2019 15:54:57 -0400
Jeff Janes <[email protected]> • #44317
Re: Query slow again after adding an `OR` operation (was: Slow PostgreSQL 10.6 query)
Wed, 9 Oct 2019 13:36:00 -0600
Michael Lewis <[email protected]> • #44316
Re: Modification of data in base folder and very large tables
Wed, 9 Oct 2019 14:42:31 -0400
Jeff Janes <[email protected]> • #44315
Re: Get the planner used by a query?
Thu, 10 Oct 2019 07:15:50 +1300
David Rowley <[email protected]> • #44314
Re: Query slows when used with view
Wed, 09 Oct 2019 12:07:47 -0400
Tom Lane <[email protected]> • #44313
Re: Query slows when used with view
Wed, 9 Oct 2019 09:32:37 -0600
Michael Lewis <[email protected]> • #44312
Re: Query slows when used with view
Wed, 9 Oct 2019 11:24:00 -0400
Jeff Janes <[email protected]> • #44311
Re: Query slows when used with view
Wed, 9 Oct 2019 09:23:14 -0600
Michael Lewis <[email protected]> • #44310
RE: Query slows when used with view
Wed, 9 Oct 2019 14:55:58 +0000
Yavuz Selim Sertoğlu (ETIYA) <[email protected]> • #44309
Re: Query slows when used with view
Wed, 09 Oct 2019 09:57:01 -0400
Tom Lane <[email protected]> • #44308
Query slows when used with view
Wed, 9 Oct 2019 12:31:40 +0000
Yavuz Selim Sertoğlu (ETIYA) <[email protected]> • #44307
Query slow again after adding an `OR` operation (was: Slow PostgreSQL 10.6 query)
Wed, 9 Oct 2019 23:07:02 +1100
Behrang Saeedzadeh <[email protected]> • #44306
Re: Modification of data in base folder and very large tables
Wed, 09 Oct 2019 09:42:18 +0100
Andrew Gierth <[email protected]> • #44305
Modification of data in base folder and very large tables
Tue, 8 Oct 2019 13:20:43 -0700
Ogden Brash <[email protected]> • #44304
Get the planner used by a query?
Wed, 9 Oct 2019 17:21:23 +1100
Behrang Saeedzadeh <[email protected]> • #44303
Re: Would SSD improve Index Only Scan performance by a lot?
Tue, 8 Oct 2019 20:17:13 -0700
Matthew Hall <[email protected]> • #44302
Re: Would SSD improve Index Only Scan performance by a lot?
Tue, 8 Oct 2019 20:12:48 -0400
Rick Otten <[email protected]> • #44301
Sv: Would SSD improve Index Only Scan performance by a lot?
Wed, 9 Oct 2019 01:42:26 +0200 (CEST)
Andreas Joseph Krogh <[email protected]> • #44300
Would SSD improve Index Only Scan performance by a lot?
Tue, 8 Oct 2019 19:37:06 -0400
Arya F <[email protected]> • #44299
Re: Out of Memory errors are frustrating as heck!
Tue, 8 Oct 2019 12:50:32 -0500
Merlin Moncure <[email protected]> • #44298
Re: Out of Memory errors are frustrating as heck!
Tue, 8 Oct 2019 12:44:39 -0500
Merlin Moncure <[email protected]> • #44297
Re: distinct on extract returns composite type
Mon, 7 Oct 2019 15:53:17 -0600
Michael Lewis <[email protected]> • #44296
Re: Slow PostgreSQL 10.6 query
Mon, 7 Oct 2019 19:27:42 +1100
Behrang Saeedzadeh <[email protected]> • #44295
Re: Out of Memory errors are frustrating as heck!
Sun, 6 Oct 2019 23:11:31 +0200
Tomas Vondra <[email protected]> • #44294
Re: Out of Memory errors are frustrating as heck!
Sun, 6 Oct 2019 23:06:18 +0200
Tomas Vondra <[email protected]> • #44293
Re: Delete huge Table under XFS
Sun, 6 Oct 2019 22:54:52 +0200
Tomas Vondra <[email protected]> • #44292
Re: Slow PostgreSQL 10.6 query
Sun, 6 Oct 2019 22:37:53 +0200
Tomas Vondra <[email protected]> • #44291
Re: Query went slow all of sudden. ON V 11.3
Sun, 6 Oct 2019 22:30:39 +0200
Tomas Vondra <[email protected]> • #44290
Re: Query went slow all of sudden. ON V 11.3
Fri, 4 Oct 2019 13:07:24 -0600
Michael Lewis <[email protected]> • #44289
Re: Query went slow all of sudden. ON V 11.3
Fri, 4 Oct 2019 19:28:54 +0530
nikhil raj <[email protected]> • #44288
Re: Query went slow all of sudden. ON V 11.3
Fri, 4 Oct 2019 08:20:44 -0500
Justin Pryzby <[email protected]> • #44287
Query went slow all of sudden. ON V 11.3
Fri, 4 Oct 2019 15:52:26 +0530
nikhil raj <[email protected]> • #44286
Re: Some observations on very slow pg_restore operations
Fri, 4 Oct 2019 01:03:00 -0500
Justin Pryzby <[email protected]> • #44285
Re: Some observations on very slow pg_restore operations
Thu, 3 Oct 2019 16:19:31 -0700
Ogden Brash <[email protected]> • #44284
Re: Some observations on very slow pg_restore operations
Thu, 3 Oct 2019 17:48:18 -0400
MichaelDBA <[email protected]> • #44283
Some observations on very slow pg_restore operations
Thu, 3 Oct 2019 13:30:30 -0700
Ogden Brash <[email protected]> • #44282
Re: pg12 - partition by column that might have null values
Thu, 3 Oct 2019 11:55:22 -0600
Michael Lewis <[email protected]> • #44281
Re: pg12 - partition by column that might have null values
Thu, 3 Oct 2019 10:30:20 +0300
Mariel Cherkassky <[email protected]> • #44280
RE: pg12 - partition by column that might have null values
Wed, 2 Oct 2019 16:14:22 -0700
"Mike Sofen" <[email protected]> • #44279
Re: pg12 - partition by column that might have null values
Wed, 2 Oct 2019 16:44:31 +0300
Mariel Cherkassky <[email protected]> • #44278
RE: pg12 - partition by column that might have null values
Wed, 2 Oct 2019 05:08:05 -0700
"Mike Sofen" <[email protected]> • #44277
Re: pg12 - partition by column that might have null values
Wed, 2 Oct 2019 10:37:11 +0300
Mariel Cherkassky <[email protected]> • #44276
Re: pg12 - partition by column that might have null values
Wed, 02 Oct 2019 09:29:58 +0200
Laurenz Albe <[email protected]> • #44275
pg12 - partition by column that might have null values
Wed, 2 Oct 2019 09:17:37 +0300
Mariel Cherkassky <[email protected]> • #44274
Re: Slow PostgreSQL 10.6 query
Tue, 1 Oct 2019 23:42:33 +1000
Behrang Saeedzadeh <[email protected]> • #44273
Re: Slow PostgreSQL 10.6 query
Tue, 01 Oct 2019 09:27:06 -0400
Tom Lane <[email protected]> • #44272
Slow PostgreSQL 10.6 query
Tue, 1 Oct 2019 22:37:03 +1000
Behrang Saeedzadeh <[email protected]> • #44271
Re: distinct on extract returns composite type
Mon, 30 Sep 2019 16:51:14 +0300
Mariel Cherkassky <[email protected]> • #44270
Re: distinct on extract returns composite type
Mon, 30 Sep 2019 09:48:16 -0400
Tom Lane <[email protected]> • #44269
Re: distinct on extract returns composite type
Mon, 30 Sep 2019 16:42:02 +0300
Mariel Cherkassky <[email protected]> • #44268
Re: sequence depends on many tables
Sun, 29 Sep 2019 11:32:23 -0400
Tom Lane <[email protected]> • #44267
Re: distinct on extract returns composite type
Sun, 29 Sep 2019 12:34:30 +0200
Félix GERZAGUET <[email protected]> • #44266
distinct on extract returns composite type
Sun, 29 Sep 2019 12:46:31 +0300
Mariel Cherkassky <[email protected]> • #44265
Re: sequence depends on many tables
Sun, 29 Sep 2019 09:05:15 +0300
Mariel Cherkassky <[email protected]> • #44264
Re: Slow pg_publication_tables with many schemas and tables
Fri, 27 Sep 2019 10:25:24 -0400
Edilmar Alves <[email protected]> • #44263
Re: Analyze on slave promoted.
Fri, 27 Sep 2019 12:41:05 +0200
Vik Fearing <[email protected]> • #44262
Re: Autovacuum is cleaning very less dead tuples
Fri, 27 Sep 2019 07:55:06 +0200
Laurenz Albe <[email protected]> • #44261
Autovacuum is cleaning very less dead tuples
Fri, 27 Sep 2019 11:10:50 +0530
Amarendra Konda <[email protected]> • #44260
RE: Monitor Postgres database status on Docker
Fri, 27 Sep 2019 05:25:28 +0000
Daulat Ram <[email protected]> • #44259
Re: Slow pg_publication_tables with many schemas and tables
Thu, 26 Sep 2019 19:11:39 -0400
Tom Lane <[email protected]> • #44258
Slow pg_publication_tables with many schemas and tables
Thu, 26 Sep 2019 16:37:02 -0400
Edilmar Alves <[email protected]> • #44257
Re: Analyze on slave promoted.
Thu, 26 Sep 2019 10:31:10 +0200
Pavel Stehule <[email protected]> • #44256
Analyze on slave promoted.
Thu, 26 Sep 2019 09:54:40 +0200
Joao Junior <[email protected]> • #44255
Re: sequence depends on many tables
Wed, 25 Sep 2019 21:23:23 +0200
Laurenz Albe <[email protected]> • #44254
Re: sequence depends on many tables
Wed, 25 Sep 2019 22:20:21 +0300
Mariel Cherkassky <[email protected]> • #44253
Re: sequence depends on many tables
Wed, 25 Sep 2019 21:19:22 +0200
Laurenz Albe <[email protected]> • #44252
sequence depends on many tables
Wed, 25 Sep 2019 15:39:46 +0300
Mariel Cherkassky <[email protected]> • #44251
Re: Slow query on V12.
Mon, 23 Sep 2019 17:23:10 -0300
Luís Roberto Weck <[email protected]> • #44250
Re: Slow query on V12.
Mon, 23 Sep 2019 15:44:23 -0400
Tom Lane <[email protected]> • #44249
Re: Slow query on V12.
Mon, 23 Sep 2019 16:12:02 -0300
Luís Roberto Weck <[email protected]> • #44248
Re: Slow query on V12.
Mon, 23 Sep 2019 16:03:54 -0300
Luís Roberto Weck <[email protected]> • #44247
Re: Slow query on V12.
Tue, 24 Sep 2019 00:13:12 +0530
nikhil raj <[email protected]> • #44246
Slow query on V12.
Mon, 23 Sep 2019 15:42:05 -0300
Luís Roberto Weck <[email protected]> • #44245
Re: pg12 partitions question
Mon, 23 Sep 2019 14:02:10 +0300
Mariel Cherkassky <[email protected]> • #44244
pg12 partitions question
Mon, 23 Sep 2019 13:59:40 +0300
Mariel Cherkassky <[email protected]> • #44243
Re: Slow query on a one-tuple table
Fri, 20 Sep 2019 09:09:35 -0400
MichaelDBA <[email protected]> • #44242
Re: Slow query on a one-tuple table
Thu, 19 Sep 2019 18:57:11 -0400
Tom Lane <[email protected]> • #44241
Re: Slow query on a one-tuple table
Thu, 19 Sep 2019 19:46:46 -0300
Luís Roberto Weck <[email protected]> • #44240
Re: Slow query on a one-tuple table
Thu, 19 Sep 2019 16:32:19 -0600
Michael Lewis <[email protected]> • #44239
Re: Slow query on a one-tuple table
Thu, 19 Sep 2019 19:27:34 -0300
Luís Roberto Weck <[email protected]> • #44238
Re: Surprising benchmark count(1) vs. count(*)
Thu, 19 Sep 2019 17:36:35 -0400
Tom Lane <[email protected]> • #44237
Re: Surprising benchmark count(1) vs. count(*)
Thu, 19 Sep 2019 16:38:33 -0400
Adam Brusselback <[email protected]> • #44236
Re: Slow query on a one-tuple table
Thu, 19 Sep 2019 17:41:19 -0300
Luís Roberto Weck <[email protected]> • #44235
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.