pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDistant mirroring
2008-08-09 17:29 UTC dforum <dforums@vieonet.com>
` Re: Distant mirroring
2008-08-09 19:29 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Distant mirroring
2008-08-11 14:26 UTC dforums <dforums@vieonet.com>
` Re: Distant mirroring
2008-08-11 15:35 UTC Fernando Hevia <fhevia@ip-tel.com.ar>
` Re: Distant mirroring
2008-08-11 16:00 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Distant mirroring
2008-08-12 15:06 UTC dforums <dforums@vieonet.com>
[6+ messages in thread]
(no subject)
2008-08-11 14:44 UTC Sven Clement <sven@dsign.lu>
答复: [PERFORM] Using PK value as a String
2008-08-11 10:05 UTC jay <jackem.mojx@alibaba-inc.com>
why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
2008-08-09 20:34 UTC Miernik <public@public.miernik.name>
` Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
2008-08-09 20:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
2008-08-09 21:19 UTC Miernik <public@public.miernik.name>
` Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
2008-08-09 21:36 UTC Miernik <public@public.miernik.name>
` Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
2008-08-09 21:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
2008-08-09 21:56 UTC Miernik <public@public.miernik.name>
` Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
2008-08-09 22:32 UTC Miernik <public@public.miernik.name>
` Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
2008-08-10 02:20 UTC Miernik <public@public.miernik.name>
` Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
2008-08-10 03:25 UTC Scott Carey <scott@richrelevance.com>
[9+ messages in thread]
index scan cost
2008-07-17 21:21 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: index scan cost
2008-07-17 22:58 UTC Dennis Brakhane <brakhane@googlemail.com>
` Re: index scan cost
2008-07-17 23:12 UTC Jeff Frost <jeff@frostconsultingllc.com>
` Re: index scan cost
2008-07-18 04:37 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: index scan cost
2008-08-09 06:17 UTC Jeff Frost <jeff@frostconsultingllc.com>
[5+ messages in thread]
Filesystem setup on new system
2008-08-07 08:46 UTC Henrik <henke@mac.se>
` Re: Filesystem setup on new system
2008-08-08 22:42 UTC Greg Smith <gsmith@gregsmith.com>
[2+ messages in thread]
query planner not using the correct index
2008-08-06 21:35 UTC Joshua Shanks <jjshanks@gmail.com>
` Re: query planner not using the correct index
2008-08-07 02:47 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: query planner not using the correct index
2008-08-07 03:14 UTC Joshua Shanks <jjshanks@gmail.com>
` Re: query planner not using the correct index
2008-08-07 03:24 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: query planner not using the correct index
2008-08-07 15:11 UTC Joshua Shanks <jjshanks@gmail.com>
` Re: query planner not using the correct index
2008-08-07 21:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query planner not using the correct index
2008-08-07 22:01 UTC Joshua Shanks <jjshanks@gmail.com>
` Re: query planner not using the correct index
2008-08-07 22:38 UTC Gregory Stark <stark@enterprisedb.com>
` Re: query planner not using the correct index
2008-08-07 23:04 UTC Joshua Shanks <jjshanks@gmail.com>
` Re: query planner not using the correct index
2008-08-07 23:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query planner not using the correct index
2008-08-07 23:55 UTC Joshua Shanks <jjshanks@gmail.com>
` Re: query planner not using the correct index
2008-08-08 00:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: query planner not using the correct index
2008-08-08 14:28 UTC Joshua Shanks <jjshanks@gmail.com>
[13+ messages in thread]
Restoration of datas
2008-08-08 07:25 UTC dforums <dforums@vieonet.com>
` Re: Restoration of datas
2008-08-08 07:56 UTC Richard Huxton <dev@archonet.com>
[2+ messages in thread]
Query Plan choice with timestamps
2008-08-07 07:50 UTC Giorgio Valoti <giorgio_v@mac.com>
` Re: Query Plan choice with timestamps
2008-08-07 08:35 UTC Richard Huxton <dev@archonet.com>
` Re: Query Plan choice with timestamps
2008-08-07 12:30 UTC Giorgio Valoti <giorgio_v@mac.com>
` Re: Query Plan choice with timestamps
2008-08-07 12:36 UTC Richard Huxton <dev@archonet.com>
` Re: Query Plan choice with timestamps
2008-08-07 15:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Plan choice with timestamps
2008-08-07 18:37 UTC Giorgio Valoti <giorgio_v@mac.com>
` Re: Query Plan choice with timestamps
2008-08-07 18:42 UTC Giorgio Valoti <giorgio_v@mac.com>
` Re: Query Plan choice with timestamps
2008-08-07 19:29 UTC Giorgio Valoti <giorgio_v@mac.com>
` Re: Query Plan choice with timestamps
2008-08-07 21:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query Plan choice with timestamps
2008-08-08 05:38 UTC Giorgio Valoti <giorgio_v@mac.com>
[10+ messages in thread]
Plz Heeeelp! performance settings
2008-08-06 22:12 UTC dforum <dforums@vieonet.com>
` Re: Plz Heeeelp! performance settings
2008-08-07 02:16 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Plz Heeeelp! performance settings
2008-08-07 07:35 UTC dforum <dforums@vieonet.com>
` Re: Plz Heeeelp! performance settings
2008-08-07 08:33 UTC Richard Huxton <dev@archonet.com>
` Re: Plz Heeeelp! performance settings
2008-08-07 09:12 UTC dforums <dforums@vieonet.com>
` Re: Plz Heeeelp! performance settings
2008-08-07 10:40 UTC Richard Huxton <dev@archonet.com>
` Re: Plz Heeeelp! performance settings
2008-08-07 13:30 UTC dforums <dforums@vieonet.com>
` Re: Plz Heeeelp! performance settings
2008-08-07 14:12 UTC Richard Huxton <dev@archonet.com>
` Re: Plz Heeeelp! performance settings
2008-08-07 15:05 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Plz Heeeelp! performance settings
2008-08-07 15:08 UTC Richard Huxton <dev@archonet.com>
[10+ messages in thread]
Unexpectedly Long DELETE Wait
2008-08-07 06:09 UTC Volkan YAZICI <yazicivo@ttmail.com>
` Re: Unexpectedly Long DELETE Wait
2008-08-07 07:58 UTC Richard Huxton <dev@archonet.com>
` Re: Unexpectedly Long DELETE Wait
2008-08-07 14:36 UTC Volkan YAZICI <yazicivo@ttmail.com>
[3+ messages in thread]
Another index related question....
2008-08-07 14:30 UTC ries van Twisk <pg@rvt.dds.nl>
pg_dump error - out of memory, Failed on request of size 536870912
2008-08-06 09:48 UTC Marcin Citowicki <marcin.citowicki@m4n.nl>
` Re: pg_dump error - out of memory, Failed on request of size 536870912
2008-08-06 10:26 UTC Marcin Citowicki <marcin.citowicki@m4n.nl>
` Re: pg_dump error - out of memory, Failed on request of size 536870912
2008-08-06 12:21 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: pg_dump error - out of memory, Failed on request of size 536870912
2008-08-06 12:33 UTC Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
[4+ messages in thread]
Posible planner improvement?
2008-05-21 10:28 UTC Albert Cervera Areny <albert@sedifa.com>
` Re: Posible planner improvement?
2008-05-21 10:48 UTC Richard Huxton <dev@archonet.com>
` Re: Posible planner improvement?
2008-05-21 11:11 UTC Albert Cervera Areny <albert@sedifa.com>
` Re: Posible planner improvement?
2008-05-21 11:24 UTC Mark Mielke <mark@mark.mielke.cc>
` Re: Posible planner improvement?
2008-05-21 11:30 UTC Albert Cervera Areny <albert@sedifa.com>
` Re: Posible planner improvement?
2008-05-21 11:37 UTC Albert Cervera Areny <albert@sedifa.com>
` Re: Posible planner improvement?
2008-05-21 11:52 UTC Luke Lonergan <LLonergan@greenplum.com>
` Re: Posible planner improvement?
2008-05-21 13:09 UTC Richard Huxton <dev@archonet.com>
` Re: Posible planner improvement?
2008-05-21 16:18 UTC PFC <lists@peufeu.com>
` Re: Posible planner improvement?
2008-05-21 16:22 UTC Albert Cervera Areny <albert@sedifa.com>
` Re: Posible planner improvement?
2008-05-24 18:49 UTC Decibel! <decibel@decibel.org>
` Re: [PERFORM] Posible planner improvement?
2008-05-25 08:21 UTC Stephen R. van den Berg <srb@cuci.nl>
` Re: Posible planner improvement?
2008-05-26 11:30 UTC ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
` Re: Posible planner improvement?
2008-08-04 18:16 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
[14+ messages in thread]
SSD Performance Article
2008-07-31 17:45 UTC Matthew T. O'Connor <matthew@zeut.net>
` Re: SSD Performance Article
2008-08-01 01:27 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: SSD Performance Article
2008-08-04 11:20 UTC H. Hall <hhall1001@reedyriver.com>
[3+ messages in thread]
Database size Vs performance degradation
2008-07-30 12:09 UTC Dave North <DNorth@signiant.com>
` Re: Database size Vs performance degradation
2008-07-30 12:28 UTC Richard Huxton <dev@archonet.com>
` Re: Database size Vs performance degradation
2008-07-30 12:36 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Database size Vs performance degradation
2008-07-30 12:41 UTC Dave North <DNorth@signiant.com>
` Re: Database size Vs performance degradation
2008-07-30 12:43 UTC Dave North <DNorth@signiant.com>
` Re: Database size Vs performance degradation
2008-07-30 14:57 UTC Valentin Bogdanov <valiouk@yahoo.co.uk>
` Re: Database size Vs performance degradation
2008-07-30 15:02 UTC Dave North <DNorth@signiant.com>
` Re: Database size Vs performance degradation
2008-07-30 15:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Database size Vs performance degradation
2008-07-30 15:32 UTC Craig James <craig_james@emolecules.com>
` Re: Database size Vs performance degradation
2008-07-30 15:46 UTC Mark Roberts <mailing_lists@pandapocket.com>
` Re: Database size Vs performance degradation
2008-07-30 16:16 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Database size Vs performance degradation
2008-07-30 16:48 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Database size Vs performance degradation
2008-07-30 16:49 UTC Mark Roberts <mailing_lists@pandapocket.com>
` Re: Database size Vs performance degradation
2008-07-30 17:18 UTC Richard Huxton <dev@archonet.com>
` Re: Database size Vs performance degradation
2008-07-30 17:39 UTC Dave North <DNorth@signiant.com>
` Re: Database size Vs performance degradation
2008-07-30 17:51 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: Database size Vs performance degradation
2008-07-30 17:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Database size Vs performance degradation
2008-07-30 18:04 UTC Mark Roberts <mailing_lists@pandapocket.com>
` Re: Database size Vs performance degradation
2008-07-30 21:58 UTC Miernik <public@public.miernik.name>
` Re: Database size Vs performance degradation
2008-07-30 22:14 UTC Mark Roberts <mailing_lists@pandapocket.com>
` Re: Database size Vs performance degradation
2008-07-31 17:49 UTC Andrzej Zawadzki <zawadaa@wp.pl>
` Re: Database size Vs performance degradation
2008-08-01 11:03 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Database size Vs performance degradation
2008-08-03 23:51 UTC Fernando Ike <fike@midstorm.org>
[23+ messages in thread]
Nls sorting in Postgresql-8.3.3
2008-08-01 08:35 UTC Praveen <praveen.k@renaissance-it.com>
` Re: [PERFORM] Nls sorting in Postgresql-8.3.3
2008-08-01 08:43 UTC Richard Huxton <dev@archonet.com>
` Re: Nls sorting in Postgresql-8.3.3
2008-08-02 10:39 UTC Mathias Stjernström <mathias@globalinn.com>
[3+ messages in thread]
how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-23 15:21 UTC Miernik <public@public.miernik.name>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-23 17:25 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-23 19:30 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-23 20:32 UTC Miernik <public@public.miernik.name>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-23 20:43 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-23 23:04 UTC Miernik <public@public.miernik.name>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-24 07:38 UTC Albert Cervera Areny <albert@sedifa.com>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-24 08:44 UTC Richard Huxton <dev@archonet.com>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-31 06:15 UTC Miernik <public@public.miernik.name>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-31 07:36 UTC Richard Huxton <dev@archonet.com>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-31 08:29 UTC Miernik <public@public.miernik.name>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-31 08:46 UTC Theo Kramer <theo@flame.co.za>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-31 09:17 UTC Miernik <public@public.miernik.name>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-31 09:24 UTC Richard Huxton <dev@archonet.com>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-31 09:45 UTC Richard Huxton <dev@archonet.com>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-31 09:52 UTC Theo Kramer <theo@flame.co.za>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-31 10:24 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: how to fix problem then when two queries run at the same time, it takes longer to complete then if run in sequence
2008-07-31 15:30 UTC Steve Crawford <scrawford@pinpointresearch.com>
[18+ messages in thread]
what is less resource-intensive, WHERE id IN or INNER JOIN?
2008-07-30 22:11 UTC Miernik <public@public.miernik.name>
` Re: what is less resource-intensive, WHERE id IN or INNER JOIN?
2008-07-31 06:47 UTC Scott Carey <scott@richrelevance.com>
[2+ messages in thread]
why "WHERE uid NOT IN" is so slow, and EXCEPT in the same situtation is fast?
2008-07-31 02:45 UTC Miernik <public@public.miernik.name>
` Re: why "WHERE uid NOT IN" is so slow, and EXCEPT in the same situtation is fast?
2008-07-31 03:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: why "WHERE uid NOT IN" is so slow, and EXCEPT in the same situtation is fast?
2008-07-31 03:18 UTC Miernik <public@public.miernik.name>
` Re: why "WHERE uid NOT IN" is so slow, and EXCEPT in the same situtation is fast?
2008-07-31 03:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Difference between "Explain analyze" and "\timing"
2008-07-31 00:19 UTC tarcizioab@c3sl.ufpr.br
` Re: Difference between "Explain analyze" and "\timing"
2008-07-31 00:59 UTC Bill Moran <wmoran@collaborativefusion.com>
` Re: Difference between "Explain analyze" and "\timing"
2008-07-31 01:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
how does pg handle concurrent queries and same queries
2008-07-28 06:43 UTC Faludi Gábor <gfaludi@fits.hu>
` Re: how does pg handle concurrent queries and same queries
2008-07-28 06:55 UTC Claus Guttesen <kometen@gmail.com>
` Re: how does pg handle concurrent queries and same queries
2008-07-28 07:53 UTC Faludi Gábor <gfaludi@fits.hu>
` Re: how does pg handle concurrent queries and same queries
2008-07-28 08:46 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: how does pg handle concurrent queries and same queries
2008-07-28 11:27 UTC Matthew Wakeling <matthew@flymine.org>
` Re: how does pg handle concurrent queries and same queries
2008-07-28 13:47 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: how does pg handle concurrent queries and same queries
2008-07-30 18:34 UTC Dennis Brakhane <brakhane@googlemail.com>
[7+ messages in thread]
A guide/tutorial to performance monitoring and tuning
2008-06-27 14:23 UTC Nikhil G. Daddikar <ngd@celoxis.com>
` Re: A guide/tutorial to performance monitoring and tuning
2008-06-27 15:37 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: A guide/tutorial to performance monitoring and tuning
2008-06-27 17:21 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: A guide/tutorial to performance monitoring and tuning
2008-06-29 18:59 UTC Greg Smith <gsmith@gregsmith.com>
` Re: A guide/tutorial to performance monitoring and tuning
2008-06-30 13:54 UTC Cédric Villemain <cedric.villemain@dalibo.com>
` Re: A guide/tutorial to performance monitoring and tuning
2008-07-21 21:27 UTC Francisco Reyes <lists@stringsutils.com>
` Re: A guide/tutorial to performance monitoring and tuning
2008-07-22 05:24 UTC Greg Smith <gsmith@gregsmith.com>
` Re: A guide/tutorial to performance monitoring and tuning
2008-07-28 20:17 UTC Mark Wong <markwkm@gmail.com>
[8+ messages in thread]
Using ENUM with huge NAMEDATALEN
2008-07-26 21:22 UTC David Andersen <david@andersen.gs>
` Re: Using ENUM with huge NAMEDATALEN
2008-07-26 21:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Using ENUM with huge NAMEDATALEN
2008-07-26 21:48 UTC David Andersen <david@andersen.gs>
` Re: Using ENUM with huge NAMEDATALEN
2008-07-27 00:13 UTC David Andersen <david@andersen.gs>
` Re: Using ENUM with huge NAMEDATALEN
2008-07-27 00:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[5+ messages in thread]
Partitioned Tables Foreign Key Constraints Problem
2008-07-24 10:15 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Partitioned Tables Foreign Key Constraints Problem
2008-07-25 22:31 UTC Josh Berkus <josh@agliodbs.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