pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDBT-1
2012-11-05 06:43 UTC Samrat <Samrat.Revagade@nttdata.com>
` DBT-1
2012-11-05 06:44 UTC Revagade, Samrat <Samrat.Revagade@nttdata.com>
[2+ messages in thread]
Suggested test points for a performance tool?
2012-11-04 23:54 UTC Christoffer Lernö <christoffer@aegik.com>
` Re: Suggested test points for a performance tool?
2012-11-05 00:08 UTC Claudio Freire <klaussfreire@gmail.com>
[2+ messages in thread]
freebsd or linux
2012-11-02 14:39 UTC list, mailing <list@sprymed.com>
pg_buffercache
2012-10-30 18:34 UTC pg noob <pgnube@gmail.com>
` Re: pg_buffercache
2012-11-01 21:26 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
Slow query, where am I going wrong?
2012-10-30 07:33 UTC Andy <andy.gumbrecht@orprovision.com>
` Re: Slow query, where am I going wrong?
2012-10-30 08:25 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Slow query, where am I going wrong?
2012-10-30 09:47 UTC AndyG <andy.gumbrecht@orprovision.com>
` Re: Slow query, where am I going wrong?
2012-10-30 14:54 UTC AndyG <andy.gumbrecht@orprovision.com>
` Re: Slow query, where am I going wrong?
2012-10-30 15:48 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Slow query, where am I going wrong?
2012-10-31 09:18 UTC AndyG <andy.gumbrecht@orprovision.com>
` Re: Slow query, where am I going wrong?
2012-10-31 09:35 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Slow query, where am I going wrong?
2012-10-31 10:18 UTC AndyG <andy.gumbrecht@orprovision.com>
` Re: Slow query, where am I going wrong?
2012-10-31 11:28 UTC AndyG <andy.gumbrecht@orprovision.com>
` Re: Slow query, where am I going wrong?
2012-10-31 13:29 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Slow query, where am I going wrong?
2012-10-31 14:59 UTC AndyG <andy.gumbrecht@orprovision.com>
[11+ messages in thread]
Seq scan on big table, episode 2
2012-10-31 10:55 UTC Vincenzo Melandri <vmelandri@imolinfo.it>
` Re: Seq scan on big table, episode 2
2012-10-31 11:46 UTC Vincenzo Melandri <vmelandri@imolinfo.it>
` Re: Seq scan on big table, episode 2
2012-10-31 13:04 UTC Shaun Thomas <sthomas@optionshouse.com>
[3+ messages in thread]
Invalid memory alloc request size
2012-10-31 10:24 UTC Mahavir Trivedi <mahavir.trivedi@gmail.com>
` Re: Invalid memory alloc request size
2012-10-31 10:28 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Invalid memory alloc request size
2012-10-31 10:34 UTC Samuel Gendler <sgendler@ideasculptor.com>
[3+ messages in thread]
Re: set-returning calls and overhead
2012-10-30 21:31 UTC Jon Nelson <jnelson+pgsql@jamponi.net>
Seq scan on 10million record table.. why?
2012-10-30 12:15 UTC Vincenzo Melandri <vmelandri@imolinfo.it>
` Re: Seq scan on 10million record table.. why?
2012-10-30 13:45 UTC Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
` Re: Seq scan on 10million record table.. why?
2012-10-30 13:53 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Seq scan on 10million record table.. why?
2012-10-30 14:03 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: Seq scan on 10million record table.. why?
2012-10-30 18:18 UTC Vincenzo Melandri <vmelandri@imolinfo.it>
[5+ messages in thread]
Prepared statements slow in 9.2 still (bad query plan)
2012-10-23 15:42 UTC Daniel Burbridge <Daniel.Burbridge@publishingtechnology.com>
` Re: Prepared statements slow in 9.2 still (bad query plan)
2012-10-28 15:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Prepared statements slow in 9.2 still (bad query plan)
2012-10-29 13:25 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Prepared statements slow in 9.2 still (bad query plan)
2012-10-30 16:41 UTC Daniel Burbridge <Daniel.Burbridge@publishingtechnology.com>
[4+ messages in thread]
PostgreSQL server failed to start
2012-10-30 09:24 UTC vignesh <vignesh.t@snovabits.net>
` Re: PostgreSQL server failed to start
2012-10-30 15:43 UTC Maciek Sakrejda <m.sakrejda@gmail.com>
[2+ messages in thread]
Replaying 48 WAL files takes 80 minutes
2012-10-29 13:05 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-29 13:19 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-29 14:29 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-29 15:04 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-29 16:42 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-29 18:27 UTC Jeff <jeff@jefftrout.com>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-29 18:36 UTC Jeff Trout <threshar@real.jefftrout.com>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-30 08:50 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-30 10:07 UTC Heikki Linnakangas <hlinnakangas@vmware.com>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-30 13:05 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-30 13:10 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-30 13:16 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Replaying 48 WAL files takes 80 minutes
2012-10-30 13:41 UTC ktm@rice.edu <ktm@rice.edu>
[13+ messages in thread]
Request for help with slow query
2012-10-29 17:41 UTC Woolcock, Sean <Sean.Woolcock@emc.com>
` Re: Request for help with slow query
2012-10-29 19:18 UTC salah jubeh <s_jubeh@yahoo.com>
` Re: Request for help with slow query
2012-10-29 19:25 UTC Woolcock, Sean <Sean.Woolcock@emc.com>
` Re: Request for help with slow query
2012-10-29 19:32 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Request for help with slow query
2012-10-29 19:36 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Request for help with slow query
2012-10-29 19:49 UTC salah jubeh <s_jubeh@yahoo.com>
` Re: Request for help with slow query
2012-10-29 19:52 UTC Kevin Grittner <kgrittn@mail.com>
` Re: Request for help with slow query
2012-10-29 19:53 UTC Woolcock, Sean <Sean.Woolcock@emc.com>
` Re: Request for help with slow query
2012-10-30 09:02 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[9+ messages in thread]
Slower Performance on Postgres 9.1.6 vs 8.2.11
2012-10-26 18:30 UTC robcron <rocron@pssd.com>
` Re: Slower Performance on Postgres 9.1.6 vs 8.2.11
2012-10-26 19:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slower Performance on Postgres 9.1.6 vs 8.2.11
2012-10-26 20:26 UTC robcron <rocron@pssd.com>
` Re: Slower Performance on Postgres 9.1.6 vs 8.2.11
2012-10-26 20:56 UTC robcron <rocron@pssd.com>
` Re: Slower Performance on Postgres 9.1.6 vs 8.2.11
2012-10-27 04:49 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Slower Performance on Postgres 9.1.6 vs 8.2.11
2012-10-29 21:40 UTC robcron <rocron@pssd.com>
[6+ messages in thread]
Tons of free RAM. Can't make it go away.
2012-10-22 17:35 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 17:44 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 17:49 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 17:49 UTC Frank Lanitz <frank@frank.uvena.de>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 17:53 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 17:56 UTC Marcus Larsson <kore@mindwipe.org>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 18:01 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 18:14 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 18:20 UTC Franklin, Dan (FEN) <Dan.Franklin@pearson.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 18:24 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 18:28 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-22 18:44 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-23 16:49 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-28 03:49 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: Tons of free RAM. Can't make it go away.
2012-10-29 16:17 UTC Shaun Thomas <sthomas@optionshouse.com>
[15+ messages in thread]
Query-Planer from 6seconds TO DAYS
2012-10-24 15:41 UTC Böckler Andreas <andy@boeckler.org>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-24 18:51 UTC Böckler Andreas <andy@boeckler.org>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-25 16:20 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-25 18:22 UTC Kevin Grittner <kgrittn@mail.com>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 14:37 UTC Böckler Andreas <andy@boeckler.org>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 14:55 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 14:59 UTC Kevin Grittner <kgrittn@mail.com>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 15:15 UTC Böckler Andreas <andy@boeckler.org>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 15:30 UTC Kevin Grittner <kgrittn@mail.com>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 15:30 UTC Böckler Andreas <andy@boeckler.org>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 15:30 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 15:41 UTC Kevin Grittner <kgrittn@mail.com>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 17:58 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 18:00 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 18:33 UTC Böckler Andreas <andy@boeckler.org>
` Re: Query-Planer from 6seconds TO DAYS
2012-10-26 20:14 UTC Jeff Janes <jeff.janes@gmail.com>
[16+ messages in thread]
PSA: New Kernels and intel_idle cpuidle Driver!
2012-10-26 17:58 UTC Shaun Thomas <sthomas@optionshouse.com>
BAD performance with enable_bitmapscan = on with Postgresql 9.0.X (X = 3 and 10)
2012-10-26 15:30 UTC Alberto Marchesini <alberto.marchesini@stdm.net>
Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6
2012-10-17 08:26 UTC Maciek Sakrejda <m.sakrejda@gmail.com>
` Re: Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6
2012-10-17 08:53 UTC Martin French <Martin.French@romaxtech.com>
` Re: Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6
2012-10-17 09:13 UTC Maciek Sakrejda <m.sakrejda@gmail.com>
` Re: Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6
2012-10-17 09:28 UTC Martin French <Martin.French@romaxtech.com>
` Re: Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6
2012-10-17 14:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6
2012-10-17 15:09 UTC Maciek Sakrejda <m.sakrejda@gmail.com>
` Re: Out of shared mem on new box with more mem, 9.1.5 -> 9.1.6
2012-10-24 20:29 UTC Kevin Grittner <kgrittn@mail.com>
[7+ messages in thread]
Query with limit goes from few ms to hours
2012-10-14 06:55 UTC henk de wit <henk53602@hotmail.com>
` Re: Query with limit goes from few ms to hours
2012-10-14 07:04 UTC henk de wit <henk53602@hotmail.com>
` Re: Query with limit goes from few ms to hours
2012-10-14 16:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query with limit goes from few ms to hours
2012-10-15 12:31 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: Query with limit goes from few ms to hours
2012-10-15 17:50 UTC henk de wit <henk53602@hotmail.com>
` Re: Query with limit goes from few ms to hours
2012-10-23 18:33 UTC Kevin Grittner <kgrittn@mail.com>
` Re: Query with limit goes from few ms to hours
2012-10-23 20:08 UTC Steve Crawford <scrawford@pinpointresearch.com>
[7+ messages in thread]
Connection Options -- SSL already uses compression?
2012-10-20 01:10 UTC Karl Denninger <karl@denninger.net>
` Re: Connection Options -- SSL already uses compression?
2012-10-21 07:51 UTC Magnus Hagander <magnus@hagander.net>
[2+ messages in thread]
Recursive query gets slower when adding an index
2012-10-19 10:47 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Recursive query gets slower when adding an index
2012-10-19 14:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Recursive query gets slower when adding an index
2012-10-19 17:22 UTC Thomas Kellerer <spam_eater@gmx.net>
[3+ messages in thread]
limit order by performance issue
2012-10-15 17:44 UTC Pedro Jiménez <p.jimenez@ismsolar.com>
` Re: limit order by performance issue
2012-10-16 19:23 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: limit order by performance issue
2012-10-16 19:28 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: limit order by performance issue
2012-10-16 19:47 UTC Karl Denninger <karl@denninger.net>
` Re: limit order by performance issue
2012-10-16 22:05 UTC Marti Raudsepp <marti@juffo.org>
` Re: limit order by performance issue
2012-10-17 09:14 UTC Pedro Jiménez Pérez <p.jimenez@ismsolar.com>
` Re: limit order by performance issue
2012-10-19 16:19 UTC Claudio Freire <klaussfreire@gmail.com>
[7+ messages in thread]
Tablespace-derived stats?
2012-10-19 14:29 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Tablespace-derived stats?
2012-10-19 14:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Tablespace-derived stats?
2012-10-19 14:54 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Tablespace-derived stats?
2012-10-19 15:05 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Tablespace-derived stats?
2012-10-19 15:07 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Tablespace-derived stats?
2012-10-19 15:26 UTC Jeff Janes <jeff.janes@gmail.com>
[6+ messages in thread]
SELECT AND AGG huge tables
2012-10-15 20:59 UTC houmanb <houman@gmx.at>
` Re: SELECT AND AGG huge tables
2012-10-15 21:09 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: SELECT AND AGG huge tables
2012-10-15 21:42 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: SELECT AND AGG huge tables
2012-10-15 21:54 UTC Ondrej Ivanič <ondrej.ivanic@gmail.com>
` Re: SELECT AND AGG huge tables
2012-10-15 23:44 UTC Bob Lunney <bob_lunney@yahoo.com>
` Re: SELECT AND AGG huge tables
2012-10-16 00:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: SELECT AND AGG huge tables
2012-10-16 02:42 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: SELECT AND AGG huge tables
2012-10-17 11:24 UTC houmanb <houman@gmx.at>
` Re: SELECT AND AGG huge tables
2012-10-19 12:24 UTC Ants Aasma <ants@cybertec.at>
[9+ 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