pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedgetting client_addr not as a superuser
2015-02-10 12:21 UTC Михаил <bemewe@mail.ru>
` Re: getting client_addr not as a superuser
2015-02-10 12:53 UTC Jov <amutu@amutu.com>
` Re: getting client_addr not as a superuser
2015-02-10 14:11 UTC Luis Antonio Dias de Sá Junior <luisjunior.sa@gmail.com>
[3+ messages in thread]
Poor performance when deleting from entity-attribute-value type master-table
2015-02-09 21:12 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Poor performance when deleting from entity-attribute-value type master-table
2015-02-09 21:36 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Poor performance when deleting from entity-attribute-value type master-table
2015-02-09 21:42 UTC Jerry Sievers <gsievers19@comcast.net>
` Re: Poor performance when deleting from entity-attribute-value type master-table
2015-02-09 21:50 UTC Andreas Joseph Krogh <andreas@visena.com>
` Re: Poor performance when deleting from entity-attribute-value type master-table
2015-02-09 22:04 UTC Josh Berkus <josh@agliodbs.com>
[5+ messages in thread]
Avoiding Refreezing XIDs Repeatedly
2015-02-09 15:58 UTC bkrug <bkrug@usatech.com>
` Re: Avoiding Refreezing XIDs Repeatedly
2015-02-09 16:48 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Avoiding Refreezing XIDs Repeatedly
2015-02-09 17:06 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Avoiding Refreezing XIDs Repeatedly
2015-02-09 18:45 UTC bkrug <bkrug@usatech.com>
` Re: Avoiding Refreezing XIDs Repeatedly
2015-02-09 18:53 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Avoiding Refreezing XIDs Repeatedly
2015-02-09 18:56 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Avoiding Refreezing XIDs Repeatedly
2015-02-09 19:07 UTC bkrug <bkrug@usatech.com>
` Re: Avoiding Refreezing XIDs Repeatedly
2015-02-09 19:10 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Avoiding Refreezing XIDs Repeatedly
2015-02-09 20:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
[9+ messages in thread]
Migrating a FoxPro system and would like input on the best way to achieve optimal performance
2015-02-09 14:21 UTC TonyS <tony@exquisiteimages.com>
` Re: Migrating a FoxPro system and would like input on the best way to achieve optimal performance
2015-02-09 18:17 UTC David G Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
Copy command Faster than original select
2015-02-06 08:30 UTC belal <belalhamed@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 08:38 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 08:44 UTC Belal Al-Hamed <belalhamed@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 08:54 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 09:15 UTC Belal Al-Hamed <belalhamed@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 09:31 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 09:50 UTC Belal Al-Hamed <belalhamed@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 09:55 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 10:36 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 12:27 UTC Belal Al-Hamed <belalhamed@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 13:12 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 13:39 UTC Belal Al-Hamed <belalhamed@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 13:49 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 15:11 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Copy command Faster than original select
2015-02-06 15:24 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Copy command Faster than original select
2015-02-06 15:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Copy command Faster than original select
2015-02-08 10:08 UTC Belal Al-Hamed <belalhamed@gmail.com>
[17+ messages in thread]
slow nested views in 9.3
2015-02-05 22:29 UTC Pascal Depuis <pascal.depuis@gmail.com>
working around JSONB's lack of stats?
2015-01-27 07:06 UTC Josh Berkus <josh@agliodbs.com>
` Re: working around JSONB's lack of stats?
2015-01-28 19:48 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: working around JSONB's lack of stats?
2015-01-28 23:03 UTC Josh Berkus <josh@agliodbs.com>
` Re: working around JSONB's lack of stats?
2015-01-28 23:34 UTC Peter Geoghegan <peter.geoghegan86@gmail.com>
` Re: working around JSONB's lack of stats?
2015-01-28 23:42 UTC Josh Berkus <josh@agliodbs.com>
` Re: working around JSONB's lack of stats?
2015-01-28 23:50 UTC Peter Geoghegan <peter.geoghegan86@gmail.com>
` Re: working around JSONB's lack of stats?
2015-01-28 23:55 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: working around JSONB's lack of stats?
2015-01-30 20:26 UTC Josh Berkus <josh@agliodbs.com>
` Re: working around JSONB's lack of stats?
2015-01-31 01:34 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: working around JSONB's lack of stats?
2015-02-01 21:08 UTC Josh Berkus <josh@agliodbs.com>
` Re: working around JSONB's lack of stats?
2015-02-02 15:42 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: working around JSONB's lack of stats?
2015-02-03 01:48 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: working around JSONB's lack of stats?
2015-02-03 19:07 UTC Josh Berkus <josh@agliodbs.com>
[13+ messages in thread]
why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)?
2015-01-30 23:44 UTC Slava Mudry <slava44@gmail.com>
` Re: why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)?
2015-01-31 01:28 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)?
2015-02-03 01:36 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)?
2015-02-03 01:52 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)?
2015-02-03 03:37 UTC Slava Mudry <slava44@gmail.com>
` Re: why pg_class.relfrozenxid needs to be updated for frozen tables (where all rows have xmin=2)?
2015-02-03 04:17 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[6+ messages in thread]
Why is GIN index slowing down my query?
2015-02-01 22:32 UTC AlexK987 <alex.cue.987@gmail.com>
` Re: Why is GIN index slowing down my query?
2015-02-01 23:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why is GIN index slowing down my query?
2015-02-02 01:37 UTC AlexK987 <alex.cue.987@gmail.com>
` Re: Why is GIN index slowing down my query?
2015-02-02 03:00 UTC AlexK987 <alex.cue.987@gmail.com>
` Re: Why is GIN index slowing down my query?
2015-02-02 03:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why is GIN index slowing down my query?
2015-02-02 09:17 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: Why is GIN index slowing down my query?
2015-02-02 10:31 UTC Marc Mamin <M.Mamin@intershop.de>
[7+ messages in thread]
Unexpected (bad) performance when querying indexed JSONB column
2015-01-31 16:00 UTC Christian Weyer <christian.weyer@thinktecture.com>
` Re: Unexpected (bad) performance when querying indexed JSONB column
2015-01-31 19:02 UTC Christian Weyer <christian.weyer@thinktecture.com>
` Re: Unexpected (bad) performance when querying indexed JSONB column
2015-02-01 21:06 UTC Josh Berkus <josh@agliodbs.com>
` Re: Unexpected (bad) performance when querying indexed JSONB column
2015-02-01 21:19 UTC Christian Weyer <christian.weyer@thinktecture.com>
` Re: Unexpected (bad) performance when querying indexed JSONB column
2015-02-01 22:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected (bad) performance when querying indexed JSONB column
2015-02-02 06:31 UTC Christian Weyer <christian.weyer@thinktecture.com>
[6+ messages in thread]
Performance of Postgresql Foreign Data Wrapper
2015-01-14 16:48 UTC Cassiano, Marco <mcassiano@manord.com>
` Re: Performance of Postgresql Foreign Data Wrapper
2015-01-31 02:01 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[2+ messages in thread]
Autocompletion with full text search
2015-01-16 00:41 UTC Ivan Schneider <ivan@doctolib.fr>
` Re: Autocompletion with full text search
2015-01-31 01:57 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[2+ messages in thread]
Why is PostgreSQL not using my index?
2015-01-26 16:32 UTC Christian Roche <Christian.Roche@workshare.com>
` Re: Why is PostgreSQL not using my index?
2015-01-26 20:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why is PostgreSQL not using my index?
2015-01-27 04:25 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Why is PostgreSQL not using my index?
2015-01-27 14:11 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
How to tell ANALYZE to collect statistics from the whole table?
2015-01-24 23:33 UTC AlexK987 <alex.cue.987@gmail.com>
` Re: How to tell ANALYZE to collect statistics from the whole table?
2015-01-25 00:49 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: How to tell ANALYZE to collect statistics from the whole table?
2015-01-25 01:04 UTC AlexK987 <alex.cue.987@gmail.com>
` Re: How to tell ANALYZE to collect statistics from the whole table?
2015-01-25 01:21 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: How to tell ANALYZE to collect statistics from the whole table?
2015-01-25 05:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How to tell ANALYZE to collect statistics from the whole table?
2015-01-26 16:51 UTC Jeff Janes <jeff.janes@gmail.com>
[6+ messages in thread]
Initial insert
2015-01-22 16:46 UTC Laurent Cathala <lca@sylob.com>
` Re: Initial insert
2015-01-23 08:54 UTC Laurent Cathala <lca@sylob.com>
` Re: Initial insert
2015-01-25 01:29 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[3+ messages in thread]
shared_buffers vs Linux file cache
2015-01-15 11:30 UTC Huan Ruan <huan.ruan.it@gmail.com>
` Re: shared_buffers vs Linux file cache
2015-01-15 17:10 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: shared_buffers vs Linux file cache
2015-01-15 22:22 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: shared_buffers vs Linux file cache
2015-01-15 23:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: shared_buffers vs Linux file cache
2015-01-16 03:32 UTC Huan Ruan <huan.ruan.it@gmail.com>
` Re: shared_buffers vs Linux file cache
2015-01-16 07:49 UTC Roman Konoval <rkonoval@gmail.com>
[6+ messages in thread]
Strange choice of general index over partial index
2015-01-15 22:30 UTC Josh Berkus <josh@agliodbs.com>
` Re: Strange choice of general index over partial index
2015-01-15 23:39 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Strange choice of general index over partial index
2015-01-16 00:37 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Strange choice of general index over partial index
2015-01-16 01:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange choice of general index over partial index
2015-01-16 02:32 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Strange choice of general index over partial index
2015-01-16 03:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Strange choice of general index over partial index
2015-01-16 03:06 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Strange choice of general index over partial index
2015-01-16 03:17 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Strange choice of general index over partial index
2015-01-16 03:28 UTC Josh Berkus <josh@agliodbs.com>
` Re: Strange choice of general index over partial index
2015-01-16 04:00 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Strange choice of general index over partial index
2015-01-16 04:15 UTC Josh Berkus <josh@agliodbs.com>
[11+ messages in thread]
New server optimization advice
2015-01-09 19:26 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: New server optimization advice
2015-01-09 19:48 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: New server optimization advice
2015-01-12 16:02 UTC Merlin Moncure <mmoncure@gmail.com>
[3+ messages in thread]
Excessive memory used for INSERT
2014-12-17 15:14 UTC Alessandro Ipe <Alessandro.Ipe@meteo.be>
` Re: Excessive memory used for INSERT
2014-12-17 15:26 UTC Torsten Zuehlsdorff <mailinglists@toco-domains.de>
` Re: Excessive memory used for INSERT
2014-12-17 15:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Excessive memory used for INSERT
2014-12-17 16:57 UTC Alessandro Ipe <Alessandro.Ipe@meteo.be>
` Re: Excessive memory used for INSERT
2014-12-17 17:04 UTC Alessandro Ipe <Alessandro.Ipe@meteo.be>
` Re: Excessive memory used for INSERT
2014-12-17 17:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Excessive memory used for INSERT
2014-12-18 07:51 UTC Torsten Förtsch <torsten.foertsch@gmx.net>
` Re: Excessive memory used for INSERT
2014-12-18 11:16 UTC Alessandro Ipe <Alessandro.Ipe@meteo.be>
` Re: Excessive memory used for INSERT
2014-12-18 15:42 UTC Alessandro Ipe <Alessandro.Ipe@meteo.be>
` Re: Excessive memory used for INSERT
2014-12-18 16:31 UTC Alessandro Ipe <Alessandro.Ipe@meteo.be>
` Re: Excessive memory used for INSERT
2014-12-18 17:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Excessive memory used for INSERT
2014-12-18 17:31 UTC Alessandro Ipe <Alessandro.Ipe@meteo.be>
` Re: Excessive memory used for INSERT
2014-12-23 11:56 UTC Alessandro Ipe <Alessandro.Ipe@meteo.be>
` Re: Excessive memory used for INSERT
2014-12-23 20:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Excessive memory used for INSERT
2015-01-06 17:40 UTC Alessandro Ipe <Alessandro.Ipe@meteo.be>
[15+ messages in thread]
trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist
2014-12-30 20:42 UTC cesar <cesarkrall@gmail.com>
` Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist
2015-01-01 07:17 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: trying to run pgbench-tools postgresql ubuntu ERROR: relation "branches" does not exist
2015-01-01 20:45 UTC cesar <cesarkrall@gmail.com>
[3+ messages in thread]
Number of Columns and Update
2014-12-22 20:53 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Number of Columns and Update
2014-12-22 21:40 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Number of Columns and Update
2014-12-22 21:41 UTC Andrew Dunstan <andrew@dunslane.net>
[3+ messages in thread]
Question about trigram GIST index
2014-12-18 17:12 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Question about trigram GIST index
2014-12-18 17:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about trigram GIST index
2014-12-18 17:32 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Question about trigram GIST index
2014-12-18 18:00 UTC Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>
` Re: Question about trigram GIST index
2014-12-18 18:08 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Question about trigram GIST index
2014-12-18 18:33 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Question about trigram GIST index
2014-12-18 19:33 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Question about trigram GIST index
2014-12-18 20:03 UTC Kevin Grittner <kgrittn@ymail.com>
[8+ messages in thread]
8xIntel S3500 SSD in RAID10 on Dell H710p
2014-12-09 23:28 UTC Strahinja Kustudić <strahinjak@nordeus.com>
` Re: 8xIntel S3500 SSD in RAID10 on Dell H710p
2014-12-10 03:55 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: 8xIntel S3500 SSD in RAID10 on Dell H710p
2014-12-10 08:30 UTC Strahinja Kustudić <strahinjak@nordeus.com>
` Re: 8xIntel S3500 SSD in RAID10 on Dell H710p
2014-12-10 22:05 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: 8xIntel S3500 SSD in RAID10 on Dell H710p
2014-12-12 21:06 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: 8xIntel S3500 SSD in RAID10 on Dell H710p
2014-12-16 11:47 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: 8xIntel S3500 SSD in RAID10 on Dell H710p
2014-12-16 19:46 UTC Strahinja Kustudić <strahinjak@nordeus.com>
[7+ messages in thread]
Tuning the configuration
2014-12-10 10:44 UTC Maila Fatticcioni <mfatticcioni@mbigroup.it>
` Re: Tuning the configuration
2014-12-10 17:47 UTC Patrick Krecker <patrick@judicata.com>
` Re: Tuning the configuration
2014-12-11 08:11 UTC Maila Fatticcioni <mfatticcioni@mbigroup.it>
` Re: Tuning the configuration
2014-12-11 12:02 UTC Andrea Suisani <sickpig@opinioni.net>
` Re: Tuning the configuration
2014-12-11 12:11 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Tuning the configuration
2014-12-11 12:48 UTC Maila Fatticcioni <mfatticcioni@mbigroup.it>
` Re: Tuning the configuration
2014-12-11 13:16 UTC Andrea Suisani <sickpig@opinioni.net>
` Re: Tuning the configuration
2014-12-11 13:26 UTC Andrea Suisani <sickpig@opinioni.net>
` Re: Tuning the configuration
2014-12-11 22:36 UTC Eric Pierce <epierce@saasmadeeasy.com>
` Re: Tuning the configuration
2014-12-12 00:04 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Tuning the configuration
2014-12-15 13:36 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Tuning the configuration
2014-12-16 11:51 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Tuning the configuration
2014-12-16 16:37 UTC Evgeniy Shishkin <itparanoia@gmail.com>
[13+ messages in thread]
Postgres slave not catching up (on 9.2)
2014-11-08 13:11 UTC Ruben Domingo Gaspar Aparicio <Ruben.Gaspar.Aparicio@cern.ch>
` Re: Postgres slave not catching up (on 9.2)
2014-11-08 20:35 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: Postgres slave not catching up (on 9.2)
2014-11-09 22:44 UTC Andres Freund <andres@2ndquadrant.com>
` Re: Postgres slave not catching up (on 9.2)
2014-11-10 10:14 UTC Ruben Domingo Gaspar Aparicio <Ruben.Gaspar.Aparicio@cern.ch>
` Re: Postgres slave not catching up (on 9.2)
2014-11-28 16:21 UTC Ruben Domingo Gaspar Aparicio <Ruben.Gaspar.Aparicio@cern.ch>
` Re: Postgres slave not catching up (on 9.2)
2014-12-15 14:18 UTC Ruben Domingo Gaspar Aparicio <Ruben.Gaspar.Aparicio@cern.ch>
` Re: Postgres slave not catching up (on 9.2)
2014-12-15 14:32 UTC Ruben Domingo Gaspar Aparicio <Ruben.Gaspar.Aparicio@cern.ch>
[7+ 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