pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedBDR, wal sender, high system cpu, mutex_lock_common
2017-09-29 23:07 UTC milist ujang <ujang.milist@gmail.com>
` Re: BDR, wal sender, high system cpu, mutex_lock_common
2017-10-01 01:36 UTC milist ujang <ujang.milist@gmail.com>
[2+ messages in thread]
Slow query in JDBC
2017-09-28 08:19 UTC Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
2017-09-28 08:48 UTC Julien Rouhaud <rjuju123@gmail.com>
` Re: Slow query in JDBC
2017-09-28 08:58 UTC Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
2017-09-28 09:20 UTC Julien Rouhaud <rjuju123@gmail.com>
` Re: Slow query in JDBC
2017-09-28 09:26 UTC Pavy Philippe <Philippe.Pavy@worldline.com>
` Re: Slow query in JDBC
2017-09-28 09:59 UTC Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
2017-09-28 13:59 UTC Dave Cramer <pg@fastcrypt.com>
` Re: Slow query in JDBC
2017-09-28 16:32 UTC Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
2017-09-28 19:04 UTC Dave Cramer <pg@fastcrypt.com>
` Re: Slow query in JDBC
2017-09-29 05:57 UTC Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
2017-09-29 06:49 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow query in JDBC
2017-09-29 10:44 UTC Subramaniam C <subramaniam31784@gmail.com>
` Re: Slow query in JDBC
2017-09-29 13:04 UTC Dave Cramer <pg@fastcrypt.com>
[13+ messages in thread]
query of partitioned object doesnt use index in qa
2017-09-13 20:28 UTC Mike Broers <mbroers@gmail.com>
` Re: query of partitioned object doesnt use index in qa
2017-09-13 21:57 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: query of partitioned object doesnt use index in qa
2017-09-14 13:25 UTC Mike Broers <mbroers@gmail.com>
` Re: query of partitioned object doesnt use index in qa
2017-09-15 20:18 UTC Mike Broers <mbroers@gmail.com>
` Re: query of partitioned object doesnt use index in qa
2017-09-15 20:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query of partitioned object doesnt use index in qa
2017-09-15 20:59 UTC Mike Broers <mbroers@gmail.com>
` Re: query of partitioned object doesnt use index in qa
2017-09-15 21:03 UTC Andres Freund <andres@anarazel.de>
` Re: query of partitioned object doesnt use index in qa
2017-09-15 22:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query of partitioned object doesnt use index in qa
2017-09-15 22:26 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: query of partitioned object doesnt use index in qa
2017-09-20 16:15 UTC Mike Broers <mbroers@gmail.com>
` Re: query of partitioned object doesnt use index in qa
2017-09-20 23:05 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: query of partitioned object doesnt use index in qa
2017-09-25 16:21 UTC Mike Broers <mbroers@gmail.com>
[12+ messages in thread]
Parallel sequential scan not supported for stored procedure with RETURN QUERY EXECUTE ?
2017-09-25 11:10 UTC Tobias Gierke <tobias.gierke@code-sourcery.de>
Query regarding EXPLAIN (ANALYZE,BUFFERS)
2017-09-21 10:52 UTC Subramaniam C <subramaniam31784@gmail.com>
` Re: Query regarding EXPLAIN (ANALYZE,BUFFERS)
2017-09-21 18:37 UTC Pavel Stehule <pavel.stehule@gmail.com>
[2+ messages in thread]
repeated subplan execution
2017-09-19 23:30 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: repeated subplan execution
2017-09-20 02:31 UTC monika yadav <monika.1234yadav@gmail.com>
` Re: repeated subplan execution
2017-09-20 16:46 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: repeated subplan execution
2017-09-21 10:35 UTC monika yadav <monika.1234yadav@gmail.com>
[4+ messages in thread]
https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
2017-09-19 00:49 UTC 園田祥平 <shohei.nkapl@gmail.com>
` Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
2017-09-19 02:44 UTC George Neuner <gneuner2@comcast.net>
` Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
2017-09-19 03:30 UTC Jonathan Rogers <jrogers@emphasys-software.com>
` Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server
2017-09-19 13:08 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[4+ messages in thread]
Pageinspect bt_metap help
2017-09-17 21:52 UTC Neto pr <netopr9@gmail.com>
` Re: Pageinspect bt_metap help
2017-09-17 21:59 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Pageinspect bt_metap help
2017-09-18 14:31 UTC Neto pr <netopr9@gmail.com>
` Re: Pageinspect bt_metap help
2017-09-19 01:07 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Pageinspect bt_metap help
2017-09-19 03:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
max partitions behind a view?
2017-09-18 11:25 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: max partitions behind a view?
2017-09-18 13:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Partitioning perfomance issue
2017-09-17 08:34 UTC Konstantin Kivi <konstantin.kivi@gmail.com>
Indexing an array of two separate columns
2017-09-15 20:51 UTC Jeremy Finzel <finzelj@gmail.com>
Store/Retrieve time series data from PostgreSQL
2017-09-14 11:51 UTC Subramaniam C <subramaniam31784@gmail.com>
` Re: Store/Retrieve time series data from PostgreSQL
2017-09-14 12:03 UTC vinny <vinny@xs4all.nl>
` Re: Store/Retrieve time series data from PostgreSQL
2017-09-14 12:33 UTC Subramaniam C <subramaniam31784@gmail.com>
` Re: Store/Retrieve time series data from PostgreSQL
2017-09-14 12:38 UTC Subramaniam C <subramaniam31784@gmail.com>
[4+ messages in thread]
postgresql 9.6 data directory fs becomes full
2017-09-11 09:42 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 9.6 data directory fs becomes full
2017-09-11 12:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql 9.6 data directory fs becomes full
2017-09-11 17:07 UTC Jerry Sievers <gsievers19@comcast.net>
[3+ messages in thread]
OS cache management
2017-09-06 08:12 UTC Soni M <diptatapa@gmail.com>
` Re: OS cache management
2017-09-06 14:13 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: [SPAM] OS cache management
2017-09-06 14:45 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: OS cache management
2017-09-10 05:48 UTC Soni M <diptatapa@gmail.com>
` Re: [SPAM] OS cache management
2017-09-10 05:49 UTC Soni M <diptatapa@gmail.com>
[5+ messages in thread]
Explain Analyze - actual time in loops
2017-09-08 03:17 UTC Neto pr <netopr9@gmail.com>
` Re: Explain Analyze - actual time in loops
2017-09-08 12:46 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Explain Analyze - actual time in loops
2017-09-08 13:08 UTC Neto pr <netopr9@gmail.com>
` Re: Explain Analyze - actual time in loops
2017-09-08 13:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Explain Analyze - actual time in loops
2017-09-08 14:02 UTC Neto pr <netopr9@gmail.com>
` Re: Explain Analyze - actual time in loops
2017-09-08 14:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
printing results of query to file in different times
2017-08-24 13:15 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: printing results of query to file in different times
2017-08-31 08:07 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Fwd: printing results of query to file in different times
2017-08-31 08:44 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: printing results of query to file in different times
2017-08-31 12:26 UTC Roman Konoval <rkonoval@gmail.com>
` Re: printing results of query to file in different times
2017-08-31 13:24 UTC George Neuner <gneuner2@comcast.net>
` Re: printing results of query to file in different times
2017-09-05 11:28 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: printing results of query to file in different times
2017-09-05 14:23 UTC George Neuner <gneuner2@comcast.net>
` Re: printing results of query to file in different times
2017-09-05 17:12 UTC George Neuner <gneuner2@comcast.net>
` Re: printing results of query to file in different times
2017-09-06 16:55 UTC George Neuner <gneuner2@comcast.net>
` Re: printing results of query to file in different times
2017-09-07 17:26 UTC George Neuner <gneuner2@comcast.net>
[10+ messages in thread]
Poor perfomance of update (and select) on partitioned tables
2017-09-07 15:13 UTC Konstantin Kivi <konstantin.kivi@gmail.com>
Slow vacuum of GIST indexes, because of random reads on PostgreSQL 9.6
2017-09-06 11:57 UTC Marcin Barczynski <mbarczynski@starfishstorage.com>
slow index scan performance
2017-09-05 13:24 UTC Soni M <diptatapa@gmail.com>
` Re: slow index scan performance
2017-09-05 13:46 UTC Soni M <diptatapa@gmail.com>
` Re: slow index scan performance
2017-09-05 13:58 UTC Soni M <diptatapa@gmail.com>
[3+ messages in thread]
Handling small inserts from many connections.
2017-09-04 08:14 UTC 우성민 <dntjdals0513@gmail.com>
` Re: Handling small inserts from many connections.
2017-09-04 11:57 UTC Michael Vitale <michaeldba@sqlexec.com>
` Re: Handling small inserts from many connections.
2017-09-04 18:15 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Handling small inserts from many connections.
2017-09-04 22:06 UTC Michaeldba@sqlexec.com <Michaeldba@sqlexec.com>
` Re: Handling small inserts from many connections.
2017-09-04 22:27 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Handling small inserts from many connections.
2017-09-04 22:54 UTC 우성민 <dntjdals0513@gmail.com>
[6+ messages in thread]
performance problem on big tables
2017-08-14 13:24 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-14 15:10 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: performance problem on big tables
2017-08-14 15:11 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: performance problem on big tables
2017-08-14 15:45 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: performance problem on big tables
2017-08-14 16:39 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: performance problem on big tables
2017-08-15 10:06 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-15 16:13 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: performance problem on big tables
2017-08-15 17:14 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: performance problem on big tables
2017-08-15 17:44 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: performance problem on big tables
2017-08-16 12:26 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-16 13:08 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: performance problem on big tables
2017-08-16 13:54 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-16 14:04 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: performance problem on big tables
2017-08-16 14:32 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-16 21:46 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: performance problem on big tables
2017-08-17 06:25 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-17 09:00 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-17 10:06 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: performance problem on big tables
2017-08-17 16:37 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: performance problem on big tables
2017-08-20 06:39 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-20 11:00 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-20 11:32 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-21 08:00 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-21 08:37 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: performance problem on big tables
2017-08-21 11:27 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-21 11:53 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: performance problem on big tables
2017-08-21 12:22 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-21 13:55 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` Re: performance problem on big tables
2017-08-21 14:19 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-21 14:35 UTC Igor Neyman <ineyman@perceptron.com>
` Re: performance problem on big tables
2017-08-21 14:37 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-21 14:51 UTC Michael DNA <michaeldba@sqlexec.com>
` Re: performance problem on big tables
2017-08-23 23:15 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: performance problem on big tables
2017-08-24 07:51 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-24 16:14 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: performance problem on big tables
2017-08-27 16:34 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: performance problem on big tables
2017-08-28 05:47 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: performance problem on big tables
2017-08-28 05:51 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: performance problem on big tables
2017-08-28 06:05 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
[39+ messages in thread]
10x faster sort performance on Skylake CPU vs Ivy Bridge
2017-08-25 14:12 UTC Felix Geisendörfer <felix@felixge.de>
` Re: 10x faster sort performance on Skylake CPU vs Ivy Bridge
2017-08-25 15:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 10x faster sort performance on Skylake CPU vs Ivy Bridge
2017-08-25 15:43 UTC Peter Geoghegan <pg@bowt.ie>
` Re: 10x faster sort performance on Skylake CPU vs Ivy Bridge
2017-08-27 10:56 UTC Felix Geisendörfer <felix@felixge.de>
[4+ messages in thread]
Partitioned table - scans through every partitions
2017-08-25 15:36 UTC Aniko Belim <anikob@spiceworks.com>
` Re: Partitioned table - scans through every partitions
2017-08-25 15:44 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Partitioned table - scans through every partitions
2017-08-25 16:08 UTC Aniko Belim <anikob@spiceworks.com>
[3+ messages in thread]
Execution plan analysis
2017-08-25 08:31 UTC Neto pr <netopr9@gmail.com>
` Re: Execution plan analysis
2017-08-25 13:06 UTC Neto pr <netopr9@gmail.com>
` Re: Execution plan analysis
2017-08-25 15:33 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[3+ messages in thread]
Hi!
2004-06-20 16:39 UTC Janio Rosa da Silva <janio_2003@yahoo.com.br>
` Re: Hi!
2004-06-22 16:23 UTC Josh Berkus <josh@agliodbs.com>
` Hi
2017-04-13 06:25 UTC Daulat Ram <Daulat.Ram@cyient.com>
` Re: Hi
2017-04-13 08:21 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Hi
2017-08-25 06:49 UTC Daulat Ram <Daulat.Ram@cyient.com>
` Re: Hi
2017-08-25 14:42 UTC David G. Johnston <david.g.johnston@gmail.com>
[6+ messages in thread]
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox