pgsql-performance
Thread
Date
Earlier messages
Later messages
Messages by Thread
Re: [PERFORM] Query Plan Performance on Partitioned Table
Pietro Pugni
Re: [PERFORM] Query Plan Performance on Partitioned Table
Rural Hunter
Re: [PERFORM] Query Plan Performance on Partitioned Table
Pietro Pugni
Re: [PERFORM] Query Plan Performance on Partitioned Table
Rural Hunter
[PERFORM] Slow HashAggregate/cache access
Alexandre de Arruda Paes
Re: [PERFORM] Slow HashAggregate/cache access
Kevin Grittner
Re: [PERFORM] Slow HashAggregate/cache access
Alexandre de Arruda Paes
Re: [PERFORM] Slow HashAggregate/cache access
Maxim Boguk
Re: [PERFORM] Slow HashAggregate/cache access
Andreas Joseph Krogh
Re: [PERFORM] Slow HashAggregate/cache access
Alexandre de Arruda Paes
Re: [PERFORM] Slow HashAggregate/cache access
Andreas Joseph Krogh
Re: [PERFORM] Slow HashAggregate/cache access
David Rowley
Re: [PERFORM] Slow HashAggregate/cache access
David Rowley
Re: [PERFORM] Slow HashAggregate/cache access
Alexandre de Arruda Paes
Re: [PERFORM] Slow HashAggregate/cache access
Alexandre de Arruda Paes
Re: [PERFORM] Slow HashAggregate/cache access
Andreas Joseph Krogh
Re: [PERFORM] Slow HashAggregate/cache access
David Rowley
[PERFORM] Performance issue with NestedLoop query
Ram N
Re: [PERFORM] Performance issue with NestedLoop query
Qingqing Zhou
Re: [PERFORM] Performance issue with NestedLoop query
Ram N
Re: [PERFORM] Performance issue with NestedLoop query
Qingqing Zhou
Re: [PERFORM] Performance issue with NestedLoop query
Ram N
Re: [PERFORM] Performance issue with NestedLoop query
Qingqing Zhou
Re: [PERFORM] Performance issue with NestedLoop query
Matheus de Oliveira
Re: [PERFORM] Performance issue with NestedLoop query
Matheus de Oliveira
[PERFORM] incredible surprise news from intel/micron right now...
Graeme B. Bell
Re: [PERFORM] incredible surprise news from intel/micron right now...
Graeme B. Bell
[PERFORM] autofreeze/vacuuming - avoiding the random performance hit
Graeme B. Bell
Re: [PERFORM] autofreeze/vacuuming - avoiding the random performance hit
Wei Shan
Re: [PERFORM] autofreeze/vacuuming - avoiding the random performance hit
Graeme B. Bell
[PERFORM] Any ideas how can I speed up this query?
Priyank Tiwari
Re: [PERFORM] Any ideas how can I speed up this query?
Graeme B. Bell
Re: [PERFORM] Any ideas how can I speed up this query?
林士博
[PERFORM] Are many idle connections bad?
Craig James
Re: [PERFORM] Are many idle connections bad?
Tom Lane
Re: [PERFORM] Are many idle connections bad?
Craig James
Re: [PERFORM] Are many idle connections bad?
Jeff Janes
Re: [PERFORM] Are many idle connections bad?
Alex Hunsaker
[PERFORM] bitmap heap scan recheck for gin/fts with no lossy blocks
Laurent Debacker
Re: [PERFORM] bitmap heap scan recheck for gin/fts with no lossy blocks
Jeff Janes
Re: [PERFORM] bitmap heap scan recheck for gin/fts with no lossy blocks
Laurent Debacker
Re: [PERFORM] bitmap heap scan recheck for gin/fts with no lossy blocks
Jeff Janes
[PERFORM] parallelisation provides postgres performance (script example + ppt slides)
Graeme B. Bell
[PERFORM] How to find the culprit in server load spikes?
Moreno Andreo
Re: [PERFORM] How to find the culprit in server load spikes?
Kevin Grittner
Re: [PERFORM] How to find the culprit in server load spikes?
Jeff Janes
[PERFORM] hyperthreadin low performance
Jeison Bedoya Delgado
Re: [PERFORM] hyperthreadin low performance
David Rowley
Re: [PERFORM] hyperthreadin low performance
Mark Kirkwood
Re: [PERFORM] hyperthreadin low performance
domenico febbo
Re: [PERFORM] hyperthreadin low performance (and some discussion about benchmarking)
Graeme B. Bell
Re: [PERFORM] hyperthreadin low performance
Mark Kirkwood
Re: [PERFORM] intel s3500 -- hot stuff
Julien Rouhaud
[PERFORM] Insert vs Update
Robert DiFalco
Re: [PERFORM] Insert vs Update
David G. Johnston
Re: [PERFORM] Insert vs Update
Michael Nolan
Re: [PERFORM] Insert vs Update
David G. Johnston
Re: [PERFORM] Insert vs Update
Robert DiFalco
Re: [PERFORM] Insert vs Update
David G. Johnston
Re: [PERFORM] Insert vs Update
Robert DiFalco
Re: [PERFORM] Insert vs Update
David G. Johnston
Re: [PERFORM] Insert vs Update
Robert DiFalco
Re: [PERFORM] Insert vs Update
Michael Nolan
Re: [PERFORM] Insert vs Update
David G. Johnston
Re: [PERFORM] Insert vs Update
Guillaume Lelarge
Re: [PERFORM] [ADMIN] could not create shared memory segment: Invalid argument
Scott Whitney
Re: [PERFORM] could not create shared memory segment: Invalid argument
Ryan King - NOAA Affiliate
[PERFORM] Query planner not using indexes with JOIN query and OR clause
Ben Hoyt
Re: [PERFORM] Query planner not using indexes with JOIN query and OR clause
Merlin Moncure
Re: [PERFORM] Query planner not using indexes with JOIN query and OR clause
Merlin Moncure
Re: [PERFORM] Query planner not using indexes with JOIN query and OR clause
Ben Hoyt
[PERFORM] QUERY PLANNER - Indexe mono column VS composite Index
Nicolas Paris
Re: [PERFORM] QUERY PLANNER - Indexe mono column VS composite Index
Guillaume Lelarge
Re: [PERFORM] QUERY PLANNER - Indexe mono column VS composite Index
Nicolas Paris
Re: [PERFORM] QUERY PLANNER - Indexe mono column VS composite Index
Jeff Janes
Re: [PERFORM] [BUGS] BUG #13493: pl/pgsql doesn't scale with cpus (PG9.3, 9.4)
Graeme B. Bell
[PERFORM] pg_stat_all_indexes understand
Nicolas Paris
Re: [PERFORM] pg_stat_all_indexes understand
Jeff Janes
Re: [PERFORM] pg_stat_all_indexes understand
Bruce Momjian
[PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Craig James
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Joshua D. Drake
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Craig James
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Joshua D. Drake
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Craig James
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Merlin Moncure
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Andres Freund
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Craig James
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Andres Freund
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Tom Lane
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Andres Freund
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Merlin Moncure
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Merlin Moncure
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
[PERFORM] Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Thomas Kellerer
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Merlin Moncure
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
Re: [PERFORM] Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
James Cloos
[PERFORM] wildcard text filter switched to boolean column, performance is way worse
Mike Broers
Re: [PERFORM] wildcard text filter switched to boolean column, performance is way worse
Tom Lane
Re: [PERFORM] wildcard text filter switched to boolean column, performance is way worse
Mike Broers
Re: [PERFORM] wildcard text filter switched to boolean column, performance is way worse
Mike Broers
Re: [PERFORM] wildcard text filter switched to boolean column, performance is way worse
Marc Mamin
[PERFORM] 9.5alpha1 vs 9.4
Mkrtchyan, Tigran
Re: [PERFORM] 9.5alpha1 vs 9.4
Mkrtchyan, Tigran
Re: [PERFORM] 9.5alpha1 vs 9.4
Andres Freund
Re: [PERFORM] 9.5alpha1 vs 9.4
Tom Lane
Re: [PERFORM] 9.5alpha1 vs 9.4
Mkrtchyan, Tigran
Re: [PERFORM] 9.5alpha1 vs 9.4
Josh Berkus
Re: [PERFORM] 9.5alpha1 vs 9.4
Mkrtchyan, Tigran
[PERFORM] Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
[PERFORM] Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Marc Mamin
Re: [PERFORM] Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Merlin Moncure
Re: [PERFORM] Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
Re: [PERFORM] Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Merlin Moncure
Re: [PERFORM] Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
Re: [PERFORM] Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Andres Freund
Re: [PERFORM] Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
Re: [PERFORM] Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Andres Freund
Re: [PERFORM] Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Graeme B. Bell
[PERFORM] New server: SSD/RAID recommendations?
Craig James
Re: [PERFORM] New server: SSD/RAID recommendations?
Andreas Joseph Krogh
Re: [PERFORM] New server: SSD/RAID recommendations?
Wes Vaske (wvaske)
Re: [PERFORM] New server: SSD/RAID recommendations?
Craig James
Re: [PERFORM] New server: SSD/RAID recommendations?
Wes Vaske (wvaske)
Re: [PERFORM] New server: SSD/RAID recommendations?
Merlin Moncure
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Wes Vaske (wvaske)
Re: [PERFORM] New server: SSD/RAID recommendations?
Heikki Linnakangas
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Vitalii Tymchyshyn
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Merlin Moncure
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Wei Shan
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Merlin Moncure
Re: [PERFORM] New server: SSD/RAID recommendations?
Michael Nolan
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Scott Marlowe
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Wes Vaske (wvaske)
Re: [PERFORM] New server: SSD/RAID recommendations?
Heikki Linnakangas
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Heikki Linnakangas
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Steve Crawford
Re: [PERFORM] New server: SSD/RAID recommendations?
Joshua D. Drake
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Mkrtchyan, Tigran
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Mkrtchyan, Tigran
Re: [PERFORM] New server: SSD/RAID recommendations?
Karl Denninger
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Karl Denninger
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Karl Denninger
Re: [PERFORM] New server: SSD/RAID recommendations?
Graeme B. Bell
Re: [PERFORM] New server: SSD/RAID recommendations?
Craig James
Re: [PERFORM] New server: SSD/RAID recommendations?
Scott Marlowe
Re: [PERFORM] New server: SSD/RAID recommendations?
Craig James
Re: [PERFORM] New server: SSD/RAID recommendations?
Merlin Moncure
[PERFORM] Sudden connection and load average spikes with postgresql 9.3
eudald_v
Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3
Tom Lane
Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3
eudald_v
Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3
Josh Berkus
Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3
eudald_v
Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3
Josh Berkus
Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3
Josh Berkus
Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3
Kevin Grittner
Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3
eudald_v
Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3
Scott Marlowe
Re: [PERFORM] Sudden connection and load average spikes with postgresql 9.3
Scott Marlowe
[PERFORM] Does anyone have python code which digests pgbench -r output?
Josh Berkus
[PERFORM] pgbouncer issue
Sheena, Prabhjot
Re: [PERFORM] pgbouncer issue
Greg Sabino Mullane
[PERFORM] Slow query (planner insisting on using 'external merge' sort type)
Ian Pushee
Re: [PERFORM] Slow query (planner insisting on using 'external merge' sort type)
Andreas Kretschmer
Re: [PERFORM] Slow query (planner insisting on using 'external merge' sort type)
Ian Pushee
Re: [PERFORM] Slow query (planner insisting on using 'external merge' sort type)
Jim Nasby
Re: [PERFORM] Slow query (planner insisting on using 'external merge' sort type)
Mark Kirkwood
Re: [PERFORM] Slow query (planner insisting on using 'external merge' sort type)
Igor Neyman
Re: [PERFORM] Slow query (planner insisting on using 'external merge' sort type)
Ian Pushee
Re: [PERFORM] Slow query (planner insisting on using 'external merge' sort type)
Igor Neyman
Re: [PERFORM] Slow query (planner insisting on using 'external merge' sort type)
Igor Neyman
[PERFORM] Techniques to Avoid Temp Files
Duane Murphy
Re: [PERFORM] Techniques to Avoid Temp Files
Albe Laurenz
Re: [PERFORM] Techniques to Avoid Temp Files
Jeff Janes
[PERFORM] How to calculate statistics for one column
Irineu Ruiz
Re: [PERFORM] How to calculate statistics for one column
Igor Neyman
Re: [PERFORM] How to calculate statistics for one column
Irineu Ruiz
Re: [PERFORM] How to calculate statistics for one column
Igor Neyman
Re: [PERFORM] How to calculate statistics for one column
Irineu Ruiz
Re: [PERFORM] How to calculate statistics for one column
Igor Neyman
[PERFORM] PGBOUNCER ISSUE PLEASE HELP(Slowing down the site)
Sheena, Prabhjot
Earlier messages
Later messages