pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedWhy is a hash join being used?
2012-06-19 21:34 UTC Tim Jacobs <tjacobs2@email.unc.edu>
` Re: Why is a hash join being used?
2012-06-20 13:36 UTC Sergey Konoplev <sergey.konoplev@postgresql-consulting.com>
` Re: Why is a hash join being used?
2012-06-22 15:59 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[3+ messages in thread]
random char or text variable in pgbench
2012-06-20 19:51 UTC philippe.beaudoin@bull.net
pgbouncer - massive overhead?
2012-06-19 16:00 UTC Strange, John W <john.w.strange@jpmorgan.com>
` Re: pgbouncer - massive overhead?
2012-06-20 15:27 UTC Steve Crawford <scrawford@pinpointresearch.com>
[2+ messages in thread]
scale up (postgresql vs mssql)
2012-04-11 22:11 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-04-13 14:32 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: scale up (postgresql vs mssql)
2012-04-13 14:40 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: scale up (postgresql vs mssql)
2012-04-13 15:04 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-04-13 16:36 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: scale up (postgresql vs mssql)
2012-04-13 16:43 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-04-13 17:49 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: scale up (postgresql vs mssql)
2012-04-13 17:52 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-04-15 12:43 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-04-16 13:10 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-04-16 15:43 UTC Andy Colson <andy@squeakycode.net>
` Re: scale up (postgresql vs mssql)
2012-04-16 15:55 UTC Richard Huxton <dev@archonet.com>
` Re: scale up (postgresql vs mssql)
2012-04-18 07:32 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-04-18 19:47 UTC Andy Colson <andy@squeakycode.net>
` Re: scale up (postgresql vs mssql)
2012-04-18 20:13 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-04-29 13:21 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-05-03 13:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-05-03 17:07 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-05-04 13:04 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-05-09 07:11 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: scale up (postgresql vs mssql)
2012-05-09 12:53 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: scale up (postgresql vs mssql)
2012-06-20 06:01 UTC Eyal Wilde <eyal@impactsoft.co.il>
` Re: scale up (postgresql vs mssql)
2012-06-20 13:43 UTC Andy Colson <andy@squeakycode.net>
` Re: scale up (postgresql vs mssql)
2012-06-20 14:55 UTC Merlin Moncure <mmoncure@gmail.com>
[24+ messages in thread]
Expected performance of querying 5k records from 4 million records?
2012-06-15 16:17 UTC Anish Kejariwal <anishkej@gmail.com>
` Re: Expected performance of querying 5k records from 4 million records?
2012-06-15 17:44 UTC Josh Berkus <josh@agliodbs.com>
` Re: Expected performance of querying 5k records from 4 million records?
2012-06-15 18:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Expected performance of querying 5k records from 4 million records?
2012-06-18 16:39 UTC Anish Kejariwal <anishkej@gmail.com>
` Re: Expected performance of querying 5k records from 4 million records?
2012-06-18 16:49 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: Expected performance of querying 5k records from 4 million records?
2012-06-18 19:08 UTC Josh Berkus <josh@agliodbs.com>
[6+ messages in thread]
correlated exists with join is slow.
2012-06-18 13:47 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: correlated exists with join is slow.
2012-06-18 14:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: correlated exists with join is slow.
2012-06-18 14:58 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: correlated exists with join is slow.
2012-06-18 15:02 UTC Віталій Тимчишин <tivv00@gmail.com>
[4+ messages in thread]
Update blocking a select count(*)?
2012-06-15 18:22 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 18:32 UTC Peter Geoghegan <peter@2ndquadrant.com>
` Re: Update blocking a select count(*)?
2012-06-15 18:41 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 18:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 18:46 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 18:46 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 18:54 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 19:03 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 19:04 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 19:12 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 19:27 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 19:32 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 19:45 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 19:51 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 19:58 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 20:00 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Update blocking a select count(*)?
2012-06-15 20:29 UTC Benedict Holland <benedict.m.holland@gmail.com>
` Re: Update blocking a select count(*)?
2012-06-15 20:38 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[18+ messages in thread]
Performance of pg_basebackup
2012-06-12 14:54 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Performance of pg_basebackup
2012-06-12 14:57 UTC Magnus Hagander <magnus@hagander.net>
` Re: Performance of pg_basebackup
2012-06-12 15:00 UTC Shaun Thomas <sthomas@optionshouse.com>
[3+ messages in thread]
Performance of CLUSTER
2012-06-10 08:20 UTC Mark Thornton <mthornton@optrak.com>
` Re: Performance of CLUSTER
2012-06-11 13:42 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Performance of CLUSTER
2012-06-11 14:02 UTC Mark Thornton <mthornton@optrak.com>
` Re: Performance of CLUSTER
2012-06-11 14:14 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Performance of CLUSTER
2012-06-11 14:44 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Performance of CLUSTER
2012-06-11 23:53 UTC Jeff Davis <pgsql@j-davis.com>
[6+ messages in thread]
how to change the index chosen in plan?
2012-06-08 13:33 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: how to change the index chosen in plan?
2012-06-08 14:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: how to change the index chosen in plan?
2012-06-08 14:23 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: how to change the index chosen in plan?
2012-06-08 14:37 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to change the index chosen in plan?
2012-06-08 16:23 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: how to change the index chosen in plan?
2012-06-08 16:39 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to change the index chosen in plan?
2012-06-09 02:08 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: how to change the index chosen in plan?
2012-06-09 14:39 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to change the index chosen in plan?
2012-06-09 15:38 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to change the index chosen in plan?
2012-06-11 04:46 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: how to change the index chosen in plan?
2012-06-11 12:07 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: how to change the index chosen in plan?
2012-06-11 12:55 UTC Rural Hunter <ruralhunter@gmail.com>
[12+ messages in thread]
Tablespaces and query planning
2012-06-08 08:15 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Tablespaces and query planning
2012-06-08 10:36 UTC Cédric Villemain <cedric@2ndquadrant.com>
` Re: Tablespaces and query planning
2012-06-11 07:01 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[3+ messages in thread]
partitioning performance question
2012-06-09 17:58 UTC Kevin Kempter <cs_dba@consistentstate.com>
` Re: partitioning performance question
2012-06-10 11:16 UTC Robert Klemme <shortcutter@googlemail.com>
[2+ messages in thread]
pg 9.1 brings host machine down
2012-06-06 12:05 UTC Konstantin Mikhailov <ekimka@gmail.com>
` Re: pg 9.1 brings host machine down
2012-06-06 12:25 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: pg 9.1 brings host machine down
2012-06-06 12:40 UTC Patric Bechtel <patric.bechtel@gmail.com>
` Re: pg 9.1 brings host machine down
2012-06-06 12:55 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: pg 9.1 brings host machine down
2012-06-08 17:52 UTC Konstantin Mikhailov <ekimka@gmail.com>
` Re: pg 9.1 brings host machine down
2012-06-10 03:26 UTC Craig Ringer <ringerc@ringerc.id.au>
[6+ messages in thread]
non index use on LIKE on a non pattern string
2012-06-08 11:11 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: non index use on LIKE on a non pattern string
2012-06-08 11:51 UTC Cédric Villemain <cedric@2ndquadrant.com>
` Re: non index use on LIKE on a non pattern string
2012-06-08 13:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: non index use on LIKE on a non pattern string
2012-06-08 14:31 UTC Cédric Villemain <cedric@2ndquadrant.com>
[4+ messages in thread]
Seqscan slowness and stored procedures
2012-05-26 21:38 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Seqscan slowness and stored procedures
2012-05-27 03:28 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Seqscan slowness and stored procedures
2012-05-27 15:57 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Seqscan slowness and stored procedures
2012-05-27 16:07 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Seqscan slowness and stored procedures
2012-06-08 09:58 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Seqscan slowness and stored procedures
2012-06-08 11:00 UTC Ivan Voras <ivoras@freebsd.org>
[6+ messages in thread]
Multiple Concurrent Updates of Shared Resource Counter
2012-06-07 07:53 UTC Nir Zilberman <nirz@checkpoint.com>
` Re: Multiple Concurrent Updates of Shared Resource Counter
2012-06-07 11:48 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: Multiple Concurrent Updates of Shared Resource Counter
2012-06-08 10:59 UTC Cédric Villemain <cedric@2ndquadrant.com>
[3+ messages in thread]
Missing block Magic
2012-06-05 16:12 UTC Alejandro Carrillo <fasterzip@yahoo.es>
` Re: Missing block Magic
2012-06-05 17:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Missing block Magic
2012-06-05 18:51 UTC Alejandro Carrillo <fasterzip@yahoo.es>
[3+ messages in thread]
Trouble with plan statistics for behaviour for query.
2012-05-31 22:29 UTC Trevor Campbell <tcampbell@atlassian.com>
` Re: Trouble with plan statistics for behaviour for query.
2012-05-31 22:55 UTC Craig James <cjames@emolecules.com>
` Re: Trouble with plan statistics for behaviour for query.
2012-05-31 23:01 UTC Trevor Campbell <tcampbell@atlassian.com>
` Re: Trouble with plan statistics for behaviour for query.
2012-05-31 23:08 UTC Craig James <cjames@emolecules.com>
` Re: Trouble with plan statistics for behaviour for query.
2012-05-31 23:34 UTC Trevor Campbell <tcampbell@atlassian.com>
` Re: Trouble with plan statistics for behaviour for query.
2012-06-01 00:08 UTC Craig James <cjames@emolecules.com>
` Re: Trouble with plan statistics for behaviour for query.
2012-06-01 09:06 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: Trouble with plan statistics for behaviour for query.
2012-06-01 15:38 UTC Maciek Sakrejda <m.sakrejda@gmail.com>
` Re: Trouble with plan statistics for behaviour for query.
2012-06-05 01:25 UTC Trevor Campbell <tcampbell@atlassian.com>
` Re: Trouble with plan statistics for behaviour for query.
2012-06-05 03:49 UTC Trevor Campbell <tcampbell@atlassian.com>
[10+ messages in thread]
Recover rows deleted
2012-05-28 18:24 UTC Alejandro Carrillo <fasterzip@yahoo.es>
` Re: Recover rows deleted
2012-05-29 20:53 UTC Jeff Davis <pgsql@j-davis.com>
` Re: Recover rows deleted
2012-05-29 21:33 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Recover rows deleted
2012-05-29 22:16 UTC Alejandro Carrillo <fasterzip@yahoo.es>
` Re: Recover rows deleted
2012-05-29 22:34 UTC Alejandro Carrillo <fasterzip@yahoo.es>
` Re: Recover rows deleted
2012-06-04 16:14 UTC Alejandro Carrillo <fasterzip@yahoo.es>
` Re: Recover rows deleted
2012-06-04 16:43 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Recover rows deleted
2012-06-04 16:47 UTC Alejandro Carrillo <fasterzip@yahoo.es>
` Re: Recover rows deleted
2012-06-04 17:04 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Recover rows deleted
2012-06-04 17:46 UTC Alejandro Carrillo <fasterzip@yahoo.es>
` Re: Recover rows deleted
2012-06-04 18:23 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Recover rows deleted
2012-06-04 18:37 UTC Alejandro Carrillo <fasterzip@yahoo.es>
` Re: Recover rows deleted
2012-06-04 18:46 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[13+ messages in thread]
High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 03:39 UTC Rajesh Kumar. Mallah <mallah@tradeindia.com>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 03:53 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 05:26 UTC Rajesh Kumar. Mallah <mallah@tradeindia.com>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 05:44 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 06:54 UTC Rajesh Kumar. Mallah <mallah@tradeindia.com>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 12:48 UTC Andy Colson <andy@squeakycode.net>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 12:58 UTC Rajesh Kumar. Mallah <mallah@tradeindia.com>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 15:53 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 15:57 UTC Stephen Frost <sfrost@snowman.net>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 16:40 UTC Rajesh Kumar. Mallah <mallah@tradeindia.com>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 16:59 UTC Rajesh Kumar. Mallah <mallah@tradeindia.com>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 17:09 UTC Stephen Frost <sfrost@snowman.net>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-05-24 21:30 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: High load average in 64-core server , no I/O wait and CPU is idle
2012-06-02 02:54 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[14+ messages in thread]
Select from sequence in slow query log
2012-06-01 13:13 UTC Chris Rimmer <chrisr@we7.com>
` Re: Select from sequence in slow query log
2012-06-01 13:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Select from sequence in slow query log
2012-06-01 15:41 UTC Chris Rimmer <chrisr@we7.com>
[3+ messages in thread]
does the query planner consider work_mem?
2012-05-30 17:57 UTC Murat Tasan <mmuurr@gmail.com>
` Re: does the query planner consider work_mem?
2012-05-30 18:25 UTC Ants Aasma <ants@cybertec.at>
` Re: does the query planner consider work_mem?
2012-05-30 20:30 UTC Murat Tasan <mmuurr@gmail.com>
` Re: does the query planner consider work_mem?
2012-05-31 22:59 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: does the query planner consider work_mem?
2012-06-01 15:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Strong slowdown on huge tables
2012-05-29 14:54 UTC Job <Job@colliniconsulting.it>
` Re: Strong slowdown on huge tables
2012-05-29 17:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
SSD selection
2012-05-15 15:21 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: SSD selection
2012-05-15 17:08 UTC David Boreham <david_list@boreham.org>
` Re: SSD selection
2012-05-15 17:22 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: SSD selection
2012-05-15 18:16 UTC Rosser Schwarz <rosser.schwarz@gmail.com>
` Re: SSD selection
2012-05-15 20:00 UTC David Boreham <david_list@boreham.org>
` Re: SSD selection
2012-05-16 17:01 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: SSD selection
2012-05-16 17:45 UTC David Boreham <david_list@boreham.org>
` Re: SSD selection
2012-05-16 18:53 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: SSD selection
2012-05-16 19:01 UTC Alejandro Carrillo <fasterzip@yahoo.es>
` Re: SSD selection
2012-05-28 12:14 UTC Greg Smith <greg@2ndQuadrant.com>
[10+ messages in thread]
Parallel (concurrent) inserts?
2012-05-25 22:04 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Parallel (concurrent) inserts?
2012-05-25 23:13 UTC Josh Berkus <josh@agliodbs.com>
` Re: Parallel (concurrent) inserts?
2012-05-25 23:36 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Parallel (concurrent) inserts?
2012-05-25 23:56 UTC Ivan Voras <ivoras@freebsd.org>
[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