pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSlow fulltext query plan
2012-04-12 22:09 UTC Benoit Delbosc <bdelbosc@nuxeo.com>
` Re: Slow fulltext query plan
2012-04-12 22:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow fulltext query plan
2012-04-12 22:56 UTC Benoit Delbosc <bdelbosc@nuxeo.com>
` Re: Slow fulltext query plan
2012-04-14 01:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow fulltext query plan
2012-04-16 13:11 UTC Florent Guillaume <fg@nuxeo.com>
[5+ messages in thread]
PostgreSQL - Help Optimizing performance - full text search on Heroku
2012-04-13 16:14 UTC xlash <solutiondb@gmail.com>
` Re: PostgreSQL - Help Optimizing performance - full text search on Heroku
2012-04-13 17:09 UTC Tomas Vondra <tv@fuzzy.cz>
[2+ messages in thread]
about multiprocessingmassdata
2012-04-04 15:52 UTC superman0920 <superman0920@gmail.com>
` Re: about multiprocessingmassdata
2012-04-04 16:34 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: about multiprocessingmassdata
2012-04-04 16:59 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: about multiprocessingmassdata
2012-04-05 14:47 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: about multiprocessingmassdata
2012-04-05 15:01 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: about multiprocessingmassdata
2012-04-09 22:37 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: about multiprocessingmassdata
2012-04-09 23:50 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: about multiprocessingmassdata
2012-04-10 13:21 UTC Merlin Moncure <mmoncure@gmail.com>
[8+ messages in thread]
Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster
2012-04-04 13:47 UTC Kim Hansen <kim@rthansen.dk>
` Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster
2012-04-05 15:34 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster
2012-04-05 16:01 UTC Kim Hansen <kim@rthansen.dk>
` Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster
2012-04-06 17:11 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster
2012-04-06 22:09 UTC Kim Hansen <kim@rthansen.dk>
` Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster
2012-04-10 02:59 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster
2012-04-10 09:55 UTC Kim Hansen <kim@rthansen.dk>
[7+ messages in thread]
Stats
2012-04-08 18:30 UTC Lukas <lukas@fmf.vgtu.lt>
` Re: Stats
2012-04-08 20:36 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[2+ messages in thread]
get/set priority of PostgreSQL backends
2012-04-07 17:06 UTC Josh Kupershmidt <schmiddy@gmail.com>
` Re: get/set priority of PostgreSQL backends
2012-04-07 18:05 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: get/set priority of PostgreSQL backends
2012-04-07 18:31 UTC Josh Kupershmidt <schmiddy@gmail.com>
[3+ messages in thread]
postgresql.conf setting for max_fsm_pages
2012-04-04 09:22 UTC ahchuan <chiochuan@gmail.com>
` Re: postgresql.conf setting for max_fsm_pages
2012-04-05 13:56 UTC Marcos Ortiz <mlortiz@uci.cu>
` Re: postgresql.conf setting for max_fsm_pages
2012-04-05 14:38 UTC Scott Marlowe <scott.marlowe@gmail.com>
[3+ messages in thread]
TCP Overhead on Local Loopback
2012-04-01 20:24 UTC Ofer Israeli <oferi@checkpoint.com>
` Re: TCP Overhead on Local Loopback
2012-04-01 22:01 UTC Andy <angelflow@yahoo.com>
` Re: TCP Overhead on Local Loopback
2012-04-01 23:48 UTC Rob Wultsch <wultsch@gmail.com>
` Re: TCP Overhead on Local Loopback
2012-04-01 23:54 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: TCP Overhead on Local Loopback
2012-04-02 00:29 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: TCP Overhead on Local Loopback
2012-04-02 01:11 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: TCP Overhead on Local Loopback
2012-04-02 08:25 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: TCP Overhead on Local Loopback
2012-04-02 11:34 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: TCP Overhead on Local Loopback
2012-04-02 16:51 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: TCP Overhead on Local Loopback
2012-04-03 15:24 UTC Ofer Israeli <oferi@checkpoint.com>
` Re: TCP Overhead on Local Loopback
2012-04-03 15:38 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: TCP Overhead on Local Loopback
2012-04-03 16:04 UTC Dave Crooke <dcrooke@gmail.com>
` Re: TCP Overhead on Local Loopback
2012-04-05 09:39 UTC Ofer Israeli <oferi@checkpoint.com>
[13+ messages in thread]
pg_autovacuum in PG9.x
2012-04-04 01:36 UTC David Kerr <dmk@mr-paradox.net>
` Re: pg_autovacuum in PG9.x
2012-04-04 01:40 UTC Brett Mc Bride <brett.mcbride@deakin.edu.au>
` Re: pg_autovacuum in PG9.x
2012-04-04 01:51 UTC David Kerr <dmk@mr-paradox.net>
[3+ messages in thread]
Update join performance issues
2012-04-03 17:29 UTC Kevin Kempter <cs_dba@consistentstate.com>
` Re: Update join performance issues
2012-04-03 17:37 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update join performance issues
2012-04-03 17:39 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Update join performance issues
2012-04-03 17:49 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update join performance issues
2012-04-03 17:51 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Update join performance issues
2012-04-03 20:43 UTC Merlin Moncure <mmoncure@gmail.com>
[6+ messages in thread]
...WHERE TRUE" condition in union results in bad query pla
2012-03-03 22:43 UTC Claus Stadler <cstadler@informatik.uni-leipzig.de>
` Re: ...WHERE TRUE" condition in union results in bad query pla
2012-03-04 03:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: ...WHERE TRUE" condition in union results in bad query pla
2012-04-03 14:57 UTC Robert Haas <robertmhaas@gmail.com>
` Re: ...WHERE TRUE" condition in union results in bad query pla
2012-04-03 15:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Performance of SQL Function versus View
2012-02-29 20:37 UTC Igor Schtein <ischtein@gmail.com>
` Re: Performance of SQL Function versus View
2012-04-03 14:21 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Performance of SQL Function versus View
2012-04-03 14:30 UTC Andrew Dunstan <andrew@dunslane.net>
[3+ messages in thread]
database slowdown while a lot of inserts occur
2012-03-29 17:59 UTC Campbell, Lance <lance@illinois.edu>
` Re: database slowdown while a lot of inserts occur
2012-03-29 18:02 UTC Campbell, Lance <lance@illinois.edu>
` Re: database slowdown while a lot of inserts occur
2012-03-29 18:14 UTC Filippos Kalamidas <filippos.kal@gmail.com>
` Re: database slowdown while a lot of inserts occur
2012-03-29 18:17 UTC Deron <fecastle@gmail.com>
` Re: database slowdown while a lot of inserts occur
2012-03-29 19:27 UTC Bob Lunney <bob_lunney@yahoo.com>
` Re: database slowdown while a lot of inserts occur
2012-03-29 19:39 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: database slowdown while a lot of inserts occur
2012-03-29 20:17 UTC Shrirang Chitnis <Shrirang.Chitnis@hovservices.com>
` Re: database slowdown while a lot of inserts occur
2012-03-29 21:36 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: database slowdown while a lot of inserts occur
2012-03-31 01:11 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: database slowdown while a lot of inserts occur
2012-03-31 01:21 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: database slowdown while a lot of inserts occur
2012-04-01 02:20 UTC Bob Lunney <bob_lunney@yahoo.com>
` Re: database slowdown while a lot of inserts occur
2012-04-02 07:14 UTC Віталій Тимчишин <tivv00@gmail.com>
[12+ messages in thread]
Tablespaces on a raid configuration
2012-03-30 14:45 UTC Campbell, Lance <lance@illinois.edu>
` Re: Tablespaces on a raid configuration
2012-03-30 14:53 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Tablespaces on a raid configuration
2012-03-30 15:02 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Tablespaces on a raid configuration
2012-03-30 15:02 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Tablespaces on a raid configuration
2012-03-30 16:11 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Tablespaces on a raid configuration
2012-03-30 17:30 UTC Craig James <cjames@emolecules.com>
` Re: Tablespaces on a raid configuration
2012-03-31 01:32 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Tablespaces on a raid configuration
2012-03-31 13:42 UTC Aidan Van Dyk <aidan@highrise.ca>
[8+ messages in thread]
Distinct + Limit
2012-03-27 20:37 UTC Francois Deliege <fdeliege@gmail.com>
` Re: Distinct + Limit
2012-03-27 20:54 UTC Francois Deliege <fdeliege@gmail.com>
` Re: Distinct + Limit
2012-03-28 00:18 UTC Ants Aasma <ants@cybertec.at>
` Re: Distinct + Limit
2012-03-28 14:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Distinct + Limit
2012-03-28 16:39 UTC Merlin Moncure <mmoncure@gmail.com>
[5+ messages in thread]
Determining working set size
2012-03-26 07:11 UTC Peter van Hardenberg <pvh@pvh.ca>
` Re: Determining working set size
2012-03-27 19:58 UTC Joshua Berkus <josh@agliodbs.com>
[2+ messages in thread]
anyone tried to use hoard allocator?
2012-03-26 09:50 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: anyone tried to use hoard allocator?
2012-03-26 11:09 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: anyone tried to use hoard allocator?
2012-03-26 16:00 UTC Steve Atkins <steve@blighty.com>
[3+ messages in thread]
Write workload is causing severe slowdown in Production
2012-03-22 07:27 UTC Gnanakumar <gnanam@zoniac.com>
` Re: Write workload is causing severe slowdown in Production
2012-03-22 09:42 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Write workload is causing severe slowdown in Production
2012-03-22 10:04 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Write workload is causing severe slowdown in Production
2012-03-22 10:32 UTC Gnanakumar <gnanam@zoniac.com>
` Re: Write workload is causing severe slowdown in Production
2012-03-22 10:43 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Write workload is causing severe slowdown in Production
2012-03-22 12:10 UTC Gnanakumar <gnanam@zoniac.com>
` Re: Write workload is causing severe slowdown in Production
2012-03-22 12:38 UTC Gnanakumar <gnanam@zoniac.com>
` Re: Write workload is causing severe slowdown in Production
2012-03-22 12:52 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Write workload is causing severe slowdown in Production
2012-03-22 12:55 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Write workload is causing severe slowdown in Production
2012-03-22 15:13 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Write workload is causing severe slowdown in Production
2012-03-22 16:18 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Write workload is causing severe slowdown in Production
2012-03-23 00:08 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Write workload is causing severe slowdown in Production
2012-03-23 10:10 UTC Gnanakumar <gnanam@zoniac.com>
` Re: Write workload is causing severe slowdown in Production
2012-03-23 10:24 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Write workload is causing severe slowdown in Production
2012-03-23 12:25 UTC Gnanakumar <gnanam@zoniac.com>
` Re: Write workload is causing severe slowdown in Production
2012-03-23 14:09 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[16+ messages in thread]
timing != log duration
2012-03-21 11:42 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: timing != log duration
2012-03-21 11:53 UTC Marti Raudsepp <marti@juffo.org>
` Re: timing != log duration
2012-03-21 14:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: timing != log duration
2012-03-21 14:48 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[4+ messages in thread]
set autovacuum=off
2012-02-22 23:50 UTC Alessandro Gagliardi <alessandro@path.com>
` Re: set autovacuum=off
2012-02-23 12:34 UTC Thom Brown <thom@linux.com>
` Re: set autovacuum=off
2012-02-23 15:18 UTC Andy Colson <andy@squeakycode.net>
` Re: set autovacuum=off
2012-02-23 17:35 UTC Alessandro Gagliardi <alessandro@path.com>
` Re: set autovacuum=off
2012-02-23 17:45 UTC Thom Brown <thom@linux.com>
` Re: set autovacuum=off
2012-02-23 17:58 UTC Alessandro Gagliardi <alessandro@path.com>
` Re: set autovacuum=off
2012-02-23 18:01 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: set autovacuum=off
2012-02-23 18:38 UTC Alessandro Gagliardi <alessandro@path.com>
` Re: set autovacuum=off
2012-02-23 18:42 UTC Peter van Hardenberg <pvh@pvh.ca>
` Re: set autovacuum=off
2012-02-23 19:07 UTC Andy Colson <andy@squeakycode.net>
` Re: set autovacuum=off
2012-02-23 19:26 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: set autovacuum=off
2012-02-23 20:28 UTC Alessandro Gagliardi <alessandro@path.com>
` Re: set autovacuum=off
2012-02-23 20:40 UTC Alessandro Gagliardi <alessandro@path.com>
` Re: set autovacuum=off
2012-02-23 20:57 UTC Andy Colson <andy@squeakycode.net>
` Re: set autovacuum=off
2012-02-23 21:07 UTC Alessandro Gagliardi <alessandro@path.com>
` Re: set autovacuum=off
2012-02-23 21:11 UTC Peter van Hardenberg <pvh@heroku.com>
` Re: set autovacuum=off
2012-02-23 21:37 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: set autovacuum=off
2012-02-23 22:30 UTC Alessandro Gagliardi <alessandro@path.com>
` Re: set autovacuum=off
2012-02-23 22:54 UTC Alessandro Gagliardi <alessandro@path.com>
` Re: set autovacuum=off
2012-02-27 21:55 UTC Filippos Kalamidas <filippos.kal@gmail.com>
` Re: set autovacuum=off
2012-02-27 21:59 UTC Filippos Kalamidas <filippos.kal@gmail.com>
` Re: set autovacuum=off
2012-03-21 14:32 UTC Robert Haas <robertmhaas@gmail.com>
[22+ messages in thread]
DBD-Pg prepared statement versus plain execution
2012-03-21 11:21 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: DBD-Pg prepared statement versus plain execution
2012-03-21 12:59 UTC ktm@rice.edu <ktm@rice.edu>
` Re: DBD-Pg prepared statement versus plain execution
2012-03-21 13:44 UTC Andy Colson <andy@squeakycode.net>
[3+ messages in thread]
slow self-join query
2012-03-17 20:56 UTC Robert Poor <rdpoor@gmail.com>
` Re: slow self-join query
2012-03-18 00:57 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: slow self-join query
2012-03-18 14:37 UTC Robert Poor <rdpoor@gmail.com>
` Re: slow self-join query
2012-03-18 14:51 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: slow self-join query
2012-03-18 15:30 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: slow self-join query
2012-03-18 15:44 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: slow self-join query
2012-03-19 03:57 UTC Robert Poor <rdpoor@gmail.com>
` Re: slow self-join query
2012-03-19 13:35 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: slow self-join query
2012-03-19 14:27 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: slow self-join query
2012-03-19 15:22 UTC Robert Poor <rdpoor@gmail.com>
` Re: slow self-join query
2012-03-19 16:45 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[11+ messages in thread]
Shared memory for large PostGIS operations
2012-03-15 04:29 UTC maplabs@light42.com
` Re: Shared memory for large PostGIS operations
2012-03-16 13:55 UTC Andy Colson <andy@squeakycode.net>
` Re: Shared memory for large PostGIS operations
2012-03-16 14:17 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Shared memory for large PostGIS operations
2012-03-16 21:00 UTC Brian Hamlin <maplabs@light42.com>
` Re: Shared memory for large PostGIS operations
2012-03-16 22:30 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Shared memory for large PostGIS operations
2012-03-17 13:20 UTC Andy Colson <andy@squeakycode.net>
` Re: Shared memory for large PostGIS operations
2012-03-17 16:16 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[7+ messages in thread]
Obtaining resource usage statistics from execution? (v 9.1)
2012-03-16 14:31 UTC Karl Denninger <karl@denninger.net>
` Re: Obtaining resource usage statistics from execution? (v 9.1)
2012-03-16 14:48 UTC Ants Aasma <ants@cybertec.at>
` Re: Obtaining resource usage statistics from execution? (v 9.1)
2012-03-16 14:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Obtaining resource usage statistics from execution? (v 9.1)
2012-03-16 15:08 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Obtaining resource usage statistics from execution? (v 9.1)
2012-03-16 15:38 UTC Karl Denninger <karl@denninger.net>
[5+ messages in thread]
index choosing problem
2012-03-15 08:32 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: index choosing problem
2012-03-15 11:44 UTC Ants Aasma <ants.aasma@eesti.ee>
[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