pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPG 9.3 materialized view VS Views, indexes, shared memory
2015-02-20 10:28 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-02-20 12:36 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-02-20 13:06 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-02-20 14:44 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-02-20 16:19 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-02-20 18:09 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-03-06 01:40 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-03-06 08:16 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-03-06 09:32 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-03-06 10:25 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-03-06 20:26 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-03-09 13:17 UTC Nicolas Paris <niparisco@gmail.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-03-10 08:31 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: PG 9.3 materialized view VS Views, indexes, shared memory
2015-03-10 08:53 UTC Nicolas Paris <niparisco@gmail.com>
[14+ messages in thread]
CREATE INDEX uses INDEX ?
2015-03-07 10:30 UTC Nicolas Paris <niparisco@gmail.com>
` Re: CREATE INDEX uses INDEX ?
2015-03-07 11:56 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: CREATE INDEX uses INDEX ?
2015-03-08 09:04 UTC Nicolas Paris <niparisco@gmail.com>
` Re: CREATE INDEX uses INDEX ?
2015-03-08 09:09 UTC Guillaume Lelarge <guillaume@lelarge.info>
[4+ messages in thread]
slow server : s_lock and _bt_checkkeys on perf top
2015-03-04 19:31 UTC Soni M <diptatapa@gmail.com>
` Re: slow server : s_lock and _bt_checkkeys on perf top
2015-03-06 01:29 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: slow server : s_lock and _bt_checkkeys on perf top
2015-03-06 14:31 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: slow server : s_lock and _bt_checkkeys on perf top
2015-03-06 16:04 UTC Soni M <diptatapa@gmail.com>
[4+ messages in thread]
Reverse Key Index
2015-02-14 18:13 UTC Sven R. Kunze <srkunze@tbz-pariv.de>
` Re: Reverse Key Index
2015-02-14 18:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Reverse Key Index
2015-02-14 18:35 UTC Sven R. Kunze <srkunze@tbz-pariv.de>
` Re: Reverse Key Index
2015-02-25 22:31 UTC Josh Berkus <josh@agliodbs.com>
` Re: Reverse Key Index
2015-02-26 11:04 UTC Sven R. Kunze <srkunze@tbz-pariv.de>
` Re: Reverse Key Index
2015-02-26 11:45 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Reverse Key Index
2015-02-26 12:23 UTC Sven R. Kunze <srkunze@tbz-pariv.de>
` Re: Reverse Key Index
2015-02-26 12:37 UTC Heikki Linnakangas <hlinnaka@iki.fi>
` Re: Reverse Key Index
2015-02-26 12:48 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Reverse Key Index
2015-02-26 13:20 UTC Sven R. Kunze <srkunze@tbz-pariv.de>
` Re: Reverse Key Index
2015-03-05 09:17 UTC Sven R. Kunze <srkunze@tbz-pariv.de>
[11+ messages in thread]
Regarding "Point-in-time Recovery" feature
2015-02-23 11:38 UTC Saurabh Gupta A <saurabh.a.gupta@ericsson.com>
` Re: Regarding "Point-in-time Recovery" feature
2015-02-23 16:03 UTC Mathis, Jason <jmathis@enova.com>
` Re: Regarding "Point-in-time Recovery" feature
2015-02-23 16:11 UTC luis.sa@htip.com.br
[3+ messages in thread]
PATCH: adaptive ndistinct estimator v3 (WAS: Re: [PERFORM] Yet another abort-early plan disaster on 9.3)
2014-12-07 01:54 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: PATCH: adaptive ndistinct estimator v3 (WAS: Re: [PERFORM] Yet another abort-early plan disaster on 9.3)
2014-12-23 10:28 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: PATCH: adaptive ndistinct estimator v3 (WAS: Re: [PERFORM] Yet another abort-early plan disaster on 9.3)
2015-02-19 03:08 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[3+ messages in thread]
Configuration tips for very large database
2015-02-12 22:25 UTC Nico Sabbi <nicola.sabbi@poste.it>
` Re: Configuration tips for very large database
2015-02-12 22:38 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Configuration tips for very large database
2015-02-12 22:48 UTC Nico Sabbi <nicola.sabbi@poste.it>
` Re: Configuration tips for very large database
2015-02-12 22:55 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Configuration tips for very large database
2015-02-12 23:14 UTC Mathis, Jason <jmathis@enova.com>
` Re: Configuration tips for very large database
2015-02-12 23:19 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Configuration tips for very large database
2015-02-13 14:01 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Configuration tips for very large database
2015-02-13 14:09 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Configuration tips for very large database
2015-02-14 19:42 UTC Nico Sabbi <nicola.sabbi@poste.it>
[9+ messages in thread]
Re[2]: [ADMIN] getting client_addr not as a superuser
2015-02-13 10:58 UTC Михаил <bemewe@mail.ru>
query - laziness of lateral join with function
2015-02-12 18:07 UTC paulcc <paulcc.two@gmail.com>
` Re: query - laziness of lateral join with function
2015-02-12 21:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query - laziness of lateral join with function
2015-02-12 22:16 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: query - laziness of lateral join with function
2015-02-12 23:28 UTC Paul Callaghan <paulcc.two@gmail.com>
[4+ messages in thread]
Survey: Max TPS you've ever seen
2015-02-09 19:30 UTC Luis Antonio Dias de Sá Junior <luisjunior.sa@gmail.com>
` Re: Survey: Max TPS you've ever seen
2015-02-09 21:29 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Survey: Max TPS you've ever seen
2015-02-10 10:48 UTC Luis Antonio Dias de Sá Junior <luisjunior.sa@gmail.com>
` Re: Survey: Max TPS you've ever seen
2015-02-10 11:27 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Survey: Max TPS you've ever seen
2015-02-11 00:31 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Survey: Max TPS you've ever seen
2015-02-12 11:12 UTC Luis Antonio Dias de Sá Junior <luisjunior.sa@gmail.com>
` Re: Survey: Max TPS you've ever seen
2015-02-12 11:20 UTC Gudmundsson Martin (mg) <martin.mg.gudmundsson@volvo.com>
` Re: Survey: Max TPS you've ever seen
2015-02-12 12:26 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Survey: Max TPS you've ever seen
2015-02-12 23:10 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[9+ messages in thread]
<empty string> Vs NULL
2015-02-09 11:22 UTC sridhar bamandlapally <sridhar.bn1@gmail.com>
` Re: [PERFORM] <empty string> Vs NULL
2015-02-09 11:53 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: <empty string> Vs NULL
2015-02-09 12:36 UTC Nikolas Everett <nik9000@gmail.com>
` Re: [PERFORM] <empty string> Vs NULL
2015-02-09 12:42 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: [ADMIN] <empty string> Vs NULL
2015-02-09 12:48 UTC Geoff Winkless <pgsqladmin@geoff.dj>
` Re: <empty string> Vs NULL
2015-02-09 12:57 UTC Geoff Winkless <pgsqladmin@geoff.dj>
` Re: [PERFORM] <empty string> Vs NULL
2015-02-09 13:02 UTC Marc Mamin <M.Mamin@intershop.de>
` Re: [PERFORM] <empty string> Vs NULL
2015-02-10 03:53 UTC sridhar bamandlapally <sridhar.bn1@gmail.com>
` Re: [PERFORM] <empty string> Vs NULL
2015-02-10 04:50 UTC Scott Ribe <scott_ribe@elevated-dev.com>
` Re: [PERFORM] <empty string> Vs NULL
2015-02-10 05:02 UTC David G Johnston <david.g.johnston@gmail.com>
` Re: [PERFORM] <empty string> Vs NULL
2015-02-10 10:07 UTC Florent Guillaume <fg@nuxeo.com>
` Re: [PERFORM] <empty string> Vs NULL
2015-02-10 10:40 UTC sridhar bamandlapally <sridhar.bn1@gmail.com>
` Re: [PERFORM] <empty string> Vs NULL
2015-02-10 14:32 UTC Scott Ribe <scott_ribe@elevated-dev.com>
[13+ messages in thread]
getting 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]
[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