pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedbrowsing table with 2 million records
2005-10-26 20:41 UTC aurora <aurora00@gmail.com>
` Re: browsing table with 2 million records
2005-10-26 20:59 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: browsing table with 2 million records
2005-10-26 21:06 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: browsing table with 2 million records
2005-10-26 21:09 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: browsing table with 2 million records
2005-10-26 21:22 UTC aurora <aurora00@gmail.com>
` Re: browsing table with 2 million records
2005-10-26 21:28 UTC Alex Turner <armtuk@gmail.com>
` Re: browsing table with 2 million records
2005-10-26 21:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: browsing table with 2 million records
2005-10-26 21:49 UTC PFC <lists@boutiquenumerique.com>
` Re: browsing table with 2 million records
2005-10-27 01:43 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: browsing table with 2 million records
2005-10-27 01:46 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: browsing table with 2 million records
2005-10-27 12:59 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: browsing table with 2 million records
2005-10-27 14:33 UTC PFC <lists@boutiquenumerique.com>
[12+ messages in thread]
insertion of bytea
2005-10-25 13:44 UTC Chris Mair <list@1006.org>
` Re: insertion of bytea
2005-10-25 14:05 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: insertion of bytea
2005-10-25 14:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: insertion of bytea
2005-10-25 21:36 UTC Chris Mair <list@1006.org>
` Re: insertion of bytea
2005-10-25 21:41 UTC Chris Mair <list@1006.org>
` Re: insertion of bytea
2005-10-27 13:40 UTC Chris Mair <list@1006.org>
[6+ messages in thread]
performance on query
2005-10-26 23:47 UTC Sidar López Cruz <sidarlopez@hotmail.com>
` Re: performance on query
2005-10-27 03:00 UTC Jim C. Nasby <jnasby@pervasive.com>
[2+ messages in thread]
Materializing a sequential scan
2005-10-19 17:45 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
2005-10-20 04:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Materializing a sequential scan
2005-10-20 04:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Materializing a sequential scan
2005-10-20 10:16 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
2005-10-20 10:18 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
2005-10-23 10:23 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
2005-10-26 21:37 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
2005-10-26 23:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Materializing a sequential scan
2005-10-26 23:22 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
2005-10-26 23:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Materializing a sequential scan
2005-10-27 00:13 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Materializing a sequential scan
2005-10-27 00:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Materializing a sequential scan
2005-10-27 00:57 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
[13+ messages in thread]
tuning seqscan costs
2005-10-19 14:51 UTC Katherine Stoovs <ambrosiac@nedsenta.nl>
` Re: [HACKERS] tuning seqscan costs
2005-10-20 14:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: tuning seqscan costs
2005-10-26 22:48 UTC Thomas F. O'Connell <tfo@sitening.com>
[3+ messages in thread]
blue prints please
2005-10-26 04:24 UTC Sidar López Cruz <sidarlopez@hotmail.com>
` Re: blue prints please
2005-10-26 06:59 UTC Jean-Max Reymond <jmreymond@gmail.com>
` Re: blue prints please
2005-10-26 18:08 UTC Bruno Wolff III <bruno@wolff.to>
[3+ messages in thread]
zero performance on query
2005-10-26 04:26 UTC Sidar López Cruz <sidarlopez@hotmail.com>
` Re: zero performance on query
2005-10-26 05:25 UTC Dmitri Bichko <dbichko@aveopharma.com>
` Re: zero performance on query
2005-10-26 10:30 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: zero performance on query
2005-10-26 12:05 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: zero performance on query
2005-10-26 15:20 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
[5+ messages in thread]
Outer join query plans and performance
2005-10-25 11:35 UTC Rich Doughty <rich@opusvl.com>
` Re: Outer join query plans and performance
2005-10-25 14:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Outer join query plans and performance
2005-10-25 18:28 UTC Rich Doughty <rich@opusvl.com>
` Re: Outer join query plans and performance
2005-10-25 22:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Outer join query plans and performance
2005-10-25 22:24 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Outer join query plans and performance
2005-10-26 08:33 UTC Rich Doughty <rich@opusvl.com>
[6+ messages in thread]
Configuration Suggestion
2005-10-26 06:05 UTC Christian Paul B. Cosinas <cpc@cybees.com>
Why different execution times for different instances for the same query?
2005-10-25 19:46 UTC Kishore B <kishorebh@gmail.com>
` Re: Why different execution times for different
2005-10-25 20:24 UTC Scott Marlowe <smarlowe@g2switchworks.com>
[2+ messages in thread]
Why Index is not working on date columns.
2005-10-25 08:47 UTC Kishore B <kishorebh@gmail.com>
` Re: Why Index is not working on date columns.
2005-10-25 13:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why Index is not working on date columns.
2005-10-25 15:04 UTC Kishore B <kishorebh@gmail.com>
` Re: Why Index is not working on date columns.
2005-10-25 18:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
impact of stats_command_string
2005-10-20 20:33 UTC jnevans@gmail.com
` Re: impact of stats_command_string
2005-10-25 16:04 UTC Michael Fuhr <mike@fuhr.org>
` Re: impact of stats_command_string
2005-10-25 17:02 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
[3+ messages in thread]
Inefficient escape codes.
2005-10-18 18:07 UTC Rodrigo Madera <rodrigo.madera@gmail.com>
` Re: Inefficient escape codes.
2005-10-18 19:03 UTC Michael Fuhr <mike@fuhr.org>
` Re: Inefficient escape codes.
2005-10-18 20:47 UTC Michael Fuhr <mike@fuhr.org>
` Re: Inefficient escape codes.
2005-10-19 07:19 UTC Peter Childs <peterachilds@gmail.com>
` Re: Inefficient escape codes.
2005-10-19 14:54 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Inefficient escape codes.
2005-10-20 07:15 UTC Nörder-Tuitje, Marcus <noerder-tuitje@technology.de>
` Re: Inefficient escape codes.
2005-10-21 16:59 UTC Rodrigo Madera <rodrigo.madera@gmail.com>
` Re: Inefficient escape codes.
2005-10-24 19:11 UTC Rodrigo Madera <rodrigo.madera@gmail.com>
` Re: Inefficient escape codes.
2005-10-25 16:03 UTC Rodrigo Madera <rodrigo.madera@gmail.com>
[9+ messages in thread]
Reindex - Is this necessary after a vacuum?
2005-10-25 13:56 UTC Markus Benne <thing@m-bass.com>
` Re: Reindex - Is this necessary after a vacuum?
2005-10-25 14:16 UTC Richard Huxton <dev@archonet.com>
` Re: Reindex - Is this necessary after a vacuum?
2005-10-25 14:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Strange planner decision on quite simple select
2005-10-25 09:47 UTC Markus Wollny <Markus.Wollny@computec.de>
` Re: Strange planner decision on quite simple select
2005-10-25 10:07 UTC Richard Huxton <dev@archonet.com>
` Re: Strange planner decision on quite simple select
2005-10-25 13:39 UTC Markus Wollny <Markus.Wollny@computec.de>
[3+ messages in thread]
Is There Any Way ....
2005-09-29 23:21 UTC Lane Van Ingen <lvaningen@esncc.com>
` Re: Is There Any Way ....
2005-09-30 00:22 UTC Dario <dario_d_s@unitech.com.ar>
` Re: Is There Any Way ....
2005-09-30 00:57 UTC mudfoot@rawbw.com
` Re: Is There Any Way ....
2005-09-30 01:46 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Is There Any Way ....
2005-09-30 07:14 UTC Richard Huxton <dev@archonet.com>
` Re: Is There Any Way ....
2005-10-04 10:31 UTC Stefan Weiss <spaceman@foo.at>
` Re: Is There Any Way ....
2005-10-04 14:45 UTC Lane Van Ingen <lvaningen@esncc.com>
` Re: Is There Any Way ....
2005-10-04 20:57 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Is There Any Way ....
2005-10-04 22:23 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Is There Any Way ....
2005-10-04 23:33 UTC Ron Peacetree <rjpeace@earthlink.net>
` Re: Is There Any Way ....
2005-10-05 00:01 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Is There Any Way ....
2005-10-05 00:40 UTC Douglas J. Trainor <trainor@transborder.net>
` Re: Is There Any Way ....
2005-10-05 01:32 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Is There Any Way ....
2005-10-05 03:06 UTC Ron Peacetree <rjpeace@earthlink.net>
` Re: Is There Any Way ....
2005-10-05 03:50 UTC Steve Atkins <steve@blighty.com>
` Re: Is There Any Way ....
2005-10-05 03:50 UTC mark@mark.mielke.cc
` Re: Is There Any Way ....
2005-10-05 06:16 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Is There Any Way ....
2005-10-05 11:00 UTC Douglas J. Trainor <trainor@transborder.net>
` Re: Is There Any Way ....
2005-10-05 11:16 UTC Dario <dario_d_s@unitech.com.ar>
` Re: Is There Any Way ....
2005-10-05 13:51 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Is There Any Way ....
2005-10-05 15:05 UTC Frank Wiles <frank@wiles.org>
` Re: Is There Any Way ....
2005-10-05 17:08 UTC Ron Peacetree <rjpeace@earthlink.net>
` Re: Is There Any Way ....
2005-10-05 19:52 UTC Douglas J. Trainor <trainor@transborder.net>
` Re: Is There Any Way ....
2005-10-24 22:18 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Is There Any Way ....
2005-10-24 23:11 UTC Alex Turner <armtuk@gmail.com>
` Re: Is There Any Way ....
2005-10-25 00:50 UTC Alan Stange <stange@rentec.com>
[26+ messages in thread]
Need help in setting optimal configuration for a huge database.
2005-10-22 21:12 UTC Kishore B <bkishorevarma@yahoo.com>
` Need help in setting optimal configuration for a huge database.
2005-10-22 21:15 UTC Kishore B <kishorebh@gmail.com>
` Re: Need help in setting optimal configuration for a huge database.
2005-10-22 21:42 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Need help in setting optimal configuration for a huge database.
2005-10-22 21:57 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Need help in setting optimal configuration for a huge
2005-10-22 22:03 UTC Karl O. Pinc <kop@meme.com>
` Re: Need help in setting optimal configuration for a huge database.
2005-10-22 22:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Need help in setting optimal configuration for a huge database.
2005-10-23 02:05 UTC Kishore B <kishorebh@gmail.com>
` Re: Need help in setting optimal configuration for a huge
2005-10-23 10:04 UTC Dennis Bjorklund <db@zigo.dhs.org>
` Re: Need help in setting optimal configuration for a huge
2005-10-23 16:31 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: Need help in setting optimal configuration for a huge
2005-10-23 16:55 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Need help in setting optimal configuration for a huge
2005-10-23 17:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Need help in setting optimal configuration for a huge
2005-10-23 17:17 UTC Tomasz Rybak <bogomips@post.pl>
` Re: Need help in setting optimal configuration for a huge database.
2005-10-23 21:35 UTC Kishore B <kishorebh@gmail.com>
` Re: [PERFORM] Need help in setting optimal configuration for a huge database.
2005-10-23 21:55 UTC Kishore B <kishorebh@gmail.com>
` Re: [PERFORM] Need help in setting optimal configuration
2005-10-24 15:28 UTC Scott Marlowe <smarlowe@g2switchworks.com>
[15+ messages in thread]
Problem analyzing explain analyze output
2005-10-23 23:53 UTC Guillaume Smet <guillaume.smet@openwide.fr>
` Re: Problem analyzing explain analyze output
2005-10-24 00:08 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Problem analyzing explain analyze output
2005-10-24 06:33 UTC Guillaume Smet <guillaume.smet@openwide.fr>
[3+ messages in thread]
prepared transactions that persist across sessions?
2005-10-23 04:14 UTC mark@mark.mielke.cc
` Re: prepared transactions that persist across sessions?
2005-10-23 06:51 UTC Bruno Wolff III <bruno@wolff.to>
` Re: prepared transactions that persist across sessions?
2005-10-24 05:03 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
[3+ messages in thread]
Using LIMIT 1 in plpgsql PERFORM statements
2005-10-22 05:05 UTC Karl O. Pinc <kop@meme.com>
` Re: Using LIMIT 1 in plpgsql PERFORM statements
2005-10-23 21:02 UTC Josh Berkus <josh@agliodbs.com>
` Re: Using LIMIT 1 in plpgsql PERFORM statements
2005-10-24 00:25 UTC Karl O. Pinc <kop@meme.com>
` Re: Using LIMIT 1 in plpgsql PERFORM statements
2005-10-24 00:40 UTC Karl O. Pinc <kop@meme.com>
` Re: Using LIMIT 1 in plpgsql PERFORM statements
2005-10-24 04:36 UTC Josh Berkus <josh@agliodbs.com>
` Re: Using LIMIT 1 in plpgsql PERFORM statements
2005-10-24 04:40 UTC Neil Conway <neilc@samurai.com>
[6+ messages in thread]
Sequential scan on FK join
2005-10-12 20:40 UTC Martin Nickel <martin@portant.com>
` Re: Sequential scan on FK join
2005-10-17 08:45 UTC Richard Huxton <dev@archonet.com>
` Re: Sequential scan on FK join
2005-10-17 13:07 UTC Martin Nickel <martin@portant.com>
` Re: Sequential scan on FK join
2005-10-17 17:45 UTC Richard Huxton <dev@archonet.com>
` Re: Sequential scan on FK join
2005-10-17 19:56 UTC Martin Nickel <martin@portant.com>
` Re: Sequential scan on FK join
2005-10-18 07:52 UTC Richard Huxton <dev@archonet.com>
` Re: Sequential scan on FK join
2005-10-21 07:59 UTC Martin Nickel <martin@portant.com>
` Re: Sequential scan on FK join
2005-10-21 08:51 UTC Martin Nickel <martin@portant.com>
` Re: Sequential scan on FK join
2005-10-22 13:25 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
[9+ messages in thread]
cached plans in plpgsql
2005-10-20 14:07 UTC Kuba Ouhrabka <kuba@comgate.cz>
` Re: cached plans in plpgsql
2005-10-20 15:03 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: cached plans in plpgsql
2005-10-20 16:25 UTC Kuba Ouhrabka <kuba@comgate.cz>
` Re: cached plans in plpgsql
2005-10-20 16:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: cached plans in plpgsql
2005-10-21 07:33 UTC Kuba Ouhrabka <kuba@comgate.cz>
[5+ messages in thread]
Deleting Records
2005-10-20 08:43 UTC Christian Paul B. Cosinas <cpc@cybees.com>
` Re: Deleting Records
2005-10-20 08:49 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Deleting Records
2005-10-20 08:50 UTC Nörder-Tuitje, Marcus <noerder-tuitje@technology.de>
` Re: Deleting Records
2005-10-20 08:52 UTC Matteo Beccati <php@beccati.com>
` Re: Deleting Records
2005-10-20 08:57 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
` Re: Deleting Records
2005-10-20 08:59 UTC Christopher Kings-Lynne <chriskl@familyhealth.com.au>
[6+ messages in thread]
Help tuning postgres
2005-10-12 14:45 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning postgres
2005-10-12 15:12 UTC Emil Briggs <emil@baymountain.com>
` Re: Help tuning postgres
2005-10-12 15:17 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning postgres
2005-10-12 15:33 UTC Emil Briggs <emil@baymountain.com>
` Re: Help tuning postgres
2005-10-12 15:54 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Help tuning postgres
2005-10-12 16:39 UTC Matthew Nuzum <mattnuzum@gmail.com>
` Re: Help tuning postgres
2005-10-12 16:55 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning postgres
2005-10-12 17:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Help tuning postgres
2005-10-12 17:32 UTC Steve Poe <spoe@sfnet.cc>
` Re: Help tuning postgres
2005-10-12 18:17 UTC Merlin Moncure <merlin.moncure@rcsonline.com>
` Re: Help tuning postgres
2005-10-12 22:00 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Help tuning postgres
2005-10-13 08:15 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning postgres
2005-10-13 10:16 UTC Markus Wollny <Markus.Wollny@computec.de>
` Re: Help tuning postgres
2005-10-13 10:24 UTC Markus Wollny <Markus.Wollny@computec.de>
` Re: Help tuning postgres
2005-10-13 12:40 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Help tuning postgres
2005-10-13 13:14 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning postgres
2005-10-13 14:50 UTC Matthew Nuzum <mattnuzum@gmail.com>
` Re: Help tuning postgres
2005-10-13 16:07 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Help tuning postgres
2005-10-18 15:18 UTC Robert Treat <xzilla@users.sourceforge.net>
` Re: Help tuning postgres
2005-10-18 15:21 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning postgres
2005-10-18 15:49 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: Help tuning postgres
2005-10-18 16:48 UTC Andrew Sullivan <ajs@crankycanuck.ca>
[22+ messages in thread]
tsearch2/GIST performance factors?
2005-10-14 22:31 UTC Craig A. James <cjames@modgraph-usa.com>
` tsearch2/GIST performance factors?
2005-10-15 14:47 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: tsearch2/GIST performance factors?
2005-10-17 17:43 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: tsearch2/GIST performance factors?
2005-10-18 06:07 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: tsearch2/GIST performance factors?
2005-10-18 06:20 UTC Oleg Bartunov <oleg@sai.msu.su>
[5+ 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