gmane.comp.db.postgresql.performance archive

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

Re: Parallel Query
Wed, 13 Nov 2019 18:07:16 -0300
Luís Roberto Weck <[email protected]> • #44425
Re: Parallel Query
Wed, 13 Nov 2019 18:04:42 -0300
Luís Roberto Weck <[email protected]> • #44424
Re: Parallel Query
Wed, 13 Nov 2019 21:47:37 +0100
Tomas Vondra <[email protected]> • #44423
Re: Parallel Query
Wed, 13 Nov 2019 15:40:17 -0500
Jeff Janes <[email protected]> • #44422
Parallel Query
Wed, 13 Nov 2019 17:16:44 -0300
Luís Roberto Weck <[email protected]> • #44421
Re: Slow "not in array" operation
Wed, 13 Nov 2019 17:15:43 +0100
Marco Colli <[email protected]> • #44420
Re: Slow "not in array" operation
Wed, 13 Nov 2019 07:18:21 -0500
Jeff Janes <[email protected]> • #44419
Re: Slow "not in array" operation
Wed, 13 Nov 2019 12:56:22 +0100
Marco Colli <[email protected]> • #44418
Re: Slow "not in array" operation
Wed, 13 Nov 2019 06:30:10 -0500
Jeff Janes <[email protected]> • #44417
Re: Slow "not in array" operation
Wed, 13 Nov 2019 06:18:16 -0500
Rick Otten <[email protected]> • #44416
Re: Slow "not in array" operation
Wed, 13 Nov 2019 21:46:10 +1100
Morris de Oryx <[email protected]> • #44415
Re: Slow "not in array" operation
Wed, 13 Nov 2019 10:20:02 +0100
Marco Colli <[email protected]> • #44414
Re: Slow "not in array" operation
Tue, 12 Nov 2019 18:33:28 -0500
Jeff Janes <[email protected]> • #44413
Re: Slow "not in array" operation
Tue, 12 Nov 2019 22:40:07 +0100
Marco Colli <[email protected]> • #44412
Re: Slow "not in array" operation
Tue, 12 Nov 2019 15:50:51 -0500
Tom Lane <[email protected]> • #44411
Re: Slow "not in array" operation
Tue, 12 Nov 2019 13:31:06 -0700
Michael Lewis <[email protected]> • #44410
Re: Slow "not in array" operation
Tue, 12 Nov 2019 21:06:34 +0100
Marco Colli <[email protected]> • #44409
Re: Slow "not in array" operation
Tue, 12 Nov 2019 13:53:34 -0600
Justin Pryzby <[email protected]> • #44408
Re: Slow "not in array" operation
Tue, 12 Nov 2019 12:20:10 -0700
Michael Lewis <[email protected]> • #44407
Re: Slow "not in array" operation
Tue, 12 Nov 2019 20:04:15 +0100
Marco Colli <[email protected]> • #44406
Re: Slow "not in array" operation
Tue, 12 Nov 2019 11:39:46 -0700
Michael Lewis <[email protected]> • #44405
Slow "not in array" operation
Tue, 12 Nov 2019 18:29:31 +0100
Marco Colli <[email protected]> • #44404
Re: FPGA optimization ...
Thu, 7 Nov 2019 01:45:51 +0100
Tomas Vondra <[email protected]> • #44403
Re: Slow planning, fast execution for particular 3-table query
Wed, 6 Nov 2019 18:18:38 -0600
Justin Pryzby <[email protected]> • #44402
Re: Slow planning, fast execution for particular 3-table query
Thu, 7 Nov 2019 13:15:30 +1300
David Rowley <[email protected]> • #44401
Re: Slow planning, fast execution for particular 3-table query
Wed, 6 Nov 2019 23:41:57 +0000
David Wheeler <[email protected]> • #44400
Re: FPGA optimization ...
Wed, 6 Nov 2019 15:15:53 -0800
Andres Freund <[email protected]> • #44399
Re: Slow planning, fast execution for particular 3-table query
Wed, 6 Nov 2019 16:59:45 -0600
Justin Pryzby <[email protected]> • #44398
Re: Slow planning, fast execution for particular 3-table query
Wed, 6 Nov 2019 15:56:50 -0700
Michael Lewis <[email protected]> • #44397
Re: Slow planning, fast execution for particular 3-table query
Wed, 6 Nov 2019 22:46:25 +0000
David Wheeler <[email protected]> • #44396
Re: FPGA optimization ...
Wed, 6 Nov 2019 22:54:48 +0100
Tomas Vondra <[email protected]> • #44395
Re: FPGA optimization ...
Wed, 6 Nov 2019 11:01:37 -0700 (MST)
AJG <[email protected]> • #44394
Re: FPGA optimization ...
Mon, 4 Nov 2019 23:52:34 -0500
Gunther <[email protected]> • #44393
Re: FPGA optimization ...
Tue, 5 Nov 2019 01:19:15 +0100
Tomas Vondra <[email protected]> • #44392
FPGA optimization ...
Mon, 4 Nov 2019 18:33:15 -0500
Gunther <[email protected]> • #44391
Re: Huge shared hit for small table
Mon, 4 Nov 2019 16:05:12 -0500
Jeff Janes <[email protected]> • #44390
Re: Huge shared hit for small table
Mon, 4 Nov 2019 21:00:15 +0000
Scott Rankin <[email protected]> • #44389
Re: Huge shared hit for small table
Mon, 4 Nov 2019 12:40:46 -0800
Peter Geoghegan <[email protected]> • #44388
Re: Huge shared hit for small table
Mon, 4 Nov 2019 20:38:36 +0000
Scott Rankin <[email protected]> • #44387
Re: Huge shared hit for small table
Mon, 4 Nov 2019 12:34:04 -0800
Peter Geoghegan <[email protected]> • #44386
Re: Huge shared hit for small table
Mon, 4 Nov 2019 15:31:52 -0500
Jeff Janes <[email protected]> • #44385
Re: Huge shared hit for small table
Mon, 4 Nov 2019 20:18:03 +0000
Scott Rankin <[email protected]> • #44384
Re: Huge shared hit for small table
Mon, 4 Nov 2019 12:17:28 -0800
Andres Freund <[email protected]> • #44383
Re: Huge shared hit for small table
Mon, 4 Nov 2019 12:07:27 -0800
Peter Geoghegan <[email protected]> • #44382
Re: Huge shared hit for small table
Mon, 4 Nov 2019 19:56:57 +0000
Scott Rankin <[email protected]> • #44381
Re: Huge shared hit for small table
Mon, 4 Nov 2019 13:56:49 -0600
Justin Pryzby <[email protected]> • #44380
Re: Huge shared hit for small table
Mon, 4 Nov 2019 11:46:29 -0800
Andres Freund <[email protected]> • #44379
Huge shared hit for small table
Mon, 4 Nov 2019 19:38:40 +0000
Scott Rankin <[email protected]> • #44378
Re: Slow planning, fast execution for particular 3-table query
Mon, 4 Nov 2019 06:53:16 +0100
Pavel Stehule <[email protected]> • #44377
Re: Slow planning, fast execution for particular 3-table query
Mon, 4 Nov 2019 05:17:11 +0000
David Wheeler <[email protected]> • #44376
Re: Slow planning, fast execution for particular 3-table query
Mon, 04 Nov 2019 00:00:59 -0500
Tom Lane <[email protected]> • #44375
Re: Slow planning, fast execution for particular 3-table query
Mon, 04 Nov 2019 05:46:41 +0100
Laurenz Albe <[email protected]> • #44374
Re: Slow planning, fast execution for particular 3-table query
Mon, 4 Nov 2019 04:42:00 +0000
David Wheeler <[email protected]> • #44373
Re: Slow planning, fast execution for particular 3-table query
Mon, 04 Nov 2019 05:37:00 +0100
Laurenz Albe <[email protected]> • #44372
Slow planning, fast execution for particular 3-table query
Mon, 4 Nov 2019 03:04:45 +0000
David Wheeler <[email protected]> • #44371
RE: Barman
Fri, 1 Nov 2019 09:42:50 +0000
Daulat Ram <[email protected]> • #44370
Re: Barman
Thu, 31 Oct 2019 19:56:46 +0100
Tomas Vondra <[email protected]> • #44369
Barman
Thu, 31 Oct 2019 17:29:34 +0000
Daulat Ram <[email protected]> • #44368
Re: GIN index on JSONB not used due to lack of nested statistics
Wed, 30 Oct 2019 18:31:44 -0400
Jeff Janes <[email protected]> • #44367
GIN index on JSONB not used due to lack of nested statistics
Wed, 30 Oct 2019 09:24:36 -0700
Alessandro Baretta <[email protected]> • #44366
Re: UNION causes horrible plan on JOIN
Tue, 29 Oct 2019 12:24:53 +0900 (JST)
Kyotaro Horiguchi <[email protected]> • #44365
Re: UNION causes horrible plan on JOIN
Mon, 28 Oct 2019 16:37:23 -0700
Craig James <[email protected]> • #44364
Re: UNION causes horrible plan on JOIN
Mon, 28 Oct 2019 16:30:24 -0700
Craig James <[email protected]> • #44363
Re: UNION causes horrible plan on JOIN
Mon, 28 Oct 2019 17:45:53 -0500
Justin Pryzby <[email protected]> • #44362
UNION causes horrible plan on JOIN
Mon, 28 Oct 2019 15:40:58 -0700
Craig James <[email protected]> • #44361
Re: Notifications within triggers seem to compromise performance
Mon, 28 Oct 2019 17:35:22 +0100
Grégoire de Turckheim <[email protected]> • #44360
Re: Notifications within triggers seem to compromise performance
Mon, 28 Oct 2019 12:25:25 -0400
Tom Lane <[email protected]> • #44359
Re: Notifications within triggers seem to compromise performance
Mon, 28 Oct 2019 16:39:30 +0100
Grégoire de Turckheim <[email protected]> • #44358
Re: Notifications within triggers seem to compromise performance
Mon, 28 Oct 2019 10:22:04 -0400
Tom Lane <[email protected]> • #44357
Notifications within triggers seem to compromise performance
Mon, 28 Oct 2019 14:42:03 +0100
Grégoire de Turckheim <[email protected]> • #44356
Re: max_connections
Tue, 22 Oct 2019 14:39:19 +0200
Pavel Stehule <[email protected]> • #44355
max_connections
Tue, 22 Oct 2019 14:28:31 +0200
Joao Junior <[email protected]> • #44354
Re: Change in CTE treatment in query plans?
Mon, 21 Oct 2019 14:22:01 +0100
David Conlin <[email protected]> • #44353
Re: Can you please tell us how set this prefetch attribute in following lines.
Fri, 18 Oct 2019 11:15:02 -0500
Justin Pryzby <[email protected]> • #44352
Can you please tell us how set this prefetch attribute in following lines.
Fri, 18 Oct 2019 03:47:49 +0000
M Tarkeshwar Rao <[email protected]> • #44351
Re: pg_stat_bgwriter
Thu, 17 Oct 2019 17:55:40 -0700 (MST)
dangal <[email protected]> • #44350
Re: pg_stat_bgwriter
Thu, 17 Oct 2019 17:50:44 -0700 (MST)
dangal <[email protected]> • #44349
Re: Reading explain plans- row estimates/actuals on lower nodes vs next level up
Fri, 18 Oct 2019 02:13:34 +0200
Tomas Vondra <[email protected]> • #44348
Re: pg_stat_bgwriter
Thu, 17 Oct 2019 19:47:10 -0400
Jeff Janes <[email protected]> • #44347
Reading explain plans- row estimates/actuals on lower nodes vs next level up
Thu, 17 Oct 2019 15:15:21 -0600
Michael Lewis <[email protected]> • #44346
Re: Change in CTE treatment in query plans?
Thu, 17 Oct 2019 11:04:32 +0200
Tom Lane <[email protected]> • #44345
Re: pg_stat_bgwriter
Wed, 16 Oct 2019 12:13:36 -0700 (MST)
dangal <[email protected]> • #44344
Re: pg_stat_bgwriter
Wed, 16 Oct 2019 10:37:37 -0700 (MST)
dangal <[email protected]> • #44343
Change in CTE treatment in query plans?
Tue, 15 Oct 2019 12:28:19 +0100
David Conlin <[email protected]> • #44342
Re: Optimising a two column OR check
Sun, 13 Oct 2019 15:38:49 +0200
Ivan Voras <[email protected]> • #44341
Re: pg_stat_bgwriter
Tue, 15 Oct 2019 02:39:35 +0200
Tomas Vondra <[email protected]> • #44340
Re: pg_stat_bgwriter
Mon, 14 Oct 2019 17:16:02 -0500
Justin Pryzby <[email protected]> • #44339
Re: pg_stat_bgwriter
Mon, 14 Oct 2019 13:12:43 -0700 (MST)
dangal <[email protected]> • #44338
Re: pg_stat_bgwriter
Mon, 14 Oct 2019 20:18:47 +0200
Tomas Vondra <[email protected]> • #44337
pg_stat_bgwriter
Sun, 13 Oct 2019 18:27:35 -0700 (MST)
dangal <[email protected]> • #44336
Re: Optimising a two column OR check
Sun, 13 Oct 2019 15:29:19 +0200
Ivan Voras <[email protected]> • #44335
Re: Optimising a two column OR check
Sat, 12 Oct 2019 17:58:22 +0100
Andrew Gierth <[email protected]> • #44334
Re: Optimising a two column OR check
Sat, 12 Oct 2019 11:54:07 -0400
MichaelDBA <[email protected]> • #44333
Re: Optimising a two column OR check
Sat, 12 Oct 2019 16:46:44 +0100
Andrew Gierth <[email protected]> • #44332
Re: Optimising a two column OR check
Sat, 12 Oct 2019 11:45:45 -0400
MichaelDBA <[email protected]> • #44331
Re: Optimising a two column OR check
Sat, 12 Oct 2019 11:35:22 -0400
MichaelDBA <[email protected]> • #44330
Re: Optimising a two column OR check
Sat, 12 Oct 2019 11:33:53 -0400
MichaelDBA <[email protected]> • #44329
Re: Optimising a two column OR check
Sat, 12 Oct 2019 16:33:37 +0100
Andrew Gierth <[email protected]> • #44328
Re: Optimising a two column OR check
Sat, 12 Oct 2019 11:27:55 -0400
MichaelDBA <[email protected]> • #44327
Re: Optimising a two column OR check
Sat, 12 Oct 2019 11:17:58 -0400
Jeff Janes <[email protected]> • #44326
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.