pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Re: Query Optimization with Kruskal’s Algorithm
2008-05-10 18:26 UTC Michael Glaesemann <grzm@seespotcode.net>
Re: Query Optimization with Kruskal’s Algorithm
2008-05-10 17:31 UTC Rauan Maemirov <rauan1987@gmail.com>
plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-06 08:21 UTC Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-06 09:53 UTC PFC <lists@peufeu.com>
` Re: plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-06 11:55 UTC Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-06 14:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-06 15:27 UTC Frank van Vugt <ftm.van.vugt@foxi.nl>
` Re: plan difference between set-returning function with ROWS within IN() and a plain join
2008-05-10 11:42 UTC Merlin Moncure <mmoncure@gmail.com>
[6+ messages in thread]
multiple joins + Order by + LIMIT query performance issue
2008-05-06 15:03 UTC Antoine Baudoux <ab@taktik.be>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 15:38 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 16:42 UTC Antoine Baudoux <ab@taktik.be>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 16:43 UTC Shaun Thomas <sthomas@leapfrogonline.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 17:24 UTC Antoine Baudoux <ab@taktik.be>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 17:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 18:04 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 18:06 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 18:14 UTC Shaun Thomas <sthomas@leapfrogonline.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-06 18:24 UTC Shaun Thomas <sthomas@leapfrogonline.com>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-07 07:23 UTC Antoine Baudoux <ab@taktik.be>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-07 10:42 UTC Matthew Wakeling <matthew@flymine.org>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-09 07:18 UTC Antoine Baudoux <ab@taktik.be>
` Re: multiple joins + Order by + LIMIT query performance issue
2008-05-09 07:53 UTC Scott Marlowe <scott.marlowe@gmail.com>
[14+ messages in thread]
Creating indexes
2008-05-08 19:00 UTC Rauan Maemirov <rauan1987@gmail.com>
` Re: Creating indexes
2008-05-08 19:49 UTC Asche <asche.public@mac.com>
` Re: Creating indexes
2008-05-08 19:52 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: Creating indexes
2008-05-08 20:08 UTC PFC <lists@peufeu.com>
` Re: Creating indexes
2008-05-09 05:41 UTC Rauan Maemirov <rauan1987@gmail.com>
[5+ messages in thread]
Creating a foreign key
2008-05-08 16:52 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Creating a foreign key
2008-05-08 17:00 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Creating a foreign key
2008-05-08 17:18 UTC Shaun Thomas <sthomas@leapfrogonline.com>
` Re: Creating a foreign key
2008-05-08 18:11 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Creating a foreign key
2008-05-08 20:02 UTC PFC <lists@peufeu.com>
[5+ messages in thread]
Ubuntu question
2008-05-08 06:52 UTC Q Master <theqmaster@gmail.com>
` Re: Ubuntu question
2008-05-08 07:01 UTC Martijn van Oosterhout <kleptog@svana.org>
` Re: [GENERAL] Ubuntu question
2008-05-08 07:47 UTC Justin <justin@emproshunts.com>
` Re: Ubuntu question
2008-05-08 07:48 UTC Justin <justin@emproshunts.com>
` Re: [GENERAL] Ubuntu question
2008-05-08 07:49 UTC Justin <justin@emproshunts.com>
[5+ messages in thread]
Re: Query Optimization with Kruskal’s Algorithm
2008-05-07 20:09 UTC Alexander Staubo <alex@purefiction.net>
Query Optimization with Kruskal’s Algorithm
2008-05-07 16:28 UTC Tarcizio Bini <tarcizioab@c3sl.ufpr.br>
Possible Redundancy/Performance Solution
2008-05-06 16:33 UTC Dennis Muhlestein <djmuhlestein@gmail.com>
` Re: Possible Redundancy/Performance Solution
2008-05-06 17:39 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Possible Redundancy/Performance Solution
2008-05-06 18:31 UTC Dennis Muhlestein <djmuhlestein@gmail.com>
` Re: Possible Redundancy/Performance Solution
2008-05-06 20:35 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Possible Redundancy/Performance Solution
2008-05-06 21:39 UTC Dennis Muhlestein <djmuhlestein@gmail.com>
` Re: Possible Redundancy/Performance Solution
2008-05-07 01:57 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Possible Redundancy/Performance Solution
2008-05-07 02:37 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Possible Redundancy/Performance Solution
2008-05-07 15:36 UTC Dennis Muhlestein <djmuhlestein@gmail.com>
[8+ messages in thread]
pgfouine - commit details?
2008-05-06 21:10 UTC Josh Cole <Josh.Cole@t8design.com>
` Re: pgfouine - commit details?
2008-05-07 00:31 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: pgfouine - commit details?
2008-05-07 05:29 UTC Josh Cole <Josh.Cole@t8design.com>
[3+ messages in thread]
Seqscan problem
2008-05-06 11:14 UTC Vlad Arkhipov <arhipov@dc.baikal.ru>
` Re: Seqscan problem
2008-05-06 14:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Seqscan problem
2008-05-07 00:48 UTC Vlad Arkhipov <arhipov@dc.baikal.ru>
[3+ messages in thread]
need to speed up query
2008-05-06 02:01 UTC Justin <justin@emproshunts.com>
` Re: need to speed up query
2008-05-06 03:27 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: need to speed up query
2008-05-06 04:08 UTC Gregory Williamson <Gregory.Williamson@digitalglobe.com>
` Re: need to speed up query
2008-05-06 05:36 UTC Justin <justin@emproshunts.com>
` Re: need to speed up query
2008-05-06 05:48 UTC Justin <justin@emproshunts.com>
` Re: need to speed up query
2008-05-06 07:02 UTC PFC <lists@peufeu.com>
` Re: need to speed up query
2008-05-06 13:22 UTC Justin <justin@emproshunts.com>
` Re: need to speed up query
2008-05-06 16:35 UTC PFC <lists@peufeu.com>
` Re: need to speed up query
2008-05-06 16:43 UTC Shaun Thomas <sthomas@leapfrogonline.com>
` Re: need to speed up query
2008-05-06 17:22 UTC Justin <justin@emproshunts.com>
` Re: need to speed up query
2008-05-06 17:41 UTC Justin <justin@emproshunts.com>
[11+ messages in thread]
What constitutes a complex query
2008-05-06 15:45 UTC Justin <justin@emproshunts.com>
` Re: What constitutes a complex query
2008-05-06 16:26 UTC Craig James <craig_james@emolecules.com>
` Re: What constitutes a complex query
2008-05-06 16:41 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: What constitutes a complex query
2008-05-06 16:56 UTC Steve Atkins <steve@blighty.com>
` Re: What constitutes a complex query
2008-05-06 16:58 UTC Richard Broersma <richard.broersma@gmail.com>
` Re: What constitutes a complex query
2008-05-06 17:23 UTC Justin <justin@emproshunts.com>
` Re: What constitutes a complex query
2008-05-06 17:37 UTC Scott Marlowe <scott.marlowe@gmail.com>
[7+ messages in thread]
Very slow INFORMATION_SCHEMA
2008-05-02 21:07 UTC Ernesto <equistango@gmail.com>
` Re: Very slow INFORMATION_SCHEMA
2008-05-02 22:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Very slow INFORMATION_SCHEMA
2008-05-05 11:30 UTC Mario Weilguni <mweilguni@sime.com>
` Re: Very slow INFORMATION_SCHEMA
2008-05-06 00:56 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Backup causing poor performance - suggestions
2008-05-05 14:59 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Backup causing poor performance - suggestions
2008-05-05 15:05 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Backup causing poor performance - suggestions
2008-05-05 15:10 UTC Campbell, Lance <lance@uiuc.edu>
` Re: Backup causing poor performance - suggestions
2008-05-05 15:54 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Backup causing poor performance - suggestions
2008-05-05 16:10 UTC Craig James <craig_james@emolecules.com>
` Re: Backup causing poor performance - suggestions
2008-05-05 17:05 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Backup causing poor performance - suggestions
2008-05-05 17:43 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Backup causing poor performance - suggestions
2008-05-05 19:44 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Backup causing poor performance - suggestions
2008-05-05 20:03 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Backup causing poor performance - suggestions
2008-05-05 20:11 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Backup causing poor performance - suggestions
2008-05-05 21:50 UTC Scott Marlowe <scott.marlowe@gmail.com>
[11+ messages in thread]
Re: pgPool query cache
2008-05-04 11:13 UTC Hannes Dorbath <light@theendofthetunnel.de>
Vacuum statistics
2008-04-29 12:14 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Vacuum statistics
2008-05-02 14:09 UTC chirag.dave@gmail.com
` Re: Vacuum statistics
2008-05-04 02:15 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Vacuum statistics
2008-05-04 04:43 UTC Mark Kirkwood <markir@paradise.net.nz>
[4+ messages in thread]
two memory-consuming postgres processes
2008-05-02 19:24 UTC Alexy Khrabrov <deliverable@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 19:30 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 19:38 UTC Alexy Khrabrov <deliverable@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 19:53 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 20:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: two memory-consuming postgres processes
2008-05-02 20:22 UTC Greg Smith <gsmith@gregsmith.com>
` Re: two memory-consuming postgres processes
2008-05-02 20:26 UTC Alexy Khrabrov <deliverable@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 20:28 UTC Alexy Khrabrov <deliverable@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 20:35 UTC Alexy Khrabrov <deliverable@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 20:40 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 20:51 UTC Alexy Khrabrov <deliverable@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 21:02 UTC Craig James <craig_james@emolecules.com>
` Re: two memory-consuming postgres processes
2008-05-02 21:09 UTC Alexy Khrabrov <deliverable@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 21:23 UTC Greg Smith <gsmith@gregsmith.com>
` Re: two memory-consuming postgres processes
2008-05-02 21:30 UTC Alexy Khrabrov <deliverable@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 21:30 UTC PFC <lists@peufeu.com>
` Re: two memory-consuming postgres processes
2008-05-02 21:43 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: two memory-consuming postgres processes
2008-05-02 22:03 UTC Alexy Khrabrov <deliverable@gmail.com>
` Re: two memory-consuming postgres processes
2008-05-02 22:29 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: two memory-consuming postgres processes
2008-05-03 09:25 UTC Matthew Wakeling <matthew@flymine.org>
` Re: two memory-consuming postgres processes
2008-05-03 15:07 UTC Merlin Moncure <mmoncure@gmail.com>
[21+ messages in thread]
Pros and Cons of 8.3.1
2008-05-02 07:31 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Pros and Cons of 8.3.1
2008-05-02 07:51 UTC Claus Guttesen <kometen@gmail.com>
` Re: Pros and Cons of 8.3.1
2008-05-02 16:30 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Pros and Cons of 8.3.1
2008-05-02 16:35 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Pros and Cons of 8.3.1
2008-05-02 16:46 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Pros and Cons of 8.3.1
2008-05-02 16:54 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Pros and Cons of 8.3.1
2008-05-02 17:11 UTC Justin <justin@emproshunts.com>
[7+ messages in thread]
Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL
2008-04-27 17:54 UTC Josh Berkus <josh@agliodbs.com>
` Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL
2008-04-28 09:17 UTC Gregory Stark <stark@enterprisedb.com>
` Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL
2008-04-28 10:59 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Benchmarks WAS: Sun Talks about MySQL
2008-04-28 16:07 UTC Josh Berkus <josh@agliodbs.com>
` Re: Benchmarks WAS: Sun Talks about MySQL
2008-04-28 18:40 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Benchmarks WAS: Sun Talks about MySQL
2008-04-28 20:55 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Benchmarks WAS: Sun Talks about MySQL
2008-05-01 14:21 UTC Jignesh K. Shah <J.K.Shah@Sun.COM>
[7+ messages in thread]
Postgres replication
2008-04-30 15:45 UTC Gernot Schwed <Gernot.Schwed@onvista-group.de>
` Re: Postgres replication
2008-04-30 20:47 UTC david@lang.hm
` Re: Postgres replication
2008-05-01 09:33 UTC Fujii Masao <masao.fujii@gmail.com>
[3+ messages in thread]
Understanding histograms
2008-04-30 04:56 UTC Len Shapiro <len@cs.pdx.edu>
` Re: Understanding histograms
2008-04-30 05:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Understanding histograms
2008-04-30 06:32 UTC Len Shapiro <lenshap@gmail.com>
` Re: Understanding histograms
2008-04-30 14:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Understanding histograms
2008-04-30 22:47 UTC Jeff Davis <pgsql@j-davis.com>
` Re: Understanding histograms
2008-04-30 23:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Understanding histograms
2008-05-01 00:53 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Understanding histograms
2008-05-01 04:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
[8+ messages in thread]
Replication Syatem
2008-04-28 13:38 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-28 13:58 UTC Peter Childs <peterachilds@gmail.com>
` Re: Replication Syatem
2008-04-28 14:05 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-28 14:13 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: Replication Syatem
2008-04-28 14:16 UTC salman <salmanb@quietcaresystems.com>
` Re: Replication Syatem
2008-04-28 14:17 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-28 14:18 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-28 16:22 UTC Andrew Sullivan <ajs@commandprompt.com>
` Re: Replication Syatem
2008-04-28 16:23 UTC Andrew Sullivan <ajs@commandprompt.com>
` Re: Replication Syatem
2008-04-28 17:39 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Replication Syatem
2008-04-28 20:58 UTC Radhika S <radhika.sambamurti@gmail.com>
` Re: Replication Syatem
2008-04-28 21:43 UTC Chris Browne <cbbrowne@acm.org>
` Re: Replication Syatem
2008-04-29 04:55 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-29 05:08 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Replication Syatem
2008-04-29 05:11 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-29 05:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Replication Syatem
2008-04-29 05:46 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-29 05:47 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Replication Syatem
2008-04-29 05:55 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Replication Syatem
2008-04-29 08:37 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Replication Syatem
2008-04-29 11:05 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-29 11:19 UTC Shane Ambler <pgsql@Sheeky.Biz>
` Re: Replication Syatem
2008-04-29 11:25 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Replication Syatem
2008-04-29 12:59 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-29 13:02 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Replication Syatem
2008-04-29 13:03 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Replication Syatem
2008-04-29 13:09 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Replication Syatem
2008-04-29 13:12 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-29 13:16 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Replication Syatem
2008-04-29 13:48 UTC Gregory Stark <stark@enterprisedb.com>
` Re: Replication Syatem
2008-04-29 14:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Replication Syatem
2008-04-29 14:48 UTC Chris Browne <cbbrowne@acm.org>
` Re: Replication Syatem
2008-04-29 15:00 UTC Vivek Khera <vivek@khera.org>
` Re: Replication Syatem
2008-04-29 16:48 UTC Shane Ambler <pgsql@Sheeky.Biz>
` Re: Replication Syatem
2008-04-30 05:29 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-30 05:37 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Replication Syatem
2008-04-30 05:39 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-30 06:43 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Replication Syatem
2008-04-30 06:49 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
` Re: Replication Syatem
2008-04-30 07:25 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Replication Syatem
2008-04-30 10:26 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Replication Syatem
2008-04-30 12:16 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Replication Syatem
2008-04-30 13:35 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: Replication Syatem
2008-04-30 13:36 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Replication Syatem
2008-04-30 14:46 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Replication Syatem
2008-04-30 15:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Replication Syatem
2008-04-30 16:15 UTC Pavan Deolasee <pavan.deolasee@gmail.com>
` Re: Replication Syatem
2008-04-30 16:47 UTC Gauri Kanekar <meetgaurikanekar@gmail.com>
[48+ messages in thread]
SSD database benchmarks
2008-04-29 18:55 UTC Greg Smith <gsmith@gregsmith.com>
` Re: SSD database benchmarks
2008-04-29 20:00 UTC Guido Neitzer <lists@event-s.net>
` Re: SSD database benchmarks
2008-04-29 23:26 UTC Greg Smith <gsmith@gregsmith.com>
` Re: SSD database benchmarks
2008-04-29 23:27 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ 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