pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAdding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-29 21:27 UTC Ben Hoyt <benhoyt@gmail.com>
` Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-30 00:18 UTC David Johnston <polobo@yahoo.com>
` Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-30 00:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-30 18:20 UTC Josh Berkus <josh@agliodbs.com>
` Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-31 08:01 UTC Ben Hoyt <benhoyt@gmail.com>
` Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-31 14:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-31 23:32 UTC Ben Hoyt <benhoyt@gmail.com>
[7+ messages in thread]
Update Trigger latency utilizing the IS DISTINCT FROM syntax
2013-10-31 22:27 UTC fburgess@radiantblue.com
Problems with hash join over nested loop
2013-10-28 21:58 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-28 23:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problems with hash join over nested loop
2013-10-28 23:53 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-29 14:10 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Problems with hash join over nested loop
2013-10-29 16:21 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-29 16:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problems with hash join over nested loop
2013-10-29 16:52 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-29 18:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problems with hash join over nested loop
2013-10-29 20:08 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-29 20:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problems with hash join over nested loop
2013-10-30 22:27 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-30 22:32 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-30 23:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
[13+ messages in thread]
Re: postgres connections
2013-10-30 14:16 UTC si24 <smrcoutts24@gmail.com>
Logic of lowering seq_page_cost for SSD?
2013-10-22 18:56 UTC Josh Berkus <josh@agliodbs.com>
BASH script for collecting analyze-related info
2013-09-29 09:09 UTC Ken Tanzer <ken.tanzer@gmail.com>
` Re: BASH script for collecting analyze-related info
2013-09-29 16:57 UTC Craig James <cjames@emolecules.com>
` Re: BASH script for collecting analyze-related info
2013-09-29 21:24 UTC Ken Tanzer <ken.tanzer@gmail.com>
` Re: BASH script for collecting analyze-related info
2013-09-29 23:59 UTC Craig James <cjames@emolecules.com>
` Re: BASH script for collecting analyze-related info
2013-09-30 07:05 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: BASH script for collecting analyze-related info
2013-10-01 02:40 UTC Ken Tanzer <ken.tanzer@gmail.com>
` Re: BASH script for collecting analyze-related info
2013-10-16 07:20 UTC Ken Tanzer <ken.tanzer@gmail.com>
` Re: BASH script for collecting analyze-related info
2013-10-17 04:50 UTC Ken Tanzer <ken.tanzer@gmail.com>
[8+ messages in thread]
Planner Conceptual Error when Joining a Subquery -- Outer Query Condition not Pulled Into Subquery
2013-10-16 06:33 UTC Gavin Wahl <gavinwahl@gmail.com>
` Re: Planner Conceptual Error when Joining a Subquery -- Outer Query Condition not Pulled Into Subquery
2013-10-16 08:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner Conceptual Error when Joining a Subquery -- Outer Query Condition not Pulled Into Subquery
2013-10-17 02:45 UTC Gavin Wahl <gavinwahl@gmail.com>
[3+ messages in thread]
limit connections pgpool
2013-10-10 15:00 UTC Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
` Re: limit connections pgpool
2013-10-11 03:10 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: limit connections pgpool
2013-10-11 03:38 UTC Tatsuo Ishii <ishii@postgresql.org>
[3+ messages in thread]
postgreSQL query via JDBC in different OS taking different running time?
2013-10-08 01:48 UTC Aftab Ahmed Chandio <aftabac@siat.ac.cn>
` Re: postgreSQL query via JDBC in different OS taking different running time?
2013-10-08 03:35 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: postgreSQL query via JDBC in different OS taking different running time?
2013-10-08 03:37 UTC John R Pierce <pierce@hogranch.com>
` Re: postgreSQL query via JDBC in different OS taking different running time?
2013-10-08 03:44 UTC David Johnston <polobo@yahoo.com>
` Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time?
2013-10-08 11:02 UTC Luca Ferrari <fluca1978@infinito.it>
` Re: postgreSQL query via JDBC in different OS taking different running time?
2013-10-10 21:44 UTC Merlin Moncure <mmoncure@gmail.com>
[6+ messages in thread]
Is there a Maximum number of partitions in which constraint_exclusion works?
2013-10-08 15:31 UTC Marcelo Vega <mavegaf@gmail.com>
Help on ṕerformance
2013-09-30 15:03 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Fwd: Help on ṕerformance
2013-09-30 15:12 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 15:33 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 15:36 UTC Hellmuth Vargas <hivs77@gmail.com>
` Re: Fwd: Help on ṕerformance
2013-09-30 16:12 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 16:16 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 16:25 UTC Gilberto Castillo <gilberto.castillo@etecsa.cu>
` Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 16:31 UTC Rodriguez Fernando <rodriguez@ort.edu.uy>
` Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 16:35 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Re: [GENERAL] Help on ṕerformance
2013-10-02 13:57 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: [GENERAL] Help on ṕerformance
2013-10-02 16:22 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Re: [GENERAL] Re: [GENERAL] Help on ṕerformance
2013-10-04 08:46 UTC Rémi Cura <remi.cura@gmail.com>
[12+ messages in thread]
57 minute SELECT
2013-10-03 00:56 UTC Samuel Stearns <sstearns@staff.iinet.net.au>
` Re: 57 minute SELECT
2013-10-03 01:03 UTC Samuel Stearns <sstearns@staff.iinet.net.au>
` Re: 57 minute SELECT
2013-10-03 01:17 UTC David Johnston <polobo@yahoo.com>
` Re: 57 minute SELECT
2013-10-03 01:17 UTC Samuel Stearns <sstearns@staff.iinet.net.au>
` Re: 57 minute SELECT
2013-10-03 01:30 UTC Samuel Stearns <sstearns@staff.iinet.net.au>
` Re: 57 minute SELECT
2013-10-03 01:35 UTC Samuel Stearns <sstearns@staff.iinet.net.au>
` Re: 57 minute SELECT
2013-10-03 01:45 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: 57 minute SELECT
2013-10-03 01:47 UTC Samuel Stearns <sstearns@staff.iinet.net.au>
` Re: 57 minute SELECT
2013-10-03 01:48 UTC David Johnston <polobo@yahoo.com>
` Re: 57 minute SELECT
2013-10-03 02:04 UTC Samuel Stearns <sstearns@staff.iinet.net.au>
` Re: 57 minute SELECT
2013-10-03 04:13 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: 57 minute SELECT
2013-10-03 04:19 UTC Samuel Stearns <sstearns@staff.iinet.net.au>
` Re: 57 minute SELECT
2013-10-03 10:08 UTC Ivan Voras <ivoras@freebsd.org>
` Re: 57 minute SELECT
2013-10-03 12:59 UTC ktm@rice.edu <ktm@rice.edu>
` Re: 57 minute SELECT
2013-10-03 16:20 UTC David Kerr <dmk@mr-paradox.net>
` Re: 57 minute SELECT
2013-10-03 16:25 UTC David Kerr <dmk@mr-paradox.net>
` Re: 57 minute SELECT
2013-10-03 22:49 UTC Samuel Stearns <sstearns@staff.iinet.net.au>
` Re: 57 minute SELECT
2013-10-03 23:05 UTC Samuel Stearns <sstearns@staff.iinet.net.au>
[18+ messages in thread]
pg_statio_all_tables columns
2013-09-30 12:45 UTC Xenofon Papadopoulos <xpapad@gmail.com>
` Re: pg_statio_all_tables columns
2013-09-30 14:40 UTC Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>
` Re: pg_statio_all_tables columns
2013-09-30 14:41 UTC Xenofon Papadopoulos <xpapad@gmail.com>
` Re: pg_statio_all_tables columns
2013-09-30 16:30 UTC Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>
` Re: pg_statio_all_tables columns
2013-09-30 17:44 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: pg_statio_all_tables columns
2013-09-30 17:50 UTC Xenofon Papadopoulos <xpapad@gmail.com>
[6+ messages in thread]
Slow plan for MAX/MIN or LIMIT 1?
2013-09-24 09:24 UTC Sam Wong <sam@hellosam.net>
` Re: Slow plan for MAX/MIN or LIMIT 1?
2013-09-24 21:49 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Slow plan for MAX/MIN or LIMIT 1?
2013-09-24 21:56 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Slow plan for MAX/MIN or LIMIT 1?
2013-09-25 12:23 UTC Sam Wong <sam@hellosam.net>
` Re: Slow plan for MAX/MIN or LIMIT 1?
2013-09-25 13:29 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Slow plan for MAX/MIN or LIMIT 1?
2013-09-25 15:20 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Slow plan for MAX/MIN or LIMIT 1?
2013-09-25 15:54 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Slow plan for MAX/MIN or LIMIT 1?
2013-09-25 16:33 UTC Sam Wong <sam@hellosam.net>
` Re: Slow plan for MAX/MIN or LIMIT 1?
2013-09-25 16:42 UTC Sam Wong <sam@hellosam.net>
` Re: Slow plan for MAX/MIN or LIMIT 1?
2013-09-25 17:05 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Slow plan for MAX/MIN or LIMIT 1?
2013-09-30 06:11 UTC didier <did447@gmail.com>
[11+ messages in thread]
Troubleshooting query performance issues
2013-09-25 15:58 UTC Jim Garrison <jim.garrison@nwea.org>
` Re: Troubleshooting query performance issues
2013-09-25 16:30 UTC bricklen <bricklen@gmail.com>
` Re: Troubleshooting query performance issues - Resolved (sort of)
2013-09-27 16:04 UTC Jim Garrison <jim.garrison@nwea.org>
` Re: Troubleshooting query performance issues - resolved (sort of)
2013-09-27 19:57 UTC Jim Garrison <jim.garrison@nwea.org>
[4+ messages in thread]
Cpu usage 100% on slave. s_lock problem.
2013-08-27 07:57 UTC Дмитрий Дегтярёв <degtyaryov@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-08-27 13:23 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-08-27 13:38 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-08-27 14:12 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-08-27 14:57 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-08-27 15:55 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-08-27 17:17 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-17 11:55 UTC Дмитрий Дегтярёв <degtyaryov@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-17 11:59 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-17 13:18 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-17 13:24 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-17 13:32 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-17 13:35 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-17 13:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-17 13:43 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-26 23:08 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-27 03:14 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Cpu usage 100% on slave. s_lock problem.
2013-09-27 12:56 UTC Merlin Moncure <mmoncure@gmail.com>
[18+ messages in thread]
Why is n_distinct always -1 for range types?
2013-09-19 20:47 UTC Josh Berkus <josh@agliodbs.com>
` Re: Why is n_distinct always -1 for range types?
2013-09-25 17:29 UTC Josh Berkus <josh@agliodbs.com>
` Re: Why is n_distinct always -1 for range types?
2013-09-25 17:53 UTC Peter Geoghegan <peter.geoghegan86@gmail.com>
[3+ messages in thread]
earthdistance query performance
2013-09-25 15:05 UTC AI Rumman <rummandba@gmail.com>
` Re: earthdistance query performance
2013-09-25 16:25 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
Bringing up new slaves faster
2013-09-24 18:52 UTC François Deliège <fdeliege@gmail.com>
Intermittent hangs with 9.2
2013-09-10 15:04 UTC David Whittaker <dave@iradix.com>
` Re: Intermittent hangs with 9.2
2013-09-10 15:26 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Intermittent hangs with 9.2
2013-09-10 15:33 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Intermittent hangs with 9.2
2013-09-10 17:44 UTC Jeff Janes <jeff.janes@gmail.com>
` Intermittent hangs with 9.2
2013-09-10 18:04 UTC David Whittaker <dave@iradix.com>
` Intermittent hangs with 9.2
2013-09-10 18:05 UTC David Whittaker <dave@iradix.com>
` Intermittent hangs with 9.2
2013-09-10 18:06 UTC David Whittaker <dave@iradix.com>
` Re: Intermittent hangs with 9.2
2013-09-11 07:26 UTC Torsten Förtsch <torsten.foertsch@gmx.net>
` Re: Intermittent hangs with 9.2
2013-09-11 08:36 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: Intermittent hangs with 9.2
2013-09-11 12:43 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Intermittent hangs with 9.2
2013-09-11 17:17 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Intermittent hangs with 9.2
2013-09-11 18:26 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Intermittent hangs with 9.2
2013-09-12 20:06 UTC David Whittaker <dave@iradix.com>
` Re: Intermittent hangs with 9.2
2013-09-13 14:52 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Intermittent hangs with 9.2
2013-09-13 15:05 UTC David Whittaker <dave@iradix.com>
` Re: Intermittent hangs with 9.2
2013-09-20 18:11 UTC David Whittaker <dave@iradix.com>
[16+ messages in thread]
View with and without ::text casting performs differently.
2013-09-05 22:45 UTC Brian Fehrle <brianf@consistentstate.com>
` Re: View with and without ::text casting performs differently.
2013-09-05 22:46 UTC Brian Fehrle <brianf@consistentstate.com>
` Re: View with and without ::text casting performs differently.
2013-09-05 23:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: View with and without ::text casting performs differently.
2013-09-06 16:42 UTC Brian Fehrle <brianf@consistentstate.com>
` Re: View with and without ::text casting performs differently.
2013-09-06 18:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: View with and without ::text casting performs differently.
2013-09-06 19:46 UTC Mark Mayo <djmornyc@gmail.com>
` Re: View with and without ::text casting performs differently.
2013-09-06 19:49 UTC Mark Mayo <djmornyc@gmail.com>
` Re: View with and without ::text casting performs differently.
2013-09-18 18:50 UTC Brian Fehrle <brianf@consistentstate.com>
[8+ messages in thread]
autovacuum and dead tuples
2013-09-18 15:42 UTC fburgess@radiantblue.com
` Re: autovacuum and dead tuples
2013-09-18 16:27 UTC Shaun Thomas <sthomas@optionshouse.com>
[2+ messages in thread]
function execute on v.9.2 slow down
2013-08-12 12:21 UTC Александр Белинский <avinfo79@gmail.com>
` Re: function execute on v.9.2 slow down
2013-09-16 23:40 UTC Robert Haas <robertmhaas@gmail.com>
` Re: function execute on v.9.2 slow down
2013-09-18 11:24 UTC Александр Белинский <avinfo79@gmail.com>
[3+ messages in thread]
stable and immutable functions in GROUP BY clauses.
2013-08-26 11:03 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: stable and immutable functions in GROUP BY clauses.
2013-09-16 19:22 UTC Marc Mamin <M.Mamin@intershop.de>
[2+ messages in thread]
How to optimization database for heavy I/O from updates (software and hardware)
2013-09-16 15:53 UTC Niels Kristian Schjødt <nielskristian@autouncle.com>
[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