pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedControling where temporary files are created
2008-02-18 15:27 UTC Nikolas Everett <nik9000@gmail.com>
` Re: Controling where temporary files are created
2008-02-18 15:50 UTC Albert Cervera Areny <albert@sedifa.com>
[2+ messages in thread]
Example web access to Postgres DB
2008-02-17 11:21 UTC Mohamed Ali JBELI <medali.jbeli@gmail.com>
` Re: Example web access to Postgres DB
2008-02-17 13:53 UTC Tino Wildenhain <tino@wildenhain.de>
` Re: Example web access to Postgres DB
2008-02-17 15:18 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Example web access to Postgres DB
2008-02-17 16:12 UTC Dave Cramer <pg@fastcrypt.com>
` Re: Example web access to Postgres DB
2008-02-17 16:22 UTC Adam Tauno Williams <adamtaunowilliams@gmail.com>
[5+ messages in thread]
Query slows after offset of 100K
2008-02-14 18:28 UTC Michael Lorenz <mlorenz1@hotmail.com>
` Re: Query slows after offset of 100K
2008-02-14 19:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query slows after offset of 100K
2008-02-14 19:49 UTC Michael Lorenz <mlorenz1@hotmail.com>
` Re: Query slows after offset of 100K
2008-02-14 20:32 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Query slows after offset of 100K
2008-02-14 21:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query slows after offset of 100K
2008-02-14 23:54 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Query slows after offset of 100K
2008-02-15 00:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query slows after offset of 100K
2008-02-15 14:47 UTC Matthew <matthew@flymine.org>
[8+ messages in thread]
Creating and updating table using function parameter reference
2008-02-13 14:25 UTC Linux Guru <linux.binary@gmail.com>
` Re: Creating and updating table using function parameter reference
2008-02-13 15:23 UTC Albert Cervera Areny <albert@sedifa.com>
` Re: Creating and updating table using function parameter reference
2008-02-14 12:35 UTC Linux Guru <linux.binary@gmail.com>
` Re: Creating and updating table using function parameter reference
2008-02-14 12:54 UTC Albert Cervera Areny <albert@sedifa.com>
` Re: Creating and updating table using function parameter reference
2008-02-15 14:14 UTC Linux Guru <linux.binary@gmail.com>
[5+ messages in thread]
Avoid long-running transactions in a long-running stored procedure?
2008-02-15 01:15 UTC David Crane <davidc@donorschoose.org>
` Re: Avoid long-running transactions in a long-running stored procedure?
2008-02-15 01:29 UTC Josh Berkus <josh@agliodbs.com>
` Re: Avoid long-running transactions in a long-running stored procedure?
2008-02-15 01:30 UTC Ow Mun Heng <Ow.Mun.Heng@wdc.com>
` Re: Avoid long-running transactions in a long-runningstored procedure?
2008-02-15 01:38 UTC David Crane <davidc@donorschoose.org>
[4+ messages in thread]
Join Query Perfomance Issue
2008-02-11 18:08 UTC Thomas Zaksek <zaksek@ptt.uni-due.de>
` Re: Join Query Perfomance Issue
2008-02-11 21:37 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Join Query Perfomance Issue
2008-02-11 21:38 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Join Query Perfomance Issue
2008-02-12 10:11 UTC Thomas Zaksek <zaksek@ptt.uni-due.de>
` Re: Join Query Perfomance Issue
2008-02-12 20:34 UTC Peter Koczan <pjkoczan@gmail.com>
` Re: Join Query Perfomance Issue
2008-02-13 11:17 UTC Thomas Zaksek <zaksek@ptt.uni-due.de>
` Re: Join Query Perfomance Issue
2008-02-13 11:45 UTC Thomas Zaksek <zaksek@ptt.uni-due.de>
` Re: Join Query Perfomance Issue
2008-02-13 15:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Join Query Perfomance Issue
2008-02-13 17:46 UTC Thomas Zaksek <zaksek@ptt.uni-due.de>
` Re: Join Query Perfomance Issue
2008-02-13 21:36 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Join Query Perfomance Issue
2008-02-14 10:57 UTC Thomas Zaksek <zaksek@ptt.uni-due.de>
` Re: Join Query Perfomance Issue
2008-02-14 23:48 UTC Chris <dmagick@gmail.com>
[12+ messages in thread]
HOT TOAST?
2008-02-13 17:50 UTC Josh Berkus <josh@agliodbs.com>
` Re: HOT TOAST?
2008-02-13 18:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: HOT TOAST?
2008-02-13 23:07 UTC Josh Berkus <josh@agliodbs.com>
[3+ messages in thread]
Optimizing No matching record Queries
2008-02-12 21:35 UTC Pallav Kalva <pkalva@livedatagroup.com>
` Re: Optimizing No matching record Queries
2008-02-12 22:09 UTC Stephen Denne <Stephen.Denne@datamail.co.nz>
` Re: Optimizing No matching record Queries
2008-02-13 00:07 UTC Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
` Re: Optimizing No matching record Queries
2008-02-13 00:16 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Optimizing No matching record Queries
2008-02-13 08:54 UTC Richard Huxton <dev@archonet.com>
` Re: Optimizing No matching record Queries
2008-02-13 19:46 UTC Pallav Kalva <pkalva@livedatagroup.com>
` Re: Optimizing No matching record Queries
2008-02-13 20:51 UTC Gregory Stark <stark@enterprisedb.com>
[7+ messages in thread]
Dell Perc/6
2008-02-12 16:32 UTC Craig James <craig_james@emolecules.com>
` Re: Dell Perc/6
2008-02-12 19:01 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Dell Perc/6
2008-02-13 10:02 UTC Tore Halset <halset@pvv.ntnu.no>
` Re: Dell Perc/6
2008-02-13 11:06 UTC Dave Cramer <pg@fastcrypt.com>
` Re: Dell Perc/6
2008-02-13 15:56 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Dell Perc/6
2008-02-13 19:45 UTC Tore Halset <halset@pvv.ntnu.no>
` Re: Dell Perc/6
2008-02-13 20:28 UTC Tore Halset <halset@pvv.ntnu.no>
[7+ messages in thread]
Small DB Server Advice
2008-02-13 13:12 UTC Rory Campbell-Lange <rory@campbell-lange.net>
` Re: Small DB Server Advice
2008-02-13 13:53 UTC Matthew <matthew@flymine.org>
` Re: Small DB Server Advice
2008-02-13 14:32 UTC Magnus Hagander <magnus@hagander.net>
` Re: Small DB Server Advice
2008-02-13 14:35 UTC Matthew <matthew@flymine.org>
` Re: Small DB Server Advice
2008-02-13 17:38 UTC Greg Smith <gsmith@gregsmith.com>
[5+ messages in thread]
Update with Subquery Performance
2008-02-11 11:06 UTC Linux Guru <linux.binary@gmail.com>
` Re: Update with Subquery Performance
2008-02-11 16:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Update with Subquery Performance
2008-02-11 21:29 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Update with Subquery Performance
2008-02-12 08:32 UTC Linux Guru <linux.binary@gmail.com>
` Re: Update with Subquery Performance
2008-02-12 08:46 UTC Linux Guru <linux.binary@gmail.com>
` Re: Update with Subquery Performance
2008-02-12 16:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Update with Subquery Performance
2008-02-13 10:59 UTC Linux Guru <linux.binary@gmail.com>
[7+ messages in thread]
Questions about enabling SSL
2008-02-11 23:58 UTC fabrix peñuelas <fabrixio1@gmail.com>
` Re: Questions about enabling SSL
2008-02-12 00:37 UTC Michael Fuhr <mike@fuhr.org>
` Re: Questions about enabling SSL
2008-02-12 01:00 UTC Michael Fuhr <mike@fuhr.org>
` Re: Questions about enabling SSL
2008-02-12 17:46 UTC fabrix peñuelas <fabrixio1@gmail.com>
[4+ messages in thread]
Question about CLUSTER
2008-02-11 20:03 UTC salman <salmanb@quietcaresystems.com>
` Re: [PERFORM] Question about CLUSTER
2008-02-11 21:33 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: [PERFORM] Question about CLUSTER
2008-02-12 02:42 UTC Michael Fuhr <mike@fuhr.org>
[3+ messages in thread]
Optimizer : query rewrite and execution plan ?
2008-02-06 08:42 UTC SURANTYN Jean François <jfsurant@supermarchesmatch.fr>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-06 09:47 UTC Richard Huxton <dev@archonet.com>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-06 10:02 UTC SURANTYN Jean François <jfsurant@supermarchesmatch.fr>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-06 10:06 UTC Richard Huxton <dev@archonet.com>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-06 11:53 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-06 12:12 UTC Theo Kramer <theo@flame.co.za>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-06 13:35 UTC Roberts, Jon <Jon.Roberts@asurion.com>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-06 15:27 UTC Erik Jones <erik@myemma.com>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-06 15:35 UTC Roberts, Jon <Jon.Roberts@asurion.com>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-06 16:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-11 09:44 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Optimizer : query rewrite and execution plan ?
2008-02-11 16:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
[12+ messages in thread]
Parallel inserts
2008-02-08 20:59 UTC Ivan Voras <ivoras@geri.cc.fer.hr>
` Re: Parallel inserts
2008-02-09 04:19 UTC Bruce Momjian <bruce@momjian.us>
[2+ messages in thread]
Benchmark Data requested
2008-02-04 18:37 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-04 18:47 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Benchmark Data requested
2008-02-04 18:50 UTC Claus Guttesen <kometen@gmail.com>
` Re: Benchmark Data requested
2008-02-04 19:07 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-04 20:09 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark Data requested
2008-02-04 20:21 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-04 22:32 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Benchmark Data requested
2008-02-04 22:33 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: Benchmark Data requested
2008-02-04 22:34 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Benchmark Data requested
2008-02-04 22:55 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: Benchmark Data requested
2008-02-04 22:56 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark Data requested
2008-02-04 23:37 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark Data requested
2008-02-05 00:10 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Benchmark Data requested
2008-02-05 00:17 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Benchmark Data requested
2008-02-05 00:49 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: Benchmark Data requested
2008-02-05 00:57 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: Benchmark Data requested
2008-02-05 08:45 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-05 09:08 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-05 14:06 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested
2008-02-05 14:24 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-05 14:29 UTC Matthew <matthew@flymine.org>
` Re: Benchmark Data requested
2008-02-05 14:43 UTC Richard Huxton <dev@archonet.com>
` Re: Benchmark Data requested
2008-02-05 14:51 UTC Matthew <matthew@flymine.org>
` Re: Benchmark Data requested
2008-02-05 14:53 UTC Matthew <matthew@flymine.org>
` Re: Benchmark Data requested
2008-02-05 14:54 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-05 15:05 UTC Richard Huxton <dev@archonet.com>
` Re: Benchmark Data requested
2008-02-05 15:25 UTC Matthew <matthew@flymine.org>
` Re: Benchmark Data requested
2008-02-05 15:26 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-05 15:52 UTC Richard Huxton <dev@archonet.com>
` Re: Benchmark Data requested
2008-02-05 15:57 UTC Matthew <matthew@flymine.org>
` Re: Benchmark Data requested
2008-02-05 15:59 UTC Richard Huxton <dev@archonet.com>
` Re: Benchmark Data requested
2008-02-05 16:09 UTC Richard Huxton <dev@archonet.com>
` Re: Benchmark Data requested
2008-02-05 16:14 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: Benchmark Data requested
2008-02-05 16:18 UTC Matthew <matthew@flymine.org>
` Re: Benchmark Data requested
2008-02-05 17:01 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested
2008-02-05 17:15 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested
2008-02-05 17:32 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-05 18:47 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: Benchmark Data requested
2008-02-05 19:48 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-05 20:06 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Benchmark Data requested
2008-02-05 20:45 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: Benchmark Data requested
2008-02-05 20:50 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: Benchmark Data requested
2008-02-05 21:45 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Benchmark Data requested
2008-02-05 22:00 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested
2008-02-06 03:35 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark Data requested
2008-02-06 07:38 UTC NikhilS <nikkhils@gmail.com>
` Re: Benchmark Data requested
2008-02-06 10:29 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested
2008-02-06 15:40 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark Data requested
2008-02-06 17:31 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested
2008-02-08 20:12 UTC Mark Wong <markwkm@gmail.com>
` Re: Benchmark Data requested
2008-02-08 20:16 UTC Mark Wong <markwkm@gmail.com>
[51+ messages in thread]
Wrong number of rows estimation by the planner
2008-02-08 12:12 UTC Yonatan Ben-Nes <yonatan@epoch.co.il>
index usage on arrays
2008-02-07 18:38 UTC andrew klassen <aptklassen@yahoo.com>
` Re: index usage on arrays
2008-02-07 18:55 UTC Oleg Bartunov <oleg@sai.msu.su>
` Re: index usage on arrays
2008-02-07 19:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 11:27 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 11:45 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 12:36 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 15:56 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 16:17 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 16:34 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 17:37 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 17:49 UTC Luke Lonergan <LLonergan@greenplum.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 19:59 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 20:04 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-06 23:36 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-07 09:31 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-07 17:06 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-07 17:11 UTC Matthew <matthew@flymine.org>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-07 17:14 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Benchmark Data requested --- pgloader CE design ideas
2008-02-07 17:15 UTC Kenneth Marshall <ktm@rice.edu>
[16+ messages in thread]
Index Scan Backward + check additional condition before heap access
2008-02-07 14:51 UTC Markus Bertheau <mbertheau.pg@googlemail.com>
Performance issue using Tsearch2
2008-02-05 11:47 UTC Viviane Lestic <vlestic@gmail.com>
` Re: Performance issue using Tsearch2
2008-02-05 13:36 UTC Ansgar -59cobalt- Wiechers <lists@planetcobalt.net>
` Re: Performance issue using Tsearch2
2008-02-05 13:48 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Performance issue using Tsearch2
2008-02-05 15:08 UTC Viviane Lestic <vlestic@gmail.com>
[4+ messages in thread]
Performance problems inside a stored procedure.
2008-01-28 12:02 UTC Matthew Lunnon <mlunnon@rwa-net.co.uk>
` Re: Performance problems inside a stored procedure.
2008-01-28 12:06 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Performance problems inside a stored procedure.
2008-01-28 12:10 UTC Matthew Lunnon <mlunnon@rwa-net.co.uk>
` Re: Performance problems inside a stored procedure.
2008-01-29 13:59 UTC Euler Taveira de Oliveira <euler@timbira.com>
` Re: Performance problems inside a stored procedure.
2008-01-29 17:38 UTC Matthew Lunnon <mlunnon@rwa-net.co.uk>
` Re: Performance problems inside a stored procedure.
2008-02-05 09:32 UTC Matthew Lunnon <mlunnon@rwa-net.co.uk>
[6+ messages in thread]
slow 8.2.6 with 50 connections
2008-02-03 16:02 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: slow 8.2.6 with 50 connections
2008-02-03 18:58 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: slow 8.2.6 with 50 connections
2008-02-03 19:35 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: slow 8.2.6 with 50 connections
2008-02-03 21:17 UTC Greg Smith <gsmith@gregsmith.com>
[4+ messages in thread]
Storage space usage
2008-02-01 08:44 UTC Gangadharan S.A. <gangadharan@gmail.com>
` Re: Storage space usage
2008-02-02 06:37 UTC Decibel! <decibel@decibel.org>
[2+ messages in thread]
How do I bulk insert to a table without affecting read performance on that table?
2008-01-25 23:27 UTC growse <nabble@growse.com>
` Re: How do I bulk insert to a table without affecting read performance on that table?
2008-01-26 02:06 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How do I bulk insert to a table without affecting read performance on that table?
2008-01-26 11:42 UTC growse <nabble@growse.com>
` Re: How do I bulk insert to a table without affecting read performance on that table?
2008-01-26 13:39 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How do I bulk insert to a table without affecting read performance on that table?
2008-01-31 23:06 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[5+ 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