pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedINDEX Performance Issue
2013-04-05 15:51 UTC Mark Davidson <mark@4each.co.uk>
` Re: INDEX Performance Issue
2013-04-05 16:37 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: INDEX Performance Issue
2013-04-07 10:03 UTC Mark Davidson <mark@4each.co.uk>
` Re: INDEX Performance Issue
2013-04-07 10:21 UTC Greg Williamson <gwilliamson39@yahoo.com>
` Re: INDEX Performance Issue
2013-04-07 15:15 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: INDEX Performance Issue
2013-04-07 22:22 UTC Mark Davidson <mark@4each.co.uk>
` Re: INDEX Performance Issue
2013-04-08 17:02 UTC Mark Davidson <mark@4each.co.uk>
` Re: INDEX Performance Issue
2013-04-08 17:19 UTC Vasilis Ventirozos <v.ventirozos@gmail.com>
` Re: INDEX Performance Issue
2013-04-08 19:31 UTC Mark Davidson <mark@4each.co.uk>
` Re: INDEX Performance Issue
2013-04-08 20:02 UTC Vasilis Ventirozos <v.ventirozos@gmail.com>
` Re: INDEX Performance Issue
2013-04-08 20:18 UTC Mark Davidson <mark@4each.co.uk>
` Re: INDEX Performance Issue
2013-04-08 20:28 UTC Vasilis Ventirozos <v.ventirozos@gmail.com>
` Re: INDEX Performance Issue
2013-04-08 20:39 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: INDEX Performance Issue
2013-04-08 20:57 UTC Mark Davidson <mark@4each.co.uk>
` Re: INDEX Performance Issue
2013-04-08 21:01 UTC Mark Davidson <mark@4each.co.uk>
` Re: INDEX Performance Issue
2013-04-15 19:30 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: INDEX Performance Issue
2013-04-15 19:37 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: INDEX Performance Issue
2013-04-15 20:16 UTC Jeff Janes <jeff.janes@gmail.com>
[18+ messages in thread]
Advice on testing buffer spin lock contention
2013-04-15 06:09 UTC Atri Sharma <atri.jiit@gmail.com>
` Re: Advice on testing buffer spin lock contention
2013-04-15 17:54 UTC Atri Sharma <atri.jiit@gmail.com>
[2+ messages in thread]
Segment best size
2013-04-12 16:45 UTC Rodrigo Barboza <rodrigombufrj@gmail.com>
` Re: Segment best size
2013-04-12 17:52 UTC Ben Chobot <bench@silentmedia.com>
` Re: Segment best size
2013-04-12 19:17 UTC Rodrigo Barboza <rodrigombufrj@gmail.com>
` Re: Segment best size
2013-04-13 01:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Segment best size
2013-04-13 17:29 UTC Rodrigo Barboza <rodrigombufrj@gmail.com>
` Re: Segment best size
2013-04-13 19:51 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Segment best size
2013-04-14 03:01 UTC Rodrigo Barboza <rodrigombufrj@gmail.com>
` Re: Segment best size
2013-04-14 05:20 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Segment best size
2013-04-14 22:34 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Segment best size
2013-04-14 23:29 UTC Rodrigo Barboza <rodrigombufrj@gmail.com>
[10+ messages in thread]
limit is sometimes not pushed in view with order
2013-04-13 08:25 UTC Rikard Pavelic <rikard@ngs.hr>
` Re: limit is sometimes not pushed in view with order
2013-04-13 15:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: limit is sometimes not pushed in view with order
2013-04-13 15:36 UTC Julian <tempura@internode.on.net>
` Re: limit is sometimes not pushed in view with order
2013-04-13 18:08 UTC Rikard Pavelic <rikard@ngs.hr>
` Re: limit is sometimes not pushed in view with order
2013-04-14 10:34 UTC Rikard Pavelic <rikard@ngs.hr>
[5+ messages in thread]
Recommended Swap space
2013-04-12 21:05 UTC Nik Tek <niktek2005@gmail.com>
` Re: Recommended Swap space
2013-04-12 21:15 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Recommended Swap space
2013-04-12 21:21 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: [PERFORM] Recommended Swap space
2013-04-12 23:06 UTC Scott Marlowe <scott.marlowe@gmail.com>
[4+ messages in thread]
Default value checkpoint_completion_target
2013-04-12 21:40 UTC Rodrigo Barboza <rodrigombufrj@gmail.com>
Changing ORDER BY column slows query dramatically
2013-04-12 16:51 UTC brick pglists <brickpglists@gmail.com>
` Re: Changing ORDER BY column slows query dramatically
2013-04-12 19:59 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Changing ORDER BY column slows query dramatically
2013-04-12 20:38 UTC brick pglists <brickpglists@gmail.com>
[3+ messages in thread]
PsqL8.3
2013-04-11 21:09 UTC Thiyagarajan, Palaniappan <pthiyagarajan@cashedge.com>
` Re: PsqL8.3
2013-04-12 10:02 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
Postgres log(pg_logs) have lots of message
2013-04-10 21:58 UTC Nik Tek <niktek2005@gmail.com>
` Re: Postgres log(pg_logs) have lots of message
2013-04-10 22:00 UTC Bambi Bellows <bbellows@dotomi.com>
` Re: [ADMIN] Postgres log(pg_logs) have lots of message
2013-04-10 22:05 UTC Nik Tek <niktek2005@gmail.com>
` Re: [PERFORM] Postgres log(pg_logs) have lots of message
2013-04-12 06:14 UTC Jeff Janes <jeff.janes@gmail.com>
[4+ messages in thread]
Performance ts_vector fulltext search
2013-04-11 07:47 UTC Luigi Saggese <luigisag@gmail.com>
` Re: Performance ts_vector fulltext search
2013-04-11 14:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Postgresql.conf file from like 7.x to 9.2
2013-04-10 21:25 UTC Tory M Blue <tmblue@gmail.com>
` Re: Postgresql.conf file from like 7.x to 9.2
2013-04-10 21:42 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Postgresql.conf file from like 7.x to 9.2
2013-04-10 21:53 UTC Tory M Blue <tmblue@gmail.com>
[3+ messages in thread]
Find how much memory is postgres using
2013-04-07 04:59 UTC Nik Tek <niktek2005@gmail.com>
` Re: [PERFORM] Find how much memory is postgres using
2013-04-07 07:15 UTC Yetkin Öztürk <yetkin85@gmail.com>
` Re: [PERFORM] Find how much memory is postgres using
2013-04-07 09:49 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Find how much memory is postgres using
2013-04-08 07:13 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Find how much memory is postgres using
2013-04-08 10:18 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Find how much memory is postgres using
2013-04-09 18:24 UTC Nik Tek <niktek2005@gmail.com>
` Re: Find how much memory is postgres using
2013-04-09 18:34 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Find how much memory is postgres using
2013-04-09 18:42 UTC Nik Tek <niktek2005@gmail.com>
[8+ messages in thread]
Picking out the most recent row using a time stamp column
2011-02-24 19:55 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-24 20:11 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-24 20:18 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Picking out the most recent row using a time stamp column
2011-02-24 20:21 UTC Michael Glaesemann <grzm@seespotcode.net>
` Re: Picking out the most recent row using a time stamp column
2011-02-24 20:24 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Picking out the most recent row using a time stamp column
2011-02-24 21:14 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-24 23:38 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-25 00:20 UTC Josh Berkus <josh@agliodbs.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-25 00:58 UTC Shaun Thomas <sthomas@peak6.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-25 01:52 UTC Josh Berkus <josh@agliodbs.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-25 16:50 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-25 20:45 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-26 13:44 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-26 20:54 UTC Florian Weimer <fw@deneb.enyo.de>
` Re: Picking out the most recent row using a time stamp column
2011-02-26 21:06 UTC Josh Berkus <josh@agliodbs.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-26 21:38 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Picking out the most recent row using a time stamp column
2011-02-26 21:52 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Picking out the most recent row using a time stamp column
2013-04-05 16:54 UTC Dave Johansen <davejohansen@gmail.com>
` Re: Picking out the most recent row using a time stamp column
2013-04-05 18:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Picking out the most recent row using a time stamp column
2013-04-08 21:10 UTC Dave Johansen <davejohansen@gmail.com>
[20+ messages in thread]
What happens between end of explain analyze and end of query execution ?
2013-04-04 14:48 UTC Franck Routier <franck.routier@axege.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-04 15:01 UTC Nikolas Everett <nik9000@gmail.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-04 15:44 UTC Franck Routier <franck.routier@axege.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-04 16:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-04 18:49 UTC Franck Routier <franck.routier@axege.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-04 19:05 UTC nik9000@gmail.com
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-04 19:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-04 19:19 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-05 13:55 UTC Franck Routier <franck.routier@axege.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-05 14:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-05 14:17 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-05 14:18 UTC Nikolas Everett <nik9000@gmail.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-06 08:02 UTC Franck Routier <franck.routier@axege.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-06 08:04 UTC Franck Routier <franck.routier@axege.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-06 08:13 UTC Franck Routier <franck.routier@axege.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-06 09:05 UTC Franck Routier <franck.routier@axege.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-06 15:26 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-06 16:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-07 12:12 UTC Franck Routier <franck.routier@axege.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-08 16:39 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: What happens between end of explain analyze and end of query execution ?
2013-04-08 16:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
[21+ messages in thread]
slow joins?
2013-04-06 01:38 UTC Joe Van Dyk <joe@tanga.com>
` Re: slow joins?
2013-04-06 01:42 UTC Joe Van Dyk <joe@tanga.com>
` Re: slow joins?
2013-04-06 01:50 UTC Joe Van Dyk <joe@tanga.com>
` Re: slow joins?
2013-04-06 01:54 UTC Greg Williamson <gwilliamson39@yahoo.com>
` Re: slow joins?
2013-04-06 02:56 UTC Joe Van Dyk <joe@tanga.com>
` Re: slow joins?
2013-04-06 03:32 UTC Greg Williamson <gwilliamson39@yahoo.com>
` Re: slow joins?
2013-04-06 10:53 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: slow joins?
2013-04-06 14:22 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: slow joins?
2013-04-06 14:43 UTC Julien Cigar <jcigar@ulb.ac.be>
[9+ messages in thread]
Postgres upgrade, security release, where?
2013-04-02 00:10 UTC Tory M Blue <tmblue@gmail.com>
` Re: Postgres upgrade, security release, where?
2013-04-02 00:27 UTC Bruce Momjian <bruce@momjian.us>
` Re: Postgres upgrade, security release, where?
2013-04-02 00:40 UTC Ian Lawrence Barwick <barwick@gmail.com>
` Re: Postgres upgrade, security release, where?
2013-04-02 00:55 UTC Bruce Momjian <bruce@momjian.us>
` Re: Postgres upgrade, security release, where?
2013-04-02 03:35 UTC Tory M Blue <tmblue@gmail.com>
` Re: Postgres upgrade, security release, where?
2013-04-02 03:43 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Postgres upgrade, security release, where?
2013-04-02 08:34 UTC Dave Page <dpage@pgadmin.org>
` Re: Postgres upgrade, security release, where?
2013-04-02 08:47 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Postgres upgrade, security release, where?
2013-04-04 08:52 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Postgres upgrade, security release, where?
2013-04-04 09:11 UTC Ian Lawrence Barwick <barwick@gmail.com>
[10+ messages in thread]
Planner is getting wrong row count
2013-04-02 18:57 UTC AI Rumman <rummandba@gmail.com>
` Re: Planner is getting wrong row count
2013-04-03 15:34 UTC Kevin Grittner <kgrittn@ymail.com>
[2+ messages in thread]
Join between 2 tables always executes a sequential scan on the larger table
2013-04-02 08:52 UTC Dieter Rehbein <dieter.rehbein@skiline.cc>
` Re: Join between 2 tables always executes a sequential scan on the larger table
2013-04-02 14:55 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Re: Join between 2 tables always executes a sequential scan on the larger table
2013-04-02 15:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Join between 2 tables always executes a sequential scan on the larger table
2013-04-03 08:18 UTC Dieter Rehbein <dieter.rehbein@skiline.cc>
` Re: Join between 2 tables always executes a sequential scan on the larger table
2013-04-03 08:24 UTC Dieter Rehbein <dieter.rehbein@skiline.cc>
` Re: Join between 2 tables always executes a sequential scan on the larger table
2013-04-03 08:50 UTC Vasilis Ventirozos <v.ventirozos@gmail.com>
[6+ messages in thread]
Problems with pg_locks explosion
2013-04-01 22:35 UTC Armand du Plessis <adp@bank.io>
` Fwd: Problems with pg_locks explosion
2013-04-01 22:56 UTC Vasilis Ventirozos <v.ventirozos@gmail.com>
` Re: Problems with pg_locks explosion
2013-04-01 23:09 UTC Armand du Plessis <adp@bank.io>
` Re: Problems with pg_locks explosion
2013-04-01 23:15 UTC Armand du Plessis <adp@bank.io>
` Re: Problems with pg_locks explosion
2013-04-01 23:43 UTC Vasilis Ventirozos <v.ventirozos@gmail.com>
` Re: Problems with pg_locks explosion
2013-04-02 00:11 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Problems with pg_locks explosion
2013-04-02 00:21 UTC Jeff Janes <jeff.janes@gmail.com>
` Fwd: Problems with pg_locks explosion
2013-04-02 00:31 UTC Armand du Plessis <adp@bank.io>
` Re: Problems with pg_locks explosion
2013-04-02 00:40 UTC Armand du Plessis <adp@bank.io>
` Re: Problems with pg_locks explosion
2013-04-02 00:59 UTC Armand du Plessis <adp@bank.io>
` Re: Problems with pg_locks explosion
2013-04-02 01:07 UTC Steven Crandell <steven.crandell@gmail.com>
` Re: Problems with pg_locks explosion
2013-04-02 02:53 UTC Armand du Plessis <adp@bank.io>
` Re: Fwd: Problems with pg_locks explosion
2013-04-02 03:41 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Problems with pg_locks explosion
2013-04-02 06:08 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Problems with pg_locks explosion
2013-04-02 06:08 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Problems with pg_locks explosion
2013-04-02 06:21 UTC Armand du Plessis <adp@bank.io>
` Re: Problems with pg_locks explosion
2013-04-02 06:25 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Problems with pg_locks explosion
2013-04-02 06:33 UTC Armand du Plessis <adp@bank.io>
` Re: Problems with pg_locks explosion
2013-04-02 06:43 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Problems with pg_locks explosion
2013-04-02 08:16 UTC Armand du Plessis <adp@bank.io>
` Re: Problems with pg_locks explosion
2013-04-02 09:55 UTC Armand du Plessis <adp@bank.io>
` Re: Problems with pg_locks explosion
2013-04-02 18:16 UTC Armand du Plessis <adp@bank.io>
[22+ messages in thread]
Question about postmaster's CPU usage
2013-03-28 19:07 UTC kelphet xiong <kelphet@gmail.com>
` Re: Question about postmaster's CPU usage
2013-03-28 21:03 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Question about postmaster's CPU usage
2013-03-28 21:20 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Question about postmaster's CPU usage
2013-03-30 23:45 UTC Ants Aasma <ants.aasma@eesti.ee>
` Re: Question about postmaster's CPU usage
2013-03-31 04:00 UTC Kelphet Xiong <kelphet@gmail.com>
` Re: Question about postmaster's CPU usage
2013-04-01 13:42 UTC Merlin Moncure <mmoncure@gmail.com>
[6+ messages in thread]
query plan estimate
2013-03-25 18:16 UTC pg noob <pgnube@gmail.com>
` Re: query plan estimate
2013-04-01 00:52 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
9.2.3 upgrade reduced pgbench performance by 60%
2013-03-25 09:57 UTC Colin Currie <colin@marketsworld.com>
` Re: 9.2.3 upgrade reduced pgbench performance by 60%
2013-03-25 20:34 UTC Josh Berkus <josh@agliodbs.com>
` Re: 9.2.3 upgrade reduced pgbench performance by 60%
2013-03-26 20:05 UTC Nicholson, Brad (Toronto, ON, CA) <bnicholson@hp.com>
` Re: 9.2.3 upgrade reduced pgbench performance by 60%
2013-03-27 22:52 UTC Josh Berkus <josh@agliodbs.com>
` Re: 9.2.3 upgrade reduced pgbench performance by 60%
2013-03-31 17:16 UTC Jeff Janes <jeff.janes@gmail.com>
[5+ messages in thread]
how to help the planner
2013-03-28 15:59 UTC Marty Frasier <m.frasier@escmatrix.com>
` Re: how to help the planner
2013-03-28 16:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: how to help the planner
2013-03-28 20:45 UTC Marty Frasier <m.frasier@escmatrix.com>
` Re: how to help the planner
2013-03-28 22:13 UTC Stephen Frost <sfrost@snowman.net>
` Re: how to help the planner
2013-03-29 18:23 UTC Igor Neyman <ineyman@perceptron.com>
[5+ messages in thread]
Reg: Slow query
2013-03-27 14:04 UTC Prakash Chinnakannan <prakash.chinnakannan@gmail.com>
` Re: Reg: Slow query
2013-03-27 14:15 UTC Vasilis Ventirozos <v.ventirozos@gmail.com>
[2+ messages in thread]
Proof of concept: Evolving postgresql.conf using genetic algorithm
2013-03-25 20:08 UTC Greg Jaskiewicz <gryzman@gmail.com>
[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