pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPoor performance problem with Materialize, 8.4 -> 9.1 (enable_material)
2012-07-13 14:11 UTC Eoghan Murray <eoghan@qatano.com>
` Re: Poor performance problem with Materialize, 8.4 -> 9.1 (enable_material)
2012-07-13 15:53 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Poor performance problem with Materialize, 8.4 -> 9.1 (enable_material)
2012-07-13 16:40 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Poor performance problem with Materialize, 8.4 -> 9.1 (enable_material)
2012-07-13 17:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor performance problem with Materialize, 8.4 -> 9.1 (enable_material)
2012-07-13 18:56 UTC Claudio Freire <klaussfreire@gmail.com>
[5+ messages in thread]
Is there a tool available to perform Data Model review, from a performance perspective?
2012-07-13 16:25 UTC B Sreejith <bsreejithin@gmail.com>
slow prepare, lots of semop calls.
2012-07-13 06:51 UTC David Kerr <dmk@mr-paradox.net>
how could select id=xx so slow?
2012-07-06 06:17 UTC Yan Chunlu <springrider@gmail.com>
` Re: how could select id=xx so slow?
2012-07-06 09:46 UTC Daniel Farina <daniel@heroku.com>
` Re: how could select id=xx so slow?
2012-07-06 11:16 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: how could select id=xx so slow?
2012-07-06 13:10 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: how could select id=xx so slow?
2012-07-09 09:20 UTC Yan Chunlu <springrider@gmail.com>
` Re: how could select id=xx so slow?
2012-07-10 01:25 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: how could select id=xx so slow?
2012-07-10 02:25 UTC Yan Chunlu <springrider@gmail.com>
` Re: how could select id=xx so slow?
2012-07-10 02:46 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: how could select id=xx so slow?
2012-07-10 02:58 UTC Yan Chunlu <springrider@gmail.com>
` Re: how could select id=xx so slow?
2012-07-11 06:24 UTC Yan Chunlu <springrider@gmail.com>
` Re: how could select id=xx so slow?
2012-07-11 08:23 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: how could select id=xx so slow?
2012-07-11 11:40 UTC Yan Chunlu <springrider@gmail.com>
` Re: how could select id=xx so slow?
2012-07-11 11:59 UTC Ants Aasma <ants@cybertec.at>
` Re: how could select id=xx so slow?
2012-07-11 16:35 UTC Yan Chunlu <springrider@gmail.com>
` Re: how could select id=xx so slow?
2012-07-12 00:18 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: how could select id=xx so slow?
2012-07-12 00:47 UTC Yan Chunlu <springrider@gmail.com>
` Re: how could select id=xx so slow?
2012-07-12 01:07 UTC Maciek Sakrejda <m.sakrejda@gmail.com>
` Re: how could select id=xx so slow?
2012-07-12 02:20 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: how could select id=xx so slow?
2012-07-12 05:10 UTC Yan Chunlu <springrider@gmail.com>
` Re: how could select id=xx so slow?
2012-07-12 06:56 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: how could select id=xx so slow?
2012-07-12 12:48 UTC Yan Chunlu <springrider@gmail.com>
` Re: how could select id=xx so slow?
2012-07-12 14:39 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: how could select id=xx so slow?
2012-07-12 16:07 UTC Ants Aasma <ants@cybertec.at>
` Re: how could select id=xx so slow?
2012-07-12 18:53 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: how could select id=xx so slow?
2012-07-13 04:02 UTC Yan Chunlu <springrider@gmail.com>
[25+ messages in thread]
moving tables
2012-06-20 22:27 UTC Midge Brown <midgems@sbcglobal.net>
` Re: moving tables
2012-06-21 00:28 UTC Josh Berkus <josh@agliodbs.com>
` Re: moving tables
2012-06-21 08:34 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: moving tables
2012-07-11 17:25 UTC Midge Brown <midgems@sbcglobal.net>
[4+ messages in thread]
Paged Query
2012-07-04 12:25 UTC Hermann Matthes <hermann.matthes@web.de>
` Re: Paged Query
2012-07-06 13:18 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: Paged Query
2012-07-06 13:19 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Paged Query
2012-07-06 13:35 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Paged Query
2012-07-06 13:43 UTC Misa Simic <misa.simic@gmail.com>
` Re: Paged Query
2012-07-09 11:55 UTC Gregg Jaskiewicz <gryzman@gmail.com>
` Re: Paged Query
2012-07-09 12:02 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Paged Query
2012-07-09 13:22 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Paged Query
2012-07-09 14:16 UTC Craig James <cjames@emolecules.com>
` Re: Paged Query
2012-07-09 14:33 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Paged Query
2012-07-09 17:41 UTC Misa Simic <misa.simic@gmail.com>
` Re: Paged Query
2012-07-09 17:46 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Paged Query
2012-07-09 18:13 UTC Gurjeet Singh <singh.gurjeet@gmail.com>
` Re: Paged Query
2012-07-09 22:24 UTC Misa Simic <misa.simic@gmail.com>
` Re: Paged Query
2012-07-09 23:48 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Paged Query
2012-07-09 23:50 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Paged Query
2012-07-10 00:34 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Paged Query
2012-07-11 08:15 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: Paged Query
2012-07-11 08:23 UTC Віталій Тимчишин <tivv00@gmail.com>
[19+ messages in thread]
The need for clustered indexes to boost TPC-V performance
2012-07-03 23:13 UTC Reza Taheri <rtaheri@vmware.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-04 05:43 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-04 07:57 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-04 08:31 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-04 13:39 UTC Daniel Farina <daniel@heroku.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-04 14:26 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-05 12:30 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-05 19:10 UTC Reza Taheri <rtaheri@vmware.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-05 19:13 UTC Reza Taheri <rtaheri@vmware.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-05 19:46 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-05 20:37 UTC Reza Taheri <rtaheri@vmware.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-05 20:52 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-06 00:41 UTC Andy Colson <andy@squeakycode.net>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-06 00:46 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-06 00:57 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-06 01:00 UTC Reza Taheri <rtaheri@vmware.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-06 01:04 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-06 01:42 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: [PERFORM] The need for clustered indexes to boost TPC-V performance
2012-07-06 03:02 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-06 03:08 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-06 03:33 UTC Reza Taheri <rtaheri@vmware.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-06 04:19 UTC Reza Taheri <rtaheri@vmware.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-10 19:05 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: The need for clustered indexes to boost TPC-V performance
2012-07-10 19:35 UTC Reza Taheri <rtaheri@vmware.com>
[24+ messages in thread]
Massive I/O spikes during checkpoint
2012-07-10 05:39 UTC David Kerr <dmk@mr-paradox.net>
` Re: Massive I/O spikes during checkpoint
2012-07-10 05:51 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Massive I/O spikes during checkpoint
2012-07-10 05:52 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Massive I/O spikes during checkpoint
2012-07-10 05:59 UTC David Kerr <dmk@mr-paradox.net>
` Re: Massive I/O spikes during checkpoint
2012-07-10 06:03 UTC David Kerr <dmk@mr-paradox.net>
` Re: Massive I/O spikes during checkpoint
2012-07-10 06:14 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Massive I/O spikes during checkpoint
2012-07-10 06:17 UTC David Kerr <dmk@mr-paradox.net>
` Re: Massive I/O spikes during checkpoint
2012-07-10 12:44 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Massive I/O spikes during checkpoint
2012-07-10 13:36 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Massive I/O spikes during checkpoint
2012-07-10 13:41 UTC Andres Freund <andres@2ndquadrant.com>
[10+ messages in thread]
Custom function in where clause
2012-07-10 08:36 UTC Pena Kupen <kupen@wippies.fi>
` Re: Custom function in where clause
2012-07-10 08:44 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Custom function in where clause
2012-07-10 08:45 UTC Brendan Jurd <direvus@gmail.com>
` Re: Custom function in where clause
2012-07-10 09:30 UTC Pena Kupen <kupen@wippies.fi>
` Fw: Re: Custom function in where clause
2012-07-10 10:20 UTC Pena Kupen <kupen@wippies.fi>
[5+ messages in thread]
Create tables performance
2012-07-06 15:15 UTC Sylvain CAILLET <scaillet@alaloop.com>
` Re: Create tables performance
2012-07-06 17:22 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Create tables performance
2012-07-06 18:12 UTC Richard Huxton <dev@archonet.com>
` Re: Create tables performance
2012-07-07 02:27 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Create tables performance
2012-07-09 06:49 UTC Sylvain CAILLET <scaillet@alaloop.com>
` Re: Create tables performance
2012-07-09 17:02 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Create tables performance
2012-07-10 06:27 UTC Sylvain CAILLET <scaillet@alaloop.com>
[7+ messages in thread]
SSDs again, LSI Warpdrive 2 anyone?
2012-07-06 00:51 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: SSDs again, LSI Warpdrive 2 anyone?
2012-07-06 04:08 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: SSDs again, LSI Warpdrive 2 anyone?
2012-07-09 17:16 UTC jamonb <jamon.bowen@lsi.com>
[3+ messages in thread]
Terrible plan for join to nested union
2012-07-07 22:35 UTC Nate Allan <nallan@ancestry.com>
` Re: Terrible plan for join to nested union
2012-07-08 00:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Terrible plan for join to nested union
2012-07-08 05:50 UTC Nate Allan <nallan@ancestry.com>
` Re: Terrible plan for join to nested union
2012-07-08 06:03 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Terrible plan for join to nested union
2012-07-08 09:43 UTC Nate Allan <nallan@ancestry.com>
` Re: Terrible plan for join to nested union
2012-07-08 15:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Terrible plan for join to nested union
2012-07-09 04:02 UTC Nate Allan <nallan@ancestry.com>
` Re: Terrible plan for join to nested union
2012-07-09 05:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Terrible plan for join to nested union
2012-07-09 06:20 UTC Nate Allan <nallan@ancestry.com>
[9+ messages in thread]
select operations that generate disk writes
2012-07-06 06:10 UTC CSS <css@morefoo.com>
` Re: select operations that generate disk writes
2012-07-06 06:20 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: select operations that generate disk writes
2012-07-06 06:52 UTC Craig Ringer <ringerc@ringerc.id.au>
[3+ messages in thread]
Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-03 23:08 UTC Reza Taheri <rtaheri@vmware.com>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-04 05:19 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-04 18:24 UTC Reza Taheri <rtaheri@vmware.com>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-04 22:35 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-06 01:25 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-06 03:22 UTC Reza Taheri <rtaheri@vmware.com>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-06 03:41 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Introducing the TPC-V benchmark, and its relationship to PostgreSQL
2012-07-06 04:03 UTC Reza Taheri <rtaheri@vmware.com>
[8+ messages in thread]
The overall experience of TPC-V benchmark team with PostgreSQL
2012-07-06 03:56 UTC Reza Taheri <rtaheri@vmware.com>
What would effect planning time?
2012-07-06 02:12 UTC David Kerr <dmk@mr-paradox.net>
MemSQL the "world's fastest database"?
2012-06-25 16:25 UTC Craig James <cjames@emolecules.com>
` Re: MemSQL the "world's fastest database"?
2012-06-25 17:03 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: MemSQL the "world's fastest database"?
2012-06-25 17:23 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: MemSQL the "world's fastest database"?
2012-06-25 17:41 UTC Josh Berkus <josh@agliodbs.com>
` Re: MemSQL the "world's fastest database"?
2012-06-25 18:02 UTC gnuoytr@rcn.com
` Re: MemSQL the "world's fastest database"?
2012-06-25 20:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: MemSQL the "world's fastest database"?
2012-07-01 04:18 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: MemSQL the "world's fastest database"?
2012-07-01 05:00 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: MemSQL the "world's fastest database"?
2012-07-03 21:46 UTC Gregg Jaskiewicz <gryzman@gmail.com>
` Re: MemSQL the "world's fastest database"?
2012-07-06 01:45 UTC Greg Smith <greg@2ndQuadrant.com>
[10+ messages in thread]
Drop statistics?
2012-06-22 17:07 UTC David Kerr <dmk@mr-paradox.net>
` Re: Drop statistics?
2012-06-22 17:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Drop statistics?
2012-06-22 18:04 UTC David Kerr <dmk@mr-paradox.net>
` Re: Drop statistics?
2012-07-03 17:16 UTC Bruce Momjian <bruce@momjian.us>
` Re: Drop statistics?
2012-07-05 05:53 UTC David Kerr <dmk@mr-paradox.net>
[5+ messages in thread]
static virtual columns as result?
2012-07-03 09:29 UTC PV <pstm.spain@gmail.com>
` Re: static virtual columns as result?
2012-07-03 13:44 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: static virtual columns as result?
2012-07-03 15:43 UTC PV <pstm.spain@gmail.com>
` Re: static virtual columns as result?
2012-07-04 10:35 UTC PV <pstm.spain@gmail.com>
[4+ messages in thread]
SSD, Postgres and safe write cache
2012-06-20 14:51 UTC Michal Szymanski <mich20061@gmail.com>
` Re: SSD, Postgres and safe write cache
2012-06-25 16:05 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: SSD, Postgres and safe write cache
2012-07-01 04:37 UTC Greg Smith <greg@2ndQuadrant.com>
[3+ messages in thread]
Performance of a large array access by position (tested version 9.1.3)
2012-06-22 07:02 UTC Maxim Boguk <maxim.boguk@gmail.com>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 05:03 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 07:53 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 08:04 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 08:19 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 08:22 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-26 09:03 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance of a large array access by position (tested version 9.1.3)
2012-06-28 10:22 UTC Cédric Villemain <cedric@2ndquadrant.com>
[8+ messages in thread]
Can I do better than this heapscan and sort?
2012-06-21 20:07 UTC Andy Halsall <halsall_andy@hotmail.com>
` Re: Can I do better than this heapscan and sort?
2012-06-26 13:36 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Can I do better than this heapscan and sort?
2012-06-26 13:42 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Can I do better than this heapscan and sort?
2012-06-27 16:49 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
[performance] fast reads on a busy server
2012-06-26 22:16 UTC Willy-Bas Loos <willybas@gmail.com>
` Re: [performance] fast reads on a busy server
2012-06-27 07:34 UTC Hannu Krosing <hannu@2ndQuadrant.com>
` Re: [performance] fast reads on a busy server
2012-06-27 10:01 UTC Willy-Bas Loos <willybas@gmail.com>
` Re: [performance] fast reads on a busy server
2012-06-27 11:28 UTC Willy-Bas Loos <willybas@gmail.com>
` Re: [performance] fast reads on a busy server
2012-06-27 11:58 UTC Willy-Bas Loos <willybas@gmail.com>
` Re: [PERFORM] [performance] fast reads on a busy server
2012-06-27 12:58 UTC Ants Aasma <ants@cybertec.at>
` Re: [PERFORM] [performance] fast reads on a busy server
2012-06-27 13:23 UTC Willy-Bas Loos <willybas@gmail.com>
[7+ messages in thread]
index-only scan is missing the INCLUDE feature
2012-06-20 04:46 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: index-only scan is missing the INCLUDE feature
2012-06-20 14:11 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: index-only scan is missing the INCLUDE feature
2012-06-20 15:32 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: index-only scan is missing the INCLUDE feature
2012-06-21 02:45 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: index-only scan is missing the INCLUDE feature
2012-06-25 15:22 UTC Cédric Villemain <cedric@2ndquadrant.com>
[5+ messages in thread]
"global/pgstat.stat" corrupt
2012-06-22 18:46 UTC David Kerr <dmk@mr-paradox.net>
` Re: "global/pgstat.stat" corrupt
2012-06-22 19:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: "global/pgstat.stat" corrupt
2012-06-22 20:11 UTC David Kerr <dmk@mr-paradox.net>
[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