pgsql-performance@postgresql.org

0

replies

Slow 3 Table Join with v bad row estimate

started 2015-11-10 18:13:21 UTC

2015-11-10 18:13:21 UTC

David Osborne

2

replies

querying jsonb for arrays inside a hash

started 2015-11-08 05:31:18 UTC

2015-11-09 23:13:48 UTC

Joe Van Dyk

1

reply

HASH

started 2015-11-05 15:11:10 UTC

2015-11-05 17:24:24 UTC

Jeff Janes

59

replies

Yet another abort-early plan disaster on 9.3

started 2014-09-18 05:11:33 UTC

2015-11-05 15:45:31 UTC

Evgeniy Shishkin

4

replies

Slow query in trigger function

started 2015-11-02 16:15:35 UTC

2015-11-03 16:58:26 UTC

Guido Niewerth

5

replies

GIN index always doing Re-check condition, postgres 9.1

started 2015-11-02 12:52:33 UTC

2015-11-03 15:05:02 UTC

Andrey Osenenko

1

reply

PostgreSQL limitation

started 2015-11-02 16:52:15 UTC

2015-11-02 18:12:21 UTC

Michael Paquier

2

replies

Query optimizer plans with very small selectivity estimates

started 2015-10-29 21:52:13 UTC

2015-10-30 05:00:07 UTC

Josh Berkus

1

reply

Scalability to more than 64 cores With PG 9.4 and RHEL 7.1 Kernel 3.10

started 2015-10-28 10:04:04 UTC

2015-10-29 18:46:39 UTC

Alex Ignatov

13

replies

Query planner wants to use seq scan

started 2015-10-27 14:35:27 UTC

2015-10-29 18:16:02 UTC

Bertrand Paquet

3

replies

Partition Constraint Exclusion Limits

started 2015-10-27 23:29:04 UTC

2015-10-28 07:59:12 UTC

Jim Nasby

7

replies

GroupAggregate and Integer Arrays

started 2015-10-23 19:29:17 UTC

2015-10-26 23:21:10 UTC

Merlin Moncure

10

replies

Recursive query performance issue

started 2015-10-20 22:34:35 UTC

2015-10-26 20:03:33 UTC

Merlin Moncure

14

replies

SELECT slows down on sixth execution

started 2015-10-14 12:38:55 UTC

2015-10-20 20:01:54 UTC

Pavel Stehule

12

replies

One long transaction or multiple short transactions?

started 2015-10-06 08:10:49 UTC

2015-10-18 01:43:29 UTC

Jim Nasby

1

reply

query partitioned table is very slow

started 2015-10-17 03:02:54 UTC

2015-10-17 04:02:08 UTC

Tom Lane

8

replies

Having some problems with concurrent COPY commands

started 2015-10-12 23:17:53 UTC

2015-10-14 02:44:28 UTC

David Rowley

0

replies

V8 optimisation (if you're using javascript in postgres)

started 2015-10-13 13:47:09 UTC

2015-10-13 13:47:09 UTC

Graeme B. Bell

4

replies

3000x Slower query when using Foreign Data Wrapper vs. local

started 2015-10-11 13:05:38 UTC

2015-10-11 15:58:16 UTC

Mohammad Habbab

2

replies

LIMIT 1 poor query plan

started 2015-10-10 13:52:35 UTC

2015-10-10 22:45:20 UTC

Marcio Ribeiro

7

replies

Multi processor server overloads occationally with system process while running postgresql-9.4

started 2015-10-03 13:39:33 UTC

2015-10-09 18:01:53 UTC

Kevin Grittner

11

replies

large object write performance

started 2015-10-08 14:17:49 UTC

2015-10-08 19:13:58 UTC

Bram Van Steenlandt

10

replies

shared-buffers set to 24GB but the RAM only use 4-5 GB average

started 2015-10-05 19:51:24 UTC

2015-10-07 18:59:49 UTC

Merlin Moncure

4

replies

Queries Per Second (QPS)

started 2015-09-26 21:24:54 UTC

2015-09-30 22:06:46 UTC

Josh Berkus

1

reply

dump restoration performance

started 2015-09-30 07:32:31 UTC

2015-09-30 07:38:28 UTC

Michael Paquier

3

replies

Performance problem with gin index

started 2015-09-29 20:45:41 UTC

2015-09-30 01:51:33 UTC

Bertrand Paquet

1

reply

Another parallel postgres project...

started 2015-09-29 13:41:01 UTC

2015-09-29 21:25:05 UTC

Corey Huinker

2

replies

Occasional Really Slow Running Updates/Inserts

started 2015-09-18 00:14:43 UTC

2015-09-18 03:14:26 UTC

Dave Stibrany

5

replies

degrading inser performance

started 2015-09-17 16:32:30 UTC

2015-09-18 01:13:02 UTC

Dave Cramer

1

reply

VACUUM VERBOSE ANALYZE taking long time to process.

started 2015-09-16 03:51:01 UTC

2015-09-16 04:52:10 UTC

Ben Chobot