pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedHow planner decides left-anchored LIKE can use index
2007-09-07 00:06 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: How planner decides left-anchored LIKE can use index
2007-09-07 00:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Reasonable amount of indices
2007-09-06 20:08 UTC Patric <lists@p-dw.com>
` Re: Reasonable amount of indices
2007-09-06 22:09 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Reasonable amount of indices
2007-09-06 23:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
ADO -PostgreSQL OLE DB Provider
2007-09-06 13:15 UTC Jayaram Bhat <bhatindia@hotmail.com>
` Re: ADO -PostgreSQL OLE DB Provider
2007-09-06 16:08 UTC Richard Broersma Jr <rabroersma@yahoo.com>
[2+ messages in thread]
RESEND:Postgres with Sun Cluster HA/Solaris 10
2007-09-05 22:48 UTC Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>
No pg_dumplo on 8.2.4
2007-09-05 07:31 UTC Daniel Rubio <drubior@tinet.org>
` Re: No pg_dumplo on 8.2.4
2007-09-05 15:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Re : optimize query with a maximum(date) extraction
2007-09-05 13:11 UTC JS Ubei <jsubei@yahoo.fr>
Vacum Analyze problem
2007-09-04 17:27 UTC rafael@akyasociados.com.ar
` Re: Vacum Analyze problem
2007-09-04 17:33 UTC Mikko Partio <mpartio@gmail.com>
` Re: Vacum Analyze problem
2007-09-04 17:45 UTC Kevin Kempter <kevin@kevinkempterllc.com>
` Re: Vacum Analyze problem
2007-09-04 17:46 UTC rafael@akyasociados.com.ar
` Re: Vacum Analyze problem
2007-09-04 17:55 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Vacum Analyze problem
2007-09-04 18:46 UTC rafael@akyasociados.com.ar
` Re: Vacum Analyze problem
2007-09-04 18:52 UTC Richard Broersma Jr <rabroersma@yahoo.com>
` Re: Vacum Analyze problem
2007-09-04 23:24 UTC Gregory Stark <stark@enterprisedb.com>
[8+ messages in thread]
join tables vs. denormalization by trigger
2007-09-04 18:53 UTC Walter Mauritz <waltermauritz@gmx.at>
` Re: join tables vs. denormalization by trigger
2007-09-04 19:18 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: join tables vs. denormalization by trigger
2007-09-04 22:48 UTC Marc Mamin <M.Mamin@intershop.de>
[3+ messages in thread]
About autovacuum
2007-09-04 18:39 UTC Jean-David Beyer <jeandavid8@verizon.net>
` Re: About autovacuum
2007-09-04 19:01 UTC Bill Moran <wmoran@collaborativefusion.com>
[2+ messages in thread]
schemas to limit data access
2007-09-01 03:02 UTC Brennan, Sean (IMS) <BrennanS@imsweb.com>
` schemas to limit data access
2007-09-01 03:02 UTC Brennan, Sean (IMS) <BrennanS@imsweb.com>
` schemas to limit data access
2007-09-01 03:08 UTC Brennan, Sean (IMS) <BrennanS@imsweb.com>
` Re: schemas to limit data access
2007-09-04 01:08 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
Performance issue with nested loop
2007-08-29 10:15 UTC Jens Reufsteck <jens.reufsteck@hobsons.de>
` Performance issue with nested loop
2007-08-29 14:33 UTC Jens Reufsteck <jens.reufsteck@hobsons.de>
` Re: Performance issue with nested loop
2007-09-01 23:50 UTC Decibel! <decibel@decibel.org>
[3+ messages in thread]
8.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>
[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