pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-28 15:22 UTC Evan Carroll <lists@evancarroll.com>
` Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-28 15:32 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-28 15:58 UTC Gregory Stark <stark@enterprisedb.com>
` Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-28 16:17 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-28 16:20 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-28 16:21 UTC Evan Carroll <me@evancarroll.com>
` Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-28 16:24 UTC Evan Carroll <lists@evancarroll.com>
` Re: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-28 16:30 UTC Evan Carroll <lists@evancarroll.com>
` Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-28 16:51 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-28 18:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-08-31 23:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy)
2007-09-01 00:09 UTC Mark Lewis <mark.lewis@mir3.com>
[12+ messages in thread]
Re: Shared memory usage
2007-08-25 20:39 UTC Martijn van Oosterhout <kleptog@svana.org>
` Shared memory usage
2007-08-25 21:22 UTC Max Zorloff <zorloff@gmail.com>
` Re: Shared memory usage
2007-08-25 22:22 UTC Max Zorloff <zorloff@gmail.com>
` Re: Shared memory usage
2007-08-25 22:32 UTC Max Zorloff <zorloff@gmail.com>
` Re: Shared memory usage
2007-08-27 10:21 UTC Adam Tauno Williams <adamtaunowilliams@gmail.com>
` Re: Shared memory usage
2007-08-27 13:18 UTC Max Zorloff <zorloff@gmail.com>
` Re: Shared memory usage
2007-08-29 19:26 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Shared memory usage
2007-08-30 06:40 UTC Max Zorloff <zorloff@gmail.com>
[8+ messages in thread]
Transaction Log
2007-08-29 19:22 UTC Markus Benne <mbenne@m-bass.com>
` Transaction Log
2007-08-29 19:24 UTC mbguy2000-1@yahoo.com
` Re: Transaction Log
2007-08-29 19:54 UTC Mark Mielke <mark@mark.mielke.cc>
` Re: Transaction Log
2007-08-29 20:11 UTC Steve Atkins <steve@blighty.com>
` Re: Transaction Log
2007-08-29 20:17 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Transaction Log
2007-08-29 20:21 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Transaction Log
2007-08-29 20:36 UTC Alan Hodgson <ahodgson@simkin.ca>
[7+ messages in thread]
LIKE query verses =
2007-08-29 12:31 UTC Karthikeyan Mahadevan <karthikeyan.mahadevan@in.ibm.com>
` Re: LIKE query verses =
2007-08-29 17:12 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: LIKE query verses =
2007-08-29 17:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Performance problem with table containing a lot of text (blog)
2007-08-28 18:53 UTC Kari Lavikka <tuner@bdb.fi>
` Re: Performance problem with table containing a lot of text (blog)
2007-08-28 19:04 UTC Dan Harris <fbsd@drivefaster.net>
` Re: Performance problem with table containing a lot of text (blog)
2007-08-28 19:10 UTC Kari Lavikka <tuner@bdb.fi>
` Re: Performance problem with table containing a lot of text (blog)
2007-08-29 08:29 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Performance problem with table containing a lot of text (blog)
2007-08-29 09:39 UTC Kari Lavikka <tuner@bdb.fi>
` Re: Performance problem with table containing a lot of text (blog)
2007-08-29 10:14 UTC Heikki Linnakangas <heikki@enterprisedb.com>
[6+ messages in thread]
index & Bitmap Heap Scan
2007-08-28 08:49 UTC Paul <paul@wayr.org>
` Re: index & Bitmap Heap Scan
2007-08-28 16:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: index & Bitmap Heap Scan
2007-08-29 08:16 UTC Paul <paul@wayr.org>
[3+ messages in thread]
Performance across multiple schemas
2007-08-28 13:05 UTC Robins <tharakan@gmail.com>
` Re: Performance across multiple schemas
2007-08-28 13:44 UTC Robins <tharakan@gmail.com>
` Re: Performance across multiple schemas
2007-08-28 13:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance across multiple schemas
2007-08-29 01:50 UTC Robins Tharakan <robins@pobox.com>
` Re: Performance across multiple schemas
2007-08-29 02:45 UTC Robins <tharakan@gmail.com>
[5+ messages in thread]
io storm on checkpoints, postgresql 8.2.4, linux
2007-08-22 15:33 UTC Dmitry Potapov <fortune.fish@gmail.com>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-22 15:57 UTC Kenneth Marshall <ktm@rice.edu>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-22 15:57 UTC Mark Mielke <mark@mark.mielke.cc>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-22 16:01 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-22 16:16 UTC Dmitry Potapov <fortune.fish@gmail.com>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-22 16:22 UTC Dmitry Potapov <fortune.fish@gmail.com>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-22 16:28 UTC Dmitry Potapov <fortune.fish@gmail.com>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-22 20:30 UTC Greg Smith <gsmith@gregsmith.com>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-23 14:37 UTC Dmitry Potapov <fortune.fish@gmail.com>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-23 17:00 UTC Greg Smith <gsmith@gregsmith.com>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-28 15:00 UTC Erik Jones <erik@myemma.com>
` Re: io storm on checkpoints, postgresql 8.2.4, linux
2007-08-28 21:34 UTC Decibel! <decibel@decibel.org>
[12+ messages in thread]
8.2.4 Chooses Bad Query Plan
2007-08-28 15:09 UTC Pallav Kalva <pkalva@livedatagroup.com>
` Re: 8.2.4 Chooses Bad Query Plan
2007-08-28 18:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.2.4 Chooses Bad Query Plan
2007-08-28 19:28 UTC Pallav Kalva <pkalva@livedatagroup.com>
` Re: 8.2.4 Chooses Bad Query Plan
2007-08-28 21:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
server performance issues - suggestions for tuning
2007-08-28 04:13 UTC Kevin Kempter <kevin@kevinkempterllc.com>
` Re: server performance issues - suggestions for tuning
2007-08-28 07:50 UTC Richard Huxton <dev@archonet.com>
` Re: server performance issues - suggestions for tuning
2007-08-28 13:12 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: server performance issues - suggestions for tuning
2007-08-28 14:26 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: server performance issues - suggestions for tuning
2007-08-28 14:32 UTC Scott Marlowe <scott.marlowe@gmail.com>
[5+ messages in thread]
significant vacuum issues - looking for suggestions
2007-08-24 19:57 UTC Kevin Kempter <kevin@kevinkempterllc.com>
` Re: significant vacuum issues - looking for suggestions
2007-08-24 20:41 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: significant vacuum issues - looking for suggestions
2007-08-24 20:52 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: significant vacuum issues - looking for suggestions
2007-08-24 21:08 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: significant vacuum issues - looking for suggestions
2007-08-24 21:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: significant vacuum issues - looking for suggestions
2007-08-25 05:34 UTC Kevin Kempter <kevin@kevinkempterllc.com>
` Re: significant vacuum issues - looking for suggestions
2007-08-27 21:00 UTC Decibel! <decibel@decibel.org>
` Re: significant vacuum issues - looking for suggestions
2007-08-27 21:56 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: significant vacuum issues - looking for suggestions
2007-08-27 22:00 UTC Kevin Kempter <kevin@kevinkempterllc.com>
` Re: significant vacuum issues - looking for suggestions
2007-08-27 22:03 UTC Kevin Kempter <kevin@kevinkempterllc.com>
` Re: significant vacuum issues - looking for suggestions
2007-08-27 22:04 UTC Decibel! <decibel@decibel.org>
` Re: significant vacuum issues - looking for suggestions
2007-08-27 22:06 UTC Kevin Kempter <kevin@kevinkempterllc.com>
[12+ messages in thread]
asynchronous commit feature
2007-08-23 13:09 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: asynchronous commit feature
2007-08-27 20:11 UTC Decibel! <decibel@decibel.org>
` Re: asynchronous commit feature
2007-08-27 21:18 UTC Merlin Moncure <mmoncure@gmail.com>
[3+ messages in thread]
Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 00:41 UTC Benjamin Arai <me@benjaminarai.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 01:29 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 03:54 UTC Brandon Shalton <brandon@cydataservices.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 05:34 UTC Benjamin Arai <me@benjaminarai.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 16:18 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 18:12 UTC Benjamin Arai <me@benjaminarai.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 18:18 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 19:49 UTC Benjamin Arai <me@benjaminarai.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 19:58 UTC Erik Jones <erik@myemma.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 20:09 UTC Erik Jones <erik@myemma.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-25 21:17 UTC Brandon Shalton <brandon@cydataservices.com>
` Re: [PERFORM] Partioning tsearch2 a table into chunks and accessing via views
2007-08-27 14:43 UTC Vivek Khera <vivek@khera.org>
[12+ messages in thread]
Bitmap Heap Scan before using index
2007-08-27 13:11 UTC GOERGLER Paul <paul@wayr.org>
Optimising "in" queries
2007-08-22 02:40 UTC Stephen Davies <scldad@sdc.com.au>
` Re: Optimising "in" queries
2007-08-22 04:20 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Optimising "in" queries
2007-08-22 10:58 UTC Russell Smith <mr-russ@pws.com.au>
` Re: Optimising "in" queries
2007-08-22 12:08 UTC Stephen Davies <scldad@sdc.com.au>
` Re: Optimising "in" queries
2007-08-22 13:25 UTC Michael Glaesemann <grzm@seespotcode.net>
` Re: Optimising "in" queries
2007-08-22 18:50 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Optimising "in" queries
2007-08-22 23:30 UTC Stephen Davies <scldad@sdc.com.au>
` Re: Optimising "in" queries
2007-08-23 00:21 UTC Michael Glaesemann <grzm@seespotcode.net>
` Re: Optimising "in" queries
2007-08-23 07:34 UTC Russell Smith <mr-russ@pws.com.au>
` Re: Optimising "in" queries
2007-08-23 07:42 UTC Russell Smith <mr-russ@pws.com.au>
` Re: Optimising "in" queries
2007-08-23 19:46 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Optimising "in" queries
2007-08-23 23:47 UTC Stephen Davies <scldad@sdc.com.au>
` Re: Optimising "in" queries
2007-08-24 02:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
[13+ messages in thread]
long-running query - needs tuning
2007-08-23 17:16 UTC Kevin Kempter <kevin@kevinkempterllc.com>
` Re: long-running query - needs tuning
2007-08-23 18:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
deadlock_timeout parameter in Postgresql.cof
2007-08-23 18:21 UTC Sachchida Ojha <sojha@secure-elements.com>
` deadlock_timeout parameter in Postgresql.cof
2007-08-23 18:23 UTC Sachchida Ojha <sojha@secure-elements.com>
` Re: deadlock_timeout parameter in Postgresql.cof
2007-08-23 18:52 UTC Bill Moran <wmoran@collaborativefusion.com>
[3+ messages in thread]
Installing PostgreSQL
2007-08-23 16:47 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Installing PostgreSQL
2007-08-23 17:08 UTC Richard Huxton <dev@archonet.com>
` Re: Installing PostgreSQL
2007-08-23 17:19 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Installing PostgreSQL
2007-08-23 17:25 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Installing PostgreSQL
2007-08-23 17:26 UTC Richard Huxton <dev@archonet.com>
` Re: Installing PostgreSQL
2007-08-23 17:37 UTC Campbell, Lance <lance@uiuc.edu>
[6+ messages in thread]
Raid Configurations
2007-08-16 16:32 UTC Robert D Oden <roden@dbasetek.com>
` Re: Raid Configurations
2007-08-17 23:55 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Raid Configurations
2007-08-23 17:13 UTC Decibel! <decibel@decibel.org>
[3+ messages in thread]
Long running transaction in pg_activity_log
2007-08-22 20:40 UTC Sachchida Ojha <sojha@secure-elements.com>
` Re: Long running transaction in pg_activity_log
2007-08-22 20:54 UTC Sachchida Ojha <sojha@secure-elements.com>
` Re: Long running transaction in pg_activity_log
2007-08-22 21:08 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Long running transaction in pg_activity_log
2007-08-22 21:58 UTC Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>
[4+ messages in thread]
Fast tsearch2, trigram matching on short phrases
2007-08-22 16:02 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Fast tsearch2, trigram matching on short phrases
2007-08-22 16:29 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Fast tsearch2, trigram matching on short phrases
2007-08-22 18:48 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: Fast tsearch2, trigram matching on short phrases
2007-08-22 20:25 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Fast tsearch2, trigram matching on short phrases
2007-08-22 20:31 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Fast tsearch2, trigram matching on short phrases
2007-08-22 20:43 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: Fast tsearch2, trigram matching on short phrases
2007-08-22 21:09 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
[7+ messages in thread]
Poor Performance after Upgrade
2007-08-21 05:17 UTC Ben Perrault <ben@mail.creepingfur.org>
` Re: Poor Performance after Upgrade
2007-08-22 04:24 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Poor Performance after Upgrade
2007-08-22 09:19 UTC vincent <vinny@xs4all.nl>
` Re: Poor Performance after Upgrade
2007-08-22 10:52 UTC Russell Smith <mr-russ@pws.com.au>
[4+ messages in thread]
Autovacuum is running forever
2007-08-21 21:26 UTC Sachchida Ojha <sojha@secure-elements.com>
` Re: Autovacuum is running forever
2007-08-21 21:35 UTC Michael Glaesemann <grzm@seespotcode.net>
` Re: Autovacuum is running forever
2007-08-21 21:37 UTC Sachchida Ojha <sojha@secure-elements.com>
` Re: Autovacuum is running forever
2007-08-21 21:46 UTC Sachchida Ojha <sojha@secure-elements.com>
` Re: Autovacuum is running forever
2007-08-21 21:52 UTC Sachchida Ojha <sojha@secure-elements.com>
` Re: Autovacuum is running forever
2007-08-21 21:54 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Autovacuum is running forever
2007-08-21 22:01 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Autovacuum is running forever
2007-08-21 22:03 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Autovacuum is running forever
2007-08-21 22:05 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Autovacuum is running forever
2007-08-21 22:07 UTC Sachchida Ojha <sojha@secure-elements.com>
` Re: Autovacuum is running forever
2007-08-21 22:19 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Autovacuum is running forever
2007-08-21 22:20 UTC Sachchida Ojha <sojha@secure-elements.com>
` Re: Autovacuum is running forever
2007-08-21 23:16 UTC Scott Marlowe <scott.marlowe@gmail.com>
[13+ messages in thread]
Re: Autovacuum running forever
2007-08-21 21:30 UTC Sachchida Ojha <sojha@secure-elements.com>
` Re: Autovacuum running forever
2007-08-21 21:47 UTC Scott Marlowe <scott.marlowe@gmail.com>
[2+ messages in thread]
Performance Solaris vs Linux
2007-08-17 06:50 UTC Fredrik Bertilsson <frebe73@gmail.com>
` Re: Performance Solaris vs Linux
2007-08-18 03:08 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Performance Solaris vs Linux
2007-08-18 10:13 UTC Chris Mair <chris@1006.org>
` Re: Performance Solaris vs Linux
2007-08-21 15:49 UTC Julius Stroffek <Julius.Stroffek@Sun.COM>
[4+ 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