pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSv: Re: Sv: Sv: Re: Latest advice on SSD?
2018-05-11 14:00 UTC Andreas Joseph Krogh <andreas@visena.com>
` Sv: Re: Sv: Sv: Re: Latest advice on SSD?
2018-05-11 14:17 UTC Andreas Joseph Krogh <andreas@visena.com>
[2+ messages in thread]
Sv: Sv: Re: Latest advice on SSD?
2018-05-11 11:23 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Sv: Sv: Re: Latest advice on SSD?
2018-05-11 12:11 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[2+ messages in thread]
Sv: Re: Latest advice on SSD?
2018-05-09 20:00 UTC Andreas Joseph Krogh <andreas@visena.com>
Time bucketing query performance
2018-05-07 23:33 UTC Julian Wilson <julianwlsn@gmail.com>
` Re: Time bucketing query performance
2018-05-08 01:08 UTC Justin Pryzby <pryzby@telsasoft.com>
[2+ messages in thread]
help in analysis of execution plans
2018-05-05 15:16 UTC Neto pr <netopr9@gmail.com>
` Re: help in analysis of execution plans
2018-05-05 18:07 UTC Neto pr <netopr9@gmail.com>
` Re: help in analysis of execution plans
2018-05-06 00:33 UTC David Rowley <david.rowley@2ndquadrant.com>
[3+ messages in thread]
Why doesn't the second query use the index for sorting?
2018-04-30 19:43 UTC Alf Lervåg <alf@lervag.net>
Performance issues while running select sql query
2018-04-29 04:35 UTC Kaushal Shriyan <kaushalshriyan@gmail.com>
` Re: Performance issues while running select sql query
2018-04-29 04:40 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Performance issues while running select sql query
2018-04-29 05:03 UTC Kaushal Shriyan <kaushalshriyan@gmail.com>
` Re: Performance issues while running select sql query
2018-04-29 05:18 UTC Kaushal Shriyan <kaushalshriyan@gmail.com>
` Performance issues while running select sql query
2018-04-29 06:10 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Performance issues while running select sql query
2018-04-29 14:18 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Performance issues while running select sql query
2018-04-29 18:10 UTC Kaushal Shriyan <kaushalshriyan@gmail.com>
[7+ messages in thread]
pg_upgrade help
2018-04-18 07:30 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-18 07:35 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: pg_upgrade help
2018-04-18 08:34 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-18 08:39 UTC Sergei Kornilov <sk@zsrv.org>
` Re: pg_upgrade help
2018-04-18 09:05 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: pg_upgrade help
2018-04-18 12:02 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-18 12:47 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: pg_upgrade help
2018-04-18 14:02 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: pg_upgrade help
2018-04-19 00:12 UTC Rajni Baliyan <saan654@gmail.com>
` Re: pg_upgrade help
2018-04-19 07:37 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-19 10:14 UTC Fabio Pardi <f.pardi@portavita.eu>
` Re: pg_upgrade help
2018-04-19 12:56 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-20 09:24 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: pg_upgrade help
2018-04-20 09:48 UTC Fabio Pardi <f.pardi@portavita.eu>
[14+ messages in thread]
SeqScan vs. IndexScan
2018-04-18 22:14 UTC Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: SeqScan vs. IndexScan
2018-04-18 22:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Data migration from postgres 8.4 to 9.4
2018-04-16 07:03 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: Data migration from postgres 8.4 to 9.4
2018-04-16 07:11 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Data migration from postgres 8.4 to 9.4
2018-04-16 08:09 UTC Gunnar "Nick" Bluth <gunnar.bluth.extern@elster.de>
` RE: Data migration from postgres 8.4 to 9.4
2018-04-17 12:24 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` RE: Data migration from postgres 8.4 to 9.4
2018-04-18 08:06 UTC Ahmed, Nawaz <Nawaz@fast.au.fujitsu.com>
[5+ messages in thread]
Installing PostgreSQL 9.5 in centos 6 using YUM
2018-04-17 09:25 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` RE: Installing PostgreSQL 9.5 in centos 6 using YUM
2018-04-18 07:47 UTC Ahmed, Nawaz <Nawaz@fast.au.fujitsu.com>
[2+ messages in thread]
citext performance
2018-04-06 16:51 UTC Deepak Somaiya <deepsom@yahoo.com>
` Re: citext performance
2018-04-08 10:12 UTC Nandakumar M <m.nanda92@gmail.com>
` Re: citext performance
2018-04-08 20:14 UTC Deepak Somaiya <deepsom@yahoo.com>
` Citext Performance
2018-04-17 21:05 UTC Deepak Somaiya <deepsom@yahoo.com>
[4+ messages in thread]
Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-16 20:42 UTC Hackety Man <hacketyman@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 05:17 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 10:49 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 10:52 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 14:01 UTC Hackety Man <hacketyman@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 14:05 UTC Hackety Man <hacketyman@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 14:23 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 15:43 UTC Hackety Man <hacketyman@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 16:13 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 16:41 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 20:29 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Unexplainable execution time difference between two test functions...one using IF (SELECT COUNT(*) FROM...) and the other using IF EXISTS (SELECT 1 FROM...)
2018-04-17 20:30 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[12+ messages in thread]
Table order at FROM clause affects performance?
2018-04-12 14:35 UTC Eduard Català <eduard.catala@gmail.com>
` Re: Table order at FROM clause affects performance?
2018-04-12 15:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Table order at FROM clause affects performance?
2018-04-12 16:25 UTC Eduard Català <eduard.catala@gmail.com>
[3+ messages in thread]
FW:
2007-05-09 01:13 UTC Orhan Aglagul <oaglagul@cittio.com>
` Sv: Latest advice on SSD?
2018-04-10 07:21 UTC Andreas Joseph Krogh <andreas@visena.com>
[2+ messages in thread]
functions: VOLATILE performs better than STABLE
2018-03-24 01:27 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: functions: VOLATILE performs better than STABLE
2018-03-25 05:00 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: functions: VOLATILE performs better than STABLE
2018-03-25 12:24 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: functions: VOLATILE performs better than STABLE
2018-04-05 14:18 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
Slow query on partitioned table.
2018-03-27 14:14 UTC Glenn Pierce <glennpierce@gmail.com>
` Re: Slow query on partitioned table.
2018-03-27 14:43 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Slow query on partitioned table.
2018-03-27 21:00 UTC Justin Pryzby <pryzby@telsasoft.com>
[3+ messages in thread]
Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 10:03 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 11:39 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 11:41 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 14:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 14:30 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 14:30 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 17:36 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-25 05:12 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-26 10:36 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-26 17:13 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[10+ messages in thread]
Slow planning time for custom function
2018-03-23 20:28 UTC bk@e8s.de
` Re: Slow planning time for custom function
2018-03-24 01:35 UTC Andres Freund <andres@anarazel.de>
` Re: Slow planning time for custom function
2018-03-24 01:52 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Slow planning time for custom function
2018-03-25 18:18 UTC bk@e8s.de
[4+ messages in thread]
DB corruption
2018-03-23 07:59 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: DB corruption
2018-03-23 08:04 UTC Michael Paquier <michael@paquier.xyz>
` Re: DB corruption
2018-03-23 15:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
badly scaling performance with appending to bytea
2018-03-21 12:03 UTC Gary Cowell <gary.cowell@gmail.com>
` Re: badly scaling performance with appending to bytea
2018-03-21 12:12 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: badly scaling performance with appending to bytea
2018-03-21 12:56 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: badly scaling performance with appending to bytea
2018-03-21 12:59 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: badly scaling performance with appending to bytea
2018-03-21 13:04 UTC Gary Cowell <gary.cowell@gmail.com>
` Re: badly scaling performance with appending to bytea
2018-03-21 13:09 UTC Pavel Stehule <pavel.stehule@gmail.com>
[6+ messages in thread]
PG 9.6 Slow inserts with long-lasting LWLocks
2018-01-22 18:43 UTC Pavel Suderevsky <psuderevsky@gmail.com>
` RE: PG 9.6 Slow inserts with long-lasting LWLocks
2018-03-15 10:29 UTC Pavel Suderevsky <psuderevsky@gmail.com>
` Re: PG 9.6 Slow inserts with long-lasting LWLocks
2018-03-16 13:42 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` RE: PG 9.6 Slow inserts with long-lasting LWLocks
2018-03-19 17:26 UTC Pavel Suderevsky <psuderevsky@gmail.com>
[4+ messages in thread]
Slow performance after restoring a dump
2018-03-19 15:13 UTC David Osborne <david@qcode.co.uk>
` Re: Slow performance after restoring a dump
2018-03-19 15:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow performance after restoring a dump
2018-03-19 15:43 UTC David Osborne <david@qcode.co.uk>
` Re: Slow performance after restoring a dump
2018-03-19 16:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow performance after restoring a dump
2018-03-19 16:33 UTC David Osborne <david@qcode.co.uk>
[5+ messages in thread]
Irrelevant columns cause massive performance change
2018-03-16 20:37 UTC Craig James <cjames@emolecules.com>
` Re: Irrelevant columns cause massive performance change
2018-03-16 20:50 UTC Andres Freund <andres@anarazel.de>
` Re: Irrelevant columns cause massive performance change
2018-03-16 21:06 UTC Craig James <cjames@emolecules.com>
[3+ messages in thread]
Too many .history file in pg_xlog takes lots of space
2018-03-14 02:31 UTC 彭昱傑 <k872892@gmail.com>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-14 05:56 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-14 06:12 UTC 彭昱傑 <k872892@gmail.com>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-14 07:04 UTC Michael Paquier <michael@paquier.xyz>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-14 13:49 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-14 15:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-15 10:22 UTC 彭昱傑 <k872892@gmail.com>
[7+ 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