pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedProposal for unlogged tables
2016-01-04 09:59 UTC Mark Zealey <mark@allaroundtheworld.fr>
` Re: Proposal for unlogged tables
2016-01-04 14:27 UTC Yves Dorfsman <yves@zioup.com>
` Re: Proposal for unlogged tables
2016-01-04 14:38 UTC Mark Zealey <mark@allaroundtheworld.fr>
` Re: Proposal for unlogged tables
2016-01-04 16:12 UTC Andres Freund <andres@anarazel.de>
` Re: Proposal for unlogged tables
2016-01-04 17:12 UTC Mark Zealey <mark@allaroundtheworld.fr>
` Re: Proposal for unlogged tables
2016-01-04 17:16 UTC Andres Freund <andres@anarazel.de>
[6+ messages in thread]
Plan differences
2015-12-31 10:12 UTC Anton Melser <melser.anton@gmail.com>
` Re: Plan differences
2015-12-31 10:44 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Plan differences
2015-12-31 14:49 UTC Anton Melser <melser.anton@gmail.com>
` Re: Plan differences
2015-12-31 15:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Plan differences
2015-12-31 16:29 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Plan differences
2015-12-31 17:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Plan differences
2015-12-31 20:10 UTC Anton Melser <melser.anton@gmail.com>
` Re: Plan differences
2016-01-01 17:13 UTC Anton Melser <melser.anton@gmail.com>
` Re: Plan differences
2016-01-04 09:04 UTC Adam Pearson <Adam.Pearson@4finance.com>
` Re: Plan differences
2016-01-04 13:30 UTC Anton Melser <melser.anton@gmail.com>
[10+ messages in thread]
Connections "Startup"
2015-12-22 07:59 UTC Artem Tomyuk <admin@leboutique.com>
` Re: Connections "Startup"
2015-12-22 08:09 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Connections "Startup"
2015-12-22 11:36 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Connections "Startup"
2015-12-23 02:32 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: [PERFORM] Connections "Startup"
2015-12-23 03:52 UTC Om Prakash Jaiswal <op12om@yahoo.co.in>
` Re: [ADMIN] Connections "Startup"
2015-12-23 04:50 UTC Pavel Stehule <pavel.stehule@gmail.com>
[6+ messages in thread]
Can't explain db size
2015-12-15 09:52 UTC Matteo Grolla <matteo.grolla@gmail.com>
` Re: Can't explain db size
2015-12-15 10:07 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Can't explain db size
2015-12-15 11:11 UTC Matteo Grolla <matteo.grolla@gmail.com>
` Re: Can't explain db size
2015-12-17 15:12 UTC Matteo Grolla <matteo.grolla@gmail.com>
` Re: Can't explain db size
2015-12-17 17:03 UTC Matteo Grolla <matteo.grolla@gmail.com>
` Re: Can't explain db size
2015-12-20 23:08 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[6+ messages in thread]
Estimation row error
2015-12-11 08:53 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-11 11:35 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-15 08:05 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-15 09:25 UTC Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>
` Re: Estimation row error
2015-12-15 09:49 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Estimation row error
2015-12-15 10:21 UTC Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>
` Re: Estimation row error
2015-12-17 09:10 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-17 09:14 UTC Matteo Grolla <matteo.grolla@gmail.com>
` Re: Estimation row error
2015-12-17 10:37 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-17 10:58 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-18 15:21 UTC Mathieu VINCENT <mathieu.vincent@pmsipilot.com>
` Re: Estimation row error
2015-12-18 15:33 UTC Pavel Stehule <pavel.stehule@gmail.com>
[12+ messages in thread]
Selectivity for lopsided foreign key columns
2015-12-17 10:11 UTC Mikkel Lauritsen <renard@tala.dk>
` Re: Selectivity for lopsided foreign key columns
2015-12-17 15:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Selectivity for lopsided foreign key columns
2015-12-17 19:14 UTC Mikkel Lauritsen <renard@tala.dk>
[3+ messages in thread]
Terrible plan choice for view with distinct on clause
2015-12-17 15:44 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Terrible plan choice for view with distinct on clause
2015-12-17 17:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Terrible plan choice for view with distinct on clause
2015-12-17 18:08 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Terrible plan choice for view with distinct on clause
2015-12-17 18:51 UTC Adam Brusselback <adambrusselback@gmail.com>
[4+ messages in thread]
Performance difference between Slon master and slave
2015-12-14 17:16 UTC Matthew Lunnon <mlunnon@rwa-net.co.uk>
` Re: Performance difference between Slon master and slave
2015-12-14 17:49 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Performance difference between Slon master and slave
2015-12-14 21:43 UTC Mattthew Lunnon <mlunnon@rwa-net.co.uk>
[3+ messages in thread]
Getting an optimal plan on the first execution of a pl/pgsql function
2015-12-14 18:53 UTC Pedro França <pedro.franca@golsat.com.br>
` Re: Getting an optimal plan on the first execution of a pl/pgsql function
2015-12-14 19:21 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Getting an optimal plan on the first execution of a pl/pgsql function
2015-12-14 20:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Getting an optimal plan on the first execution of a pl/pgsql function
2015-12-14 20:50 UTC Pedro França <pedro.franca@golsat.com.br>
[4+ messages in thread]
Advise needed for a join query with a where conditional
2015-12-11 04:38 UTC ankur_adwyze <ankur@adwyze.com>
` Re: Advise needed for a join query with a where conditional
2015-12-11 05:04 UTC ankur_adwyze <ankur@adwyze.com>
` Re: Advise needed for a join query with a where conditional
2015-12-11 23:50 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Advise needed for a join query with a where conditional
2015-12-12 16:58 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
partitioned table set and indexes
2015-12-11 19:01 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioned table set and indexes
2015-12-11 19:44 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: partitioned table set and indexes
2015-12-11 20:40 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioned table set and indexes
2015-12-11 21:27 UTC Kevin Grittner <kgrittn@gmail.com>
` Re: partitioned table set and indexes
2015-12-11 21:44 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: partitioned table set and indexes
2015-12-11 22:09 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioned table set and indexes
2015-12-12 00:20 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: partitioned table set and indexes
2015-12-12 00:55 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioned table set and indexes
2015-12-12 03:13 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[9+ messages in thread]
checkpoints, proper config
2015-12-10 09:12 UTC Tory M Blue <tmblue@gmail.com>
` Re: checkpoints, proper config
2015-12-10 17:20 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: checkpoints, proper config
2015-12-10 18:35 UTC Tory M Blue <tmblue@gmail.com>
` Re: checkpoints, proper config
2015-12-10 20:00 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: checkpoints, proper config
2015-12-10 20:58 UTC Tory M Blue <tmblue@gmail.com>
` Re: checkpoints, proper config
2015-12-10 21:14 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: checkpoints, proper config
2015-12-10 22:40 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: checkpoints, proper config
2015-12-10 22:45 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: checkpoints, proper config
2015-12-11 01:20 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: checkpoints, proper config
2015-12-11 23:45 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: checkpoints, proper config
2015-12-11 23:47 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[11+ messages in thread]
postgresql upgrade from 9.3 to 9.4 error
2015-12-10 20:35 UTC Sheena, Prabhjot <Prabhjot.Singh@classmates.com>
Slow Index Creation, why is it not consuming more memory.
2015-12-08 06:36 UTC Tory M Blue <tmblue@gmail.com>
` Re: Slow Index Creation, why is it not consuming more memory.
2015-12-08 06:40 UTC Peter Geoghegan <peter.geoghegan86@gmail.com>
[2+ messages in thread]
ossp-uuid: Performance considerations for different UUID approaches?
2015-12-04 19:34 UTC Brendan McCollam <bmccollam@uchicago.edu>
Index scan cost calculation
2015-11-26 16:11 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Index scan cost calculation
2015-11-26 16:34 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Index scan cost calculation
2015-11-26 16:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index scan cost calculation
2015-11-26 17:50 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Index scan cost calculation
2015-11-26 18:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index scan cost calculation
2015-11-28 19:25 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index scan cost calculation
2015-11-30 14:03 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Index scan cost calculation
2015-11-30 23:03 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index scan cost calculation
2015-12-01 11:22 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Index scan cost calculation
2015-12-02 22:32 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Index scan cost calculation
2015-12-03 13:06 UTC Glyn Astill <glynastill@yahoo.co.uk>
[11+ messages in thread]
Query that took a lot of time in Postgresql when not using trim in order by
2015-11-25 14:15 UTC Blas Pico <toni.pico@gmail.com>
` Re: Query that took a lot of time in Postgresql when not using trim in order by
2015-11-25 16:22 UTC Alex Ignatov <a.ignatov@postgrespro.ru>
` Re: Query that took a lot of time in Postgresql when not using trim in order by
2015-11-25 16:35 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Query that took a lot of time in Postgresql when not using trim in order by
2015-11-25 18:01 UTC Blas Pico <toni.pico@gmail.com>
` Re: Query that took a lot of time in Postgresql when not using trim in order by
2015-11-29 13:23 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Query that took a lot of time in Postgresql when not using trim in order by
2015-11-29 17:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
No index only scan on md5 index
2015-11-26 00:25 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: No index only scan on md5 index
2015-11-26 00:55 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: No index only scan on md5 index
2015-11-26 01:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: No index only scan on md5 index
2015-11-26 01:06 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: No index only scan on md5 index
2015-11-26 01:16 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: No index only scan on md5 index
2015-11-26 08:20 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[6+ messages in thread]
Why is now()::date so much faster than current_date
2015-11-17 08:49 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Why is now()::date so much faster than current_date
2015-11-17 11:03 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Why is now()::date so much faster than current_date
2015-11-17 15:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Recursive query performance issue
2015-10-20 17:34 UTC Jamie Koceniak <jkoceniak@mediamath.com>
` Re: Recursive query performance issue
2015-10-21 07:03 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Recursive query performance issue
2015-10-21 13:22 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Recursive query performance issue
2015-10-21 17:55 UTC Jamie Koceniak <jkoceniak@mediamath.com>
` Re: Recursive query performance issue
2015-10-21 18:23 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Recursive query performance issue
2015-10-21 18:40 UTC Jamie Koceniak <jkoceniak@mediamath.com>
` Re: Recursive query performance issue
2015-10-21 18:51 UTC Jamie Koceniak <jkoceniak@mediamath.com>
` Re: Recursive query performance issue
2015-10-21 19:25 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Recursive query performance issue
2015-10-21 19:32 UTC Jamie Koceniak <jkoceniak@mediamath.com>
` Re: Recursive query performance issue
2015-10-21 19:45 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Recursive query performance issue
2015-10-21 19:49 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Recursive query performance issue
2015-10-22 14:48 UTC vincent elschot <vinny@xs4all.nl>
` Re: Recursive query performance issue
2015-10-23 17:45 UTC Jamie Koceniak <jkoceniak@mediamath.com>
` Re: Recursive query performance issue
2015-10-23 18:00 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Recursive query performance issue
2015-10-26 15:03 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Recursive query performance issue
2015-11-14 06:58 UTC Jamie Koceniak <jkoceniak@mediamath.com>
` Re: Recursive query performance issue
2015-11-16 14:19 UTC Merlin Moncure <mmoncure@gmail.com>
[17+ messages in thread]
Hanging query on a fresh restart
2015-11-10 21:42 UTC Jason Jho <jasonjho@gmail.com>
` Re: Hanging query on a fresh restart
2015-11-13 21:40 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Hanging query on a fresh restart
2015-11-14 16:07 UTC Kevin Grittner <kgrittn@ymail.com>
[3+ messages in thread]
Simple delete query is taking too long (never ends)
2015-11-11 19:09 UTC Massalin Yerzhan <yerzhik@gmail.com>
` Re: Simple delete query is taking too long (never ends)
2015-11-11 19:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Simple delete query is taking too long (never ends)
2015-11-12 15:12 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Simple delete query is taking too long (never ends)
2015-11-12 15:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Simple delete query is taking too long (never ends)
2015-11-12 15:48 UTC Craig James <cjames@emolecules.com>
` Re: Simple delete query is taking too long (never ends)
2015-11-12 22:07 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Simple delete query is taking too long (never ends)
2015-11-12 22:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Simple delete query is taking too long (never ends)
2015-11-13 14:15 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Simple delete query is taking too long (never ends)
2015-11-13 15:51 UTC Scott Marlowe <scott.marlowe@gmail.com>
[9+ messages in thread]
Slow 3 Table Join with v bad row estimate
2015-11-10 12:13 UTC David Osborne <david@qcode.co.uk>
` Re: Slow 3 Table Join with v bad row estimate
2015-11-10 15:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow 3 Table Join with v bad row estimate
2015-11-10 16:38 UTC David Osborne <david@qcode.co.uk>
` Re: Slow 3 Table Join with v bad row estimate
2015-11-10 17:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow 3 Table Join with v bad row estimate
2015-11-10 17:31 UTC David Osborne <david@qcode.co.uk>
` Re: Slow 3 Table Join with v bad row estimate
2015-11-10 18:38 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Slow 3 Table Join with v bad row estimate
2015-11-11 10:04 UTC David Osborne <david@qcode.co.uk>
[7+ messages in thread]
querying jsonb for arrays inside a hash
2015-11-07 23:31 UTC Joe Van Dyk <joe@tanga.com>
` Re: querying jsonb for arrays inside a hash
2015-11-08 00:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: querying jsonb for arrays inside a hash
2015-11-09 17:13 UTC Joe Van Dyk <joe@tanga.com>
[3+ messages in thread]
HASH
2015-11-05 09:11 UTC Artem Tomyuk <admin@leboutique.com>
` Re: HASH
2015-11-05 11:24 UTC Jeff Janes <jeff.janes@gmail.com>
[2+ 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