pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
2008-02-22 18:37 UTC Susan Russo <russo@morgan.harvard.edu>
` Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
2008-02-22 19:18 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
2008-02-25 13:11 UTC Matthew <matthew@flymine.org>
[3+ messages in thread]
store A LOT of 3-tuples for comparisons
2008-02-22 15:42 UTC Moritz Onken <onken@houseofdesign.de>
` Re: store A LOT of 3-tuples for comparisons
2008-02-22 15:49 UTC Matthew <matthew@flymine.org>
` Re: store A LOT of 3-tuples for comparisons
2008-02-23 07:53 UTC Shane Ambler <pgsql@Sheeky.Biz>
` Re: store A LOT of 3-tuples for comparisons
2008-02-23 09:07 UTC Moritz Onken <onken@houseofdesign.de>
[4+ messages in thread]
loading same instance of dump to two different servers simultaneously?
2008-02-22 18:34 UTC Susan Russo <russo@morgan.harvard.edu>
` Re: loading same instance of dump to two different servers simultaneously?
2008-02-22 19:26 UTC Geoffrey <lists@serioustechnology.com>
` Re: loading same instance of dump to two different servers simultaneously?
2008-02-22 19:27 UTC Geoffrey <lists@serioustechnology.com>
[3+ messages in thread]
7 hrs for a pg_restore?
2008-02-19 18:03 UTC Douglas J Hunley <doug@hunley.homeip.net>
` Re: 7 hrs for a pg_restore?
2008-02-19 18:12 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: 7 hrs for a pg_restore?
2008-02-19 18:13 UTC Richard Huxton <dev@archonet.com>
` Re: 7 hrs for a pg_restore?
2008-02-19 18:15 UTC Dave Cramer <pg@fastcrypt.com>
` Re: 7 hrs for a pg_restore?
2008-02-19 18:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7 hrs for a pg_restore?
2008-02-19 18:23 UTC Jeff Davis <pgsql@j-davis.com>
` Re: 7 hrs for a pg_restore?
2008-02-19 18:58 UTC Douglas J Hunley <doug@hunley.homeip.net>
` Re: 7 hrs for a pg_restore?
2008-02-19 19:00 UTC Douglas J Hunley <doug@hunley.homeip.net>
` Re: 7 hrs for a pg_restore?
2008-02-19 19:08 UTC Douglas J Hunley <doug@hunley.homeip.net>
` Re: 7 hrs for a pg_restore?
2008-02-19 19:20 UTC Douglas J Hunley <doug@hunley.homeip.net>
` Re: 7 hrs for a pg_restore?
2008-02-19 19:28 UTC Dave Cramer <pg@fastcrypt.com>
` Re: 7 hrs for a pg_restore?
2008-02-19 19:35 UTC Douglas J Hunley <doug@hunley.homeip.net>
` Re: 7 hrs for a pg_restore?
2008-02-19 19:46 UTC Jeff Davis <pgsql@j-davis.com>
` Re: 7 hrs for a pg_restore?
2008-02-19 19:51 UTC Jeff Davis <pgsql@j-davis.com>
` Re: 7 hrs for a pg_restore?
2008-02-19 20:07 UTC Jeff <threshar@torgo.978.org>
` Re: 7 hrs for a pg_restore?
2008-02-19 20:16 UTC Dave Cramer <pg@fastcrypt.com>
` Re: 7 hrs for a pg_restore?
2008-02-19 20:20 UTC Douglas J Hunley <doug@hunley.homeip.net>
` Re: 7 hrs for a pg_restore?
2008-02-19 20:55 UTC Douglas J Hunley <doug@hunley.homeip.net>
` Re: 7 hrs for a pg_restore?
2008-02-19 21:32 UTC Erik Jones <erik@myemma.com>
` Re: 7 hrs for a pg_restore?
2008-02-19 22:53 UTC Greg Smith <gsmith@gregsmith.com>
` Re: 7 hrs for a pg_restore?
2008-02-20 09:01 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: 7 hrs for a pg_restore?
2008-02-20 11:29 UTC ohp@pyrenet.fr
` Re: 7 hrs for a pg_restore?
2008-02-20 13:26 UTC Douglas J Hunley <doug@hunley.homeip.net>
` Re: 7 hrs for a pg_restore?
2008-02-20 13:28 UTC Douglas J Hunley <doug@hunley.homeip.net>
` Re: 7 hrs for a pg_restore?
2008-02-20 14:14 UTC Gregory Stark <stark@enterprisedb.com>
` Re: 7 hrs for a pg_restore?
2008-02-20 16:27 UTC Erik Jones <erik@myemma.com>
` Re: 7 hrs for a pg_restore?
2008-02-20 16:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7 hrs for a pg_restore?
2008-02-20 17:11 UTC Matthew <matthew@flymine.org>
` Re: 7 hrs for a pg_restore?
2008-02-20 17:31 UTC Erik Jones <erik@myemma.com>
` Re: 7 hrs for a pg_restore?
2008-02-20 18:04 UTC Jeff Davis <pgsql@j-davis.com>
` Re: 7 hrs for a pg_restore?
2008-02-20 18:18 UTC Matthew <matthew@flymine.org>
` Re: 7 hrs for a pg_restore?
2008-02-20 18:35 UTC Jeff Davis <pgsql@j-davis.com>
` Re: 7 hrs for a pg_restore?
2008-02-20 18:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7 hrs for a pg_restore?
2008-02-20 23:31 UTC Gregory Stark <stark@enterprisedb.com>
` Re: 7 hrs for a pg_restore?
2008-02-20 23:35 UTC Chris <dmagick@gmail.com>
` Re: 7 hrs for a pg_restore?
2008-02-21 05:29 UTC Chris <dmagick@gmail.com>
` Re: 7 hrs for a pg_restore?
2008-02-21 05:30 UTC Gregory Stark <stark@enterprisedb.com>
` Re: 7 hrs for a pg_restore?
2008-02-21 13:58 UTC Matthew <matthew@flymine.org>
` Re: 7 hrs for a pg_restore?
2008-02-21 17:28 UTC Guillaume Cottenceau <gc@mnc.ch>
` Re: 7 hrs for a pg_restore?
2008-02-21 18:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7 hrs for a pg_restore?
2008-02-21 19:17 UTC Vivek Khera <vivek@khera.org>
` Re: 7 hrs for a pg_restore?
2008-02-22 10:40 UTC Guillaume Cottenceau <gc@mnc.ch>
[42+ messages in thread]
4s query want to run faster
2008-02-21 20:48 UTC Adonias Malosso <malosso@gmail.com>
` Re: 4s query want to run faster
2008-02-21 20:58 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: 4s query want to run faster
2008-02-21 21:05 UTC Adonias Malosso <malosso@gmail.com>
` Re: 4s query want to run faster
2008-02-21 21:10 UTC Claus Guttesen <kometen@gmail.com>
` Re: 4s query want to run faster
2008-02-21 21:11 UTC Adonias Malosso <malosso@gmail.com>
` Re: 4s query want to run faster
2008-02-21 21:16 UTC Claus Guttesen <kometen@gmail.com>
` Re: 4s query want to run faster
2008-02-21 21:23 UTC Adonias Malosso <malosso@gmail.com>
` Re: 4s query want to run faster
2008-02-21 21:25 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: 4s query want to run faster
2008-02-21 22:59 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: 4s query want to run faster
2008-02-21 23:16 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: 4s query want to run faster
2008-02-21 23:40 UTC Dave Cramer <pg@fastcrypt.com>
` Re: 4s query want to run faster
2008-02-22 05:10 UTC Mark Kirkwood <markir@paradise.net.nz>
[12+ messages in thread]
config settings, was: 4s query want to run faster
2008-02-22 00:24 UTC Scott Marlowe <scott.marlowe@gmail.com>
Question about shared_buffers and cpu usage
2008-02-21 05:13 UTC bh yuan <bhyuan@gmail.com>
` Re: Question about shared_buffers and cpu usage
2008-02-21 07:15 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Question about shared_buffers and cpu usage
2008-02-21 12:24 UTC Dave Cramer <pg@fastcrypt.com>
[3+ messages in thread]
planner favors seq scan too early
2008-02-21 07:04 UTC Markus Bertheau <mbertheau.pg@googlemail.com>
` Re: planner favors seq scan too early
2008-02-21 08:34 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
Need Help selecting Large Data From PQSQL
2008-02-20 11:02 UTC shilpa.raghavendra@wipro.com
` Re: Need Help selecting Large Data From PQSQL
2008-02-20 11:38 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
mis-estimate in nested query causes slow runtimes
2008-02-11 22:24 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: mis-estimate in nested query causes slow runtimes
2008-02-11 23:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: mis-estimate in nested query causes slow runtimes
2008-02-12 14:02 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: mis-estimate in nested query causes slow runtimes
2008-02-12 15:09 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: mis-estimate in nested query causes slow runtimes
2008-02-18 19:32 UTC Chris Kratz <chris.kratz@vistashare.com>
` Re: mis-estimate in nested query causes slow runtimes
2008-02-20 11:07 UTC Chris Kratz <chris.kratz@vistashare.com>
[6+ messages in thread]
wal_sync_methods for AIX
2008-02-15 21:55 UTC Dan Langille <dan@langille.org>
` Re: wal_sync_methods for AIX
2008-02-15 22:04 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: wal_sync_methods for AIX
2008-02-15 22:20 UTC Erik Jones <erik@myemma.com>
` Re: Fwd: wal_sync_methods for AIX
2008-02-19 20:21 UTC JP Fletcher <jpfletch@ca.afilias.info>
` Re: wal_sync_methods for AIX
2008-02-19 21:58 UTC Dan Langille <dan@langille.org>
` Re: wal_sync_methods for AIX
2008-02-19 22:09 UTC Erik Jones <erik@myemma.com>
` Re: Fwd: wal_sync_methods for AIX
2008-02-19 22:57 UTC Greg Smith <gsmith@gregsmith.com>
[7+ messages in thread]
Disable WAL completely
2008-02-18 09:11 UTC Kathirvel, Jeevanandam <Jeevanandam.Kathirvel@honeywell.com>
` Re: Disable WAL completely
2008-02-18 09:19 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Disable WAL completely
2008-02-18 09:24 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: Disable WAL completely
2008-02-18 09:30 UTC Kathirvel, Jeevanandam <Jeevanandam.Kathirvel@honeywell.com>
` Re: Disable WAL completely
2008-02-18 09:32 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Disable WAL completely
2008-02-18 15:34 UTC Erik Jones <erik@myemma.com>
` Re: Disable WAL completely
2008-02-18 16:49 UTC Tobias Brox <tobias@nordicbet.com>
` Re: Disable WAL completely
2008-02-19 14:48 UTC Matthew <matthew@flymine.org>
` Re: Disable WAL completely
2008-02-19 15:48 UTC Andrew Sullivan <ajs@crankycanuck.ca>
[9+ messages in thread]
strange plan choice
2008-02-19 15:27 UTC Cousin Marc <mcousin@sigma.fr>
shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-15 12:35 UTC Peter Schuller <peter.schuller@infidyne.com>
` Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-15 13:37 UTC Kenneth Marshall <ktm@rice.edu>
` Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-15 13:58 UTC Peter Schuller <peter.schuller@infidyne.com>
` Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-15 14:29 UTC Greg Smith <gsmith@gregsmith.com>
` Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-15 18:06 UTC Josh Berkus <josh@agliodbs.com>
` Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-15 18:37 UTC Erik Jones <erik@myemma.com>
` Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-15 18:42 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-15 19:34 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
` Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-15 19:46 UTC Erik Jones <erik@myemma.com>
` Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-18 07:39 UTC Peter Schuller <peter.schuller@infidyne.com>
` Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
2008-02-18 21:24 UTC Greg Smith <gsmith@gregsmith.com>
[11+ messages in thread]
Controling 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]
[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