pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedGuidance Requested - Bulk Inserting + Queries
2011-11-30 15:27 UTC Benjamin Johnson <benjamin.johnson@getcarbonblack.com>
` Re: Guidance Requested - Bulk Inserting + Queries
2011-11-30 16:17 UTC Leonardo Francalanci <m_lists@yahoo.it>
` Re: Guidance Requested - Bulk Inserting + Queries
2011-12-01 02:00 UTC Benjamin Johnson <benjamin.johnson@getcarbonblack.com>
` Re: Guidance Requested - Bulk Inserting + Queries
2011-12-01 15:06 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Guidance Requested - Bulk Inserting + Queries
2011-12-22 02:30 UTC Benjamin Johnson <benjamin.johnson@getcarbonblack.com>
` Re: Guidance Requested - Bulk Inserting + Queries
2011-12-22 08:04 UTC Jeff Janes <jeff.janes@gmail.com>
[6+ messages in thread]
Re: OOM-killer issue with a specific query SOLVED
2011-12-21 05:09 UTC nabble.30.miller_2555@spamgourmet.com
Re: OOM-killer issue with a specific query 9 of 20)
2011-12-20 16:46 UTC nabble.30.miller_2555@spamgourmet.com
` Re: OOM-killer issue with a specific query 9 of 20)
2011-12-20 20:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Re: OOM-killer issue with a specific query 11 of 20)
2011-12-20 18:33 UTC nabble.30.miller_2555@spamgourmet.com
OOM-killer issue with a specific query
2011-12-19 15:52 UTC nabble.30.miller_2555@spamgourmet.com
` Re: OOM-killer issue with a specific query
2011-12-20 13:24 UTC Scott Marlowe <scott.marlowe@gmail.com>
[2+ messages in thread]
will the planner ever use an index when the condition is <> ?
2011-12-17 15:30 UTC Roxanne Reid-Bennett <rox@tara-lu.com>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-17 16:24 UTC Filip Rembiałkowski <plk.zuber@gmail.com>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-18 10:41 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-18 14:52 UTC Roxanne Reid-Bennett <rox@tara-lu.com>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-18 18:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-18 20:11 UTC Marti Raudsepp <marti@juffo.org>
` Re: will the planner ever use an index when the condition is <> ?
2011-12-18 20:18 UTC Roxanne Reid-Bennett <rox@tara-lu.com>
[7+ messages in thread]
Is it possible to use index on column for regexp match operator '~'?
2011-12-14 16:05 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: Is it possible to use index on column for regexp match operator '~'?
2011-12-14 20:43 UTC Marti Raudsepp <marti@juffo.org>
` Re: Is it possible to use index on column for regexp match operator '~'?
2011-12-15 01:54 UTC Rural Hunter <ruralhunter@gmail.com>
[3+ messages in thread]
Slow query after upgrade from 8.2 to 8.4
2011-12-08 17:29 UTC Kaloyan Iliev Iliev <kaloyan@digsys.bg>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-08 17:52 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-09 03:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-09 12:23 UTC Kaloyan Iliev Iliev <kaloyan@digsys.bg>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-09 15:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-13 22:13 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Slow query after upgrade from 8.2 to 8.4
2011-12-14 17:48 UTC Kaloyan Iliev Iliev <kaloyan@digsys.bg>
[7+ messages in thread]
Partitions and joins lead to index lookups on all partitions
2011-12-07 15:15 UTC Christiaan Willemsen <cwillemsen@technocon.com>
` Re: Partitions and joins lead to index lookups on all partitions
2011-12-07 21:36 UTC Ondrej Ivanič <ondrej.ivanic@gmail.com>
` Re: Partitions and joins lead to index lookups on all partitions
2011-12-08 13:57 UTC voodooless <cwillemsen@technocon.com>
` Re: Partitions and joins lead to index lookups on all partitions
2011-12-14 16:06 UTC voodooless <cwillemsen@technocon.com>
[4+ messages in thread]
Postgres array parser
2011-12-13 13:55 UTC Aleksej Trofimov <aleksej.trofimov@ruptela.lt>
` Re: Postgres array parser
2011-12-13 14:02 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Postgres array parser
2011-12-13 14:28 UTC Aleksej Trofimov <aleksej.trofimov@ruptela.lt>
` Re: Postgres array parser
2011-12-13 14:42 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Postgres array parser
2011-12-14 09:21 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Postgres array parser
2011-12-14 09:59 UTC Aleksej Trofimov <aleksej.trofimov@ruptela.lt>
` Re: Postgres array parser
2011-12-14 10:27 UTC Marc Mamin <M.Mamin@intershop.de>
[7+ messages in thread]
select distinct uses index scan vs full table scan
2011-12-13 18:12 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: select distinct uses index scan vs full table scan
2011-12-13 19:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: select distinct uses index scan vs full table scan
2011-12-13 20:17 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
[3+ messages in thread]
autovacuum, exclude table
2011-12-12 14:25 UTC Anibal David Acosta <aa@devshock.com>
` Re: autovacuum, exclude table
2011-12-12 14:45 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: autovacuum, exclude table
2011-12-12 14:55 UTC Anibal David Acosta <aa@devshock.com>
` Re: autovacuum, exclude table
2011-12-12 15:16 UTC Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
` Re: autovacuum, exclude table
2011-12-12 15:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Common slow query reasons - help with a special log
2011-12-10 16:52 UTC Daniel Cristian Cruz <danielcristian@gmail.com>
` Re: Common slow query reasons - help with a special log
2011-12-10 17:25 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Common slow query reasons - help with a special log
2011-12-10 17:25 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Common slow query reasons - help with a special log
2011-12-10 22:40 UTC Daniel Cristian Cruz <danielcristian@gmail.com>
` Re: Common slow query reasons - help with a special log
2011-12-10 23:50 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Common slow query reasons - help with a special log
2011-12-11 01:27 UTC Daniel Cristian Cruz <danielcristian@gmail.com>
` Re: Common slow query reasons - help with a special log
2011-12-11 03:11 UTC Tomas Vondra <tv@fuzzy.cz>
[7+ messages in thread]
pg_upgrade
2011-12-03 04:09 UTC Tory M Blue <tmblue@gmail.com>
` Re: pg_upgrade
2011-12-03 14:03 UTC Klaus Ita <klaus@worstofall.com>
` Re: pg_upgrade
2011-12-03 14:04 UTC Bruce Momjian <bruce@momjian.us>
` Re: pg_upgrade
2011-12-03 19:35 UTC Tory M Blue <tmblue@gmail.com>
` Re: pg_upgrade
2011-12-03 23:42 UTC Bruce Momjian <bruce@momjian.us>
` Re: pg_upgrade
2011-12-04 02:20 UTC Bruce Momjian <bruce@momjian.us>
` Re: pg_upgrade
2011-12-05 13:36 UTC Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com>
` Re: pg_upgrade
2011-12-05 15:24 UTC Bruce Momjian <bruce@momjian.us>
` Re: pg_upgrade
2011-12-05 15:29 UTC Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com>
` Re: pg_upgrade
2011-12-05 15:34 UTC Bruce Momjian <bruce@momjian.us>
` Re: pg_upgrade
2011-12-05 17:21 UTC Tory M Blue <tmblue@gmail.com>
` Re: pg_upgrade
2011-12-05 18:22 UTC Bruce Momjian <bruce@momjian.us>
` Re: pg_upgrade
2011-12-05 18:31 UTC Tory M Blue <tmblue@gmail.com>
` Re: pg_upgrade
2011-12-05 19:00 UTC Tory M Blue <tmblue@gmail.com>
` Re: pg_upgrade
2011-12-05 19:08 UTC Bruce Momjian <bruce@momjian.us>
` Re: pg_upgrade
2011-12-05 19:08 UTC Bruce Momjian <bruce@momjian.us>
` Re: pg_upgrade
2011-12-05 23:25 UTC Tory M Blue <tmblue@gmail.com>
` Re: pg_upgrade
2011-12-07 20:13 UTC Tory M Blue <tmblue@gmail.com>
` Re: pg_upgrade
2011-12-08 20:14 UTC Bruce Momjian <bruce@momjian.us>
[19+ messages in thread]
Response time increases over time
2011-12-06 21:30 UTC Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>
` Re: Response time increases over time
2011-12-07 04:11 UTC Josh Berkus <josh@agliodbs.com>
` Re: Response time increases over time
2011-12-07 08:23 UTC Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>
` Re: Response time increases over time
2011-12-07 09:35 UTC Mario Splivalo <mario.splivalo@megafon.hr>
` Re: Response time increases over time
2011-12-07 22:13 UTC Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>
` Re: Response time increases over time
2011-12-08 04:37 UTC Aidan Van Dyk <aidan@highrise.ca>
` Re: Response time increases over time
2011-12-08 08:50 UTC Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>
` Re: Response time increases over time
2011-12-08 13:44 UTC Marti Raudsepp <marti@juffo.org>
` Re: Response time increases over time
2011-12-08 15:48 UTC Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>
` Re: Response time increases over time
2011-12-08 15:58 UTC Bob Lunney <bob_lunney@yahoo.com>
` Re: Response time increases over time
2011-12-08 17:21 UTC Havasvölgyi Ottó <havasvolgyi.otto@gmail.com>
[11+ messages in thread]
autovacuum, any log?
2011-12-07 15:34 UTC Anibal David Acosta <aa@devshock.com>
` Re: autovacuum, any log?
2011-12-07 20:19 UTC Scott Marlowe <scott.marlowe@gmail.com>
[2+ messages in thread]
Question about VACUUM
2011-12-03 03:32 UTC Ernesto Quiñones <ernestoq@gmail.com>
` Re: Question about VACUUM
2011-12-03 03:42 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Question about VACUUM
2011-12-03 13:11 UTC Ernesto Quiñones <ernestoq@gmail.com>
` Re: Question about VACUUM
2011-12-03 16:00 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Question about VACUUM
2011-12-03 20:05 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Question about VACUUM
2011-12-05 17:19 UTC Ernesto Quiñones <ernestoq@gmail.com>
` Re: Question about VACUUM
2011-12-05 17:42 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Question about VACUUM
2011-12-05 17:44 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Question about VACUUM
2011-12-05 17:46 UTC Ernesto Quiñones <ernestoq@gmail.com>
` Re: Question about VACUUM
2011-12-05 18:36 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Question about VACUUM
2011-12-05 20:29 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Question about VACUUM
2011-12-07 04:13 UTC Josh Berkus <josh@agliodbs.com>
` Re: Question about VACUUM
2011-12-07 15:14 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[13+ messages in thread]
Intersect/Union X AND/OR
2011-12-02 15:55 UTC Thiago Godoi <thiagogodoi10@gmail.com>
` Re: Intersect/Union X AND/OR
2011-12-02 19:49 UTC Bruce Momjian <bruce@momjian.us>
` Re: Intersect/Union X AND/OR
2011-12-02 20:52 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Intersect/Union X AND/OR
2011-12-05 12:14 UTC Thiago Godoi <thiagogodoi10@gmail.com>
` Re: Intersect/Union X AND/OR
2011-12-05 15:19 UTC Bruce Momjian <bruce@momjian.us>
` Re: Intersect/Union X AND/OR
2011-12-07 14:56 UTC Marti Raudsepp <marti@juffo.org>
[6+ messages in thread]
Different query plans on same servers
2011-12-06 19:48 UTC Mario Splivalo <mario.splivalo@megafon.hr>
` Re: Different query plans on same servers
2011-12-06 20:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Different query plans on same servers
2011-12-06 20:17 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Different query plans on same servers
2011-12-06 20:29 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Different query plans on same servers
2011-12-07 00:23 UTC Mario Splivalo <mario.splivalo@megafon.hr>
` Re: Different query plans on same servers
2011-12-07 00:27 UTC Mario Splivalo <mario.splivalo@megafon.hr>
` Re: Different query plans on same servers
2011-12-07 00:35 UTC Mario Splivalo <mario.splivalo@megafon.hr>
` Re: Different query plans on same servers
2011-12-07 09:34 UTC Mario Splivalo <mario.splivalo@megafon.hr>
[8+ messages in thread]
manually force planner to use of index A vs index B
2011-12-03 14:34 UTC MirrorX <mirrorx@gmail.com>
` Re: manually force planner to use of index A vs index B
2011-12-03 15:10 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: manually force planner to use of index A vs index B
2011-12-03 15:15 UTC MirrorX <mirrorx@gmail.com>
[3+ messages in thread]
Autovacuum Issue
2011-11-23 05:55 UTC J Ramesh Kumar <rameshj1977@gmail.com>
` Re: Autovacuum Issue
2011-11-23 06:10 UTC Raghavendra <raghavendra.rao@enterprisedb.com>
` Re: Autovacuum Issue
2011-12-01 18:18 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Autovacuum Issue
2011-12-01 22:35 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Autovacuum Issue
2011-12-02 03:02 UTC Scott Marlowe <scott.marlowe@gmail.com>
[5+ messages in thread]
vacuum internals and performance affect
2011-11-29 17:12 UTC MirrorX <mirrorx@gmail.com>
` Re: vacuum internals and performance affect
2011-11-30 21:19 UTC Josh Berkus <josh@agliodbs.com>
` Re: vacuum internals and performance affect
2011-11-30 21:34 UTC MirrorX <mirrorx@gmail.com>
` Re: vacuum internals and performance affect
2011-12-01 18:01 UTC Josh Berkus <josh@agliodbs.com>
` Re: vacuum internals and performance affect
2011-12-01 19:23 UTC MirrorX <mirrorx@gmail.com>
[5+ messages in thread]
Problems with FTS
2010-12-15 13:56 UTC Rauan Maemirov <rauan@maemirov.com>
` Re: Problems with FTS
2010-12-18 17:56 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Problems with FTS
2011-01-11 08:16 UTC Rauan Maemirov <rauan@maemirov.com>
` Re: Problems with FTS
2011-01-14 19:03 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Problems with FTS
2011-11-21 05:53 UTC Rauan Maemirov <rauan@maemirov.com>
` Re: Problems with FTS
2011-11-30 20:58 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Problems with FTS
2011-12-01 06:11 UTC Jesper Krogh <jesper@krogh.cc>
[7+ messages in thread]
Query planner suggestion, for indexes with similar but not exact ordering.
2011-11-14 22:22 UTC Andrew Barnham <andrew.barnham@gmail.com>
` Re: Query planner suggestion, for indexes with similar but not exact ordering.
2011-11-30 20:50 UTC Robert Haas <robertmhaas@gmail.com>
[2+ messages in thread]
WAL in RAM
2011-10-28 15:28 UTC Marcus Engene <mengpg2@engene.se>
` Re: WAL in RAM
2011-10-28 15:45 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: WAL in RAM
2011-10-28 16:11 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: WAL in RAM
2011-10-28 18:26 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: WAL in RAM
2011-10-28 18:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: WAL in RAM
2011-10-28 19:03 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: WAL in RAM
2011-10-28 19:07 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: WAL in RAM
2011-10-28 19:09 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: WAL in RAM
2011-10-28 19:55 UTC David Boreham <david_list@boreham.org>
` Re: WAL in RAM
2011-10-29 17:54 UTC Marcus Engene <mengpg2@engene.se>
` Re: WAL in RAM
2011-10-29 20:11 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: WAL in RAM
2011-11-29 16:58 UTC Marcus Engene <mengpg2@engene.se>
[12+ 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