pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed57 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>
COPY TO and VACUUM
2013-09-03 16:16 UTC Roberto Grandi <roberto.grandi@trovaprezzi.it>
` Re: COPY TO and VACUUM
2013-09-03 20:34 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: COPY TO and VACUUM
2013-09-04 06:15 UTC Roberto Grandi <roberto.grandi@trovaprezzi.it>
` Re: COPY TO and VACUUM
2013-09-04 08:10 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: COPY TO and VACUUM
2013-09-04 16:29 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: COPY TO and VACUUM
2013-09-05 16:05 UTC Roberto Grandi <roberto.grandi@trovaprezzi.it>
` Re: COPY TO and VACUUM
2013-09-05 16:24 UTC David Kerr <dmk@mr-paradox.net>
` Re: COPY TO and VACUUM
2013-09-05 18:14 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: COPY TO and VACUUM
2013-09-12 06:14 UTC Roberto Grandi <roberto.grandi@trovaprezzi.it>
` Re: COPY TO and VACUUM
2013-09-16 00:18 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: COPY TO and VACUUM
2013-09-16 15:14 UTC Roberto Grandi <roberto.grandi@trovaprezzi.it>
[11+ messages in thread]
Extremely slow server?
2013-09-14 18:28 UTC Craig James <cjames@emolecules.com>
` Re: Extremely slow server?
2013-09-14 18:36 UTC bricklen <bricklen@gmail.com>
` Re: Extremely slow server?
2013-09-15 01:54 UTC Craig James <cjames@emolecules.com>
` Re: Extremely slow server?
2013-09-15 02:06 UTC bricklen <bricklen@gmail.com>
` Re: Extremely slow server?
2013-09-15 07:50 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: Extremely slow server?
2013-09-15 20:55 UTC Jeff Janes <jeff.janes@gmail.com>
[6+ messages in thread]
How clustering for scale out works in PostgreSQL
2013-08-29 12:14 UTC bsreejithin <bsreejithin@gmail.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 14:59 UTC Richard Huxton <dev@archonet.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 15:08 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 16:13 UTC bsreejithin <bsreejithin@gmail.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 16:21 UTC Mike Blackwell <mike.blackwell@rrd.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 16:42 UTC bsreejithin <bsreejithin@gmail.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 16:46 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 16:49 UTC Igor Neyman <ineyman@perceptron.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 16:52 UTC bsreejithin <bsreejithin@gmail.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 16:54 UTC bsreejithin <bsreejithin@gmail.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 17:45 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: How clustering for scale out works in PostgreSQL
2013-08-29 17:48 UTC bsreejithin <bsreejithin@gmail.com>
` Re: How clustering for scale out works in PostgreSQL
2013-08-31 14:44 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: How clustering for scale out works in PostgreSQL
2013-09-02 01:38 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How clustering for scale out works in PostgreSQL
2013-09-02 07:08 UTC Craig Ringer <craig@2ndquadrant.com>
` Re: How clustering for scale out works in PostgreSQL
2013-09-02 07:46 UTC Craig Ringer <craig@2ndquadrant.com>
` Re: How clustering for scale out works in PostgreSQL
2013-09-12 15:18 UTC Jim Nasby <jim@nasby.net>
` Re: How clustering for scale out works in PostgreSQL
2013-09-12 18:46 UTC Kevin Grittner <kgrittn@ymail.com>
[18+ messages in thread]
Optimising views
2013-08-30 02:22 UTC Bastiaan Olij <bastiaan@basenlily.me>
` Re: Optimising views
2013-09-12 15:10 UTC Jim Nasby <jim@nasby.net>
[2+ messages in thread]
Varchar vs foreign key vs enumerator - table and index size
2013-08-31 13:35 UTC Łukasz Walkowski <lukasz.walkowski@homplex.pl>
` Re: Varchar vs foreign key vs enumerator - table and index size
2013-08-31 15:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Varchar vs foreign key vs enumerator - table and index size
2013-08-31 17:06 UTC Łukasz Walkowski <lukasz.walkowski@homplex.pl>
` Re: Varchar vs foreign key vs enumerator - table and index size
2013-09-01 01:31 UTC Craig James <cjames@emolecules.com>
` Re: Varchar vs foreign key vs enumerator - table and index size
2013-09-01 03:10 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Varchar vs foreign key vs enumerator - table and index size
2013-09-02 09:47 UTC Łukasz Walkowski <lukasz.walkowski@homplex.pl>
` Re: Varchar vs foreign key vs enumerator - table and index size
2013-09-02 09:53 UTC Łukasz Walkowski <lukasz.walkowski@homplex.pl>
` Re: Varchar vs foreign key vs enumerator - table and index size
2013-09-02 17:02 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Varchar vs foreign key vs enumerator - table and index size
2013-09-03 19:00 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Varchar vs foreign key vs enumerator - table and index size
2013-09-12 15:07 UTC Jim Nasby <jim@nasby.net>
[10+ messages in thread]
Reasons for choosing one execution plan over another?
2013-09-11 11:16 UTC Mikkel Lauritsen <renard@tala.dk>
` Re: Reasons for choosing one execution plan over another?
2013-09-11 16:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Reasons for choosing one execution plan over another?
2013-09-11 16:55 UTC Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>
` Re: Reasons for choosing one execution plan over another?
2013-09-11 19:23 UTC Mikkel Lauritsen <renard@tala.dk>
` Re: Reasons for choosing one execution plan over another?
2013-09-11 21:07 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Reasons for choosing one execution plan over another?
2013-09-12 13:29 UTC Mikkel Lauritsen <renard@tala.dk>
[6+ messages in thread]
Memory-olic query and Materialize
2013-09-12 10:14 UTC Souquieres Adam <adam.souquieres@axege.com>
slow sort
2013-09-11 10:36 UTC Maximilian Tyrtania <lists@contactking.de>
` Re: slow sort
2013-09-11 13:58 UTC bricklen <bricklen@gmail.com>
` Re: slow sort
2013-09-11 15:24 UTC Maximilian Tyrtania <lists@contactking.de>
` Re: slow sort
2013-09-11 15:31 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: slow sort
2013-09-12 08:00 UTC Maximilian Tyrtania <lists@contactking.de>
[5+ messages in thread]
RESTORE multiple DBs concurrently
2013-09-06 15:52 UTC Roberto Grandi <roberto.grandi@trovaprezzi.it>
` Re: RESTORE multiple DBs concurrently
2013-09-07 09:46 UTC Michael Paquier <michael.paquier@gmail.com>
[2+ messages in thread]
planner and having clausule
2013-09-06 08:05 UTC Ľubomír Varga <varga@plaintext.sk>
` Re: planner and having clausule
2013-09-06 08:44 UTC Ľubomír Varga <varga@plaintext.sk>
[2+ messages in thread]
Question About WAL filename and its time stamp
2013-09-05 13:19 UTC ascot.moss@gmail.com <ascot.moss@gmail.com>
` Re: Question About WAL filename and its time stamp
2013-09-06 02:17 UTC Suzuki Hironobu <hironobu@interdb.jp>
` Re: Question About WAL filename and its time stamp
2013-09-06 05:22 UTC Haribabu kommi <haribabu.kommi@huawei.com>
[3+ 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