pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing a window function in a view
2013-02-21 23:37 UTC Chris Hanks <christopher.m.hanks@gmail.com>
Speed of exist
2013-02-19 06:34 UTC Bastiaan Olij <bastiaan@basenlily.me>
` Re: Speed of exist
2013-02-19 07:31 UTC Andy <andy.gumbrecht@orprovision.com>
` Re: Speed of exist
2013-02-19 07:36 UTC Bastiaan Olij <bastiaan@basenlily.me>
` Re: Speed of exist
2013-02-19 07:39 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Speed of exist
2013-02-19 10:18 UTC Bastiaan Olij <bastiaan@basenlily.me>
[5+ messages in thread]
slow query plans caused by under-estimation of CTE cardinality
2013-02-18 16:45 UTC John Lumby <johnlumby@hotmail.com>
` Re: slow query plans caused by under-estimation of CTE cardinality
2013-02-18 20:40 UTC Vitalii Tymchyshyn <tivv00@gmail.com>
` Re: slow query plans caused by under-estimation of CTE cardinality
2013-02-18 23:26 UTC John Lumby <johnlumby@hotmail.com>
` Re: slow query plans caused by under-estimation of CTE cardinality
2013-02-19 10:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Surprising no use of indexes - low performance
2013-02-14 15:35 UTC Nicolas Charles <nicolas.charles@normation.com>
` Re: Surprising no use of indexes - low performance
2013-02-14 18:25 UTC Ireneusz Pluta <ipluta@wp.pl>
` Re: Surprising no use of indexes - low performance
2013-02-14 19:27 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Surprising no use of indexes - low performance
2013-02-15 09:00 UTC Nicolas Charles <nicolas.charles@normation.com>
` Re: Surprising no use of indexes - low performance
2013-02-15 18:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Surprising no use of indexes - low performance
2013-02-15 21:27 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Surprising no use of indexes - low performance
2013-02-16 09:25 UTC Nicolas Charles <nicolas.charles@normation.com>
[7+ messages in thread]
temp tablespaces and SSDs, etc..
2013-02-08 20:52 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: temp tablespaces and SSDs, etc..
2013-02-16 00:32 UTC Bruce Momjian <bruce@momjian.us>
[2+ messages in thread]
Partition insert trigger using C language
2013-01-10 18:45 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-01-10 18:54 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Partition insert trigger using C language
2013-01-10 19:11 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-01-10 19:14 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Partition insert trigger using C language
2013-01-10 19:22 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Partition insert trigger using C language
2013-01-10 19:48 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-01-10 19:57 UTC Charles Gomes <charlesrg@outlook.com>
` Re: Partition insert trigger using C language
2013-01-11 10:19 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Partition insert trigger using C language
2013-01-11 10:36 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-01-11 10:57 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-01-11 11:02 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Partition insert trigger using C language
2013-01-11 11:55 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-02-11 15:24 UTC Ali Pouya <alipouya2@gmail.com>
` Re: Partition insert trigger using C language
2013-02-13 11:00 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: Partition insert trigger using C language
2013-02-15 08:47 UTC Ali Pouya <alipouya2@gmail.com>
[15+ messages in thread]
700K Inserts in transaction
2013-02-14 10:28 UTC Asmir Mustafic <goetas@lignano.it>
` Re: 700K Inserts in transaction
2013-02-14 11:51 UTC nik9000@gmail.com
[2+ messages in thread]
PG_XLOG 27028 files running out of space
2013-02-14 10:49 UTC Tory M Blue <tmblue@gmail.com>
` Re: PG_XLOG 27028 files running out of space
2013-02-14 11:01 UTC Ian Lawrence Barwick <barwick@gmail.com>
` Re: PG_XLOG 27028 files running out of space
2013-02-14 11:06 UTC Tory M Blue <tmblue@gmail.com>
` Re: PG_XLOG 27028 files running out of space
2013-02-14 11:08 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: PG_XLOG 27028 files running out of space
2013-02-14 11:09 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: PG_XLOG 27028 files running out of space
2013-02-14 11:11 UTC Tory M Blue <tmblue@gmail.com>
[6+ messages in thread]
connection poolers' db connections
2013-02-13 13:47 UTC Yetkin Öztürk <yetkin85@gmail.com>
` Re: connection poolers' db connections
2013-02-13 14:56 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: connection poolers' db connections
2013-02-13 15:35 UTC Yetkin Öztürk <yetkin85@gmail.com>
[3+ messages in thread]
numerical primary key vs alphanumerical primary key
2013-02-04 21:52 UTC Anne Rosset <arosset@collab.net>
` Re: numerical primary key vs alphanumerical primary key
2013-02-04 21:57 UTC Виктор Егоров <vyegorov@gmail.com>
` Re: numerical primary key vs alphanumerical primary key
2013-02-12 13:06 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: numerical primary key vs alphanumerical primary key
2013-02-12 15:05 UTC Grant Johnson <grant@amadensor.com>
` Re: numerical primary key vs alphanumerical primary key
2013-02-12 15:14 UTC Florent Guillaume <fg@nuxeo.com>
` Re: numerical primary key vs alphanumerical primary key
2013-02-12 16:26 UTC Claudio Freire <klaussfreire@gmail.com>
[6+ messages in thread]
postgresql.conf recommendations
2013-02-05 22:02 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-05 22:37 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-05 23:46 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 04:23 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 06:00 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 06:18 UTC ac@hsk.hk <ac@hsk.hk>
` Re: postgresql.conf recommendations
2013-02-06 12:49 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: postgresql.conf recommendations
2013-02-06 15:42 UTC David Whittaker <dave@iradix.com>
` Re: postgresql.conf recommendations
2013-02-06 18:20 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 19:13 UTC David Whittaker <dave@iradix.com>
` Re: postgresql.conf recommendations
2013-02-06 19:33 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 19:45 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 19:47 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 20:12 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 20:27 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-06 21:12 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: postgresql.conf recommendations
2013-02-07 12:06 UTC Strahinja Kustudić <strahinjak@nordeus.com>
` Re: postgresql.conf recommendations
2013-02-07 14:41 UTC Charles Gomes <charlesrg@outlook.com>
` Re: postgresql.conf recommendations
2013-02-07 17:29 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-07 17:49 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 13:19 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 13:24 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 14:51 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 19:37 UTC Josh Krupka <jkrupka@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 20:16 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgresql.conf recommendations
2013-02-09 21:03 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql.conf recommendations
2013-02-10 04:02 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgresql.conf recommendations
2013-02-11 14:57 UTC Charles Gomes <charlesrg@outlook.com>
` Re: postgresql.conf recommendations
2013-02-11 22:10 UTC Johnny Tan <johnnydtan@gmail.com>
` Re: postgresql.conf recommendations
2013-02-11 22:57 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql.conf recommendations
2013-02-11 23:29 UTC Will Platnick <wplatnick@gmail.com>
` Re: postgresql.conf recommendations
2013-02-12 02:54 UTC Scott Marlowe <scott.marlowe@gmail.com>
[32+ messages in thread]
Is it correct to optimize a query with subselect in the "where"?
2013-02-11 12:52 UTC Alexandre Riveira <alexandre@objectdata.com.br>
Slow query even with aggressive auto analyze
2013-02-08 12:36 UTC Karolis Pocius <kpocius@northplains.com>
` Re: Slow query even with aggressive auto analyze
2013-02-10 06:52 UTC Amit kapila <amit.kapila@huawei.com>
[2+ messages in thread]
Query Time is Slow
2013-02-08 22:13 UTC Foster, Kristian B (HSC) <kristian-foster@ouhsc.edu>
` Re: Query Time is Slow
2013-02-08 22:45 UTC Kevin Grittner <kgrittn@ymail.com>
[2+ messages in thread]
FTS performance issue probably due to wrong planner estimate of detoasting
2013-02-08 00:52 UTC Stefan Keller <sfkeller@gmail.com>
` Re: FTS performance issue probably due to wrong planner estimate of detoasting
2013-02-08 05:45 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: FTS performance issue probably due to wrong planner estimate of detoasting
2013-02-08 06:56 UTC Jesper Krogh <jesper@krogh.cc>
` Re: FTS performance issue probably due to wrong planner estimate of detoasting
2013-02-08 17:30 UTC Stefan Keller <sfkeller@gmail.com>
[4+ messages in thread]
Simple join doesn't use index
2013-01-03 22:54 UTC Alex Vinnik <alvinnik.g@gmail.com>
` Re: Simple join doesn't use index
2013-01-03 23:11 UTC Jeremy Harris <jgh@wizmail.org>
` Re: Simple join doesn't use index
2013-01-04 04:33 UTC Stefan Andreatta <s.andreatta@synedra.com>
` Re: Simple join doesn't use index
2013-01-08 00:13 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Simple join doesn't use index
2013-01-09 04:34 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Simple join doesn't use index
2013-01-09 15:49 UTC Alex Vinnik <alvinnik.g@gmail.com>
` Re: Simple join doesn't use index
2013-01-09 15:53 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Simple join doesn't use index
2013-01-28 23:43 UTC Alex Vinnik <alvinnik.g@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 00:55 UTC Filip Rembiałkowski <plk.zuber@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 02:31 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 14:24 UTC Alex Vinnik <alvinnik.g@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 14:41 UTC Alex Vinnik <alvinnik.g@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 16:19 UTC Filip Rembiałkowski <plk.zuber@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 16:41 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 17:39 UTC Ben Chobot <bench@silentmedia.com>
` Re: Simple join doesn't use index
2013-01-29 18:59 UTC Alex Vinnik <alvinnik.g@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 19:35 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 20:06 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 20:43 UTC Alex Vinnik <alvinnik.g@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 20:48 UTC Alex Vinnik <alvinnik.g@gmail.com>
` Re: Simple join doesn't use index
2013-01-29 23:15 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Simple join doesn't use index
2013-02-02 16:39 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Simple join doesn't use index
2013-02-04 21:14 UTC Dan Fairs <dan.fairs@gmail.com>
[23+ messages in thread]
Fighting the planner >:-(
2013-02-01 17:11 UTC Casey Allen Shobe <casey@shobe.info>
` Re: Fighting the planner >:-(
2013-02-01 17:54 UTC Casey Allen Shobe <casey@shobe.info>
` Re: Fighting the planner >:-(
2013-02-01 18:50 UTC Richard Huxton <dev@archonet.com>
` Re: Fighting the planner >:-(
2013-02-01 19:18 UTC Casey Allen Shobe <casey@shobe.info>
` Re: Fighting the planner >:-(
2013-02-01 21:02 UTC Casey Allen Shobe <casey@shobe.info>
` Re: Fighting the planner >:-(
2013-02-01 21:12 UTC Виктор Егоров <vyegorov@gmail.com>
` Re: Fighting the planner >:-(
2013-02-01 21:18 UTC Casey Allen Shobe <casey@shobe.info>
` Re: Fighting the planner >:-(
2013-02-01 21:55 UTC Виктор Егоров <vyegorov@gmail.com>
` Re: Fighting the planner >:-(
2013-02-01 22:03 UTC Casey Allen Shobe <casey@shobe.info>
` Re: Fighting the planner >:-(
2013-02-01 22:17 UTC Виктор Егоров <vyegorov@gmail.com>
[10+ messages in thread]
pgbench to the MAXINT
2011-01-08 01:59 UTC Greg Smith <greg@2ndquadrant.com>
` Re: pgbench to the MAXINT
2011-01-10 05:17 UTC Euler Taveira de Oliveira <euler@timbira.com>
` Re: pgbench to the MAXINT
2011-01-10 08:25 UTC Greg Smith <greg@2ndquadrant.com>
` Re: pgbench to the MAXINT
2011-01-11 21:34 UTC Euler Taveira de Oliveira <euler@timbira.com>
` Re: [PERFORM] pgbench to the MAXINT
2011-01-18 18:42 UTC Greg Smith <greg@2ndquadrant.com>
` Re: [PERFORM] pgbench to the MAXINT
2011-01-30 20:09 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] pgbench to the MAXINT
2011-02-04 03:28 UTC Greg Smith <greg@2ndquadrant.com>
` Re: [PERFORM] pgbench to the MAXINT
2011-02-07 16:03 UTC Greg Smith <greg@2ndquadrant.com>
` Re: [PERFORM] pgbench to the MAXINT
2011-02-09 08:38 UTC Greg Smith <greg@2ndquadrant.com>
` Re: [PERFORM] pgbench to the MAXINT
2011-02-09 19:40 UTC Stephen Frost <sfrost@snowman.net>
` Re: [PERFORM] pgbench to the MAXINT
2011-02-11 02:27 UTC Greg Smith <greg@2ndquadrant.com>
` Re: [PERFORM] pgbench to the MAXINT
2011-02-11 03:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] pgbench to the MAXINT
2011-02-11 13:35 UTC Stephen Frost <sfrost@snowman.net>
` Re: [PERFORM] pgbench to the MAXINT
2011-02-16 02:41 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] pgbench to the MAXINT
2011-02-16 13:15 UTC Greg Smith <greg@2ndquadrant.com>
` Re: [PERFORM] pgbench to the MAXINT
2011-02-16 15:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] pgbench to the MAXINT
2012-12-21 06:16 UTC Gurjeet Singh <singh.gurjeet@gmail.com>
` Re: [PERFORM] pgbench to the MAXINT
2013-01-27 04:24 UTC Satoshi Nagayasu <snaga@uptime.jp>
` Re: [PERFORM] pgbench to the MAXINT
2013-01-28 21:30 UTC Gurjeet Singh <singh.gurjeet@gmail.com>
` Re: [PERFORM] pgbench to the MAXINT
2013-01-29 10:12 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
[20+ messages in thread]
Triggers and transactions
2013-01-28 18:54 UTC Craig James <cjames@emolecules.com>
` Re: Triggers and transactions
2013-01-28 19:10 UTC Richard Huxton <dev@archonet.com>
` Re: Triggers and transactions
2013-01-28 19:25 UTC Rosser Schwarz <rosser.schwarz@gmail.com>
[3+ messages in thread]
PostgreSQL over internet
2013-01-27 00:15 UTC belal hamed <belalhamed@gmail.com>
` Re: PostgreSQL over internet
2013-01-27 02:45 UTC ktm@rice.edu <ktm@rice.edu>
` Re: PostgreSQL over internet
2013-01-27 06:13 UTC Richard Neill <rn214@richardneill.org>
` Re: PostgreSQL over internet
2013-01-27 12:09 UTC belal hamed <belalhamed@gmail.com>
` Re: PostgreSQL over internet
2013-01-27 17:33 UTC ktm@rice.edu <ktm@rice.edu>
` Re: PostgreSQL over internet
2013-01-27 20:23 UTC David Rowley <dgrowleyml@gmail.com>
` Re: PostgreSQL over internet
2013-01-28 11:15 UTC belal hamed <belalhamed@gmail.com>
[7+ messages in thread]
Nested loop and simple join query - slow after upgrade to 9.2
2013-01-25 15:34 UTC alexandre - aldeia digital <adaldeia@gmail.com>
` Re: Nested loop and simple join query - slow after upgrade to 9.2
2013-01-25 18:29 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Nested loop and simple join query - slow after upgrade to 9.2
2013-01-25 19:30 UTC alexandre - aldeia digital <adaldeia@gmail.com>
[3+ messages in thread]
DML's to tpcw benchmark for postgresql
2013-01-25 06:38 UTC Sachin D. Kotwal <kotsachin@gmail.com>
autovacuum fringe case?
2013-01-23 16:53 UTC AJ Weber <aweber@comcast.net>
` Re: autovacuum fringe case?
2013-01-23 19:03 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: autovacuum fringe case?
2013-01-23 19:13 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: autovacuum fringe case?
2013-01-23 22:17 UTC Kevin Grittner <kgrittn@mail.com>
` Re: autovacuum fringe case?
2013-01-23 22:48 UTC AJ Weber <aweber@comcast.net>
` Re: autovacuum fringe case?
2013-01-24 02:03 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: autovacuum fringe case?
2013-01-24 03:06 UTC Jeff Janes <jeff.janes@gmail.com>
[7+ messages in thread]
High CPU usage after partitioning
2013-01-21 15:05 UTC rudi <rudolone@gmail.com>
` Re: High CPU usage after partitioning
2013-01-21 17:13 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: High CPU usage after partitioning
2013-01-21 21:12 UTC Kevin Grittner <kgrittn@mail.com>
` Re: High CPU usage after partitioning
2013-01-22 00:41 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: High CPU usage after partitioning
2013-01-22 13:34 UTC rudi <rudolone@gmail.com>
` Re: High CPU usage after partitioning
2013-01-22 14:04 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: High CPU usage after partitioning
2013-01-22 14:21 UTC rudi <rudolone@gmail.com>
` Re: High CPU usage after partitioning
2013-01-22 14:46 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: High CPU usage after partitioning
2013-01-22 15:08 UTC rudi <rudolone@gmail.com>
` Re: High CPU usage after partitioning
2013-01-22 15:42 UTC Igor Neyman <ineyman@perceptron.com>
` Re: High CPU usage after partitioning
2013-01-22 18:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
[11+ messages in thread]
Analyze and default_statistics_target
2013-01-21 15:29 UTC AJ Weber <aweber@comcast.net>
` Re: Analyze and default_statistics_target
2013-01-21 15:47 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Analyze and default_statistics_target
2013-01-21 16:00 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[3+ 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