gmane.comp.db.postgresql.performance archive

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

Re: Suggestion to improve query performance for GIS query.
Fri, 22 May 2020 13:04:21 +0530
postgann2020 s <[email protected]> • #44625
Suggestion to improve query performance for GIS query.
Fri, 22 May 2020 12:29:16 +0530
postgann2020 s <[email protected]> • #44624
Re: shared buffers and startup process
Wed, 15 Jan 2020 11:48:00 +0900
Michael Paquier <[email protected]> • #44623
shared buffers and startup process
Tue, 14 Jan 2020 16:29:51 +0100
Joao Junior <[email protected]> • #44622
Re: Bad query plan when you add many OR conditions
Tue, 14 Jan 2020 09:01:30 +0100
Thomas Kellerer <[email protected]> • #44621
Re: Seeking reason behind performance gain in 12 with HashAggregate
Mon, 13 Jan 2020 16:11:48 -0800
Shira Bezalel <[email protected]> • #44620
Re: Seeking reason behind performance gain in 12 with HashAggregate
Mon, 13 Jan 2020 19:15:11 -0300
Alvaro Herrera <[email protected]> • #44619
Re: Bad query plan when you add many OR conditions
Mon, 13 Jan 2020 23:14:11 +0100
Tomas Vondra <[email protected]> • #44618
Re: Seeking reason behind performance gain in 12 with HashAggregate
Mon, 13 Jan 2020 13:45:55 -0800
Shira Bezalel <[email protected]> • #44617
Re: Seeking reason behind performance gain in 12 with HashAggregate
Mon, 13 Jan 2020 22:11:56 +0100
Tomas Vondra <[email protected]> • #44616
Re: Seeking reason behind performance gain in 12 with HashAggregate
Mon, 13 Jan 2020 12:44:14 -0800
Shira Bezalel <[email protected]> • #44615
Re: Seeking reason behind performance gain in 12 with HashAggregate
Mon, 13 Jan 2020 11:07:16 -0700
Michael Lewis <[email protected]> • #44614
Re: Seeking reason behind performance gain in 12 with HashAggregate
Mon, 13 Jan 2020 09:34:04 -0800
Shira Bezalel <[email protected]> • #44613
Re: Seeking reason behind performance gain in 12 with HashAggregate
Mon, 13 Jan 2020 10:42:20 -0600
Justin Pryzby <[email protected]> • #44612
Seeking reason behind performance gain in 12 with HashAggregate
Mon, 13 Jan 2020 08:29:05 -0800
Shira Bezalel <[email protected]> • #44611
Re: Bad query plan when you add many OR conditions
Fri, 10 Jan 2020 12:12:52 -0500
Jeff Janes <[email protected]> • #44610
Re: Bad query plan when you add many OR conditions
Fri, 10 Jan 2020 17:03:41 +0100
Marco Colli <[email protected]> • #44609
Re: Bad query plan when you add many OR conditions
Fri, 10 Jan 2020 10:18:02 -0500
Tom Lane <[email protected]> • #44608
Re: Bad query plan when you add many OR conditions
Fri, 10 Jan 2020 15:53:22 +0100
Marco Colli <[email protected]> • #44607
Re: Bad query plan when you add many OR conditions
Fri, 10 Jan 2020 07:34:47 -0600
Justin Pryzby <[email protected]> • #44606
Re: Bad query plan when you add many OR conditions
Fri, 10 Jan 2020 14:30:27 +0100
Marco Colli <[email protected]> • #44605
Re: Bad query plan when you add many OR conditions
Fri, 10 Jan 2020 12:03:39 +0100
Marco Colli <[email protected]> • #44604
Re: Bad query plan when you add many OR conditions
Thu, 9 Jan 2020 21:06:02 -0600
Justin Pryzby <[email protected]> • #44603
Bad query plan when you add many OR conditions
Fri, 10 Jan 2020 02:11:14 +0100
Marco Colli <[email protected]> • #44602
Re: distinguish index cost component from table component
Fri, 3 Jan 2020 10:03:15 -0600
Justin Pryzby <[email protected]> • #44601
Re: distinguish index cost component from table component
Fri, 3 Jan 2020 09:33:35 -0500
Jeff Janes <[email protected]> • #44600
distinguish index cost component from table component
Fri, 3 Jan 2020 08:14:27 -0600
Justin Pryzby <[email protected]> • #44599
Re: Merge join doesn't seem to break early when I (and planner) think it should - 10.4
Fri, 27 Dec 2019 11:52:18 -0500
Jeff Janes <[email protected]> • #44598
Merge join doesn't seem to break early when I (and planner) think it should - 10.4
Thu, 26 Dec 2019 15:07:41 -0500
Timothy Garnett <[email protected]> • #44597
Re: How to set parallel_tuple_cost
Fri, 20 Dec 2019 20:37:15 -0500
Jeff Janes <[email protected]> • #44596
Re: How to set parallel_tuple_cost
Fri, 20 Dec 2019 16:24:53 -0800
Andres Freund <[email protected]> • #44595
Re: How to set parallel_tuple_cost
Fri, 20 Dec 2019 13:58:57 -0500
Tom Lane <[email protected]> • #44594
Re: How to set parallel_tuple_cost
Fri, 20 Dec 2019 19:42:19 +0100
Laurenz Albe <[email protected]> • #44593
How to set parallel_tuple_cost
Fri, 20 Dec 2019 13:03:29 -0500
Jeff Janes <[email protected]> • #44592
Re: Consecutive Query Executions with Increasing Execution Time
Thu, 19 Dec 2019 23:21:10 -0600
Shijia Wei <[email protected]> • #44591
Re: How to prevent POSTGRES killing linux system from accepting too much inserts?
Wed, 18 Dec 2019 21:25:54 +0100
Osahon Oduware <[email protected]> • #44590
Re: How to prevent POSTGRES killing linux system from accepting too much inserts?
Wed, 18 Dec 2019 14:09:25 -0500
Jeff Janes <[email protected]> • #44589
Re: How to prevent POSTGRES killing linux system from accepting too much inserts?
Wed, 18 Dec 2019 12:34:36 -0600
Merlin Moncure <[email protected]> • #44588
Re: Consecutive Query Executions with Increasing Execution Time
Wed, 18 Dec 2019 08:44:14 -0500
Tom Lane <[email protected]> • #44587
Re: Consecutive Query Executions with Increasing Execution Time
Wed, 18 Dec 2019 13:17:10 +0100
Laurenz Albe <[email protected]> • #44586
Re: shared memory size during upgrade pgsql with partitions (max_locks_per_transaction)
Wed, 18 Dec 2019 09:16:11 +0000
Piotr Włodarczyk <[email protected]> • #44585
How to prevent POSTGRES killing linux system from accepting too much inserts?
Wed, 18 Dec 2019 17:53:26 +0800
"James(王旭)" <[email protected]> • #44584
Re: weird long time query
Wed, 18 Dec 2019 11:23:37 +0800
Kaijiang Chen <[email protected]> • #44583
Re: shared memory size during upgrade pgsql with partitions (max_locks_per_transaction)
Tue, 17 Dec 2019 22:01:19 -0600
Justin Pryzby <[email protected]> • #44582
shared memory size during upgrade pgsql with partitions
Tue, 17 Dec 2019 20:03:41 +0000
Piotr Włodarczyk <[email protected]> • #44581
Re: weird long time query
Tue, 17 Dec 2019 12:04:20 -0500
Tom Lane <[email protected]> • #44580
Re: Consecutive Query Executions with Increasing Execution Time
Tue, 17 Dec 2019 11:11:12 -0500
Jeff Janes <[email protected]> • #44579
Re: Consecutive Query Executions with Increasing Execution Time
Tue, 17 Dec 2019 14:08:39 +0100
Laurenz Albe <[email protected]> • #44578
Re: weird long time query
Tue, 17 Dec 2019 12:08:33 +0100
Pavel Stehule <[email protected]> • #44577
weird long time query
Tue, 17 Dec 2019 10:58:17 +0800
Kaijiang Chen <[email protected]> • #44576
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 20:04:45 -0800
Andres Freund <[email protected]> • #44575
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 16:53:31 -0800
Sam Gendler <[email protected]> • #44574
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 17:48:16 -0500
Tom Lane <[email protected]> • #44573
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 23:08:52 +0100
Nicolas Charles <[email protected]> • #44572
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 15:50:17 -0500
Tom Lane <[email protected]> • #44571
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 12:39:10 -0800
Peter Geoghegan <[email protected]> • #44570
Re: performance degredation after upgrade from 9.6 to 12
Mon, 16 Dec 2019 18:29:12 +0100
Pavel Stehule <[email protected]> • #44569
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 11:28:09 -0600
Shijia Wei <[email protected]> • #44568
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 08:50:36 -0500
Tom Lane <[email protected]> • #44567
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 14:25:49 +0100
Laurenz Albe <[email protected]> • #44566
Re: performance degredation after upgrade from 9.6 to 12
Mon, 16 Dec 2019 15:01:57 +0200
Mariel Cherkassky <[email protected]> • #44565
RE: performance degredation after upgrade from 9.6 to 12
Mon, 16 Dec 2019 15:27:01 +0300
"Andrew Zakharov" <[email protected]> • #44564
Re: performance degredation after upgrade from 9.6 to 12
Mon, 16 Dec 2019 13:48:20 +0200
Mariel Cherkassky <[email protected]> • #44563
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 11:17:50 +0100
Olivier Gautherot <[email protected]> • #44562
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 03:51:24 -0600
Shijia Wei <[email protected]> • #44561
Re: Consecutive Query Executions with Increasing Execution Time
Mon, 16 Dec 2019 09:03:54 +0100
Olivier Gautherot <[email protected]> • #44560
Consecutive Query Executions with Increasing Execution Time
Sun, 15 Dec 2019 23:59:26 -0600
Shijia Wei <[email protected]> • #44559
Re: Strange runtime partition pruning behaviour with 11.4
Mon, 5 Aug 2019 09:29:33 +0200
Thomas Kellerer <[email protected]> • #44558
Re: Legal disclaimers on emails to this group
Thu, 12 Dec 2019 16:03:32 +0100
Moreno Andreo <[email protected]> • #44557
Re: Legal disclaimers on emails to this group
Thu, 12 Dec 2019 15:49:54 +0100
Moreno Andreo <[email protected]> • #44556
Re: Specific query taking time to process
Wed, 11 Dec 2019 21:25:12 -0500
Jeff Janes <[email protected]> • #44555
Re: Specific query taking time to process
Wed, 11 Dec 2019 19:53:57 +0000
Fahiz Mohamed <[email protected]> • #44554
Re: Specific query taking time to process
Wed, 11 Dec 2019 16:14:44 -0500
Jeff Janes <[email protected]> • #44553
Re: Specific query taking time to process
Wed, 11 Dec 2019 13:09:19 -0700
Michael Lewis <[email protected]> • #44552
Re: unexpected result for wastedbytes query after vacuum full
Wed, 11 Dec 2019 16:23:05 +0100
Guillaume Lelarge <[email protected]> • #44551
Re: Specific query taking time to process
Tue, 10 Dec 2019 14:42:06 -0600
Justin Pryzby <[email protected]> • #44550
Re: Specific query taking time to process
Tue, 10 Dec 2019 13:15:08 -0700
Michael Lewis <[email protected]> • #44549
Re: unexpected result for wastedbytes query after vacuum full
Tue, 10 Dec 2019 14:48:26 -0500
Jeff Janes <[email protected]> • #44548
Re: unexpected result for wastedbytes query after vacuum full
Tue, 10 Dec 2019 17:43:31 +0100
Guillaume Lelarge <[email protected]> • #44547
Re: Specific query taking time to process
Mon, 9 Dec 2019 22:39:38 +0000
Fahiz Mohamed <[email protected]> • #44546
RE: unexpected result for wastedbytes query after vacuum full
Mon, 9 Dec 2019 23:06:52 +0000
Mike Schanne <[email protected]> • #44545
RE: Legal disclaimers on emails to this group
Mon, 9 Dec 2019 23:05:04 +0000
Mike Schanne <[email protected]> • #44544
Re: Logical replication performance
Mon, 9 Dec 2019 17:31:39 -0500
Jeff Janes <[email protected]> • #44543
Re: Specific query taking time to process
Mon, 9 Dec 2019 12:03:15 -0700
Michael Lewis <[email protected]> • #44542
Re: Specific query taking time to process
Sun, 8 Dec 2019 22:13:07 -0600
Justin Pryzby <[email protected]> • #44541
Specific query taking time to process
Sat, 7 Dec 2019 20:05:59 +0000
Fahiz Mohamed <[email protected]> • #44540
Re: How to run in parallel in Postgres, EXECUTE_PARALLEL
Sun, 8 Dec 2019 21:59:51 +0000
Lars Aksel Opsahl <[email protected]> • #44539
Re: How to run in parallel in Postgres, EXECUTE_PARALLEL
Sun, 8 Dec 2019 15:04:05 -0500
Joe Conway <[email protected]> • #44538
Re: How to run in parallel in Postgres, EXECUTE_PARALLEL
Sun, 8 Dec 2019 18:14:14 +0000
Lars Aksel Opsahl <[email protected]> • #44537
Re: query that canceled isnt logged
Sun, 08 Dec 2019 10:42:00 -0500
Tom Lane <[email protected]> • #44536
Re: query that canceled isnt logged
Sun, 8 Dec 2019 17:23:01 +0200
Mariel Cherkassky <[email protected]> • #44535
Re: query that canceled isnt logged
Sun, 8 Dec 2019 17:18:37 +0200
Mariel Cherkassky <[email protected]> • #44534
Re: query that canceled isnt logged
Sun, 08 Dec 2019 10:05:02 -0500
Tom Lane <[email protected]> • #44533
query that canceled isnt logged
Sun, 8 Dec 2019 15:08:27 +0200
Mariel Cherkassky <[email protected]> • #44532
Re: Legal disclaimers on emails to this group
Sat, 7 Dec 2019 07:10:15 -0500
Jean-David Beyer <[email protected]> • #44531
Re: How to run in parallel in Postgres
Sat, 7 Dec 2019 11:27:56 +0000
Lars Aksel Opsahl <[email protected]> • #44530
Re: How to run in parallel in Postgres
Sat, 7 Dec 2019 11:17:25 +0000
Lars Aksel Opsahl <[email protected]> • #44529
Re: How to run in parallel in Postgres
Fri, 6 Dec 2019 19:25:21 -0600
Justin Pryzby <[email protected]> • #44528
Re: How to run in parallel in Postgres
Sat, 7 Dec 2019 12:23:15 +1100
Ondrej Ivanič <[email protected]> • #44527
Re: autovacuum locking question
Fri, 6 Dec 2019 19:59:00 -0500
Jeff Janes <[email protected]> • #44526
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.