pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedFastest way / best practice to calculate "next birthdays"
2008-05-04 12:29 UTC Hannes Dorbath <light@theendofthetunnel.de>
` Re: Fastest way / best practice to calculate "next birthdays"
2008-05-04 16:11 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2008-05-04 17:50 UTC Hannes Dorbath <light@theendofthetunnel.de>
` Re: Fastest way / best practice to calculate "next birthdays"
2008-05-04 19:05 UTC Zoltan Boszormenyi <zb@cybertec.at>
` Re: Fastest way / best practice to calculate "next birthdays"
2008-05-05 05:41 UTC Shane Ambler <pgsql@Sheeky.Biz>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-05-18 09:30 UTC er.tejaspatel88@gmail.com <er.tejaspatel88@gmail.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-05-21 03:22 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-05-21 16:15 UTC Bosco Rama <postgres@boscorama.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-05-21 16:50 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-05-22 21:23 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-06-01 19:11 UTC Kevin Grittner <kgrittn@ymail.com>
[11+ messages in thread]
Slow hash join performance with many batches
2015-06-01 16:03 UTC Alex Adriaanse <alex@oseberg.io>
` Re: Slow hash join performance with many batches
2015-06-01 17:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Postmaster eating up all my cpu
2015-05-28 11:25 UTC birimblongas <bianca.stephani@gmail.com>
` Re: Postmaster eating up all my cpu
2015-05-30 20:45 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[2+ messages in thread]
Partitioning and performance
2015-05-28 14:31 UTC Ravi Krishna <sravikrishna3@gmail.com>
` Re: Partitioning and performance
2015-05-28 14:41 UTC Ravi Krishna <sravikrishna3@gmail.com>
` Re: Partitioning and performance
2015-05-28 18:05 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[3+ messages in thread]
Fastest Backup & Restore for perf testing
2015-05-27 20:24 UTC Wes Vaske (wvaske) <wvaske@micron.com>
` Re: Fastest Backup & Restore for perf testing
2015-05-27 20:37 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Fastest Backup & Restore for perf testing
2015-05-27 20:39 UTC Steve Atkins <steve@blighty.com>
` Re: Fastest Backup & Restore for perf testing
2015-05-28 17:40 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[4+ messages in thread]
ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881
2015-05-27 07:50 UTC Tory M Blue <tmblue@gmail.com>
` Re: ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881
2015-05-27 22:02 UTC Josh Berkus <josh@agliodbs.com>
[2+ messages in thread]
MAX() and multi-column index on a partitioned table?
2015-05-22 22:27 UTC Dave Johansen <davejohansen@gmail.com>
` Re: MAX() and multi-column index on a partitioned table?
2015-05-22 22:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: MAX() and multi-column index on a partitioned table?
2015-05-22 23:53 UTC Dave Johansen <davejohansen@gmail.com>
` Re: MAX() and multi-column index on a partitioned table?
2015-05-23 01:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
How to clean/truncate / VACUUM FULL pg_largeobject without (much) downtime?
2015-05-11 09:55 UTC Muthusamy, Sivaraman <sivaraman.muthusamy@in.verizon.com>
` Re: How to clean/truncate / VACUUM FULL pg_largeobject without (much) downtime?
2015-05-22 21:17 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[2+ messages in thread]
PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-23 19:47 UTC Jan Gunnar Dyrset <jan.g.dyrset@cybernetica.no>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-29 08:06 UTC Andres Freund <andres@anarazel.de>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-29 08:08 UTC Andres Freund <andres@anarazel.de>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-29 14:07 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-29 14:35 UTC ktm@rice.edu <ktm@rice.edu>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-29 14:56 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-05-21 18:54 UTC Josh Berkus <josh@agliodbs.com>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-05-21 20:39 UTC Andres Freund <andres@anarazel.de>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-05-21 23:16 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-05-22 17:34 UTC Josh Berkus <josh@agliodbs.com>
[10+ messages in thread]
union all and filter / index scan -> seq scan
2015-05-21 10:41 UTC Florian Lohoff <f@zz.de>
` Re: union all and filter / index scan -> seq scan
2015-05-21 15:09 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: union all and filter / index scan -> seq scan
2015-05-21 15:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
optimization join on random value
2015-05-03 21:23 UTC Anton Bushmelev <djeday84@gmail.com>
` Re: optimization join on random value
2015-05-03 21:28 UTC Heikki Linnakangas <hlinnaka@iki.fi>
[2+ messages in thread]
Index Scan Backward Slow
2015-05-01 10:54 UTC David Osborne <david@qcode.co.uk>
` Re: Index Scan Backward Slow
2015-05-01 10:59 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Index Scan Backward Slow
2015-05-01 11:06 UTC David Osborne <david@qcode.co.uk>
` Re: Index Scan Backward Slow
2015-05-02 08:48 UTC Robert Klemme <shortcutter@googlemail.com>
[4+ messages in thread]
Query plan with missing timespans
2015-04-22 17:37 UTC Andomar <andomar@aule.net>
` Re: Query plan with missing timespans
2015-04-22 19:47 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Query plan with missing timespans
2015-04-22 19:59 UTC Andomar <andomar@aule.net>
` Re: Query plan with missing timespans
2015-04-22 20:18 UTC Jason Petersen <jason@citusdata.com>
` Re: Query plan with missing timespans
2015-04-23 04:40 UTC Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
[5+ messages in thread]
Postgresql Host Swapping Hard With Abundant Free Memory
2015-04-17 18:25 UTC Christian Gough <brukshut@gmail.com>
` Re: Postgresql Host Swapping Hard With Abundant Free Memory
2015-04-22 23:33 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[2+ messages in thread]
extract(year from date) doesn't use index but maybe could?
2015-04-19 17:16 UTC Jon Dufresne <jon.dufresne@gmail.com>
` Re: extract(year from date) doesn't use index but maybe could?
2015-04-19 17:42 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: extract(year from date) doesn't use index but maybe could?
2015-04-19 20:10 UTC Jon Dufresne <jon.dufresne@gmail.com>
` Re: extract(year from date) doesn't use index but maybe could?
2015-04-19 21:03 UTC Adam Tauno Williams <awilliam@whitemice.org>
` Re: extract(year from date) doesn't use index but maybe could?
2015-04-19 21:12 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: extract(year from date) doesn't use index but maybe could?
2015-04-19 21:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: extract(year from date) doesn't use index but maybe could?
2015-04-19 22:05 UTC Yves Dorfsman <yves@zioup.com>
` Re: extract(year from date) doesn't use index but maybe could?
2015-04-19 22:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: extract(year from date) doesn't use index but maybe could?
2015-04-20 00:13 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: extract(year from date) doesn't use index but maybe could?
2015-04-22 16:15 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[10+ messages in thread]
pushing order by + limit to union subqueries
2015-02-28 09:08 UTC Paolo Losi <paolo.losi@gmail.com>
` Re: pushing order by + limit to union subqueries
2015-02-28 16:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] pushing order by + limit to union subqueries
2015-04-16 18:49 UTC Qingqing Zhou <zhouqq.postgres@gmail.com>
[3+ messages in thread]
Performance of vacuumlo
2015-04-15 01:46 UTC Andreas Joseph Krogh <andreas@visena.com>
Some performance testing?
2015-03-31 19:52 UTC Josh Berkus <josh@agliodbs.com>
` Re: Some performance testing?
2015-03-31 20:41 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: Some performance testing?
2015-04-01 09:02 UTC Przemysław Deć <przemyslaw.dec@linuxpolska.pl>
` Re: Some performance testing?
2015-04-03 17:44 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: Some performance testing?
2015-04-06 20:51 UTC Josh Berkus <josh@agliodbs.com>
` Re: Some performance testing?
2015-04-07 16:46 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: Some performance testing?
2015-04-07 17:41 UTC Josh Berkus <josh@agliodbs.com>
` Re: Some performance testing?
2015-04-07 18:07 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: Some performance testing?
2015-04-08 19:05 UTC Josh Berkus <josh@agliodbs.com>
` Re: Some performance testing?
2015-04-08 21:29 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: Some performance testing?
2015-04-08 22:09 UTC Michael Nolan <htfoot@gmail.com>
` Re: Some performance testing?
2015-04-09 09:04 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Some performance testing?
2015-04-09 10:39 UTC Przemysław Deć <przemyslaw.dec@linuxpolska.pl>
` Re: Some performance testing?
2015-04-09 11:01 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Some performance testing?
2015-04-09 11:56 UTC Przemysław Deć <przemyslaw.dec@linuxpolska.pl>
` Re: Some performance testing?
2015-04-09 13:35 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Some performance testing?
2015-04-09 15:15 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Some performance testing?
2015-04-09 15:20 UTC Wes Vaske (wvaske) <wvaske@micron.com>
` Re: Some performance testing?
2015-04-10 13:21 UTC Michael Nolan <htfoot@gmail.com>
` Re: Some performance testing?
2015-04-10 13:29 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Some performance testing?
2015-04-14 19:58 UTC Josh Berkus <josh@agliodbs.com>
[21+ messages in thread]
Cannot get query to use btree-gin index when ORDER BY
2015-04-09 21:39 UTC Andreas Joseph Krogh <andreas@visena.com>
NVMe or AHCI PCI-express? A comment for people benchmarking...
2015-04-09 14:45 UTC Graeme B. Bell <grb@skogoglandskap.no>
Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-01 13:56 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-01 14:27 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-01 14:32 UTC Aidan Van Dyk <aidan@highrise.ca>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-01 14:44 UTC Wei Shan <weishan.ang@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-01 16:38 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 02:19 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 10:33 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 10:47 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 10:51 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 10:57 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 12:22 UTC Mkrtchyan, Tigran <tigran.mkrtchyan@desy.de>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 12:29 UTC didier <did447@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 12:51 UTC Aidan Van Dyk <aidan@highrise.ca>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 13:23 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 13:52 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 14:00 UTC Aidan Van Dyk <aidan@highrise.ca>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 14:25 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-02 15:11 UTC didier <did447@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-03 13:43 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-03 13:55 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-03 15:00 UTC Josh Krupka <jkrupka@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-03 15:10 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-03 15:21 UTC Josh Krupka <jkrupka@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-03 15:33 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-07 16:49 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-07 17:17 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-07 17:45 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL
2015-04-08 10:37 UTC Pietro Pugni <pietro.pugni@gmail.com>
[28+ messages in thread]
Weird CASE WHEN behaviour causing query to be suddenly very slow
2015-03-31 08:53 UTC Kevin Viraud <kevin.viraud@rocket-internet.de>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
2015-03-31 09:08 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
2015-03-31 09:19 UTC Kevin Viraud <kevin.viraud@rocket-internet.de>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
2015-03-31 09:41 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
2015-03-31 13:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
2015-03-31 15:58 UTC Kevin Viraud <kevin.viraud@rocket-internet.de>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
2015-03-31 17:03 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
2015-04-07 23:38 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Weird CASE WHEN behaviour causing query to be suddenly very slow
2015-04-07 23:50 UTC Qingqing Zhou <zhouqq.postgres@gmail.com>
[9+ messages in thread]
views much slower in 9.3 than 8.4
2015-03-18 17:00 UTC Carson, Leonard <lcarson@sdsc.edu>
` Re: views much slower in 9.3 than 8.4
2015-03-18 17:16 UTC Kevin Grittner <kgrittn@ymail.com>
` Fwd: views much slower in 9.3 than 8.4
2015-03-18 22:18 UTC Carson, Leonard <lcarson@sdsc.edu>
` Re: Fwd: views much slower in 9.3 than 8.4
2015-03-18 22:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: views much slower in 9.3 than 8.4
2015-03-19 17:24 UTC Carson, Leonard <lcarson@sdsc.edu>
` Re: views much slower in 9.3 than 8.4
2015-03-19 23:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: views much slower in 9.3 than 8.4
2015-03-28 17:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: views much slower in 9.3 than 8.4
2015-03-30 14:46 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: views much slower in 9.3 than 8.4
2015-03-30 15:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: views much slower in 9.3 than 8.4
2015-04-07 23:30 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[10+ messages in thread]
Poor performing query re-write using tsrange index
2015-04-02 03:26 UTC Burgess, Freddie <FBurgess@Radiantblue.com>
Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-25 12:04 UTC Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-25 12:45 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-25 14:22 UTC Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-25 16:07 UTC Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-25 17:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-25 18:07 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-25 20:00 UTC Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-25 21:45 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-26 07:48 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-26 08:17 UTC Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-26 08:26 UTC Feike Steenbergen <feikesteenbergen@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-26 12:44 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-26 16:35 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index only scan sometimes switches to sequential scan for small amount of rows
2015-03-26 22:19 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[14+ 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