pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Sv: 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