pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpl/pgsql performance
2014-04-25 08:48 UTC Mehdi Ravanbakhsh <babakco@gmail.com>
` Re: pl/pgsql performance
2014-04-25 08:53 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: pl/pgsql performance
2014-04-27 12:41 UTC Michael Paquier <michael.paquier@gmail.com>
[3+ messages in thread]
Poor performance for delete query
2014-04-24 19:42 UTC Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>
` Re: Poor performance for delete query
2014-04-24 20:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor performance for delete query
2014-04-24 20:57 UTC Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>
` Re: Poor performance for delete query
2014-04-24 21:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Poor performance for delete query
2014-04-25 05:04 UTC Jonatan Evald Buus <jonatan.buus@cellpointmobile.com>
` Re: Poor performance for delete query
2014-04-25 14:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Server vacuuming the same table again and again
2014-04-25 07:47 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: Server vacuuming the same table again and again
2014-04-25 08:12 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Server vacuuming the same table again and again
2014-04-25 08:22 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: Server vacuuming the same table again and again
2014-04-25 08:29 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: Server vacuuming the same table again and again
2014-04-25 09:19 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Server vacuuming the same table again and again
2014-04-25 09:22 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Server vacuuming the same table again and again
2014-04-25 09:31 UTC Дмитрий Шалашов <skaurus@gmail.com>
` Re: Server vacuuming the same table again and again
2014-04-25 09:46 UTC Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>
` Re: Server vacuuming the same table again and again
2014-04-25 09:47 UTC Torsten Förtsch <torsten.foertsch@gmx.net>
` Re: Server vacuuming the same table again and again
2014-04-25 10:36 UTC Дмитрий Шалашов <skaurus@gmail.com>
[10+ messages in thread]
tsearch2, large data and indexes
2014-04-19 23:15 UTC Ivan Voras <ivoras@freebsd.org>
` Re: tsearch2, large data and indexes
2014-04-22 06:40 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: tsearch2, large data and indexes
2014-04-22 07:57 UTC Ivan Voras <ivoras@freebsd.org>
` Re: tsearch2, large data and indexes
2014-04-22 15:58 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: tsearch2, large data and indexes
2014-04-23 11:08 UTC Ivan Voras <ivoras@freebsd.org>
` Re: tsearch2, large data and indexes
2014-04-23 12:26 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: tsearch2, large data and indexes
2014-04-23 13:00 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: tsearch2, large data and indexes
2014-04-23 22:56 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: tsearch2, large data and indexes
2014-04-24 11:34 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: tsearch2, large data and indexes
2014-04-24 12:34 UTC Ivan Voras <ivoras@freebsd.org>
` Re: tsearch2, large data and indexes
2014-04-24 19:27 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: tsearch2, large data and indexes
2014-04-24 19:57 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: tsearch2, large data and indexes
2014-04-25 06:37 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
[13+ messages in thread]
HFS+ pg_test_fsync performance
2014-04-14 22:32 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: HFS+ pg_test_fsync performance
2014-04-15 12:18 UTC desmodemone <desmodemone@gmail.com>
` Re: HFS+ pg_test_fsync performance
2014-04-15 14:31 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: HFS+ pg_test_fsync performance
2014-04-23 18:04 UTC Josh Berkus <josh@agliodbs.com>
` Re: HFS+ pg_test_fsync performance
2014-04-23 18:19 UTC Mel Llaguno <mllaguno@coverity.com>
` Re: HFS+ pg_test_fsync performance
2014-04-23 18:29 UTC Josh Berkus <josh@agliodbs.com>
[6+ messages in thread]
Adding new field to big table
2014-03-14 11:30 UTC acanada <acanada@cnio.es>
` Re: Adding new field to big table
2014-03-14 16:49 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Adding new field to big table
2014-03-14 17:06 UTC acanada <acanada@cnio.es>
` Re: Adding new field to big table
2014-03-14 19:29 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Adding new field to big table
2014-03-17 09:39 UTC acanada <acanada@cnio.es>
` Re: Adding new field to big table
2014-03-18 06:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Adding new field to big table
2014-04-23 17:59 UTC RichmondDyes@monroehosp.org
[7+ messages in thread]
Best practices for update timestamp with/without triggers
2014-04-22 01:16 UTC Verghese, Riya <rverghese@cobalt.com>
` Re: Best practices for update timestamp with/without triggers
2014-04-23 10:28 UTC hubert depesz lubaczewski <depesz@depesz.com>
[2+ messages in thread]
Stalls on PGSemaphoreLock
2014-03-25 12:46 UTC Matthew Spilich <mspilich@tripadvisor.com>
` Re: Stalls on PGSemaphoreLock
2014-03-25 17:17 UTC Ray Stell <stellr@vt.edu>
` Re: Stalls on PGSemaphoreLock
2014-03-25 18:38 UTC Matthew Spilich <mspilich@tripadvisor.com>
` Re: Stalls on PGSemaphoreLock
2014-03-25 20:10 UTC Pavy Philippe <Philippe.Pavy@worldline.com>
` Re: Stalls on PGSemaphoreLock
2014-03-25 20:35 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: Stalls on PGSemaphoreLock
2014-03-26 06:26 UTC Takashi Horikawa <t-horikawa@aj.jp.nec.com>
` Re: Stalls on PGSemaphoreLock
2014-03-27 07:38 UTC Gudmundsson Martin (mg) <martin.mg.gudmundsson@volvo.com>
` Re: Stalls on PGSemaphoreLock
2014-04-22 15:12 UTC Matthew Spilich <mspilich@tripadvisor.com>
` Re: Stalls on PGSemaphoreLock
2014-04-22 15:48 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
[9+ messages in thread]
Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-20 04:30 UTC Laurence Parry <greenreaper@hotmail.com>
` Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-20 04:46 UTC Oleg Bartunov <obartunov@gmail.com>
` Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-20 05:44 UTC Laurence Parry <greenreaper@hotmail.com>
` Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-22 06:28 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-22 07:15 UTC Oleg Bartunov <obartunov@gmail.com>
` Re: Workaround: Planner preference for tsquery filter vs. GIN index in fast text search
2014-04-22 13:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Query on partitioned table not using index
2014-04-22 10:14 UTC Souquieres Adam <adam.souquieres@axege.com>
Best practice question
2014-04-22 01:19 UTC Tory M Blue <tmblue@gmail.com>
` Re: Best practice question
2014-04-22 01:31 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: Best practice question
2014-04-22 02:01 UTC Sergey Konoplev <gray.ru@gmail.com>
[3+ messages in thread]
Fast 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 Jeff Janes <jeff.janes@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 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]
[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