pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery with no result set, really really slow adding ORBDER BY / LIMIT clause
2017-04-20 07:19 UTC Marco Renzi <renzi.mrc@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
2017-04-20 11:16 UTC Marco Renzi <renzi.mrc@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
2017-04-20 11:54 UTC vinny <vinny@xs4all.nl>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
2017-04-20 12:16 UTC Marco Renzi <renzi.mrc@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
2017-04-20 15:57 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
2017-04-20 16:05 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
2017-04-21 06:49 UTC Marco Renzi <renzi.mrc@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
2017-04-21 06:56 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
2017-04-21 07:05 UTC Marco Renzi <renzi.mrc@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
2017-04-21 07:12 UTC Pavel Stehule <pavel.stehule@gmail.com>
[10+ messages in thread]
update from performance question
2017-04-18 21:46 UTC Armand Pirvu (home) <armand.pirvu@gmail.com>
` Re: update from performance question
2017-04-19 08:06 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: update from performance question
2017-04-19 23:11 UTC Armand Pirvu (home) <armand.pirvu@gmail.com>
[3+ messages in thread]
Insert Concurrency
2017-04-18 02:55 UTC ROBERT PRICE <rprice504@hotmail.com>
` Re: Insert Concurrency
2017-04-18 05:41 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Insert Concurrency
2017-04-18 05:45 UTC Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: Insert Concurrency
2017-04-18 15:29 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Insert Concurrency
2017-04-18 15:41 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Insert Concurrency
2017-04-18 15:49 UTC David McKelvie <dmck@interactive.co.uk>
` Re: Insert Concurrency
2017-04-18 16:29 UTC ROBERT PRICE <rprice504@hotmail.com>
[7+ messages in thread]
Create a materialized view in PostgreSQL which can be access by all the user account
2017-04-17 17:00 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Create a materialized view in PostgreSQL which can be access by all the user account
2017-04-17 17:12 UTC David G. Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
Restoring Postgres Dump is very slow with Ubuntu 16.04
2017-04-15 08:11 UTC Hans Braxmeier <hans.braxmeier@outlook.com>
` Re: Restoring Postgres Dump is very slow with Ubuntu 16.04
2017-04-15 13:59 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
[2+ messages in thread]
self join estimate and constraint exclusion
2017-03-26 19:33 UTC Justin Pryzby <pryzby@telsasoft.com>
` self join estimate and constraint exclusion
2017-04-15 00:23 UTC Justin Pryzby <pryzby@telsasoft.com>
[2+ messages in thread]
Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
2017-04-14 23:30 UTC Hans Braxmeier <hans.braxmeier@outlook.com>
` Re: Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
2017-04-14 23:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Impact of track_activity_query_size on high traffic OLTP system
2017-04-13 20:45 UTC Jeremy Finzel <finzelj@gmail.com>
` Re: Impact of track_activity_query_size on high traffic OLTP system
2017-04-13 21:17 UTC Rick Otten <rottenwindfish@gmail.com>
[2+ messages in thread]
Postgresql, and ODBC handles
2017-04-13 19:30 UTC Reza Taheri <rtaheri@vmware.com>
Understanding PostgreSQL query execution time
2017-04-07 14:56 UTC Haider Ali <alihaider907@gmail.com>
` Re: Understanding PostgreSQL query execution time
2017-04-07 15:03 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: Understanding PostgreSQL query execution time
2017-04-07 15:15 UTC Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Understanding PostgreSQL query execution time
2017-04-10 12:18 UTC vinny <vinny@xs4all.nl>
[4+ messages in thread]
Filter certain range of IP address.
2017-04-07 14:13 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Filter certain range of IP address.
2017-04-07 14:22 UTC vinny <vinny@xs4all.nl>
` Re: Filter certain range of IP address.
2017-04-07 15:18 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Filter certain range of IP address.
2017-04-07 15:29 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Filter certain range of IP address.
2017-04-07 15:56 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: Filter certain range of IP address.
2017-04-07 16:09 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Filter certain range of IP address.
2017-04-07 16:20 UTC Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Filter certain range of IP address.
2017-04-10 11:33 UTC vinny <vinny@xs4all.nl>
[8+ messages in thread]
Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
2017-04-06 00:09 UTC Sfiligoi, Igor <Igor.Sfiligoi@ga.com>
` Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
2017-04-06 00:26 UTC rverghese <riyav@hotmail.com>
` Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
2017-04-06 01:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
2017-04-06 01:10 UTC rverghese <riyav@hotmail.com>
[4+ messages in thread]
Table not using tsvector gin index and performance much worse than when it uses it.
2017-04-05 22:51 UTC rverghese <riyav@hotmail.com>
` Re: Table not using tsvector gin index and performance much worse than when it uses it.
2017-04-05 23:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Table not using tsvector gin index and performance much worse than when it uses it.
2017-04-05 23:54 UTC rverghese <riyav@hotmail.com>
[3+ messages in thread]
How to send content of log file in official mailid.
2017-04-05 16:53 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
Best design for performance
2017-03-27 23:43 UTC Riaan Stander <rstander@exa.co.za>
` Re: Best design for performance
2017-03-28 00:42 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Best design for performance
2017-03-28 01:17 UTC Riaan Stander <rstander@exa.co.za>
` Re: Best design for performance
2017-03-28 02:22 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Best design for performance
2017-03-28 12:41 UTC Riaan Stander <rstander@exa.co.za>
` Re: Best design for performance
2017-03-28 17:15 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Best design for performance
2017-03-28 22:51 UTC Riaan Stander <rstander@exa.co.za>
[7+ messages in thread]
Postgres not using all RAM (Huge Page activated on a 96GB RAM system)
2017-03-24 09:58 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system)
2017-03-24 14:00 UTC Andrew Kerber <andrew.kerber@gmail.com>
` Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system)
2017-03-24 19:47 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system)
2017-03-24 20:16 UTC Álvaro Hernández Tortosa <aht@8kdata.com>
` Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system)
2017-03-25 01:27 UTC Shaun Thomas <bonesmoses@gmail.com>
` Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system)
2017-03-25 01:56 UTC trafdev <trafdev@mail.ru>
` Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system)
2017-03-27 13:27 UTC Merlin Moncure <mmoncure@gmail.com>
[7+ messages in thread]
Performance issue after upgrading from 9.4 to 9.6
2017-03-06 13:20 UTC Piotr Gasidło <quaker@barbara.eu.org>
` Re: Performance issue after upgrading from 9.4 to 9.6
2017-03-27 13:21 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
Optimizing around retained tuples
2017-03-21 19:24 UTC James Parks <james.parks@meraki.net>
` Re: Optimizing around retained tuples
2017-03-22 01:56 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Optimizing around retained tuples
2017-03-22 01:58 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Optimizing around retained tuples
2017-03-24 16:00 UTC Brad DeJong <Brad.Dejong@infor.com>
[4+ messages in thread]
Please help with a slow query: there are millions of records, what can we do?
2017-03-08 02:26 UTC Pat Maddox <pat@adorable.io>
` Re: Please help with a slow query: there are millions of records, what can we do?
2017-03-08 10:05 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Please help with a slow query: there are millions of records, what can we do?
2017-03-08 18:00 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Please help with a slow query: there are millions of records, what can we do?
2017-03-22 15:07 UTC Pat Maddox <pat@adorable.io>
[4+ messages in thread]
Auto generate number in Postgres-9.1.
2017-03-20 13:38 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Auto generate number in Postgres-9.1.
2017-03-20 13:43 UTC Josh Berkus <josh@berkus.org>
` Re: Auto generate number in Postgres-9.1.
2017-03-20 13:48 UTC Andreas Karlsson <andreas@proxel.se>
` Re: Auto generate number in Postgres-9.1.
2017-03-20 13:50 UTC John Gorman <jgorman@eldocomp.com>
` Re: Auto generate number in Postgres-9.1.
2017-03-20 14:08 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Auto generate number in Postgres-9.1.
2017-03-20 15:40 UTC Andreas Karlsson <andreas@proxel.se>
[6+ messages in thread]
Huge difference between ASC and DESC ordering
2017-03-06 14:22 UTC twoflower <standa.kurik@gmail.com>
` Re: Huge difference between ASC and DESC ordering
2017-03-06 16:19 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Huge difference between ASC and DESC ordering
2017-03-06 16:46 UTC twoflower <standa.kurik@gmail.com>
` Re: Huge difference between ASC and DESC ordering
2017-03-06 17:11 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Huge difference between ASC and DESC ordering
2017-03-07 08:40 UTC twoflower <standa.kurik@gmail.com>
[5+ messages in thread]
Speeding up JSON + TSQUERY + GIN
2017-02-26 13:28 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Speeding up JSON + TSQUERY + GIN
2017-02-26 20:13 UTC Oleg Bartunov <obartunov@gmail.com>
` Re: Speeding up JSON + TSQUERY + GIN
2017-02-27 14:46 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Speeding up JSON + TSQUERY + GIN
2017-02-27 18:22 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Speeding up JSON + TSQUERY + GIN
2017-02-28 08:27 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Speeding up JSON + TSQUERY + GIN
2017-02-28 16:49 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Speeding up JSON + TSQUERY + GIN
2017-03-01 14:02 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Speeding up JSON + TSQUERY + GIN
2017-03-01 17:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Speeding up JSON + TSQUERY + GIN
2017-03-02 21:19 UTC Sven R. Kunze <srkunze@mail.de>
` Re: Speeding up JSON + TSQUERY + GIN
2017-03-06 04:25 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Speeding up JSON + TSQUERY + GIN
2017-03-06 21:10 UTC Sven R. Kunze <srkunze@mail.de>
[11+ messages in thread]
Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-02-21 13:49 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-02-21 15:04 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-02-21 19:40 UTC Wes Vaske (wvaske) <wvaske@micron.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-02-21 20:01 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-02-21 20:09 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-02-21 21:50 UTC Wes Vaske (wvaske) <wvaske@micron.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-02-21 23:18 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-02-21 23:44 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-02-21 23:46 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-02-22 15:36 UTC Wes Vaske (wvaske) <wvaske@micron.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-03-02 21:51 UTC Pietro Pugni <pietro.pugni@gmail.com>
` Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
2017-03-03 15:03 UTC Merlin Moncure <mmoncure@gmail.com>
[12+ messages in thread]
How Can I check PostgreSQL backup is successfully or not ?
2017-02-27 09:35 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: How Can I check PostgreSQL backup is successfully or not ?
2017-02-27 10:36 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: How Can I check PostgreSQL backup is successfully or not ?
2017-02-27 13:29 UTC John Gorman <jgorman@eldocomp.com>
` Re: How Can I check PostgreSQL backup is successfully or not ?
2017-02-27 14:00 UTC vinny <vinny@xs4all.nl>
` Re: How Can I check PostgreSQL backup is successfully or not ?
2017-02-27 14:10 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: How Can I check PostgreSQL backup is successfully or not ?
2017-03-02 12:05 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: How Can I check PostgreSQL backup is successfully or not ?
2017-03-02 13:14 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: How Can I check PostgreSQL backup is successfully or not ?
2017-03-02 13:19 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: How Can I check PostgreSQL backup is successfully or not ?
2017-03-02 16:26 UTC ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: How Can I check PostgreSQL backup is successfully or not ?
2017-03-02 16:32 UTC Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: How Can I check PostgreSQL backup is successfully or not ?
2017-03-02 16:50 UTC Gustavo Vargas <gustavo.nv@gmail.com>
[11+ messages in thread]
anti-join with small table via text/varchar cannot estimate rows correctly
2017-03-01 22:00 UTC Stefan Andreatta <s.andreatta@synedra.com>
` Re: anti-join with small table via text/varchar cannot estimate rows correctly
2017-03-01 22:12 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: anti-join with small table via text/varchar cannot estimate rows correctly
2017-03-02 00:24 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: anti-join with small table via text/varchar cannot estimate rows correctly
2017-03-02 00:28 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: anti-join with small table via text/varchar cannot estimate rows correctly
2017-03-02 01:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: anti-join with small table via text/varchar cannot estimate rows correctly
2017-03-02 05:14 UTC Stefan Andreatta <s.andreatta@synedra.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