pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedMaking the most of memory?
2008-01-23 04:11 UTC Joshua Fielek <jfielek@centriccrm.com>
` Re: Making the most of memory?
2008-01-23 05:20 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Making the most of memory?
2008-01-23 14:59 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Making the most of memory?
2008-01-23 18:44 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Making the most of memory?
2008-01-23 19:06 UTC Rich <rhdyes@gmail.com>
` Re: Making the most of memory?
2008-01-23 19:57 UTC Guy Rouillier <guyr-ml1@burntmail.com>
` Re: Making the most of memory?
2008-01-23 20:40 UTC A.M. <agentm@themactionfaction.com>
` Re: Making the most of memory?
2008-01-23 20:50 UTC Brian Hurt <bhurt@janestcapital.com>
` Re: Making the most of memory?
2008-01-23 21:06 UTC Craig James <craig_james@emolecules.com>
` Re: Making the most of memory?
2008-01-24 00:54 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Making the most of memory?
2008-01-24 01:45 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Making the most of memory?
2008-01-24 08:05 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Making the most of memory?
2008-01-24 09:19 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Making the most of memory?
2008-01-24 14:01 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Making the most of memory?
2008-01-24 14:15 UTC Matthew <matthew@flymine.org>
` Re: Making the most of memory?
2008-01-24 14:26 UTC Florian Weimer <fweimer@bfk.de>
` Re: Making the most of memory?
2008-01-24 16:09 UTC Chris Browne <cbbrowne@acm.org>
` Re: Making the most of memory?
2008-01-24 16:23 UTC Chris Browne <cbbrowne@acm.org>
` Re: Making the most of memory?
2008-01-24 18:01 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Making the most of memory?
2008-01-24 18:21 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Making the most of memory?
2008-01-25 08:18 UTC Florian Weimer <fweimer@bfk.de>
[21+ messages in thread]
Configuration settings (shared_buffers, etc) in Linux: puzzled
2008-01-24 18:00 UTC Rick Schumeyer <rschumeyer@ieee.org>
` Re: Configuration settings (shared_buffers, etc) in Linux: puzzled
2008-01-24 18:52 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Configuration settings (shared_buffers, etc) in Linux: puzzled
2008-01-25 01:53 UTC Fernando Ike <fike@midstorm.org>
[3+ messages in thread]
*_cost recommendation with 8.3 and a fully cached db
2008-01-23 12:36 UTC Guillaume Smet <guillaume.smet@gmail.com>
Workaround for cross column stats dependency
2008-01-23 00:57 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Workaround for cross column stats dependency
2008-01-23 01:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Workaround for cross column stats dependency
2008-01-23 02:02 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Workaround for cross column stats dependency
2008-01-23 09:05 UTC Guillaume Smet <guillaume.smet@gmail.com>
[4+ messages in thread]
SELECT * FROM table is too slow
2007-12-16 18:34 UTC Adam PAPAI <wooh@wooh.hu>
` Re: SELECT * FROM table is too slow
2007-12-16 18:37 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: SELECT * FROM table is too slow
2007-12-16 19:03 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: SELECT * FROM table is too slow
2007-12-16 22:49 UTC andrew@pillette.com
` Re: SELECT * FROM table is too slow
2008-01-22 19:44 UTC Luiz K. Matsumura <luiz@planit.com.br>
` Re: SELECT * FROM table is too slow
2008-01-22 20:19 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: SELECT * FROM table is too slow
2008-01-23 08:47 UTC Guillaume Cottenceau <gc@mnc.ch>
[7+ messages in thread]
Optimizing queries that use temporary tables
2008-01-22 19:32 UTC Luiz K. Matsumura <luiz@planit.com.br>
` Re: Optimizing queries that use temporary tables
2008-01-22 20:34 UTC Scott Marlowe <scott.marlowe@gmail.com>
[2+ messages in thread]
8.3 synchronous_commit
2008-01-21 21:55 UTC Hannes Dorbath <light@theendofthetunnel.de>
` Re: 8.3 synchronous_commit
2008-01-21 22:11 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: 8.3 synchronous_commit
2008-01-21 22:25 UTC Jeff Davis <pgsql@j-davis.com>
` Re: 8.3 synchronous_commit
2008-01-21 23:31 UTC Greg Smith <gsmith@gregsmith.com>
` Re: 8.3 synchronous_commit
2008-01-21 23:45 UTC Jeff Davis <pgsql@j-davis.com>
` Re: 8.3 synchronous_commit
2008-01-22 00:26 UTC Greg Smith <gsmith@gregsmith.com>
` Re: 8.3 synchronous_commit
2008-01-22 00:48 UTC Fernando Ike <fike@midstorm.org>
` Re: 8.3 synchronous_commit
2008-01-22 08:32 UTC Florian Weimer <fweimer@bfk.de>
` Re: 8.3 synchronous_commit
2008-01-22 08:49 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: 8.3 synchronous_commit
2008-01-22 08:56 UTC Florian Weimer <fweimer@bfk.de>
` Re: 8.3 synchronous_commit
2008-01-22 11:56 UTC Hannes Dorbath <light@theendofthetunnel.de>
` Re: 8.3 synchronous_commit
2008-01-22 12:13 UTC Hannes Dorbath <light@theendofthetunnel.de>
[12+ messages in thread]
scheduler
2008-01-22 07:00 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: scheduler
2008-01-22 08:10 UTC Claus Guttesen <kometen@gmail.com>
` Re: scheduler
2008-01-22 08:27 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: scheduler
2008-01-22 08:37 UTC david@lang.hm
` Re: scheduler
2008-01-22 08:45 UTC Luke Lonergan <LLonergan@greenplum.com>
[5+ messages in thread]
strange pauses
2008-01-16 10:42 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: strange pauses
2008-01-16 10:50 UTC Richard Huxton <dev@archonet.com>
` Re: strange pauses
2008-01-16 15:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: strange pauses
2008-01-16 15:30 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: strange pauses
2008-01-16 15:37 UTC Greg Smith <gsmith@gregsmith.com>
` Re: strange pauses
2008-01-17 06:50 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: strange pauses
2008-01-17 09:16 UTC Brian Herlihy <btherl@yahoo.com.au>
` Re: strange pauses
2008-01-17 13:44 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: strange pauses
2008-01-18 10:58 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: strange pauses
2008-01-18 12:03 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: strange pauses
2008-01-18 12:41 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: strange pauses
2008-01-18 15:36 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: strange pauses
2008-01-21 07:58 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: strange pauses
2008-01-21 19:29 UTC Decibel! <decibel@decibel.org>
[14+ messages in thread]
Slow performance with left outer join
2008-01-21 15:00 UTC Marten Verhoeven <m.verhoeven@van-beek.nl>
` Re: Slow performance with left outer join
2008-01-21 15:17 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Slow performance with left outer join
2008-01-21 16:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow performance with left outer join
2008-01-21 18:04 UTC Pavel Stehule <pavel.stehule@gmail.com>
[4+ messages in thread]
[OT] RAID controllers blocking one another?
2008-01-17 20:17 UTC Sean Davis <sdavis2@mail.nih.gov>
` Re: [OT] RAID controllers blocking one another?
2008-01-17 21:07 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: [OT] RAID controllers blocking one another?
2008-01-17 23:23 UTC Greg Smith <gsmith@gregsmith.com>
` Re: [OT] RAID controllers blocking one another?
2008-01-17 23:30 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: [OT] RAID controllers blocking one another?
2008-01-18 13:03 UTC Sean Davis <sdavis2@mail.nih.gov>
` Re: [OT] RAID controllers blocking one another?
2008-01-18 19:14 UTC Greg Smith <gsmith@gregsmith.com>
` Re: [OT] RAID controllers blocking one another?
2008-01-18 19:35 UTC Sean Davis <sdavis2@mail.nih.gov>
` Re: [OT] RAID controllers blocking one another?
2008-01-19 17:31 UTC david@lang.hm
[8+ messages in thread]
Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list]
2008-01-15 17:05 UTC Doug Knight <dknight@wsi.com>
` Re: Tuning Postgresql on Windows XP Pro 32 bit [was on HACKERS list]
2008-01-18 22:50 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[2+ messages in thread]
Saving result set of SELECT to table column
2008-01-14 18:19 UTC Patric <lists@p-dw.com>
` Re: Saving result set of SELECT to table column
2008-01-14 18:38 UTC Ansgar -59cobalt- Wiechers <lists@planetcobalt.net>
` Re: Saving result set of SELECT to table column
2008-01-15 03:30 UTC Robins Tharakan <tharakan@gmail.com>
[3+ messages in thread]
Seq scans on indexed columns.
2008-01-14 14:18 UTC Yannick Le Guédart <yannick@over-blog.com>
` Re: Seq scans on indexed columns.
2008-01-14 14:34 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: Seq scans on indexed columns.
2008-01-14 19:06 UTC Shane Ambler <pgsql@Sheeky.Biz>
[3+ messages in thread]
Best way to index IP data?
2008-01-10 23:14 UTC Kevin Kempter <kevin@kevinkempterllc.com>
` Re: Best way to index IP data?
2008-01-10 23:22 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Best way to index IP data?
2008-01-10 23:25 UTC Steve Atkins <steve@blighty.com>
` Re: Best way to index IP data?
2008-01-10 23:41 UTC Jonah H. Harris <jonah.harris@gmail.com>
` Re: Best way to index IP data?
2008-01-11 09:31 UTC Pomarede Nicolas <npomarede@corp.free.fr>
` Re: Best way to index IP data?
2008-01-11 15:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Best way to index IP data?
2008-01-11 15:37 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Best way to index IP data?
2008-01-11 15:55 UTC Pomarede Nicolas <npomarede@corp.free.fr>
` Re: Best way to index IP data?
2008-01-11 16:11 UTC Steve Atkins <steve@blighty.com>
` Re: Best way to index IP data?
2008-01-11 16:18 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Best way to index IP data?
2008-01-11 16:27 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-11 20:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Best way to index IP data?
2008-01-11 20:19 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: Best way to index IP data?
2008-01-11 21:27 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-11 21:32 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-11 21:37 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Best way to index IP data?
2008-01-11 21:40 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-11 22:02 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-11 22:24 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Best way to index IP data?
2008-01-11 22:38 UTC Steve Atkins <steve@blighty.com>
` Re: Best way to index IP data?
2008-01-11 22:43 UTC Pomarede Nicolas <npomarede@corp.free.fr>
` Re: Best way to index IP data?
2008-01-11 23:00 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Best way to index IP data?
2008-01-11 23:37 UTC Steve Atkins <steve@blighty.com>
` Re: Best way to index IP data?
2008-01-11 23:52 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Best way to index IP data?
2008-01-11 23:55 UTC Steve Atkins <steve@blighty.com>
` Re: Best way to index IP data?
2008-01-12 00:11 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-12 00:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Best way to index IP data?
2008-01-12 00:21 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-12 00:36 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-12 00:43 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Best way to index IP data?
2008-01-12 00:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Best way to index IP data?
2008-01-12 00:57 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Best way to index IP data?
2008-01-12 01:04 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-12 01:07 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-12 01:58 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-12 02:56 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Best way to index IP data?
2008-01-12 06:00 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: Best way to index IP data?
2008-01-12 11:17 UTC david@lang.hm
` Re: Best way to index IP data?
2008-01-14 08:27 UTC Florian Weimer <fweimer@bfk.de>
` Re: Best way to index IP data?
2008-01-14 11:19 UTC Michael Stone <mstone+postgres@mathom.us>
` Re: Best way to index IP data?
2008-01-14 14:05 UTC Florian Weimer <fweimer@bfk.de>
` Re: Best way to index IP data?
2008-01-14 14:12 UTC Michael Stone <mstone+postgres@mathom.us>
[42+ messages in thread]
Inheritance, unique keys and performance
2008-01-12 19:34 UTC Julian Scarfe <julian@avbrief.com>
` Re: Inheritance, unique keys and performance
2008-01-12 20:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inheritance, unique keys and performance
2008-01-13 09:13 UTC Julian Scarfe <julian@avbrief.com>
` Re: Inheritance, unique keys and performance
2008-01-13 18:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Inheritance, unique keys and performance
2008-01-13 19:28 UTC Julian Scarfe <julian@avbrief.com>
` Re: Inheritance, unique keys and performance
2008-01-13 20:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Simple select, but takes long time
2008-01-12 01:33 UTC James DeMichele <James.DeMichele@redfin.com>
` Re: Simple select, but takes long time
2008-01-12 02:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Simple select, but takes long time
2008-01-12 05:37 UTC andrew@pillette.com
` Re: Simple select, but takes long time
2008-01-12 05:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Evaluating boolean formula: slow performance
2008-01-11 17:06 UTC Jörg Kiegeland <kiegeland@ikv.de>
` Re: Evaluating boolean formula: slow performance
2008-01-11 17:42 UTC Jörg Kiegeland <kiegeland@ikv.de>
[2+ messages in thread]
not exists clause
2008-01-10 20:15 UTC S Golly <gollykai@gmail.com>
` Re: not exists clause
2008-01-10 21:50 UTC Josh Berkus <josh@agliodbs.com>
` Re: not exists clause
2008-01-11 04:00 UTC Guy Rouillier <guyr-ml1@burntmail.com>
[3+ messages in thread]
big database performance
2008-01-09 08:18 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: big database performance
2008-01-09 08:27 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: big database performance
2008-01-09 08:42 UTC Frank Habermann <lordlamer@lordlamer.de>
` Re: big database performance
2008-01-09 12:53 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: big database performance
2008-01-09 16:16 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: big database performance
2008-01-09 16:50 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: big database performance
2008-01-09 16:59 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: big database performance
2008-01-09 17:42 UTC Jared Mauch <jared@puck.nether.net>
` Re: big database performance
2008-01-09 18:44 UTC Greg Smith <gsmith@gregsmith.com>
` Re: big database performance
2008-01-09 21:01 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: big database performance
2008-01-10 08:45 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: big database performance
2008-01-10 08:57 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: big database performance
2008-01-10 11:08 UTC Stephane Bailliez <sbailliez@gmail.com>
` Re: big database performance
2008-01-10 14:21 UTC Jared Mauch <jared@puck.nether.net>
` Re: big database performance
2008-01-10 14:34 UTC Jared Mauch <jared@puck.nether.net>
[15+ messages in thread]
Search for fixed set of keywords
2008-01-09 10:43 UTC Jörg Kiegeland <kiegeland@ikv.de>
` Re: Search for fixed set of keywords
2008-01-09 10:55 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: Search for fixed set of keywords
2008-01-10 09:23 UTC Jörg Kiegeland <kiegeland@ikv.de>
` Re: Search for fixed set of keywords
2008-01-10 12:05 UTC Oleg Bartunov <oleg@sai.msu.su>
[4+ messages in thread]
After Vacuum Analyse - Procedure performance not improved - Innner select is faster
2008-01-09 04:03 UTC Anoo Sivadasan Pillai <aspillai@in.rm.com>
` Re: After Vacuum Analyse - Procedure performance not improved - Innner select is faster
2008-01-09 05:06 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster
2008-01-09 06:00 UTC Anoo Sivadasan Pillai <aspillai@in.rm.com>
` Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster
2008-01-09 18:06 UTC Erik Jones <erik@myemma.com>
[4+ messages in thread]
Loss of cache when persistent connexion is closed
2008-01-08 15:35 UTC Guillaume Pungeot <gpungeot@gmail.com>
` Re: Loss of cache when persistent connexion is closed
2008-01-09 00:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
concurrent inserts into two separate tables are very slow
2008-01-06 03:00 UTC Sergei Shelukhin <realgeek@gmail.com>
` Re: concurrent inserts into two separate tables are very slow
2008-01-07 22:17 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: concurrent inserts into two separate tables are very slow
2008-01-07 22:49 UTC Sergei Shelukhin <realgeek@gmail.com>
` Re: concurrent inserts into two separate tables are very slow
2008-01-07 23:08 UTC Scott Marlowe <scott.marlowe@gmail.com>
[4+ messages in thread]
Commit takes a long time.
2008-01-03 14:35 UTC Peter Childs <peterachilds@gmail.com>
` Re: Commit takes a long time.
2008-01-03 16:20 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Commit takes a long time.
2008-01-03 16:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Commit takes a long time.
2008-01-04 08:46 UTC Peter Childs <peterachilds@gmail.com>
` Re: Commit takes a long time.
2008-01-04 10:17 UTC Simon Riggs <simon@2ndquadrant.com>
[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