pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedFast distinct not working as expected
2014-04-17 15:11 UTC Franck Routier <franck.routier@axege.com>
` Re: Fast distinct not working as expected
2014-04-17 15:57 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Fast distinct not working as expected
2014-04-17 17:17 UTC Franck Routier <franck.routier@axege.com>
` Re: Fast distinct not working as expected
2014-04-17 18:17 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Fast distinct not working as expected
2014-04-18 07:22 UTC Franck Routier <franck.routier@axege.com>
` Re: Fast distinct not working as expected
2014-04-18 08:07 UTC Franck Routier <franck.routier@axege.com>
` Re: Fast distinct not working as expected
2014-04-21 14:16 UTC Merlin Moncure <mmoncure@gmail.com>
[7+ messages in thread]
IP addresses, NetBlocks, and ASNs
2014-04-20 02:12 UTC Gary Warner <gar@cis.uab.edu>
` Re: IP addresses, NetBlocks, and ASNs
2014-04-20 14:57 UTC Steve Atkins <steve@blighty.com>
` Re: IP addresses, NetBlocks, and ASNs
2014-04-20 21:01 UTC Gary Warner <gar@cis.uab.edu>
[3+ messages in thread]
Hot standby 9.2.1 PANIC: WAL contains references to invalid pages
2014-04-18 08:23 UTC Vishalakshi Navaneethakrishnan <nvishalakshi@sirahu.com>
` Re: Hot standby 9.2.1 PANIC: WAL contains references to invalid pages
2014-04-19 23:41 UTC Sergey Konoplev <gray.ru@gmail.com>
[2+ messages in thread]
Help on migrating data from MSSQL2008R2 to PostgreSQL 9.3
2014-04-18 08:33 UTC Wureka JI <wureka@gmail.com>
Approach to Data Summary and Analysis
2014-04-14 16:27 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Approach to Data Summary and Analysis
2014-04-14 21:35 UTC Vincent Veyron <vincent.veyron@libremen.org>
` Re: [GENERAL] Approach to Data Summary and Analysis
2014-04-15 14:56 UTC Chris Curvey <chris@chriscurvey.com>
` Re: Approach to Data Summary and Analysis
2014-04-15 15:12 UTC Chris Curvey <chris@chriscurvey.com>
` Re: [GENERAL] Approach to Data Summary and Analysis
2014-04-15 15:53 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Approach to Data Summary and Analysis
2014-04-15 16:02 UTC Rob Sargent <robjsargent@gmail.com>
` Re: Approach to Data Summary and Analysis
2014-04-15 22:26 UTC Roxanne Reid-Bennett <rox@tara-lu.com>
` Re: Approach to Data Summary and Analysis
2014-04-16 01:10 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Approach to Data Summary and Analysis
2014-04-16 01:27 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Approach to Data Summary and Analysis
2014-04-16 15:42 UTC Roxanne Reid-Bennett <rox@tara-lu.com>
` Re: Approach to Data Summary and Analysis
2014-04-16 18:40 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Approach to Data Summary and Analysis
2014-04-18 05:46 UTC Roxanne Reid-Bennett <rox@tara-lu.com>
[12+ messages in thread]
Workaround for working_mem max value in windows?
2014-04-16 01:36 UTC Nick Eubank <nickeubank@gmail.com>
` Re: Workaround for working_mem max value in windows?
2014-04-16 06:42 UTC Martin French <Martin.French@romaxtech.com>
` Re: Workaround for working_mem max value in windows?
2014-04-16 08:29 UTC amulsul <sul_amul@yahoo.co.in>
` Re: Workaround for working_mem max value in windows?
2014-04-16 16:35 UTC Nick Eubank <nickeubank@gmail.com>
` Re: Workaround for working_mem max value in windows?
2014-04-16 17:08 UTC Martin French <Martin.French@romaxtech.com>
` Re: Workaround for working_mem max value in windows?
2014-04-16 19:48 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Workaround for working_mem max value in windows?
2014-04-17 01:35 UTC Nick Eubank <nickeubank@gmail.com>
` Re: Workaround for working_mem max value in windows?
2014-04-17 07:05 UTC amul sul <sul_amul@yahoo.co.in>
[8+ messages in thread]
unneeded joins on view
2014-04-16 15:13 UTC Linos <info@linos.es>
` Re: unneeded joins on view
2014-04-16 15:57 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: unneeded joins on view
2014-04-16 16:08 UTC Linos <info@linos.es>
[3+ messages in thread]
Queries very slow after data size increases
2014-04-16 13:05 UTC sheishere b <sheishere48@gmail.com>
Testing strategies
2014-04-15 15:57 UTC Dave Cramer <davecramer@gmail.com>
` Re: Testing strategies
2014-04-15 20:23 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
[2+ messages in thread]
Tuning Postgres for Single connection use
2014-04-14 21:46 UTC Nick Eubank <nickeubank@gmail.com>
` Re: Tuning Postgres for Single connection use
2014-04-14 22:41 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Tuning Postgres for Single connection use
2014-04-14 23:39 UTC Nick Eubank <nickeubank@gmail.com>
` Re: Tuning Postgres for Single connection use
2014-04-15 00:12 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Tuning Postgres for Single connection use
2014-04-15 00:19 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Tuning Postgres for Single connection use
2014-04-15 00:29 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Tuning Postgres for Single connection use
2014-04-15 00:50 UTC Nick Eubank <nickeubank@gmail.com>
` Re: Tuning Postgres for Single connection use
2014-04-15 16:12 UTC Nick Eubank <nickeubank@gmail.com>
` Re: Tuning Postgres for Single connection use
2014-04-15 16:43 UTC Schnabel, Robert D. <schnabelr@missouri.edu>
` Re: Tuning Postgres for Single connection use
2014-04-15 16:43 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Tuning Postgres for Single connection use
2014-04-15 17:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Tuning Postgres for Single connection use
2014-04-15 18:51 UTC Nick Eubank <nickeubank@gmail.com>
[12+ messages in thread]
Checkpoint distribution
2014-04-14 09:46 UTC Borodin Vladimir <root@simply.name>
` Re: Checkpoint distribution
2014-04-14 15:11 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Checkpoint distribution
2014-04-14 16:42 UTC Borodin Vladimir <root@simply.name>
` Re: Checkpoint distribution
2014-04-14 18:09 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Checkpoint distribution
2014-04-15 10:16 UTC Borodin Vladimir <root@simply.name>
[5+ messages in thread]
SSI slows down over time
2014-04-06 02:25 UTC Ryan Johnson <ryan.johnson@cs.utoronto.ca>
` Re: SSI slows down over time
2014-04-06 08:30 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: SSI slows down over time
2014-04-06 14:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SSI slows down over time
2014-04-07 10:52 UTC Ryan Johnson <ryan.johnson@cs.utoronto.ca>
` Re: SSI slows down over time
2014-04-07 14:11 UTC Ryan Johnson <scovich@gmail.com>
` Re: SSI slows down over time
2014-04-07 14:36 UTC Ryan Johnson <ryan.johnson@cs.utoronto.ca>
` Re: SSI slows down over time
2014-04-07 14:38 UTC Ryan Johnson <ryan.johnson@cs.utoronto.ca>
` Re: SSI slows down over time
2014-04-09 21:21 UTC Bruce Momjian <bruce@momjian.us>
` SSI slows down over time
2014-04-14 12:58 UTC Ryan Johnson <ryan.johnson@cs.utoronto.ca>
` Re: SSI slows down over time
2014-04-14 12:59 UTC Ryan Johnson <ryan.johnson@cs.utoronto.ca>
` Re: SSI slows down over time
2014-04-14 14:14 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: SSI slows down over time
2014-04-14 14:22 UTC Ryan Johnson <ryan.johnson@cs.utoronto.ca>
` Re: SSI slows down over time
2014-04-14 15:54 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: SSI slows down over time
2014-04-14 20:30 UTC Ryan Johnson <ryan.johnson@cs.utoronto.ca>
` Re: SSI slows down over time
2014-04-15 01:57 UTC Ryan Johnson <ryan.johnson@cs.utoronto.ca>
[15+ messages in thread]
Getting query plan alternatives from query planner?
2014-03-20 16:53 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Getting query plan alternatives from query planner?
2014-03-20 17:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Getting query plan alternatives from query planner?
2014-03-21 07:37 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Getting query plan alternatives from query planner?
2014-03-21 07:51 UTC Atri Sharma <atri.jiit@gmail.com>
` Re: Getting query plan alternatives from query planner?
2014-03-21 13:34 UTC Craig James <cjames@emolecules.com>
` Re: Getting query plan alternatives from query planner?
2014-03-21 14:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Getting query plan alternatives from query planner?
2014-03-21 19:43 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Getting query plan alternatives from query planner?
2014-04-14 14:39 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Getting query plan alternatives from query planner?
2014-04-14 14:59 UTC Eric Schwarzenbach <subscriber@blackbrook.org>
` Re: Getting query plan alternatives from query planner?
2014-04-14 15:35 UTC Craig James <cjames@emolecules.com>
` Re: Getting query plan alternatives from query planner?
2014-04-14 18:36 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Getting query plan alternatives from query planner?
2014-04-14 19:18 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
[12+ messages in thread]
Ye olde slow query
2014-03-11 20:02 UTC Murphy, Kevin <MURPHYKE@email.chop.edu>
` Re: Ye olde slow query
2014-03-11 22:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Ye olde slow query
2014-04-14 13:55 UTC Murphy, Kevin <MURPHYKE@email.chop.edu>
[3+ messages in thread]
Batch update query performance
2014-04-04 12:00 UTC Hans Drexler <Hans.Drexler@HumanInference.com>
` Re: Batch update query performance
2014-04-07 12:06 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Batch update query performance
2014-04-07 12:53 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Batch update query performance
2014-04-07 21:26 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: batch update query performance
2014-04-08 13:21 UTC Hans Drexler <Hans.Drexler@HumanInference.com>
` Re: batch update query performance
2014-04-14 00:02 UTC Jeff Janes <jeff.janes@gmail.com>
[6+ messages in thread]
query against large table not using sensible index to find very small amount of data
2014-04-08 12:48 UTC Andrew W. Gibbs <awgibbs@awgibbs.com>
` Re: query against large table not using sensible index to find very small amount of data
2014-04-08 13:39 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: query against large table not using sensible index to find very small amount of data
2014-04-08 13:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query against large table not using sensible index to find very small amount of data
2014-04-08 22:51 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: query against large table not using sensible index to find very small amount of data
2014-04-09 00:57 UTC 'Andrew W. Gibbs' <awgibbs@awgibbs.com>
` Re: query against large table not using sensible index to find very small amount of data
2014-04-13 00:12 UTC Andrew W. Gibbs <awgibbs@awgibbs.com>
[6+ messages in thread]
performance degradation after launching postgres cluster using pgpool-II
2014-03-31 08:31 UTC Cora Ma <machengcheng001@hotmail.com>
` Re: performance degradation after launching postgres cluster using pgpool-II
2014-04-07 13:46 UTC Tatsuo Ishii <ishii@postgresql.org>
` Re: performance degradation after launching postgres cluster using pgpool-II
2014-04-11 07:29 UTC Cora Ma <machengcheng001@hotmail.com>
[3+ messages in thread]
Optimizing Time Series Access
2014-04-08 21:20 UTC Robert Burgholzer <rburghol@vt.edu>
` Re: Optimizing Time Series Access
2014-04-09 19:48 UTC Robert Burgholzer <rburghol@vt.edu>
[2+ messages in thread]
Interesting case of index un-usage
2014-04-09 18:56 UTC Claudio Freire <klaussfreire@gmail.com>
PGSQL, checkpoints, and file system syncs
2014-04-03 00:38 UTC Reza Taheri <rtaheri@vmware.com>
` PGSQL, checkpoints, and file system syncs
2014-04-03 17:39 UTC Reza Taheri <rtaheri@vmware.com>
` Re: PGSQL, checkpoints, and file system syncs
2014-04-03 18:01 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: PGSQL, checkpoints, and file system syncs
2014-04-03 18:11 UTC Reza Taheri <rtaheri@vmware.com>
` Re: PGSQL, checkpoints, and file system syncs
2014-04-04 06:11 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: PGSQL, checkpoints, and file system syncs
2014-04-04 20:27 UTC Reza Taheri <rtaheri@vmware.com>
` Re: PGSQL, checkpoints, and file system syncs
2014-04-08 14:00 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: PGSQL, checkpoints, and file system syncs
2014-04-09 16:42 UTC Bruce Momjian <bruce@momjian.us>
` Re: PGSQL, checkpoints, and file system syncs
2014-04-09 16:51 UTC Bruce Momjian <bruce@momjian.us>
[9+ messages in thread]
Why shared_buffers max is 8GB?
2014-03-26 12:21 UTC Alexey Vasiliev <leopard_ne@inbox.ru>
` Re: Why shared_buffers max is 8GB?
2014-03-26 12:35 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Why shared_buffers max is 8GB?
2014-03-26 12:45 UTC desmodemone <desmodemone@gmail.com>
` Re: Why shared_buffers max is 8GB?
2014-03-26 13:23 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Why shared_buffers max is 8GB?
2014-03-26 13:24 UTC Markella Skempri <markella_skembri@hotmail.com>
` Re: Why shared_buffers max is 8GB?
2014-03-26 13:30 UTC Martin French <Martin.French@romaxtech.com>
` Re: Why shared_buffers max is 8GB?
2014-03-26 13:32 UTC Martin French <Martin.French@romaxtech.com>
` Re: Why shared_buffers max is 8GB?
2014-03-26 13:47 UTC Markella Skempri <markella_skembri@hotmail.com>
` Re: Why shared_buffers max is 8GB?
2014-03-26 14:04 UTC Martin French <Martin.French@romaxtech.com>
` Re: Why shared_buffers max is 8GB?
2014-03-26 14:23 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Why shared_buffers max is 8GB?
2014-03-26 14:23 UTC desmodemone <desmodemone@gmail.com>
` Re: Why shared_buffers max is 8GB?
2014-03-26 16:14 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Why shared_buffers max is 8GB?
2014-03-26 16:36 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Why shared_buffers max is 8GB?
2014-04-02 09:38 UTC Alexey Klyukin <alexk@hintbits.com>
` Re: Why shared_buffers max is 8GB?
2014-04-09 11:46 UTC Bruce Momjian <bruce@momjian.us>
[15+ messages in thread]
Performance regressions in PG 9.3 vs PG 9.0
2014-04-07 18:34 UTC uher dslij <codon3@gmail.com>
` Re: Performance regressions in PG 9.3 vs PG 9.0
2014-04-08 19:58 UTC uher dslij <codon3@gmail.com>
` Re: Performance regressions in PG 9.3 vs PG 9.0
2014-04-08 21:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance regressions in PG 9.3 vs PG 9.0
2014-04-09 00:16 UTC uher dslij <codon3@gmail.com>
` Re: Performance regressions in PG 9.3 vs PG 9.0
2014-04-09 00:23 UTC uher dslij <codon3@gmail.com>
` Re: Performance regressions in PG 9.3 vs PG 9.0
2014-04-09 01:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Nested loop issue
2014-04-08 09:35 UTC Manoj Gadi <Manoj.Gadi@uni-konstanz.de>
` Re: Nested loop issue
2014-04-08 20:40 UTC Dhananjay Singh <dk_singh99@yahoo.com>
[2+ messages in thread]
performance drop when function argument is evaluated in WHERE clause
2014-04-08 11:53 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause
2014-04-08 13:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause
2014-04-08 17:33 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause
2014-04-08 17:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
PGSQL 9.3 - Materialized View - multithreading
2014-04-04 16:29 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-04 16:54 UTC Thom Brown <thom@linux.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-04 19:49 UTC PARIS Nicolas <niparisco@gmail.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-04 19:57 UTC Thom Brown <thom@linux.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-04 20:07 UTC PARIS Nicolas <niparisco@gmail.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-04 20:14 UTC Thom Brown <thom@linux.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-04 20:26 UTC PARIS Nicolas <niparisco@gmail.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-04 20:34 UTC ktm@rice.edu <ktm@rice.edu>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-06 19:07 UTC Thom Brown <thom@linux.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-06 22:21 UTC PARIS Nicolas <niparisco@gmail.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-07 10:29 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-07 12:49 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-07 12:59 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-07 13:56 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PGSQL 9.3 - Materialized View - multithreading
2014-04-07 14:05 UTC Graeme B. Bell <grb@skogoglandskap.no>
[15+ 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