pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDoes setval(nextval()+N) generate unique blocks of IDs?
2012-08-20 23:32 UTC Craig James <cjames@emolecules.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 00:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 00:59 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 01:06 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 07:41 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 07:45 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 14:12 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 14:36 UTC Craig James <cjames@emolecules.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 15:32 UTC Craig James <cjames@emolecules.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 17:53 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 20:03 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 20:04 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 20:59 UTC Craig James <cjames@emolecules.com>
` Re: Does setval(nextval()+N) generate unique blocks of IDs?
2012-08-21 21:06 UTC Scott Marlowe <scott.marlowe@gmail.com>
[14+ messages in thread]
7k records into Sort node, 4.5m out?
2012-08-14 01:15 UTC Christophe Pettus <xof@thebuild.com>
` Re: 7k records into Sort node, 4.5m out?
2012-08-14 01:35 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: 7k records into Sort node, 4.5m out?
2012-08-14 01:48 UTC Christophe Pettus <xof@thebuild.com>
` Re: 7k records into Sort node, 4.5m out?
2012-08-14 02:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7k records into Sort node, 4.5m out?
2012-08-15 19:13 UTC Christophe Pettus <xof@thebuild.com>
` Re: 7k records into Sort node, 4.5m out?
2012-08-15 20:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7k records into Sort node, 4.5m out?
2012-08-15 21:02 UTC Josh Berkus <josh@agliodbs.com>
` Re: 7k records into Sort node, 4.5m out?
2012-08-15 21:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7k records into Sort node, 4.5m out?
2012-08-16 00:25 UTC Josh Berkus <josh@agliodbs.com>
` Re: 7k records into Sort node, 4.5m out?
2012-08-16 06:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7k records into Sort node, 4.5m out?
2012-08-19 19:53 UTC Josh Berkus <josh@agliodbs.com>
` Re: 7k records into Sort node, 4.5m out?
2012-08-20 15:40 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 7k records into Sort node, 4.5m out?
2012-08-20 17:47 UTC Josh Berkus <josh@agliodbs.com>
[13+ messages in thread]
Index bloat problem?
2005-04-21 17:00 UTC Bill Chandler <billybobc1210@yahoo.com>
` Re: Index bloat problem?
2005-04-21 17:22 UTC Josh Berkus <josh@agliodbs.com>
` Re: Index bloat problem?
2005-04-21 17:33 UTC Alex Turner <armtuk@gmail.com>
` Re: Index bloat problem?
2005-04-21 17:38 UTC Bill Chandler <billybobc1210@yahoo.com>
` Re: Index bloat problem?
2005-04-21 17:42 UTC Josh Berkus <josh@agliodbs.com>
` Re: Index bloat problem?
2005-04-21 17:44 UTC Josh Berkus <josh@agliodbs.com>
` Re: Index bloat problem?
2005-04-21 17:47 UTC Chris Browne <cbbrowne@acm.org>
` Re: Index bloat problem?
2005-04-21 17:50 UTC Josh Berkus <josh@agliodbs.com>
` Re: Index bloat problem?
2005-04-21 18:24 UTC Michael Guerin <guerin@rentec.com>
` Re: Index bloat problem?
2005-04-21 18:28 UTC Josh Berkus <josh@agliodbs.com>
` Re: Index bloat problem?
2005-04-21 18:41 UTC a3a18850@telus.net
` Re: Index bloat problem?
2005-04-21 19:03 UTC Bill Chandler <billybobc1210@yahoo.com>
` Re: Index bloat problem?
2005-04-21 19:12 UTC Alex Turner <armtuk@gmail.com>
` Re: Index bloat problem?
2005-04-21 19:33 UTC Dave Chapeskie <pgsql@ddm.wox.org>
` Re: Index bloat problem?
2005-04-21 19:55 UTC Josh Berkus <josh@agliodbs.com>
` Re: Index bloat problem?
2005-04-21 22:15 UTC Mischa Sandberg <mischa.sandberg@telus.net>
` Re: Index bloat problem?
2005-04-21 22:59 UTC Bill Chandler <billybobc1210@yahoo.com>
` Re: Index bloat problem?
2005-04-21 23:54 UTC John A Meinel <john@arbash-meinel.com>
` Re: Index bloat problem?
2005-04-21 23:56 UTC Josh Berkus <josh@agliodbs.com>
` Re: Index bloat problem?
2005-04-22 05:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index bloat problem?
2005-04-22 08:44 UTC David Roussel <pgsql-performance@diroussel.xsmail.com>
` Re: Index bloat problem?
2005-04-22 14:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index bloat problem?
2005-04-22 16:16 UTC David Roussel <pgsql-performance@diroussel.xsmail.com>
` Re: Index bloat problem?
2005-04-22 17:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index bloat problem?
2005-04-23 03:12 UTC Jim C. Nasby <decibel@decibel.org>
` Index Bloat Problem
2012-08-10 22:15 UTC Strahinja Kustudić <strahinjak@nordeus.com>
` Re: Index Bloat Problem
2012-08-11 09:30 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Index Bloat Problem
2012-08-13 22:52 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Index Bloat Problem
2012-08-14 04:14 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index Bloat Problem
2012-08-16 19:57 UTC Strahinja Kustudić <strahinjak@nordeus.com>
` Re: Index Bloat Problem
2012-08-18 02:33 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Index Bloat Problem
2012-08-18 08:01 UTC Greg Williamson <gwilliamson39@yahoo.com>
[32+ messages in thread]
best practice to avoid table bloat?
2012-08-16 20:33 UTC Anibal David Acosta <aa@devshock.com>
` Re: best practice to avoid table bloat?
2012-08-16 20:48 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: best practice to avoid table bloat?
2012-08-16 20:52 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: best practice to avoid table bloat?
2012-08-16 21:10 UTC Anibal David Acosta <aa@devshock.com>
` Re: best practice to avoid table bloat?
2012-08-16 21:39 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[5+ messages in thread]
High Disk write and space taken by PostgreSQL
2012-08-16 03:23 UTC J Ramesh Kumar <rameshj1977@gmail.com>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 03:36 UTC David Barton <dave@oneit.com.au>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 04:30 UTC J Ramesh Kumar <rameshj1977@gmail.com>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 04:39 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 05:40 UTC J Ramesh Kumar <rameshj1977@gmail.com>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 05:41 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 05:48 UTC Ondrej Ivanič <ondrej.ivanic@gmail.com>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 05:50 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 14:53 UTC Bruce Momjian <bruce@momjian.us>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 14:56 UTC Bruce Momjian <bruce@momjian.us>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 15:49 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 16:07 UTC anarazel@anarazel.de <andres@anarazel.de>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 16:23 UTC Bruce Momjian <bruce@momjian.us>
` Re: High Disk write and space taken by PostgreSQL
2012-08-16 21:16 UTC Merlin Moncure <mmoncure@gmail.com>
[14+ messages in thread]
cluster on conditional index?
2012-08-14 15:27 UTC Doug Hunley <doug.hunley@gmail.com>
` Re: cluster on conditional index?
2012-08-14 17:10 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: cluster on conditional index?
2012-08-14 17:29 UTC ktm@rice.edu <ktm@rice.edu>
` Re: cluster on conditional index?
2012-08-15 13:43 UTC Doug Hunley <doug.hunley@gmail.com>
` Re: cluster on conditional index?
2012-08-15 21:05 UTC Josh Berkus <josh@agliodbs.com>
` Re: cluster on conditional index?
2012-08-15 21:19 UTC Bosco Rama <postgres@boscorama.com>
` Re: cluster on conditional index?
2012-08-16 15:25 UTC Doug Hunley <doug.hunley@gmail.com>
` Re: cluster on conditional index?
2012-08-16 16:04 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: cluster on conditional index?
2012-08-16 16:16 UTC Jeff Janes <jeff.janes@gmail.com>
[9+ messages in thread]
Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-23 08:41 UTC Jim Vanns <james.vanns@framestore.com>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-23 13:46 UTC Martin French <Martin.French@romaxtech.com>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-23 13:53 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-23 14:46 UTC Jim Vanns <james.vanns@framestore.com>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-23 14:47 UTC Jim Vanns <james.vanns@framestore.com>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-23 15:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-23 15:49 UTC Jim Vanns <james.vanns@framestore.com>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-24 00:30 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-24 06:50 UTC Martin French <Martin.French@romaxtech.com>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-24 08:37 UTC Jim Vanns <james.vanns@framestore.com>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-24 08:48 UTC Jim Vanns <james.vanns@framestore.com>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-24 09:18 UTC Martin French <Martin.French@romaxtech.com>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-07-24 09:34 UTC Jim Vanns <james.vanns@framestore.com>
` Re: Odd blocking (or massively latent) issue - even with EXPLAIN
2012-08-16 16:14 UTC Jim Vanns <james.vanns@framestore.com>
[14+ messages in thread]
Postgres 9.1.4 - high stats collector IO usage
2012-07-28 04:33 UTC David Barton <dave@oneit.com.au>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-07-28 07:07 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-07-28 16:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-07-28 17:08 UTC David Barton <dave@oneit.com.au>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-07-28 17:11 UTC David Barton <dave@oneit.com.au>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-07-31 01:21 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-08-06 14:10 UTC Magnus Hagander <magnus@hagander.net>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-08-06 14:16 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-08-06 14:18 UTC Magnus Hagander <magnus@hagander.net>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-08-06 14:43 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-08-12 21:23 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-08-13 02:17 UTC David Barton <dave@oneit.com.au>
` Re: Postgres 9.1.4 - high stats collector IO usage
2012-08-13 19:40 UTC Jeff Janes <jeff.janes@gmail.com>
[13+ messages in thread]
Deferred constraints performance impact ?
2012-07-20 02:27 UTC mark <dvlhntr@gmail.com>
` Re: Deferred constraints performance impact ?
2012-08-12 22:42 UTC Jeff Davis <pgsql@j-davis.com>
` Re: Deferred constraints performance impact ?
2012-08-13 08:33 UTC Robert Klemme <shortcutter@googlemail.com>
[3+ messages in thread]
Improve DB Size / Performance with Table Refactoring
2012-08-11 14:23 UTC Anthony Presley <anthony@resolution.com>
Is drop/restore trigger transactional?
2012-08-07 18:48 UTC Craig James <cjames@emolecules.com>
` Re: Is drop/restore trigger transactional?
2012-08-07 20:15 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Is drop/restore trigger transactional?
2012-08-07 20:39 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Is drop/restore trigger transactional?
2012-08-07 20:45 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Is drop/restore trigger transactional?
2012-08-07 21:21 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Is drop/restore trigger transactional?
2012-08-07 21:39 UTC Craig James <cjames@emolecules.com>
` Re: Is drop/restore trigger transactional?
2012-08-07 22:01 UTC Samuel Gendler <sgendler@ideasculptor.com>
` Re: Is drop/restore trigger transactional?
2012-08-07 22:02 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Is drop/restore trigger transactional?
2012-08-07 22:22 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Is drop/restore trigger transactional?
2012-08-07 22:46 UTC Craig James <cjames@emolecules.com>
` Re: Is drop/restore trigger transactional?
2012-08-08 00:29 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Is drop/restore trigger transactional?
2012-08-08 00:42 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Is drop/restore trigger transactional?
2012-08-11 14:16 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
[13+ messages in thread]
query overhead
2012-07-11 11:46 UTC Andy Halsall <halsall_andy@hotmail.com>
` Re: query overhead
2012-07-13 16:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query overhead
2012-07-14 03:28 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: query overhead
2012-07-16 14:43 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: query overhead
2012-07-21 08:30 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: query overhead
2012-08-10 18:19 UTC Jeff Janes <jeff.janes@gmail.com>
[6+ messages in thread]
DELETE vs TRUNCATE explanation
2012-07-11 00:37 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: DELETE vs TRUNCATE explanation
2012-07-11 05:22 UTC Daniel Farina <daniel@heroku.com>
` Re: DELETE vs TRUNCATE explanation
2012-07-11 14:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: DELETE vs TRUNCATE explanation
2012-07-11 14:19 UTC ktm@rice.edu <ktm@rice.edu>
` Re: DELETE vs TRUNCATE explanation
2012-07-11 18:10 UTC Matthew Woodcraft <matthew@woodcraft.me.uk>
` Re: DELETE vs TRUNCATE explanation
2012-07-11 20:18 UTC Craig James <cjames@emolecules.com>
` Re: DELETE vs TRUNCATE explanation
2012-07-11 20:47 UTC Shaun Thomas <sthomas@optionshouse.com>
` Re: DELETE vs TRUNCATE explanation
2012-07-11 21:04 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: DELETE vs TRUNCATE explanation
2012-07-11 21:32 UTC Mark Thornton <mthornton@optrak.com>
` Re: DELETE vs TRUNCATE explanation
2012-07-11 22:09 UTC Craig James <cjames@emolecules.com>
` Re: DELETE vs TRUNCATE explanation
2012-07-11 22:51 UTC Daniel Farina <daniel@heroku.com>
` Re: DELETE vs TRUNCATE explanation
2012-07-12 01:23 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: DELETE vs TRUNCATE explanation
2012-07-12 01:26 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: DELETE vs TRUNCATE explanation
2012-07-12 01:41 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: DELETE vs TRUNCATE explanation
2012-07-12 06:12 UTC Daniel Farina <daniel@heroku.com>
` Re: DELETE vs TRUNCATE explanation
2012-07-12 07:45 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: DELETE vs TRUNCATE explanation
2012-07-12 19:15 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: DELETE vs TRUNCATE explanation
2012-07-12 23:21 UTC Harold A. Giménez <harold.gimenez@gmail.com>
` Re: DELETE vs TRUNCATE explanation
2012-07-13 01:00 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-13 04:55 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-15 00:10 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-15 18:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-15 22:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 00:22 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 01:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 01:43 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 15:58 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 16:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 16:26 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 16:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 16:53 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 16:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 18:39 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 19:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 19:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 19:26 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-16 19:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-18 03:22 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-18 21:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-19 12:56 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-19 14:09 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-19 16:17 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-19 18:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-19 20:03 UTC Robert Haas <robertmhaas@gmail.com>
` Re: [PERFORM] DELETE vs TRUNCATE explanation
2012-07-19 21:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: DELETE vs TRUNCATE explanation
2012-08-09 18:06 UTC Jeff Janes <jeff.janes@gmail.com>
[46+ messages in thread]
Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m
2012-08-07 12:01 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m
2012-08-07 12:16 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m
2012-08-07 12:22 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m
2012-08-07 13:56 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m
2012-08-07 14:37 UTC Craig James <cjames@emolecules.com>
` Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m
2012-08-08 00:07 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m
2012-08-08 00:50 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m
2012-08-09 11:00 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m
2012-08-09 16:17 UTC Jeff Janes <jeff.janes@gmail.com>
[9+ messages in thread]
Re: Postgresql - performance of using array in big database
2012-08-08 06:33 UTC Craig Ringer <ringerc@ringerc.id.au>
` Re: Postgresql - performance of using array in big database
2012-08-09 00:18 UTC Ondrej Ivanič <ondrej.ivanic@gmail.com>
[2+ messages in thread]
Postgres Upgrade from 8.4 to 9.1
2012-08-06 05:38 UTC Rajiv Kasera <rajiv.kasera@pinelabs.com>
` Re: Postgres Upgrade from 8.4 to 9.1
2012-08-08 06:50 UTC Craig Ringer <ringerc@ringerc.id.au>
[2+ messages in thread]
Sequential scan instead of index scan
2012-08-06 15:08 UTC Ioannis Anagnostopoulos <ioannis@anatec.com>
` Re: Sequential scan instead of index scan
2012-08-06 15:16 UTC David Barton <dave@oneit.com.au>
` Re: Sequential scan instead of index scan
2012-08-06 15:24 UTC Ioannis Anagnostopoulos <ioannis@anatec.com>
` Re: Sequential scan instead of index scan
2012-08-06 15:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sequential scan instead of index scan
2012-08-06 22:04 UTC Ioannis Anagnostopoulos <ioannis@anatec.com>
` Re: Sequential scan instead of index scan
2012-08-07 03:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Sequential scan instead of index scan
2012-08-07 12:15 UTC Ioannis Anagnostopoulos <ioannis@anatec.com>
` Re: Sequential scan instead of index scan
2012-08-07 16:00 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Sequential scan instead of index scan
2012-08-07 16:06 UTC Ioannis Anagnostopoulos <ioannis@anatec.com>
` Re: Sequential scan instead of index scan
2012-08-07 17:42 UTC Jeff Janes <jeff.janes@gmail.com>
[10+ messages in thread]
slow query, different plans
2012-08-04 00:38 UTC Midge Brown <midgems@sbcglobal.net>
` Re: slow query, different plans
2012-08-04 01:30 UTC Greg Williamson <gwilliamson39@yahoo.com>
` Re: slow query, different plans
2012-08-04 06:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow query, different plans
2012-08-06 17:43 UTC Midge Brown <midgems@sbcglobal.net>
` Re: slow query, different plans
2012-08-06 18:36 UTC Midge Brown <midgems@sbcglobal.net>
[5+ messages in thread]
Linux memory zone reclaim
2012-07-18 01:52 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: Linux memory zone reclaim
2012-07-18 02:00 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Linux memory zone reclaim
2012-07-18 03:51 UTC Dave Crooke <dcrooke@gmail.com>
` Re: Linux memory zone reclaim
2012-07-18 05:38 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Linux memory zone reclaim
2012-07-24 18:36 UTC John Lister <john.lister@kickstone.com>
` Re: Linux memory zone reclaim
2012-07-24 18:41 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Linux memory zone reclaim
2012-07-24 20:12 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Linux memory zone reclaim
2012-07-24 21:00 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Linux memory zone reclaim
2012-07-24 21:23 UTC John Lister <john.lister@kickstone.com>
` Re: Linux memory zone reclaim
2012-07-24 21:37 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Linux memory zone reclaim
2012-07-24 21:57 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Linux memory zone reclaim
2012-07-24 22:05 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Linux memory zone reclaim
2012-07-27 00:25 UTC Bruce Momjian <bruce@momjian.us>
` Re: Linux memory zone reclaim
2012-07-30 16:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Linux memory zone reclaim
2012-07-30 17:09 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Linux memory zone reclaim
2012-07-30 17:26 UTC Bruce Momjian <bruce@momjian.us>
` Re: Linux memory zone reclaim
2012-08-03 22:30 UTC Josh Berkus <josh@agliodbs.com>
` Re: Linux memory zone reclaim
2012-08-03 23:02 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Linux memory zone reclaim
2012-08-03 23:15 UTC Josh Berkus <josh@agliodbs.com>
[19+ messages in thread]
Messed up time zones
2012-08-03 08:31 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Messed up time zones
2012-08-03 08:58 UTC JC de Villa <jc.devilla@gmail.com>
` Re: Messed up time zones
2012-08-03 09:18 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Messed up time zones
2012-08-03 09:48 UTC JC de Villa <jc.devilla@gmail.com>
` Re: Messed up time zones
2012-08-03 10:40 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Messed up time zones
2012-08-03 10:55 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Messed up time zones
2012-08-03 14:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Messed up time zones
2012-08-03 15:23 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Messed up time zones
2012-08-03 15:34 UTC Bill MacArthur <webmaster@dhs-club.com>
` Re: Messed up time zones
2012-08-03 16:06 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Messed up time zones
2012-08-03 16:20 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Messed up time zones
2012-08-03 16:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [ADMIN] Messed up time zones
2012-08-03 17:21 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Messed up time zones
2012-08-03 17:25 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: Messed up time zones
2012-08-03 18:25 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: [ADMIN] Messed up time zones
2012-08-03 18:25 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: [ADMIN] Messed up time zones
2012-08-03 18:37 UTC Laszlo Nagy <gandalf@shopzeus.com>
[17+ messages in thread]
query using incorrect index
2012-08-02 14:54 UTC Russell Keane <Russell.Keane@inps.co.uk>
` Re: query using incorrect index
2012-08-02 20:13 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: query using incorrect index
2012-08-03 09:18 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: query using incorrect index
2012-08-03 09:50 UTC Russell Keane <Russell.Keane@inps.co.uk>
` Re: query using incorrect index
2012-08-03 10:00 UTC Russell Keane <Russell.Keane@inps.co.uk>
` Re: query using incorrect index
2012-08-03 14:33 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: query using incorrect index
2012-08-03 15:57 UTC Russell Keane <Russell.Keane@inps.co.uk>
[7+ messages in thread]
Using ctid column changes plan drastically
2012-07-24 10:13 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Using ctid column changes plan drastically
2012-07-24 14:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Using ctid column changes plan drastically
2012-07-24 14:54 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Using ctid column changes plan drastically
2012-07-24 15:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Using ctid column changes plan drastically
2012-07-24 16:32 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Using ctid column changes plan drastically
2012-07-24 17:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Using ctid column changes plan drastically
2012-07-25 08:10 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Using ctid column changes plan drastically
2012-08-01 16:42 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[8+ messages in thread]
ZFS vs. UFS
2012-07-24 12:51 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: ZFS vs. UFS
2012-07-24 13:03 UTC Georgi Naplatanov <gosho@oles.biz>
` Re: ZFS vs. UFS
2012-07-24 13:18 UTC Ivan Voras <ivoras@freebsd.org>
` Re: ZFS vs. UFS
2012-07-24 14:23 UTC Torsten Zuehlsdorff <foo@meisterderspiele.de>
` Re: ZFS vs. UFS
2012-07-24 14:34 UTC Craig James <cjames@emolecules.com>
` Re: ZFS vs. UFS
2012-07-24 18:27 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: ZFS vs. UFS
2012-07-24 18:35 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: ZFS vs. UFS
2012-07-24 19:14 UTC Craig James <cjames@emolecules.com>
` Re: ZFS vs. UFS
2012-07-25 07:00 UTC Torsten Zuehlsdorff <foo@meisterderspiele.de>
` Re: ZFS vs. UFS
2012-07-27 05:24 UTC Greg Smith <greg@2ndQuadrant.com>
` Re: ZFS vs. UFS
2012-07-31 08:50 UTC Laszlo Nagy <gandalf@shopzeus.com>
` Re: ZFS vs. UFS
2012-07-31 14:33 UTC Craig James <cjames@emolecules.com>
[12+ messages in thread]
Index slow down insertions...
2012-07-15 01:14 UTC Ioannis Anagnostopoulos <ioannis@anatec.com>
` Re: Index slow down insertions...
2012-07-16 10:24 UTC Ioannis Anagnostopoulos <ioannis@anatec.com>
` Re: Index slow down insertions...
2012-07-19 12:24 UTC Ioannis Anagnostopoulos <ioannis@anatec.com>
` Re: Index slow down insertions...
2012-07-30 22:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[4+ messages in thread]
pgstat wait timeout
2012-07-27 22:03 UTC Anibal David Acosta <aa@devshock.com>
` Re: pgstat wait timeout
2012-07-27 22:31 UTC Anibal David Acosta <aa@devshock.com>
[2+ 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