pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion about disk IO an index use and seeking advice
2008-04-24 13:59 UTC Nikolas Everett <nik9000@gmail.com>
` Re: Question about disk IO an index use and seeking advice
2008-04-24 15:27 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Question about disk IO an index use and seeking advice
2008-04-24 16:56 UTC PFC <lists@peufeu.com>
` Re: Question about disk IO an index use and seeking advice
2008-04-24 18:19 UTC Nikolas Everett <nik9000@gmail.com>
` Re: Question about disk IO an index use and seeking advice
2008-04-24 20:02 UTC PFC <lists@peufeu.com>
[5+ messages in thread]
SELECT 'DBD::Pg ping test'
2008-04-23 07:19 UTC sathiya psql <sathiya.psql@gmail.com>
` Re: SELECT 'DBD::Pg ping test'
2008-04-23 08:28 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: SELECT 'DBD::Pg ping test'
2008-04-23 16:40 UTC Jeffrey Baker <jwbaker@gmail.com>
[3+ messages in thread]
mysterious difference in speed when combining two queries with OR
2008-04-23 07:23 UTC Hans Ekbrand <hans.ekbrand@sociology.gu.se>
` Re: mysterious difference in speed when combining two queries with OR
2008-04-23 07:58 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: mysterious difference in speed when combining two queries with OR
2008-04-23 08:57 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: mysterious difference in speed when combining two queries with OR
2008-04-23 09:06 UTC hans <hans.ekbrand@sociology.gu.se>
` Re: mysterious difference in speed when combining two queries with OR
2008-04-23 09:22 UTC Hans Ekbrand <hans.ekbrand@sociology.gu.se>
` Re: mysterious difference in speed when combining two queries with OR
2008-04-23 11:00 UTC Theo Kramer <theo@flame.co.za>
` Re: mysterious difference in speed when combining two queries with OR
2008-04-23 12:56 UTC PFC <lists@peufeu.com>
` Re: mysterious difference in speed when combining two queries with OR
2008-04-23 13:31 UTC Gregory Stark <stark@enterprisedb.com>
[8+ messages in thread]
Suspicious top output
2008-04-22 18:34 UTC Rafael Barrera Oro <rafael@akyasociados.com.ar>
` Re: Suspicious top output
2008-04-22 23:50 UTC Ivan Voras <ivoras@geri.cc.fer.hr>
` Re: Suspicious top output
2008-04-23 05:43 UTC Greg Smith <gsmith@gregsmith.com>
[3+ messages in thread]
Background writer underemphasized ...
2008-04-16 15:22 UTC Marinos Yannikos <mjy@geizhals.at>
` Re: Background writer underemphasized ...
2008-04-16 17:47 UTC Chris Browne <cbbrowne@acm.org>
` Re: Background writer underemphasized ...
2008-04-16 18:43 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Background writer underemphasized ...
2008-04-16 19:45 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Background writer underemphasized ...
2008-04-16 19:55 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Background writer underemphasized ...
2008-04-16 20:07 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Background writer underemphasized ...
2008-04-17 18:46 UTC Marinos Yannikos <mjy@geizhals.at>
` Re: Background writer underemphasized ...
2008-04-19 09:22 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Background writer underemphasized ...
2008-04-19 15:06 UTC James Mansion <james@mansionfamily.plus.com>
` Re: Background writer underemphasized ...
2008-04-19 19:29 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Background writer underemphasized ...
2008-04-20 14:41 UTC James Mansion <james@mansionfamily.plus.com>
` Re: Background writer underemphasized ...
2008-04-23 05:11 UTC Greg Smith <gsmith@gregsmith.com>
[12+ messages in thread]
[PERFORMANCE] Error loading 37G CSV file "invalid string enlargement request size 65536"
2008-04-22 21:05 UTC Adonias Malosso <malosso@gmail.com>
` Re: [PERFORMANCE] Error loading 37G CSV file "invalid string enlargement request size 65536"
2008-04-22 21:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORMANCE] Error loading 37G CSV file "invalid string enlargement request size 65536"
2008-04-23 03:31 UTC Shane Ambler <pgsql@Sheeky.Biz>
[3+ messages in thread]
connections slowing everything down?
2008-04-21 09:50 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: connections slowing everything down?
2008-04-21 14:04 UTC Erik Jones <erik@myemma.com>
` Re: connections slowing everything down?
2008-04-21 14:15 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: connections slowing everything down?
2008-04-21 14:46 UTC Erik Jones <erik@myemma.com>
` Re: connections slowing everything down?
2008-04-23 00:46 UTC Merlin Moncure <mmoncure@gmail.com>
[5+ messages in thread]
CPU bound at 99%
2008-04-22 15:31 UTC Bryan Buecking <buecking@gmail.com>
` Re: CPU bound at 99%
2008-04-22 15:41 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: CPU bound at 99%
2008-04-22 15:55 UTC Erik Jones <erik@myemma.com>
` Re: CPU bound at 99%
2008-04-22 15:56 UTC Bryan Buecking <buecking@gmail.com>
` Re: CPU bound at 99%
2008-04-22 16:10 UTC Bryan Buecking <buecking@gmail.com>
` Re: CPU bound at 99%
2008-04-22 16:15 UTC Harald Armin Massa <haraldarminmassa@gmail.com>
` Re: CPU bound at 99%
2008-04-22 16:16 UTC Bryan Buecking <buecking@gmail.com>
` Re: CPU bound at 99%
2008-04-22 16:21 UTC Rodrigo Gonzalez <rjgonzale@gmail.com>
` Re: CPU bound at 99%
2008-04-22 16:22 UTC Bryan Buecking <buecking@gmail.com>
` Re: CPU bound at 99%
2008-04-22 16:23 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: CPU bound at 99%
2008-04-22 16:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: CPU bound at 99%
2008-04-22 16:36 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: CPU bound at 99%
2008-04-22 16:45 UTC PFC <lists@peufeu.com>
` Re: CPU bound at 99%
2008-04-22 23:58 UTC Ivan Voras <ivoras@geri.cc.fer.hr>
[14+ messages in thread]
Group by more efficient than distinct?
2008-04-18 03:46 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Group by more efficient than distinct?
2008-04-18 08:25 UTC Thomas Pundt <mlists@rp-online.de>
` Re: Group by more efficient than distinct?
2008-04-18 09:36 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Group by more efficient than distinct?
2008-04-18 10:35 UTC PFC <lists@peufeu.com>
` Re: Group by more efficient than distinct?
2008-04-20 15:12 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Group by more efficient than distinct?
2008-04-20 15:15 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Group by more efficient than distinct?
2008-04-21 05:35 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Group by more efficient than distinct?
2008-04-21 23:34 UTC PFC <lists@peufeu.com>
` Re: Group by more efficient than distinct?
2008-04-21 23:50 UTC Mark Mielke <mark@mark.mielke.cc>
` Re: Group by more efficient than distinct?
2008-04-22 01:39 UTC Mark Mielke <mark@mark.mielke.cc>
` Re: Group by more efficient than distinct?
2008-04-22 10:34 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Group by more efficient than distinct?
2008-04-22 12:01 UTC Mark Mielke <mark@mark.mielke.cc>
` Re: Group by more efficient than distinct?
2008-04-22 12:22 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Group by more efficient than distinct?
2008-04-22 13:04 UTC Mark Mielke <mark@mark.mielke.cc>
[14+ messages in thread]
Vacuum settings
2008-04-20 17:48 UTC dforums <dforums@vieonet.com>
` Re: Vacuum settings
2008-04-21 15:03 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Vacuum settings
2008-04-21 15:31 UTC Guillaume Cottenceau <gc@mnc.ch>
[3+ messages in thread]
Exact index overhead
2008-04-17 09:27 UTC Gunther Mayer <gunther.mayer@googlemail.com>
` Re: Exact index overhead
2008-04-17 10:00 UTC Richard Huxton <dev@archonet.com>
` Re: Exact index overhead
2008-04-17 10:02 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Exact index overhead
2008-04-17 10:16 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Exact index overhead
2008-04-17 15:42 UTC Gunther Mayer <gunther.mayer@googlemail.com>
` Re: Exact index overhead
2008-04-19 16:48 UTC Scott Marlowe <scott.marlowe@gmail.com>
[6+ messages in thread]
3-days-long vacuum of 20GB table
2008-04-18 16:35 UTC Jeffrey Baker <jwbaker@gmail.com>
` Re: 3-days-long vacuum of 20GB table
2008-04-18 17:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 3-days-long vacuum of 20GB table
2008-04-18 17:32 UTC Jeffrey Baker <jwbaker@gmail.com>
` Re: 3-days-long vacuum of 20GB table
2008-04-18 17:34 UTC Jeffrey Baker <jwbaker@gmail.com>
` Re: 3-days-long vacuum of 20GB table
2008-04-18 17:54 UTC Jeffrey Baker <jwbaker@gmail.com>
` Re: 3-days-long vacuum of 20GB table
2008-04-18 18:24 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: 3-days-long vacuum of 20GB table
2008-04-18 19:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 3-days-long vacuum of 20GB table
2008-04-19 05:57 UTC Heikki Linnakangas <heikki@enterprisedb.com>
[8+ messages in thread]
Message queue table..
2008-04-18 17:49 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Message queue table..
2008-04-18 18:18 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Message queue table..
2008-04-18 19:23 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Message queue table..
2008-04-18 19:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Message queue table..
2008-04-18 19:57 UTC Chris Browne <cbbrowne@acm.org>
[5+ messages in thread]
full_page_write and also compressed logging
2008-04-18 19:55 UTC James Mansion <james@mansionfamily.plus.com>
Performance increase with elevator=deadline
2008-04-11 11:22 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Performance increase with elevator=deadline
2008-04-11 14:47 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Performance increase with elevator=deadline
2008-04-11 15:09 UTC Jeff <threshar@torgo.978.org>
` Re: Performance increase with elevator=deadline
2008-04-11 16:40 UTC Matthew <matthew@flymine.org>
` Re: Performance increase with elevator=deadline
2008-04-11 18:03 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Performance increase with elevator=deadline
2008-04-11 19:56 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Performance increase with elevator=deadline
2008-04-15 13:27 UTC Florian Weimer <fweimer@bfk.de>
` Re: Performance increase with elevator=deadline
2008-04-15 19:08 UTC david@lang.hm
` Re: Performance increase with elevator=deadline
2008-04-16 05:27 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Performance increase with elevator=deadline
2008-04-18 14:38 UTC Enrico Sirola <enrico.sirola@gmail.com>
[10+ messages in thread]
SQL Function Slowness, 8.3.0
2008-04-16 15:06 UTC Gavin M. Roy <gmr@myyearbook.com>
` Re: SQL Function Slowness, 8.3.0
2008-04-16 15:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL Function Slowness, 8.3.0
2008-04-16 15:14 UTC Mark Mielke <mark@mark.mielke.cc>
` Re: SQL Function Slowness, 8.3.0
2008-04-16 18:44 UTC Gavin M. Roy <gmr@myyearbook.com>
` Re: SQL Function Slowness, 8.3.0
2008-04-16 18:58 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: SQL Function Slowness, 8.3.0
2008-04-16 20:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL Function Slowness, 8.3.0
2008-04-17 16:12 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: SQL Function Slowness, 8.3.0
2008-04-17 16:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL Function Slowness, 8.3.0
2008-04-17 16:25 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: SQL Function Slowness, 8.3.0
2008-04-17 16:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL Function Slowness, 8.3.0
2008-04-17 16:50 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: SQL Function Slowness, 8.3.0
2008-04-17 17:00 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: SQL Function Slowness, 8.3.0
2008-04-17 17:15 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: SQL Function Slowness, 8.3.0
2008-04-17 23:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL Function Slowness, 8.3.0
2008-04-18 03:41 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: SQL Function Slowness, 8.3.0
2008-04-18 04:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL Function Slowness, 8.3.0
2008-04-18 04:21 UTC Craig Ringer <craig@postnewspapers.com.au>
[17+ messages in thread]
seq scan issue...
2008-04-17 18:24 UTC kevin kempter <kevin@kevinkempterllc.com>
` Re: seq scan issue...
2008-04-17 18:30 UTC Jeffrey Baker <jwbaker@gmail.com>
` Re: seq scan issue...
2008-04-17 18:31 UTC Rodrigo Gonzalez <rjgonzale@gmail.com>
` Re: seq scan issue...
2008-04-17 23:53 UTC PFC <lists@peufeu.com>
[4+ messages in thread]
POSIX file updates
2008-03-31 19:53 UTC James Mansion <james@mansionfamily.plus.com>
` Re: POSIX file updates
2008-03-31 20:02 UTC Mark Mielke <mark@mark.mielke.cc>
` Re: POSIX file updates
2008-03-31 20:41 UTC James Mansion <james@mansionfamily.plus.com>
` Re: POSIX file updates
2008-03-31 20:57 UTC James Mansion <james@mansionfamily.plus.com>
` Re: POSIX file updates
2008-03-31 21:28 UTC James Mansion <james@mansionfamily.plus.com>
` Re: POSIX file updates
2008-03-31 22:44 UTC Greg Smith <gsmith@gregsmith.com>
` Re: POSIX file updates
2008-04-01 05:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: POSIX file updates
2008-04-02 19:10 UTC James Mansion <james@mansionfamily.plus.com>
` Re: POSIX file updates
2008-04-02 20:24 UTC Andreas Kostyrka <andreas@kostyrka.org>
` Re: POSIX file updates
2008-04-02 22:48 UTC James Mansion <james@mansionfamily.plus.com>
` Re: POSIX file updates
2008-04-02 23:39 UTC Greg Smith <gsmith@gregsmith.com>
` Re: POSIX file updates
2008-04-02 23:49 UTC Greg Smith <gsmith@gregsmith.com>
` Re: POSIX file updates
2008-04-03 05:32 UTC James Mansion <james@mansionfamily.plus.com>
` Re: POSIX file updates
2008-04-17 18:19 UTC Greg Smith <gsmith@gregsmith.com>
[14+ messages in thread]
rename constraint
2008-04-17 12:03 UTC sathiya psql <sathiya.psql@gmail.com>
` Re: rename constraint
2008-04-17 12:14 UTC Thomas Spreng <spreng@socket.ch>
[2+ messages in thread]
db size
2008-04-14 06:29 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: db size
2008-04-14 06:55 UTC Vinubalaji Gopal <VGopal@abaca.com>
` Re: db size
2008-04-14 08:37 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: db size
2008-04-14 09:18 UTC PFC <lists@peufeu.com>
` Re: db size
2008-04-14 09:21 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: db size
2008-04-14 09:33 UTC PFC <lists@peufeu.com>
` Re: db size
2008-04-14 09:44 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: db size
2008-04-14 10:01 UTC PFC <lists@peufeu.com>
` Re: db size
2008-04-14 10:40 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: db size
2008-04-14 13:12 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: db size
2008-04-15 07:33 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: db size
2008-04-15 11:12 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: db size
2008-04-17 06:28 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: db size
2008-04-17 08:15 UTC Richard Huxton <dev@archonet.com>
` Re: db size
2008-04-17 08:37 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: db size
2008-04-17 08:43 UTC Adrian Moisey <adrian@careerjunction.co.za>
` Re: db size
2008-04-17 08:52 UTC Richard Huxton <dev@archonet.com>
[17+ messages in thread]
Query running slow
2008-04-16 21:14 UTC samantha mahindrakar <sam.mahindrakar@gmail.com>
` Re: Query running slow
2008-04-16 23:19 UTC PFC <lists@peufeu.com>
[2+ messages in thread]
Anybody using the Dell Powervault MD3000 array?
2008-04-16 20:15 UTC Jeffrey Baker <jwbaker@gmail.com>
` Re: Anybody using the Dell Powervault MD3000 array?
2008-04-16 20:17 UTC Gavin M. Roy <gmr@myyearbook.com>
` Re: Anybody using the Dell Powervault MD3000 array?
2008-04-16 20:20 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Anybody using the Dell Powervault MD3000 array?
2008-04-16 20:37 UTC Jeffrey Baker <jwbaker@gmail.com>
` Re: Anybody using the Dell Powervault MD3000 array?
2008-04-16 20:39 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Anybody using the Dell Powervault MD3000 array?
2008-04-16 20:52 UTC Gavin M. Roy <gmr@myyearbook.com>
` Re: Anybody using the Dell Powervault MD3000 array?
2008-04-16 22:47 UTC Craig James <craig_james@emolecules.com>
[7+ messages in thread]
varchar index joins not working?
2008-04-10 03:13 UTC Adam Gundy <adam@starsilk.net>
` Re: varchar index joins not working?
2008-04-10 08:46 UTC Richard Huxton <dev@archonet.com>
` Re: varchar index joins not working?
2008-04-10 14:52 UTC Adam Gundy <adam@starsilk.net>
` Re: varchar index joins not working?
2008-04-10 18:54 UTC Adam Gundy <adam@starsilk.net>
` Re: varchar index joins not working?
2008-04-14 07:14 UTC Richard Huxton <dev@archonet.com>
` Re: varchar index joins not working?
2008-04-14 17:02 UTC Adam Gundy <adam@starsilk.net>
` Re: varchar index joins not working?
2008-04-14 17:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: varchar index joins not working?
2008-04-14 17:54 UTC Richard Huxton <dev@archonet.com>
` Re: varchar index joins not working?
2008-04-14 21:13 UTC Adam Gundy <adam@starsilk.net>
` Re: varchar index joins not working?
2008-04-14 22:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: varchar index joins not working?
2008-04-14 22:16 UTC Adam Gundy <adam@starsilk.net>
[11+ messages in thread]
Re: Cached Query Plans
2008-04-12 09:13 UTC PFC <lists@peufeu.com>
Performance is low Postgres+Solaris
2008-04-03 11:45 UTC MUNAGALA REDDY <munagalar@yahoo.com>
` Re: Performance is low Postgres+Solaris
2008-04-10 23:22 UTC Reid Thompson <reid.thompson@ateb.com>
` Re: Performance is low Postgres+Solaris
2008-04-10 23:30 UTC Reid Thompson <reid.thompson@ateb.com>
` Re: Performance is low Postgres+Solaris
2008-04-11 20:26 UTC Greg Smith <gsmith@gregsmith.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