pgsql-performance - December 2014

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 4 5 6 7 8 9 10 11 12 13 15 16 17 18 22 23 30

Dec. 2, 2014

Thread Author Time
CTE query plan ignores selective index Patrick Krecker 20:59
Re: CTE query plan ignores selective index Tom Lane 22:07

Dec. 4, 2014

Thread Author Time
Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform Josh Berkus 19:10
Query doesn't use index on hstore column Michael Barker 20:42
Re: Query doesn't use index on hstore column [email protected] 21:46

Dec. 5, 2014

Thread Author Time
Re: Query doesn't use index on hstore column Tom Lane 01:32
Re: Yet another abort-early plan disaster on 9.3 📎 Simon Riggs 06:46
Re: Yet another abort-early plan disaster on 9.3 Merlin Moncure 15:45
Re: Yet another abort-early plan disaster on 9.3 Simon Riggs 16:04

Dec. 6, 2014

Thread Author Time
Re: Query doesn't use index on hstore column Michael Barker 00:05
Re: intel s3500 -- hot stuff Bruce Momjian 13:08

Dec. 7, 2014

Thread Author Time
PATCH: adaptive ndistinct estimator v3 (WAS: Re: [PERFORM] Yet another abort-early plan disaster on 9.3) 📎 Tomas Vondra 01:54
querying with index on jsonb slower than standard column. Why? Tim Dudgeon 22:59

Dec. 8, 2014

Thread Author Time
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 00:19
Re: querying with index on jsonb slower than standard column. Why? Tim Dudgeon 00:43
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 00:53
Re: querying with index on jsonb slower than standard column. Why? Tim Dudgeon 01:05
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 01:15
Re: querying with index on jsonb slower than standard column. Why? Tom Lane 01:28
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 15:31
Re: querying with index on jsonb slower than standard column. Why? Tom Lane 15:46
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 15:50
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 16:44
Re: querying with index on jsonb slower than standard column. Why? Tom Lane 16:56
Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 20:53
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 21:14
Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 21:22
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 21:34
Re: [SQL] querying with index on jsonb slower than standard column. Why? Tim Dudgeon 21:39
Re: intel s3500 -- hot stuff Merlin Moncure 21:40

Dec. 9, 2014

Thread Author Time
Hardware Requirements Vivekanand Joshi 18:42
Re: Hardware Requirements Claudio Freire 18:55
Re: intel s3500 -- hot stuff Bruce Momjian 20:43
8xIntel S3500 SSD in RAID10 on Dell H710p Strahinja Kustudić 23:28

Dec. 10, 2014

Thread Author Time
Re: Yet another abort-early plan disaster on 9.3 Josh Berkus 01:46
Re: Yet another abort-early plan disaster on 9.3 Simon Riggs 02:09
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Mark Kirkwood 03:55
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Strahinja Kustudić 08:30
Tuning the configuration Maila Fatticcioni 10:44
When does PostgreSQL collapse subqueries to join? Sven R. Kunze 11:31
Re: When does PostgreSQL collapse subqueries to join? Tom Lane 15:34
Re: intel s3500 -- hot stuff Jeff Janes 16:52
Re: Tuning the configuration Patrick Krecker 17:47
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Mark Kirkwood 22:05

Dec. 11, 2014

Thread Author Time
Re: Tuning the configuration Maila Fatticcioni 08:11
Re: Tuning the configuration Andrea Suisani 12:02
Re: Tuning the configuration Evgeniy Shishkin 12:11
Re: Tuning the configuration Maila Fatticcioni 12:48
Re: Tuning the configuration Andrea Suisani 13:16
Re: Tuning the configuration Andrea Suisani 13:26
Re: Tuning the configuration Eric Pierce 22:36

Dec. 12, 2014

Thread Author Time
Re: Tuning the configuration Mark Kirkwood 00:04
Re: Yet another abort-early plan disaster on 9.3 📎 Simon Riggs 03:22
Re: Yet another abort-early plan disaster on 9.3 📎 Simon Riggs 03:31
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Merlin Moncure 21:06
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Josh Berkus 21:24
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 21:44
Re: [PERFORM] Re: querying with index on jsonb slower than standard column. Why? Claudio Freire 22:10
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Andrew Dunstan 23:27

Dec. 13, 2014

Thread Author Time
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 01:20
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Andrew Dunstan 03:05
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Claudio Freire 05:38

Dec. 15, 2014

Thread Author Time
Re: Tuning the configuration Graeme B. Bell 13:36
Re: Postgres slave not catching up (on 9.2) Ruben Domingo Gaspar Aparicio 14:18
Re: Postgres slave not catching up (on 9.2) Ruben Domingo Gaspar Aparicio 14:32

Dec. 16, 2014

Thread Author Time
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Graeme B. Bell 11:47
Re: Tuning the configuration Graeme B. Bell 11:51
Re: Tuning the configuration Evgeniy Shishkin 16:37
Re: 8xIntel S3500 SSD in RAID10 on Dell H710p Strahinja Kustudić 19:46

Dec. 17, 2014

Thread Author Time
Re: Yet another abort-early plan disaster on 9.3 📎 Simon Riggs 07:55
Excessive memory used for INSERT 📎 Alessandro Ipe 15:14
Re: Excessive memory used for INSERT Torsten Zuehlsdorff 15:26
Re: Excessive memory used for INSERT Tom Lane 15:41
Re: Excessive memory used for INSERT Alessandro Ipe 16:57
Re: Excessive memory used for INSERT Alessandro Ipe 17:04
Re: Excessive memory used for INSERT Tom Lane 17:49

Dec. 18, 2014

Thread Author Time
Re: Excessive memory used for INSERT Torsten Förtsch 07:51
Re: Excessive memory used for INSERT Alessandro Ipe 11:16
Re: Excessive memory used for INSERT Alessandro Ipe 15:42
Re: Excessive memory used for INSERT Alessandro Ipe 16:31
Re: Excessive memory used for INSERT Tom Lane 17:05
Question about trigram GIST index Robert DiFalco 17:12
Re: Question about trigram GIST index Tom Lane 17:18
Re: Excessive memory used for INSERT Alessandro Ipe 17:31
Re: Question about trigram GIST index Robert DiFalco 17:32
Re: Question about trigram GIST index Giuseppe Broccolo 18:00
Re: Question about trigram GIST index Robert DiFalco 18:08
Re: Question about trigram GIST index Jeff Janes 18:33
Re: Question about trigram GIST index Robert DiFalco 19:33
Re: Question about trigram GIST index Kevin Grittner 20:03

Dec. 22, 2014

Thread Author Time
Number of Columns and Update Robert DiFalco 20:53
Re: Number of Columns and Update Heikki Linnakangas 21:40
Re: Number of Columns and Update Andrew Dunstan 21:41

Dec. 23, 2014

Thread Author Time
Re: PATCH: adaptive ndistinct estimator v3 (WAS: Re: [PERFORM] Yet another abort-early plan disaster on 9.3) Heikki Linnakangas 10:28
Re: Excessive memory used for INSERT 📎 Alessandro Ipe 11:56
Re: Excessive memory used for INSERT Tom Lane 20:27

Dec. 30, 2014

Thread Author Time
trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist cesar 20:42

Browse Archives

Prev | Next
Jump to day: 1 2 4 5 6 7 8 9 10 11 12 13 15 16 17 18 22 23 30