pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCREATE EXTENSION postgis;
2017-07-20 09:05 UTC Daulat Ram <Daulat.Ram@cyient.com>
` Re: CREATE EXTENSION postgis;
2017-07-20 10:51 UTC Florent Guillaume <fguillaume@nuxeo.com>
[2+ messages in thread]
partitioning materialized views
2017-07-06 15:03 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioning materialized views
2017-07-06 15:25 UTC Shaun Thomas <shaun.thomas@2ndquadrant.com>
` Re: partitioning materialized views
2017-07-06 16:05 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioning materialized views
2017-07-06 16:27 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: partitioning materialized views
2017-07-07 13:12 UTC Shaun Thomas <shaun.thomas@2ndquadrant.com>
` Re: partitioning materialized views
2017-07-20 01:23 UTC Claudio Freire <klaussfreire@gmail.com>
[6+ messages in thread]
How to grant only create schemas and create database objects permission to user.
2017-07-19 12:23 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: How to grant only create schemas and create database objects permission to user.
2017-07-19 13:43 UTC vinny <vinny@xs4all.nl>
[2+ messages in thread]
Performance degradation from PostgreSQL 8.2.21 to PostgreSQL 9.3.2
2017-07-19 01:54 UTC fx TATEISHI KOJI <koji.tateishi@fujixerox.co.jp>
` Re: Performance degradation from PostgreSQL 8.2.21 to PostgreSQL 9.3.2
2017-07-19 06:46 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[2+ messages in thread]
Postgres Dump - Creating index never stops
2017-07-12 19:00 UTC Hans Braxmeier <hans.braxmeier@outlook.com>
` Re: Postgres Dump - Creating index never stops
2017-07-12 19:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
vacuum analyze affecting query performance
2017-07-10 17:25 UTC rverghese <riyav@hotmail.com>
` Re: vacuum analyze affecting query performance
2017-07-11 07:15 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: vacuum analyze affecting query performance
2017-07-11 15:57 UTC rverghese <riyav@hotmail.com>
[3+ messages in thread]
estimate correlation of index separately from table (Re: index fragmentation on insert-only table with non-unique column)
2017-07-07 23:41 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: estimate correlation of index separately from table (Re: index fragmentation on insert-only table with non-unique column)
2017-07-08 03:27 UTC Peter Geoghegan <pg@bowt.ie>
[2+ messages in thread]
Unable to start the slave instance
2017-07-05 09:14 UTC Daulat Ram <Daulat.Ram@cyient.com>
` Unable to start the slave instance
2017-07-05 09:26 UTC Daulat Ram <Daulat.Ram@cyient.com>
` Re: Unable to start the slave instance
2017-07-05 13:10 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Unable to start the slave instance
2017-07-06 05:02 UTC Daulat Ram <Daulat.Ram@cyient.com>
` Re: Unable to start the slave instance
2017-07-06 05:10 UTC Michael Paquier <michael.paquier@gmail.com>
[5+ messages in thread]
Simple SQL too slow
2017-06-30 19:14 UTC Daviramos Roussenq Fortunato <daviramosrf@gmail.com>
` Re: Simple SQL too slow
2017-06-30 19:50 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Simple SQL too slow
2017-07-01 16:56 UTC Daviramos Roussenq Fortunato <daviramosrf@gmail.com>
` Re: Simple SQL too slow
2017-07-01 19:44 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Simple SQL too slow
2017-07-01 20:39 UTC Daviramos Roussenq Fortunato <daviramosrf@gmail.com>
` Re: Simple SQL too slow
2017-07-01 20:58 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Simple SQL too slow
2017-07-01 21:17 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
` Re: Simple SQL too slow
2017-07-02 01:26 UTC Daviramos Roussenq Fortunato <daviramosrf@gmail.com>
` Re: Simple SQL too slow
2017-07-02 04:25 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Simple SQL too slow
2017-07-02 08:39 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Simple SQL too slow
2017-07-02 10:01 UTC Nicolas CHARLES <nicolas.charles@normation.com>
` Re: Simple SQL too slow
2017-07-02 13:57 UTC Daviramos Roussenq Fortunato <daviramosrf@gmail.com>
[12+ messages in thread]
(no subject)
2017-06-28 06:47 UTC Yevhenii Kurtov <yevhenii.kurtov@gmail.com>
` Re:
2017-06-28 07:12 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re:
2017-06-28 07:28 UTC Yevhenii Kurtov <yevhenii.kurtov@gmail.com>
` Re:
2017-06-28 07:43 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re:
2017-06-28 13:08 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re:
2017-06-28 13:10 UTC Brad DeJong <Brad.Dejong@infor.com>
` Re:
2017-06-29 05:17 UTC Yevhenii Kurtov <yevhenii.kurtov@gmail.com>
` Re:
2017-06-29 15:50 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re:
2017-06-29 18:11 UTC Jeff Janes <jeff.janes@gmail.com>
` Re:
2017-06-29 19:11 UTC Yevhenii Kurtov <yevhenii.kurtov@gmail.com>
` Re:
2017-06-29 21:28 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re:
2017-06-30 03:09 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re:
2017-06-30 17:46 UTC Jeff Janes <jeff.janes@gmail.com>
[13+ messages in thread]
Performance of information_schema with many schemata and tables
2017-06-27 23:57 UTC Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: Performance of information_schema with many schemata and tables
2017-06-28 01:31 UTC Pritam Baral <pritam@pritambaral.com>
` Re: Performance of information_schema with many schemata and tables
2017-06-28 09:38 UTC Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
` Re: Performance of information_schema with many schemata and tables
2017-06-28 14:25 UTC Ulf Lohbrügge <ulf.lohbruegge@gmail.com>
[4+ messages in thread]
Efficiently merging and sorting collections of sorted rows
2017-06-23 22:58 UTC Clint Miller <clint.miller1@gmail.com>
` Re: Efficiently merging and sorting collections of sorted rows
2017-06-23 23:32 UTC Peter Geoghegan <pg@bowt.ie>
` Re: Efficiently merging and sorting collections of sorted rows
2017-06-23 23:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Efficiently merging and sorting collections of sorted rows
2017-06-28 13:13 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
Fwd: Stalled post to pgsql-performance
2017-06-27 13:15 UTC Chris Wilson <chris+postgresql@qwirx.com>
Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-23 20:09 UTC Chris Wilson <chris+postgresql@qwirx.com>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-24 02:01 UTC Karl Czajkowski <karlcz@isi.edu>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-26 15:43 UTC Chris Wilson <chris+postgresql@qwirx.com>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-26 17:01 UTC Karl Czajkowski <karlcz@isi.edu>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-26 20:32 UTC Karl Czajkowski <karlcz@isi.edu>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
2017-06-26 21:22 UTC Jeff Janes <jeff.janes@gmail.com>
[6+ messages in thread]
Inappropriate inner table for nested loop join
2017-06-23 10:31 UTC Akihiko Odaki <akihiko.odaki.4i@stu.hosei.ac.jp>
` Re: Inappropriate inner table for nested loop join
2017-06-23 11:20 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Inappropriate inner table for nested loop join
2017-06-23 11:36 UTC Akihiko Odaki <akihiko.odaki.4i@stu.hosei.ac.jp>
` Re: Inappropriate inner table for nested loop join
2017-06-23 11:54 UTC Akihiko Odaki <akihiko.odaki.4i@stu.hosei.ac.jp>
` Re: Inappropriate inner table for nested loop join
2017-06-23 13:05 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Inappropriate inner table for nested loop join
2017-06-26 08:55 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[6+ messages in thread]
slow delete due to reference
2017-06-24 07:28 UTC Rikard Pavelic <rikard@ngs.hr>
` Re: slow delete due to reference
2017-06-24 16:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 00:40 UTC Sumeet Shukla <sumeet.k.shukla@gmail.com>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 00:54 UTC Dave Stibrany <dstibrany@gmail.com>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 04:35 UTC Sumeet Shukla <sumeet.k.shukla@gmail.com>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 04:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 07:52 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 12:09 UTC Adam Brusselback <adambrusselback@gmail.com>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
2017-06-23 16:55 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
[7+ messages in thread]
substring index what is better way to query
2017-06-20 11:51 UTC Tieson Molly <tvmaly@gmail.com>
` Re: substring index what is better way to query
2017-06-20 14:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: substring index what is better way to query
2017-06-20 14:40 UTC Tieson Molly <tvmaly@gmail.com>
` Re: substring index what is better way to query
2017-06-20 14:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Using array instead of sub table (storage and speed)
2017-06-15 08:06 UTC Lutz Fischer <l.fischer@ed.ac.uk>
` Re: Using array instead of sub table (storage and speed)
2017-06-15 13:37 UTC Stephen Frost <sfrost@snowman.net>
` Re: Using array instead of sub table (storage and speed)
2017-06-16 10:37 UTC Lutz Fischer <l.fischer@ed.ac.uk>
` Re: Using array instead of sub table (storage and speed)
2017-06-16 12:05 UTC Stephen Frost <sfrost@snowman.net>
[4+ messages in thread]
Re: Re: join under-estimates with ineq conditions
2017-06-08 16:05 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Re: join under-estimates with ineq conditions
2017-06-16 02:53 UTC Justin Pryzby <pryzby@telsasoft.com>
[2+ messages in thread]
Sudden drastic change in performance
2017-06-15 14:53 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: Sudden drastic change in performance
2017-06-15 15:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sudden drastic change in performance
2017-06-15 15:14 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[3+ messages in thread]
Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-09 13:55 UTC Cocco Gianfranco <Gianfranco.Cocco@eng.it>
` Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-09 22:43 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-12 17:27 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-12 21:25 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-13 09:34 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-13 20:38 UTC Michael Paquier <michael.paquier@gmail.com>
[6+ messages in thread]
R: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
2017-06-13 09:10 UTC Cocco Gianfranco <Gianfranco.Cocco@eng.it>
Rollback table data.
2017-06-07 11:33 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Rollback table data.
2017-06-07 12:42 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Rollback table data.
2017-06-07 12:48 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Rollback table data.
2017-06-07 13:23 UTC Anthony Sotolongo <asotolongo@gmail.com>
` Re: Rollback table data.
2017-06-08 00:15 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Rollback table data.
2017-06-10 07:04 UTC phb07 <phb07@apra.asso.fr>
[6+ messages in thread]
index of only not null, use function index?
2017-05-22 15:17 UTC Ariel <aspostgresql@dsgml.com>
` Re: index of only not null, use function index?
2017-06-08 14:47 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: index of only not null, use function index?
2017-06-08 14:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: index of only not null, use function index?
2017-06-08 16:05 UTC Jeremy Finzel <finzelj@gmail.com>
` Re: index of only not null, use function index?
2017-06-08 19:57 UTC Merlin Moncure <mmoncure@gmail.com>
[5+ 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