pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCan you please suggest me some links where I can learn:
2013-09-05 05:13 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` Re: Can you please suggest me some links where I can learn:
2013-09-05 05:25 UTC John R Pierce <pierce@hogranch.com>
` Re: [PERFORM] Can you please suggest me some links where I can learn:
2013-09-05 15:39 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: [PERFORM] Can you please suggest me some links where I can learn:
2013-09-05 22:42 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: [PERFORM] Can you please suggest me some links where I can learn:
2013-09-05 22:53 UTC John R Pierce <pierce@hogranch.com>
[5+ messages in thread]
higth performance write to disk
2013-09-04 15:22 UTC Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
` Re: higth performance write to disk
2013-09-04 15:27 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: higth performance write to disk
2013-09-04 18:52 UTC Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
` Re: higth performance write to disk
2013-09-04 19:19 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: higth performance write to disk
2013-09-04 19:39 UTC Merlin Moncure <mmoncure@gmail.com>
[5+ messages in thread]
Slow query-plan generation (fast query) PG 9.2
2013-09-03 07:46 UTC jesper@krogh.cc
` Re: Slow query-plan generation (fast query) PG 9.2
2013-09-03 07:47 UTC Craig Ringer <craig@2ndquadrant.com>
` Re: Slow query-plan generation (fast query) PG 9.2
2013-09-03 19:34 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Slow query-plan generation (fast query) PG 9.2
2013-09-04 13:59 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
AMD vs Intel
2013-09-04 09:01 UTC Johan Loubser <johanl@sun.ac.za>
` Re: AMD vs Intel
2013-09-04 10:41 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: AMD vs Intel
2013-09-04 13:14 UTC David Boreham <david_list@boreham.org>
[3+ messages in thread]
SQL statement over 500% slower with 9.2 compared with 9.1
2013-08-26 12:33 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: SQL statement over 500% slower with 9.2 compared with 9.1
2013-08-27 09:19 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: SQL statement over 500% slower with 9.2 compared with 9.1
2013-08-27 21:27 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: SQL statement over 500% slower with 9.2 compared with 9.1
2013-08-28 04:10 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: SQL statement over 500% slower with 9.2 compared with 9.1
2013-08-28 09:07 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: SQL statement over 500% slower with 9.2 compared with 9.1
2013-08-28 10:15 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
` Re: SQL statement over 500% slower with 9.2 compared with 9.1
2013-08-28 19:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: SQL statement over 500% slower with 9.2 compared with 9.1
2013-09-04 06:49 UTC Rafael Martinez <r.m.guerrero@usit.uio.no>
[8+ messages in thread]
Weird case of wrong index choice
2013-09-03 21:47 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Weird case of wrong index choice
2013-09-03 23:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Weird case of wrong index choice
2013-09-03 23:49 UTC Claudio Freire <klaussfreire@gmail.com>
[3+ messages in thread]
apply
2013-09-03 22:16 UTC Milos Babic <milos.babic@gmail.com>
planner parameters
2013-09-02 19:57 UTC Torsten Förtsch <torsten.foertsch@gmx.net>
` Re: planner parameters
2013-09-03 19:02 UTC Kevin Grittner <kgrittn@ymail.com>
[2+ messages in thread]
Query plan change with multiple elements in IN clause
2013-08-30 09:05 UTC Mathieu De Zutter <mathieu@dezutter.org>
` Re: Query plan change with multiple elements in IN clause
2013-08-30 14:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Poor OFFSET performance in PostgreSQL 9.1.6
2013-08-28 20:39 UTC fburgess@radiantblue.com
` Re: Poor OFFSET performance in PostgreSQL 9.1.6
2013-08-28 21:26 UTC Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Poor OFFSET performance in PostgreSQL 9.1.6
2013-08-28 22:08 UTC fburgess@radiantblue.com
` Re: Poor OFFSET performance in PostgreSQL 9.1.6
2013-08-28 23:10 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Poor OFFSET performance in PostgreSQL 9.1.6
2013-08-29 04:43 UTC David Rowley <dgrowleyml@gmail.com>
` Re: Poor OFFSET performance in PostgreSQL 9.1.6
2013-08-29 11:00 UTC hubert depesz lubaczewski <depesz@depesz.com>
[6+ messages in thread]
Poor performance on simple queries compared to sql server express
2013-08-26 05:09 UTC Adam Ma'ruf <adam.maruf@gmail.com>
` Re: Poor performance on simple queries compared to sql server express
2013-08-26 06:36 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Poor performance on simple queries compared to sql server express
2013-08-26 13:02 UTC Adam Ma'ruf <adam.maruf@gmail.com>
` Re: Poor performance on simple queries compared to sql server express
2013-08-26 13:40 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Poor performance on simple queries compared to sql server express
2013-08-27 04:06 UTC Adam Ma'ruf <adam.maruf@gmail.com>
` Re: Poor performance on simple queries compared to sql server express
2013-08-27 21:37 UTC Tomas Vondra <tv@fuzzy.cz>
[6+ messages in thread]
PostgreSQL 9.2.4 very slow on laptop with windows 8
2013-08-22 11:30 UTC girish subbaramu <gsubbaramu@hotmail.com>
` Re: PostgreSQL 9.2.4 very slow on laptop with windows 8
2013-08-22 15:25 UTC Imre Samu <pella.samu@gmail.com>
` Re: PostgreSQL 9.2.4 very slow on laptop with windows 8
2013-08-23 08:14 UTC Richard Huxton <dev@archonet.com>
` Re: PostgreSQL 9.2.4 very slow on laptop with windows 8
2013-08-26 07:23 UTC girish subbaramu <gsubbaramu@hotmail.com>
[4+ messages in thread]
How to investiage slow insert problem
2013-08-20 01:44 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: How to investiage slow insert problem
2013-08-20 02:38 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: How to investiage slow insert problem
2013-08-20 02:45 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: How to investiage slow insert problem
2013-08-20 03:01 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: How to investiage slow insert problem
2013-08-20 04:34 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: How to investiage slow insert problem
2013-08-20 05:30 UTC Rural Hunter <ruralhunter@gmail.com>
` How to investiage slow insert problem
2013-08-21 00:24 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: How to investiage slow insert problem
2013-08-21 01:33 UTC Rural Hunter <ruralhunter@gmail.com>
` Re: How to investiage slow insert problem
2013-08-21 13:10 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: How to investiage slow insert problem
2013-08-21 13:17 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
[10+ messages in thread]
Function execute slow down in 9.2
2013-08-12 14:59 UTC Александр Белинский <avinfo79@gmail.com>
` Re: Function execute slow down in 9.2
2013-08-12 15:24 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Function execute slow down in 9.2
2013-08-16 12:27 UTC Александр Белинский <avinfo79@gmail.com>
` Re: Function execute slow down in 9.2
2013-08-21 09:03 UTC Pavel Stehule <pavel.stehule@gmail.com>
[4+ messages in thread]
queries with DISTINCT / GROUP BY giving different plans
2013-08-14 15:33 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: queries with DISTINCT / GROUP BY giving different plans
2013-08-14 18:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: queries with DISTINCT / GROUP BY giving different plans
2013-08-16 19:20 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: queries with DISTINCT / GROUP BY giving different plans
2013-08-16 19:36 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: queries with DISTINCT / GROUP BY giving different plans
2013-08-20 15:13 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: queries with DISTINCT / GROUP BY giving different plans
2013-08-20 16:24 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: queries with DISTINCT / GROUP BY giving different plans
2013-08-20 17:56 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: queries with DISTINCT / GROUP BY giving different plans
2013-08-20 21:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: queries with DISTINCT / GROUP BY giving different plans
2013-08-20 22:21 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: queries with DISTINCT / GROUP BY giving different plans
2013-08-20 23:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
[10+ messages in thread]
Can query planner prefer a JOIN over a high-cost Function?
2013-08-20 18:06 UTC David McNett <pglists@macnugget.org>
` Re: Can query planner prefer a JOIN over a high-cost Function?
2013-08-20 19:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
DBT5 execution failed due to undefined symbol: PQescapeLiteral
2013-08-16 04:13 UTC amul sul <sul_amul@yahoo.co.in>
` Re: DBT5 execution failed due to undefined symbol: PQescapeLiteral
2013-08-16 07:26 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: DBT5 execution failed due to undefined symbol: PQescapeLiteral
2013-08-20 07:13 UTC amulsul <sul_amul@yahoo.co.in>
[3+ messages in thread]
Create one query out of two
2013-08-17 20:19 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Create one query out of two
2013-08-18 00:31 UTC Calvin Dodge <caldodge@gmail.com>
` Re: Create one query out of two
2013-08-18 20:23 UTC Kevin Grittner <kgrittn@ymail.com>
[3+ messages in thread]
Need some basic information
2013-08-14 05:38 UTC M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
` Re: Need some basic information
2013-08-16 00:57 UTC Josh Berkus <josh@agliodbs.com>
[2+ messages in thread]
Index on a range array
2013-08-13 20:47 UTC Daniel Cristian Cruz <danielcristian@gmail.com>
` Re: Index on a range array
2013-08-14 12:21 UTC Daniel Cristian Cruz <danielcristian@gmail.com>
` Re: Index on a range array
2013-08-15 07:30 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
[3+ messages in thread]
Interesting case of IMMUTABLE significantly hurting performance
2013-08-14 00:41 UTC Craig Ringer <craig@2ndquadrant.com>
` Re: Interesting case of IMMUTABLE significantly hurting performance
2013-08-14 02:46 UTC Craig Ringer <craig@2ndquadrant.com>
` Re: Interesting case of IMMUTABLE significantly hurting performance
2013-08-14 03:52 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Interesting case of IMMUTABLE significantly hurting performance
2013-08-14 03:57 UTC Craig Ringer <craig@2ndquadrant.com>
` Re: Interesting case of IMMUTABLE significantly hurting performance
2013-08-14 04:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Interesting case of IMMUTABLE significantly hurting performance
2013-08-14 04:44 UTC Craig Ringer <craig@2ndquadrant.com>
` Re: Interesting case of IMMUTABLE significantly hurting performance
2013-08-14 19:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
[7+ messages in thread]
subselect requires offset 0 for good performance.
2013-08-01 19:40 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: subselect requires offset 0 for good performance.
2013-08-01 21:15 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: subselect requires offset 0 for good performance.
2013-08-01 23:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: subselect requires offset 0 for good performance.
2013-08-02 01:22 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: subselect requires offset 0 for good performance.
2013-08-02 07:37 UTC Vik Fearing <vik.fearing@dalibo.com>
` Re: subselect requires offset 0 for good performance.
2013-08-02 17:08 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: subselect requires offset 0 for good performance.
2013-08-02 19:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: subselect requires offset 0 for good performance.
2013-08-02 19:58 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: subselect requires offset 0 for good performance.
2013-08-02 20:26 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: subselect requires offset 0 for good performance.
2013-08-02 20:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: subselect requires offset 0 for good performance.
2013-08-02 21:27 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: subselect requires offset 0 for good performance.
2013-08-06 22:12 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: subselect requires offset 0 for good performance.
2013-08-08 22:09 UTC Vik Fearing <vik.fearing@dalibo.com>
` Re: subselect requires offset 0 for good performance.
2013-08-13 21:01 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: subselect requires offset 0 for good performance.
2013-08-13 22:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: subselect requires offset 0 for good performance.
2013-08-13 23:42 UTC Scott Marlowe <scott.marlowe@gmail.com>
[16+ messages in thread]
Efficient Correlated Update
2013-08-08 18:06 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Efficient Correlated Update
2013-08-08 22:21 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Efficient Correlated Update
2013-08-09 15:44 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Efficient Correlated Update
2013-08-09 15:49 UTC Klaus Ita <klaus@worstofall.com>
` Re: Efficient Correlated Update
2013-08-09 15:52 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Efficient Correlated Update
2013-08-09 15:54 UTC Igor Neyman <ineyman@perceptron.com>
[6+ messages in thread]
Efficiently query for the most recent record for a given user
2013-08-07 18:12 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Efficiently query for the most recent record for a given user
2013-08-07 18:19 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Efficiently query for the most recent record for a given user
2013-08-07 18:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Efficiently query for the most recent record for a given user
2013-08-07 18:35 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Efficiently query for the most recent record for a given user
2013-08-07 18:39 UTC Robert DiFalco <robert.difalco@gmail.com>
` Re: Efficiently query for the most recent record for a given user
2013-08-07 18:39 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Efficiently query for the most recent record for a given user
2013-08-07 19:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Efficiently query for the most recent record for a given user
2013-08-07 19:05 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Efficiently query for the most recent record for a given user
2013-08-07 19:13 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Efficiently query for the most recent record for a given user
2013-08-08 20:08 UTC Claudio Freire <klaussfreire@gmail.com>
[10+ messages in thread]
Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-02 13:43 UTC slapo@centrum.sk
` Re: Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-05 08:14 UTC slapo@centrum.sk
` Re: Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-06 19:01 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-07 12:42 UTC slapo@centrum.sk
` Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-07 13:46 UTC Igor Neyman <ineyman@perceptron.com>
` RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-07 14:42 UTC slapo@centrum.sk
` Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-07 14:48 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-07 14:48 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-07 14:49 UTC Pavel Stehule <pavel.stehule@gmail.com>
` RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-07 15:33 UTC slapo@centrum.sk
` Re: Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-07 15:50 UTC Igor Neyman <ineyman@perceptron.com>
` Re: RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-07 15:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] RE: [PERFORM] Re: [PERFORM] Sub-optimal plan for a paginated query on a view with another view inside of it.
2013-08-08 06:59 UTC slapo@centrum.sk
[13+ 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