pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedREINDEXing database-wide daily
2010-03-30 09:32 UTC Gnanakumar <gnanam@zoniac.com>
` Re: REINDEXing database-wide daily
2010-03-30 14:05 UTC Andy Colson <andy@squeakycode.net>
` Re: REINDEXing database-wide daily
2010-03-30 15:05 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[3+ messages in thread]
why does swap not recover?
2010-03-26 23:57 UTC Richard Yen <dba@richyen.com>
` Re: why does swap not recover?
2010-03-27 00:05 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: why does swap not recover?
2010-03-27 00:25 UTC Scott Carey <scott@richrelevance.com>
` Re: why does swap not recover?
2010-03-27 00:25 UTC Craig James <craig_james@emolecules.com>
` Re: why does swap not recover?
2010-03-28 04:08 UTC Richard Yen <dba@richyen.com>
` Re: why does swap not recover?
2010-03-30 06:18 UTC Josh Berkus <josh@agliodbs.com>
` Re: why does swap not recover?
2010-03-30 14:57 UTC Robert Haas <robertmhaas@gmail.com>
[7+ messages in thread]
Why Wal_buffer is 64KB
2010-03-25 15:01 UTC Tadipathri Raghu <traghu.dba@gmail.com>
` Re: Why Wal_buffer is 64KB
2010-03-25 16:05 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: Why Wal_buffer is 64KB
2010-03-25 17:15 UTC Jaime Casanova <jcasanov@systemguards.com.ec>
` Re: Why Wal_buffer is 64KB
2010-03-25 18:14 UTC Pierre C <lists@peufeu.com>
` Re: Why Wal_buffer is 64KB
2010-03-26 03:19 UTC Tadipathri Raghu <traghu.dba@gmail.com>
` Re: Why Wal_buffer is 64KB
2010-03-26 13:43 UTC Pierre C <lists@peufeu.com>
` Re: Why Wal_buffer is 64KB
2010-03-26 14:00 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Why Wal_buffer is 64KB
2010-03-29 06:00 UTC Tadipathri Raghu <traghu.dba@gmail.com>
` Re: Why Wal_buffer is 64KB
2010-03-29 06:45 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Why Wal_buffer is 64KB
2010-03-29 07:05 UTC Tadipathri Raghu <traghu.dba@gmail.com>
` Re: Why Wal_buffer is 64KB
2010-03-30 14:43 UTC Robert Haas <robertmhaas@gmail.com>
[11+ messages in thread]
Performance regarding LIKE searches
2010-03-29 16:42 UTC randalls@bioinfo.wsu.edu
` Re: Performance regarding LIKE searches
2010-03-29 17:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance regarding LIKE searches
2010-03-29 17:23 UTC randalls@bioinfo.wsu.edu
` Re: Performance regarding LIKE searches
2010-03-29 17:36 UTC Andy Colson <andy@squeakycode.net>
` Re: Performance regarding LIKE searches
2010-03-30 09:34 UTC Matthew Wakeling <matthew@flymine.org>
[5+ messages in thread]
transaction overhead at "on commit delete rows";
2010-03-29 13:59 UTC admin@gifts.ru <admin@gifts.ru>
Optimizer showing wrong rows in plan
2010-03-28 06:51 UTC Tadipathri Raghu <traghu.dba@gmail.com>
` Re: Optimizer showing wrong rows in plan
2010-03-28 07:02 UTC Szymon Guz <mabewlun@gmail.com>
` Re: Optimizer showing wrong rows in plan
2010-03-28 07:11 UTC Tadipathri Raghu <traghu.dba@gmail.com>
` Re: Optimizer showing wrong rows in plan
2010-03-28 07:29 UTC Szymon Guz <mabewlun@gmail.com>
` Re: Optimizer showing wrong rows in plan
2010-03-28 07:33 UTC Tadipathri Raghu <traghu.dba@gmail.com>
` Re: Optimizer showing wrong rows in plan
2010-03-28 09:07 UTC Tadipathri Raghu <traghu.dba@gmail.com>
` Re: Optimizer showing wrong rows in plan
2010-03-28 09:18 UTC Frank Heikens <frankheikens@mac.com>
` Re: Optimizer showing wrong rows in plan
2010-03-28 09:27 UTC Gary Doades <gpd@gpdnet.co.uk>
` Re: Optimizer showing wrong rows in plan
2010-03-28 16:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizer showing wrong rows in plan
2010-03-28 17:08 UTC Jeremy Harris <jgh@wizmail.org>
` Re: Optimizer showing wrong rows in plan
2010-03-28 17:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizer showing wrong rows in plan
2010-03-29 04:56 UTC Tadipathri Raghu <traghu.dba@gmail.com>
` Re: Optimizer showing wrong rows in plan
2010-03-29 11:17 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Optimizer showing wrong rows in plan
2010-03-29 12:24 UTC raghavendra t <raagavendra.rao@gmail.com>
` Re: Optimizer showing wrong rows in plan
2010-03-29 13:43 UTC Nikolas Everett <nik9000@gmail.com>
[15+ messages in thread]
Pgbench TPS Calculation
2010-03-27 20:05 UTC Reydan Cankur <reydan.cankur@gmail.com>
` Re: Pgbench TPS Calculation
2010-03-29 04:22 UTC Greg Smith <greg@2ndquadrant.com>
[2+ messages in thread]
Forcing index scan on query produces 16x faster
2010-03-17 21:25 UTC Christian Brink <cbrink@r-stream.com>
` Re: Forcing index scan on query produces 16x faster
2010-03-17 21:56 UTC David Wilson <david.t.wilson@gmail.com>
` Re: Forcing index scan on query produces 16x faster
2010-03-17 22:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Forcing index scan on query produces 16x faster
2010-03-18 01:01 UTC Eger, Patrick <peger@automotive.com>
` Re: Forcing index scan on query produces 16x faster
2010-03-19 00:08 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Forcing index scan on query produces 16x faster
2010-03-25 00:46 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Forcing index scan on query produces 16x faster
2010-03-25 00:59 UTC Eger, Patrick <peger@automotive.com>
` Re: Forcing index scan on query produces 16x faster
2010-03-25 02:16 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Forcing index scan on query produces 16x faster
2010-03-28 21:04 UTC Cédric Villemain <cedric.villemain.debian@gmail.com>
[9+ messages in thread]
Block at a time ...
2010-03-16 23:58 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Block at a time ...
2010-03-17 00:14 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Block at a time ...
2010-03-17 07:32 UTC Pierre C <lists@peufeu.com>
` Re: Block at a time ...
2010-03-17 09:52 UTC Greg Stark <gsstark@mit.edu>
` Re: Block at a time ...
2010-03-17 14:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Block at a time ...
2010-03-17 15:16 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Block at a time ...
2010-03-17 16:41 UTC Craig James <craig_james@emolecules.com>
` Re: Block at a time ...
2010-03-17 17:02 UTC Bob Lunney <bob_lunney@yahoo.com>
` Re: Block at a time ...
2010-03-22 18:47 UTC Scott Carey <scott@richrelevance.com>
` Re: Block at a time ...
2010-03-22 20:55 UTC Pierre C <lists@peufeu.com>
` Re: Block at a time ...
2010-03-22 21:06 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Block at a time ...
2010-03-22 21:25 UTC Greg Stark <gsstark@mit.edu>
` Re: Block at a time ...
2010-03-22 23:46 UTC Craig James <craig_james@emolecules.com>
` Re: Block at a time ...
2010-03-27 00:19 UTC Scott Carey <scott@richrelevance.com>
[14+ messages in thread]
pg_dump far too slow
2010-03-14 08:01 UTC David Newall <postgresql@davidnewall.com>
` Re: pg_dump far too slow
2010-03-14 20:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_dump far too slow
2010-03-16 01:53 UTC Robert Haas <robertmhaas@gmail.com>
` Re: pg_dump far too slow
2010-03-16 03:04 UTC Dave Crooke <dcrooke@gmail.com>
` Re: pg_dump far too slow
2010-03-18 12:15 UTC Matthew Wakeling <matthew@flymine.org>
` Re: pg_dump far too slow
2010-03-21 13:17 UTC David Newall <postgresql@davidnewall.com>
` Re: pg_dump far too slow
2010-03-21 13:56 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: pg_dump far too slow
2010-03-21 14:33 UTC Dave Crooke <dcrooke@gmail.com>
` Re: pg_dump far too slow
2010-03-21 15:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_dump far too slow
2010-03-21 15:50 UTC David Newall <postgresql@davidnewall.com>
` Re: pg_dump far too slow
2010-03-21 18:03 UTC Bob Lunney <bob_lunney@yahoo.com>
` Re: pg_dump far too slow
2010-03-27 00:06 UTC Scott Carey <scott@richrelevance.com>
[12+ messages in thread]
Performance Tuning Large PL/PGSQL Stored Procedure
2010-03-23 21:00 UTC Eliot Gable <egable+pgsql-performance@gmail.com>
` Re: Performance Tuning Large PL/PGSQL Stored Procedure
2010-03-26 02:00 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance Tuning Large PL/PGSQL Stored Procedure
2010-03-26 03:56 UTC Eliot Gable <egable+pgsql-performance@gmail.com>
` Re: Performance Tuning Large PL/PGSQL Stored Procedure
2010-03-26 12:06 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance Tuning Large PL/PGSQL Stored Procedure
2010-03-26 12:18 UTC Richard Huxton <dev@archonet.com>
[5+ messages in thread]
good effective_io_concurrency for FusionIO drives?
2010-03-25 22:19 UTC Richard Yen <dba@richyen.com>
default_statistics_target
2010-03-14 23:27 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: default_statistics_target
2010-03-15 08:33 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: default_statistics_target
2010-03-15 13:18 UTC Greg Smith <greg@2ndquadrant.com>
` Re: default_statistics_target
2010-03-22 22:19 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: default_statistics_target
2010-03-25 15:44 UTC Robert Haas <robertmhaas@gmail.com>
[5+ messages in thread]
Memory question
2003-06-27 19:09 UTC Patrick Hatcher <PHatcher@macys.com>
` Re: Memory question
2003-06-27 19:44 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Memory question
2003-06-27 19:54 UTC Josh Berkus <josh@agliodbs.com>
` Re: Memory question
2003-06-27 19:58 UTC Patrick Hatcher <PHatcher@macys.com>
` Re: Memory question
2003-06-27 19:59 UTC Patrick Hatcher <PHatcher@macys.com>
` Re: Memory question
2003-06-27 20:17 UTC Jord Tanner <jord@indygecko.com>
` Re: Memory question
2003-06-27 20:30 UTC Matthew Hixson <hixson@poindextrose.org>
` Re: Memory question
2003-06-27 20:49 UTC Arjen van der Meijden <acm@tweakers.net>
` Re: Memory question
2003-06-27 20:51 UTC scott.marlowe <scott.marlowe@ihs.com>
` Re: Memory question
2003-06-27 20:55 UTC Arjen van der Meijden <acm@tweakers.net>
` Re: Memory question
2003-06-30 05:49 UTC Thomas Swan <tswan@idigx.com>
` Re: Memory question
2003-06-30 16:02 UTC Jonathan Gardner <jgardner@jonathangardner.net>
` memory question
2010-03-25 00:49 UTC Campbell, Lance <lance@illinois.edu>
` Re: memory question
2010-03-25 02:06 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: memory question
2010-03-25 06:28 UTC Dave Crooke <dcrooke@gmail.com>
` Re: memory question
2010-03-25 10:35 UTC Matthew Wakeling <matthew@flymine.org>
[16+ messages in thread]
PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster
2010-03-22 19:09 UTC Christian Brink <cbrink@r-stream.com>
` Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster
2010-03-22 19:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster
2010-03-22 23:12 UTC Eger, Patrick <peger@automotive.com>
` Re: PostgreSQL upgraded to 8.2 but forcing index scan on query produces faster
2010-03-24 16:06 UTC Christian Brink <cbrink@r-stream.com>
[4+ messages in thread]
tuning auto vacuum for highly active tables
2010-03-23 20:54 UTC Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
` Re: tuning auto vacuum for highly active tables
2010-03-23 21:35 UTC Szu-Ching Peckner <speckner@activedg.com>
` Re: tuning auto vacuum for highly active tables
2010-03-23 21:37 UTC Szu-Ching Peckner <speckner@activedg.com>
` Re: tuning auto vacuum for highly active tables
2010-03-23 21:41 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: tuning auto vacuum for highly active tables
2010-03-23 23:28 UTC Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
` Re: tuning auto vacuum for highly active tables
2010-03-23 23:59 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: tuning auto vacuum for highly active tables
2010-03-24 03:20 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: tuning auto vacuum for highly active tables
2010-03-24 03:22 UTC Alvaro Herrera <alvherre@commandprompt.com>
[8+ messages in thread]
Got that new server, now it's time for config!
2010-03-22 22:36 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Got that new server, now it's time for config!
2010-03-22 23:16 UTC Dan Harris <fbsd@drivefaster.net>
` Re: Got that new server, now it's time for config!
2010-03-23 04:12 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Got that new server, now it's time for config!
2010-03-23 13:08 UTC Scott Mead <scott.lists@enterprisedb.com>
[4+ messages in thread]
Re: GiST index performance
2010-02-25 23:42 UTC Bruce Momjian <bruce@momjian.us>
` Re: GiST index performance
2010-02-25 23:44 UTC Bruce Momjian <bruce@momjian.us>
` Re: GiST index performance
2010-03-02 16:21 UTC Robert Haas <robertmhaas@gmail.com>
` Re: GiST index performance
2010-03-02 16:23 UTC Robert Haas <robertmhaas@gmail.com>
` Re: GiST index performance
2010-03-03 01:13 UTC Bruce Momjian <bruce@momjian.us>
` Re: GiST index performance
2010-03-15 15:58 UTC Matthew Wakeling <matthew@flymine.org>
` Re: GiST index performance
2010-03-16 01:58 UTC Robert Haas <robertmhaas@gmail.com>
` Re: GiST index performance
2010-03-16 16:18 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: GiST index performance
2010-03-17 09:26 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: GiST index performance
2010-03-19 16:31 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: GiST index performance
2010-03-19 20:20 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: GiST index performance
2010-03-19 20:49 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: GiST index performance
2010-03-19 21:16 UTC Kenneth Marshall <ktm@rice.edu>
` Re: GiST index performance
2010-03-20 16:16 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: GiST index performance
2010-03-22 13:29 UTC Matthew Wakeling <matthew@flymine.org>
` Re: GiST index performance
2010-03-22 14:02 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: GiST index performance
2010-03-22 14:23 UTC Matthew Wakeling <matthew@flymine.org>
[17+ messages in thread]
too complex query plan for not exists query and multicolumn indexes
2010-03-19 12:26 UTC Corin <wakathane@gmail.com>
` Re: too complex query plan for not exists query and multicolumn indexes
2010-03-19 13:58 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: too complex query plan for not exists query and multicolumn indexes
2010-03-19 17:02 UTC Justin Graf <zzzzz.graf@gmail.com>
` Re: too complex query plan for not exists query and multicolumn indexes
2010-03-19 18:27 UTC Stephen Frost <sfrost@snowman.net>
` Re: too complex query plan for not exists query and multicolumn indexes
2010-03-19 19:12 UTC Dave Crooke <dcrooke@gmail.com>
` Re: too complex query plan for not exists query and multicolumn indexes
2010-03-22 11:48 UTC Matthew Wakeling <matthew@flymine.org>
` Re: too complex query plan for not exists query and multicolumn indexes
2010-03-22 12:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
[7+ messages in thread]
pgbench installation
2010-03-20 04:50 UTC Reydan Cankur <reydan.cankur@gmail.com>
` Re: pgbench installation
2010-03-22 05:00 UTC Greg Smith <greg@2ndquadrant.com>
[2+ messages in thread]
GZIP of pre-zipped output
2010-03-21 17:04 UTC Dave Crooke <dcrooke@gmail.com>
` Re: GZIP of pre-zipped output
2010-03-22 02:46 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: GZIP of pre-zipped output
2010-03-22 03:00 UTC Scott Marlowe <scott.marlowe@gmail.com>
[3+ messages in thread]
PG using index+filter instead only use index
2010-03-19 13:45 UTC Alexandre de Arruda Paes <adaldeia@gmail.com>
` Re: PG using index+filter instead only use index
2010-03-19 19:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PG using index+filter instead only use index
2010-03-19 21:04 UTC Alexandre de Arruda Paes <adaldeia@gmail.com>
` Re: PG using index+filter instead only use index
2010-03-20 02:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Building multiple indexes concurrently
2010-03-17 01:04 UTC Rob Wultsch <wultsch@gmail.com>
` Re: Building multiple indexes concurrently
2010-03-17 05:13 UTC Ben Chobot <bench@silentmedia.com>
` Re: Building multiple indexes concurrently
2010-03-17 10:11 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Building multiple indexes concurrently
2010-03-17 14:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Building multiple indexes concurrently
2010-03-17 15:07 UTC Rob Wultsch <wultsch@gmail.com>
` Re: Building multiple indexes concurrently
2010-03-17 18:44 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Building multiple indexes concurrently
2010-03-17 19:24 UTC Andres Freund <andres@anarazel.de>
` Re: Building multiple indexes concurrently
2010-03-17 20:24 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Building multiple indexes concurrently
2010-03-17 20:49 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Building multiple indexes concurrently
2010-03-17 21:18 UTC Hannu Krosing <hannu@2ndquadrant.com>
` Re: Building multiple indexes concurrently
2010-03-18 20:12 UTC Justin Pitts <justinpitts@gmail.com>
` Re: Building multiple indexes concurrently
2010-03-18 21:20 UTC Hannu Krosing <hannu@2ndquadrant.com>
` Re: Building multiple indexes concurrently
2010-03-18 21:45 UTC Justin Pitts <justinpitts@gmail.com>
` Re: Building multiple indexes concurrently
2010-03-19 17:38 UTC Andres Freund <andres@anarazel.de>
[14+ messages in thread]
Testing FusionIO
2010-03-08 14:41 UTC Devrim GÜNDÜZ <devrim@gunduz.org>
` Re: Testing FusionIO
2010-03-08 14:53 UTC Łukasz Jagiełło <lukasz.jagiello@gforces.pl>
` Re: Testing FusionIO
2010-03-08 14:55 UTC Yeb Havinga <yebhavinga@gmail.com>
` Re: Testing FusionIO
2010-03-08 17:38 UTC Ben Chobot <bench@silentmedia.com>
` Re: Testing FusionIO
2010-03-08 20:50 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Testing FusionIO
2010-03-08 21:09 UTC Ben Chobot <bench@silentmedia.com>
` Re: Testing FusionIO
2010-03-17 12:30 UTC Devrim GÜNDÜZ <devrim@gunduz.org>
` Re: Testing FusionIO
2010-03-17 13:03 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: Testing FusionIO
2010-03-17 13:11 UTC Justin Pitts <justinpitts@gmail.com>
` Re: Testing FusionIO
2010-03-17 13:18 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: Testing FusionIO
2010-03-17 13:52 UTC Justin Pitts <justinpitts@gmail.com>
` Re: Testing FusionIO
2010-03-17 14:41 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: Testing FusionIO
2010-03-17 18:11 UTC Justin Pitts <justinpitts@gmail.com>
` Re: Testing FusionIO
2010-03-17 19:23 UTC Kenny Gorman <kgorman@kennygorman.com>
` Re: Testing FusionIO
2010-03-17 20:01 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: Testing FusionIO
2010-03-17 20:14 UTC david@lang.hm
` Re: Testing FusionIO
2010-03-17 22:53 UTC Ben Chobot <bench@silentmedia.com>
[17+ messages in thread]
Postgres DB maintainenance - vacuum and reindex
2010-03-16 05:30 UTC Meena_Ramkumar <winmeena_ramkumar@yahoo.co.in>
` Re: Postgres DB maintainenance - vacuum and reindex
2010-03-16 16:58 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres DB maintainenance - vacuum and reindex
2010-03-16 17:06 UTC Ben Chobot <bench@silentmedia.com>
` Re: Postgres DB maintainenance - vacuum and reindex
2010-03-16 17:29 UTC Ing. Marcos Ortiz Valmaseda <mlortiz@uci.cu>
[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