pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedNestedLoops over BitmapScan question
2012-09-28 23:11 UTC Виктор Егоров <vyegorov@gmail.com>
` Re: NestedLoops over BitmapScan question
2012-10-01 23:09 UTC Виктор Егоров <vyegorov@gmail.com>
[2+ messages in thread]
Spurious failure to obtain row lock possible in PG 9.1?
2012-09-24 21:18 UTC henk de wit <henk53602@hotmail.com>
` Re: Spurious failure to obtain row lock possible in PG 9.1?
2012-09-25 10:48 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: Spurious failure to obtain row lock possible in PG 9.1?
2012-09-29 12:40 UTC henk de wit <henk53602@hotmail.com>
[3+ messages in thread]
Query plan, nested EXISTS
2012-09-28 21:04 UTC Matt Daw <matt@shotgunsoftware.com>
` Re: Query plan, nested EXISTS
2012-09-28 21:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query plan, nested EXISTS
2012-09-28 21:47 UTC Matt Daw <matt@shotgunsoftware.com>
` Re: Query plan, nested EXISTS
2012-09-28 22:56 UTC Matt Daw <matt@shotgunsoftware.com>
[4+ messages in thread]
Possible Performance Regression with Transitive Comparisons vs. Constants
2012-09-28 19:22 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Possible Performance Regression with Transitive Comparisons vs. Constants
2012-09-28 20:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Possible Performance Regression with Transitive Comparisons vs. Constants
2012-09-28 21:37 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: Possible Performance Regression with Transitive Comparisons vs. Constants
2012-09-28 22:25 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
"Select * " on 12-18M row table from remote machine thru JDBC - Performance nose-dives after 10M-ish records
2012-09-28 13:52 UTC antthelimey <antthelimey@gmail.com>
` Re: "Select * " on 12-18M row table from remote machine thru JDBC - Performance nose-dives after 10M-ish records
2012-09-28 15:10 UTC Deron <fecastle@gmail.com>
[2+ messages in thread]
exponential performance decrease, problem with version postgres + RHEL?
2012-09-28 10:43 UTC John Nash <postgres.dba.needs.help@gmail.com>
` Re: [PERFORM] exponential performance decrease, problem with version postgres + RHEL?
2012-09-28 10:47 UTC Nikolay Ulyanitsky <lystor@gmail.com>
` RE: [PERFORM] exponential performance decrease, problem with version postgres + RHEL?
2012-09-28 10:58 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: [PERFORM] Re: [PERFORM] exponential performance decrease, problem with version postgres + RHEL?
2012-09-28 10:58 UTC John Nash <postgres.dba.needs.help@gmail.com>
[4+ messages in thread]
Inaccurate Explain Cost
2012-09-26 18:38 UTC Robert Sosinski <rsosinski@ticketevolution.com>
` Re: Inaccurate Explain Cost
2012-09-26 20:03 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: [PERFORM] Inaccurate Explain Cost
2012-09-26 20:20 UTC Edson Richter <edsonrichter@hotmail.com>
` Re: Inaccurate Explain Cost
2012-09-26 20:21 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Inaccurate Explain Cost
2012-09-26 22:42 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: [PERFORM] Inaccurate Explain Cost
2012-09-26 23:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [GENERAL] Inaccurate Explain Cost
2012-09-27 00:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: [GENERAL] Inaccurate Explain Cost
2012-09-27 10:48 UTC Matthias <nitrogenycs@gmail.com>
[8+ messages in thread]
wrong join result set estimate
2012-09-26 21:57 UTC Evgeny Shishkin <itparanoia@gmail.com>
Planner selects different execution plans depending on limit
2012-09-10 14:24 UTC bill_martin@freenet.de
` Re: Planner selects different execution plans depending on limit
2012-09-10 18:18 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Planner selects different execution plans depending on limit
2012-09-11 07:20 UTC Bill Martin <bill.martin@communote.com>
` Re: Planner selects different execution plans depending on limit
2012-09-11 17:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner selects different execution plans depending on limit
2012-09-13 09:05 UTC Bill Martin <bill.martin@communote.com>
` Re: Planner selects different execution plans depending on limit
2012-09-13 14:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner selects different execution plans depending on limit
2012-09-13 14:42 UTC Bill Martin <bill.martin@communote.com>
` Re: Planner selects different execution plans depending on limit
2012-09-13 14:48 UTC Jesper Krogh <jesper@krogh.cc>
` Re: Planner selects different execution plans depending on limit
2012-09-13 14:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner selects different execution plans depending on limit
2012-09-13 17:19 UTC Bill Martin <bill.martin@communote.com>
` Re: Planner selects different execution plans depending on limit
2012-09-13 17:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Planner selects different execution plans depending on limit
2012-09-16 21:39 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: [PERFORM] Planner selects different execution plans depending on limit
2012-09-16 22:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner selects different execution plans depending on limit
2012-09-18 07:28 UTC Bill Martin <bill.martin@communote.com>
` Re: [PERFORM] Planner selects different execution plans depending on limit
2012-09-26 15:52 UTC Bruce Momjian <bruce@momjian.us>
[15+ messages in thread]
Newbie performance problem - semop taking most of time ?
2012-09-19 12:34 UTC mal.oracledba <mal.oracledba@gmail.com>
` Re: Newbie performance problem - semop taking most of time ?
2012-09-22 05:50 UTC Daniel Farina <daniel@heroku.com>
` Re: Newbie performance problem - semop taking most of time ?
2012-09-23 19:42 UTC mal.oracledba <mal.oracledba@gmail.com>
` Re: Newbie performance problem - semop taking most of time ?
2012-09-23 20:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
wal_sync_method on FreeBSD 9.0 - ZFS
2012-09-14 20:19 UTC Sébastien Lorion <sl@thestrangefactory.com>
` Re: wal_sync_method on FreeBSD 9.0 - ZFS
2012-09-17 10:56 UTC Ivan Voras <ivoras@freebsd.org>
` Re: wal_sync_method on FreeBSD 9.0 - ZFS
2012-09-22 14:01 UTC Sébastien Lorion <sl@thestrangefactory.com>
[3+ messages in thread]
PostgreSQL performance on 64 bit as compared to 32 bit
2012-09-16 03:48 UTC Umesh Kirdat <umesh.kirdat@yahoo.com>
` Re: PostgreSQL performance on 64 bit as compared to 32 bit
2012-09-22 02:43 UTC Claudio Freire <klaussfreire@gmail.com>
[2+ messages in thread]
Query Planner Optimization?
2012-09-21 17:08 UTC Brandon <cdsboy@gmail.com>
Are there known performance issues with defining all Foreign Keys as deferrable initially immediate
2012-09-14 15:56 UTC McKinzie, Alan (Alan) <alanmck@avaya.com>
` Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate
2012-09-16 13:45 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate
2012-09-16 14:12 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate
2012-09-16 15:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate
2012-09-17 02:59 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate
2012-09-17 13:38 UTC McKinzie, Alan (Alan) <alanmck@avaya.com>
[6+ messages in thread]
Remote access to Postgresql slow
2012-09-14 09:02 UTC Manoj Agarwal <ma@ockham.be>
` Re: Remote access to Postgresql slow
2012-09-15 21:17 UTC Andrew Barnham <andrew.barnham@gmail.com>
` Re: Remote access to Postgresql slow
2012-09-15 21:20 UTC Scott Marlowe <scott.marlowe@gmail.com>
[3+ messages in thread]
Setting autovacuum_vacuum_scale_factor to 0 a good idea ?
2012-09-14 20:11 UTC Sébastien Lorion <sl@thestrangefactory.com>
` Re: Setting autovacuum_vacuum_scale_factor to 0 a good idea ?
2012-09-14 21:49 UTC Josh Berkus <josh@agliodbs.com>
` Re: Setting autovacuum_vacuum_scale_factor to 0 a good idea ?
2012-09-15 02:35 UTC Sébastien Lorion <sl@thestrangefactory.com>
[3+ messages in thread]
AppScale backend datastore (NoSQL again kind of)
2012-09-13 18:11 UTC Ross Reedstrom <reedstrm@rice.edu>
` Re: AppScale backend datastore (NoSQL again kind of)
2012-09-13 18:30 UTC Marcos Ortiz <mlortiz@uci.cu>
` Re: AppScale backend datastore (NoSQL again kind of)
2012-09-13 22:15 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[3+ messages in thread]
Linux machine aggressively clearing cache
2012-03-27 20:06 UTC Joshua Berkus <josh@agliodbs.com>
` Re: Linux machine aggressively clearing cache
2012-03-27 20:10 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Linux machine aggressively clearing cache
2012-03-27 20:40 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Linux machine aggressively clearing cache
2012-03-28 18:37 UTC Joshua Berkus <josh@agliodbs.com>
` Re: Linux machine aggressively clearing cache
2012-03-31 00:51 UTC Josh Berkus <josh@agliodbs.com>
` Re: Linux machine aggressively clearing cache
2012-04-12 15:47 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Linux machine aggressively clearing cache
2012-04-19 00:09 UTC Josh Berkus <josh@agliodbs.com>
` Re: Linux machine aggressively clearing cache
2012-09-13 19:00 UTC Ross Reedstrom <reedstrm@rice.edu>
[8+ messages in thread]
(no subject)
2012-09-13 18:25 UTC Feridun türk <feridunturk@gmail.com>
: PostgreSQL Index behavior
2012-09-10 12:39 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : PostgreSQL Index behavior
2012-09-10 15:36 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: : PostgreSQL Index behavior
2012-09-12 06:57 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : PostgreSQL Index behavior
2012-09-12 14:12 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: : PostgreSQL Index behavior
2012-09-13 09:22 UTC Venkat Balaji <venkat.balaji@verse.in>
` Re: : PostgreSQL Index behavior
2012-09-13 09:39 UTC Tomas Vondra <tv@fuzzy.cz>
[6+ messages in thread]
add column with default value is very slow
2012-09-11 13:20 UTC AI Rumman <rummandba@gmail.com>
` Re: add column with default value is very slow
2012-09-11 13:41 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: add column with default value is very slow
2012-09-11 13:44 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: add column with default value is very slow
2012-09-11 13:55 UTC AI Rumman <rummandba@gmail.com>
` Re: add column with default value is very slow
2012-09-11 13:59 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: add column with default value is very slow
2012-09-11 14:04 UTC AI Rumman <rummandba@gmail.com>
` Re: add column with default value is very slow
2012-09-11 14:05 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: add column with default value is very slow
2012-09-11 14:07 UTC Andrew Dunstan <andrew@dunslane.net>
[8+ messages in thread]
Slow Performance on a XEON E5504
2012-08-24 09:47 UTC Felix Schubert <input@fescon.de>
` Slow Performance on a XEON E5504
2012-08-25 12:07 UTC Felix Schubert <input@fescon.de>
` Re: Slow Performance on a XEON E5504
2012-08-25 12:42 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Slow Performance on a XEON E5504
2012-08-25 12:53 UTC Felix Schubert <input@fescon.de>
` Re: Slow Performance on a XEON E5504
2012-08-25 12:59 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Slow Performance on a XEON E5504
2012-08-25 13:04 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Slow Performance on a XEON E5504
2012-08-25 21:26 UTC Felix Schubert <input@fescon.de>
` Re: Slow Performance on a XEON E5504
2012-08-25 21:47 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Slow Performance on a XEON E5504
2012-09-10 20:58 UTC Marcos Ortiz <mlortiz@uci.cu>
[9+ messages in thread]
force defaults
2012-09-10 14:40 UTC Willy-Bas Loos <willybas@gmail.com>
libpq or postgresql performance
2012-09-06 20:04 UTC Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com>
` Re: libpq or postgresql performance
2012-09-07 05:35 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: libpq or postgresql performance
2012-09-07 06:45 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: libpq or postgresql performance
2012-09-07 06:52 UTC Ireneusz Pluta <ipluta@wp.pl>
` Re: libpq or postgresql performance
2012-09-07 17:24 UTC Ireneusz Pluta <ipluta@wp.pl>
` Re: libpq or postgresql performance
2012-09-10 09:01 UTC Ireneusz Pluta <ipluta@wp.pl>
[6+ messages in thread]
exponential performance decrease in ISD transaction
2012-08-31 12:27 UTC John Nash <postgres.dba.needs.help@gmail.com>
` Re: exponential performance decrease in ISD transaction
2012-08-31 13:36 UTC Heikki Linnakangas <hlinnaka@iki.fi>
` Re: exponential performance decrease in ISD transaction
2012-08-31 16:17 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: exponential performance decrease in ISD transaction
2012-09-03 11:22 UTC John Nash <postgres.dba.needs.help@gmail.com>
` Re: exponential performance decrease in ISD transaction
2012-09-03 17:27 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: exponential performance decrease in ISD transaction
2012-09-06 03:55 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: exponential performance decrease in ISD transaction
2012-09-07 10:55 UTC John Nash <postgres.dba.needs.help@gmail.com>
` Re: exponential performance decrease in ISD transaction
2012-09-07 10:57 UTC John Nash <postgres.dba.needs.help@gmail.com>
[8+ 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