pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedperformance tuning queries
2008-11-27 04:21 UTC Kevin Kempter <kevink@consistentstate.com>
` Re: performance tuning queries
2008-11-27 06:12 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: performance tuning queries
2008-11-27 08:38 UTC PFC <lists@peufeu.com>
` Re: performance tuning queries
2008-11-27 10:09 UTC Mario Weilguni <mweilguni@sime.com>
[4+ messages in thread]
Monitoring buffercache...
2008-11-24 18:43 UTC Kevin Kempter <kevin@consistentstate.com>
` Re: Monitoring buffercache...
2008-11-24 19:45 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: Monitoring buffercache...
2008-11-24 19:46 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Monitoring buffercache...
2008-11-24 19:52 UTC Brad Nicholson <bnichols@ca.afilias.info>
` Re: Monitoring buffercache...
2008-11-24 21:24 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Monitoring buffercache...
2008-11-25 04:34 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Monitoring buffercache...
2008-11-25 04:40 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Monitoring buffercache...
2008-11-25 04:54 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Monitoring buffercache...
2008-11-25 19:37 UTC Mark Kirkwood <markir@paradise.net.nz>
[9+ messages in thread]
limit clause produces wrong query plan
2008-11-23 20:52 UTC Andrus <kobruleht2@hot.ee>
` Re: limit clause produces wrong query plan
2008-11-24 17:26 UTC Andrus <kobruleht2@hot.ee>
` Re: limit clause produces wrong query plan
2008-11-24 19:23 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: limit clause produces wrong query plan
2008-11-24 20:04 UTC Andrus <kobruleht2@hot.ee>
` Re: limit clause produces wrong query plan
2008-11-24 22:19 UTC Chris <dmagick@gmail.com>
` Re: limit clause produces wrong query plan
2008-11-24 22:58 UTC PFC <lists@peufeu.com>
` Re: limit clause produces wrong query plan
2008-11-24 23:10 UTC Scott Carey <scott@richrelevance.com>
[7+ messages in thread]
Hash join on int takes 8..114 seconds
2008-11-19 20:29 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-19 23:28 UTC PFC <lists@peufeu.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-20 09:12 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-20 10:45 UTC Richard Huxton <dev@archonet.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-20 11:14 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-20 11:22 UTC Richard Huxton <dev@archonet.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-20 13:46 UTC PFC <lists@peufeu.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 13:49 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 15:12 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 16:15 UTC tv@fuzzy.cz
` Re: Hash join on int takes 8..114 seconds
2008-11-21 16:32 UTC Richard Huxton <dev@archonet.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 17:51 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 17:57 UTC PFC <lists@peufeu.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 18:31 UTC PFC <lists@peufeu.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 19:00 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 19:08 UTC PFC <lists@peufeu.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 19:10 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 19:13 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 19:16 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 19:45 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 19:48 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 20:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 20:08 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 20:20 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 20:48 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 21:22 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 21:51 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-21 23:01 UTC Scott Carey <scott@richrelevance.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-22 14:13 UTC PFC <lists@peufeu.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-22 17:58 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-22 23:24 UTC PFC <lists@peufeu.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-23 14:39 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-23 18:47 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hash join on int takes 8..114 seconds
2008-11-23 21:30 UTC Scott Carey <scott@richrelevance.com>
` Re: Hash join on int takes 8..114 seconds
2008-11-23 21:35 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-23 22:43 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-23 23:11 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hash join on int takes 8..114 seconds
2008-11-23 23:39 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hash join on int takes 8..114 seconds
2008-11-24 12:35 UTC Andrus <kobruleht2@hot.ee>
` Re: Hash join on int takes 8..114 seconds
2008-11-24 13:39 UTC tv@fuzzy.cz
` Re: Hash join on int takes 8..114 seconds
2008-11-24 21:16 UTC Andrus <kobruleht2@hot.ee>
[41+ messages in thread]
Perc 3 DC
2008-11-22 14:18 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Perc 3 DC
2008-11-22 16:16 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Perc 3 DC
2008-11-22 16:59 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Perc 3 DC
2008-11-22 18:27 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Perc 3 DC
2008-11-22 22:00 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Perc 3 DC
2008-11-24 13:23 UTC Steve Clark <sclark@netwolves.com>
` Re: Perc 3 DC
2008-11-24 14:49 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Perc 3 DC
2008-11-24 14:52 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Perc 3 DC
2008-11-24 15:06 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: Perc 3 DC
2008-11-24 15:18 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Perc 3 DC
2008-11-24 15:41 UTC Simon Waters <simonw@zynet.net>
` Re: Perc 3 DC
2008-11-24 16:24 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Perc 3 DC
2008-11-24 16:56 UTC PFC <lists@peufeu.com>
[13+ messages in thread]
seq scan over 3.3 million rows instead of single key index access
2008-11-22 19:33 UTC Andrus <kobruleht2@hot.ee>
` Re: seq scan over 3.3 million rows instead of single key index access
2008-11-22 23:03 UTC Gregory Stark <stark@enterprisedb.com>
` Re: seq scan over 3.3 million rows instead of single key index access
2008-11-22 23:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: seq scan over 3.3 million rows instead of single key index access
2008-11-23 04:20 UTC Andrus <kobruleht2@hot.ee>
` Re: seq scan over 3.3 million rows instead of single key index access
2008-11-23 08:10 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: seq scan over 3.3 million rows instead of single key index access
2008-11-23 08:13 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: seq scan over 3.3 million rows instead of single keyindex access
2008-11-23 11:43 UTC Andrus <kobruleht2@hot.ee>
` Re: seq scan over 3.3 million rows instead of single key index access
2008-11-23 12:20 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
[8+ messages in thread]
Performance and IN clauses
2008-11-18 15:53 UTC Kynn Jones <kynnjo@gmail.com>
` Re: Performance and IN clauses
2008-11-18 16:12 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Performance and IN clauses
2008-11-18 16:38 UTC tv@fuzzy.cz
` Re: Performance and IN clauses
2008-11-18 23:29 UTC Mark Roberts <mailing_lists@pandapocket.com>
` Re: Performance and IN clauses
2008-11-19 00:49 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Performance and IN clauses
2008-11-21 01:09 UTC Tomas Vondra <tv@fuzzy.cz>
[6+ messages in thread]
Very Urgent : Sequences Problem
2008-11-19 15:54 UTC Kranti™ K K Parisa <kranti.parisa@gmail.com>
` Re: [PERFORM] Very Urgent : Sequences Problem
2008-11-19 16:31 UTC Tino Wildenhain <tino@wildenhain.de>
` Re: [PERFORM] Very Urgent : Sequences Problem
2008-11-19 16:31 UTC Josh Berkus <josh@agliodbs.com>
` Re: [PERFORM] Very Urgent : Sequences Problem
2008-11-19 16:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: [PERFORM] Very Urgent : Sequences Problem
2008-11-19 16:53 UTC tv@fuzzy.cz
` Re: Very Urgent : Sequences Problem
2008-11-20 05:04 UTC Greg Smith <gsmith@gregsmith.com>
[6+ messages in thread]
PostgreSQL NOT IN performance
2008-11-19 11:51 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL NOT IN performance
2008-11-19 12:22 UTC DANIEL CRISTIAN CRUZ <daniel.cruz@sc.senai.br>
` Re: PostgreSQL NOT IN performance
2008-11-19 13:11 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: PostgreSQL NOT IN performance
2008-11-19 14:44 UTC Stephan Szabo <sszabo@megazone.bigpanda.com>
` Re: PostgreSQL NOT IN performance
2008-11-19 14:55 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL NOT IN performance
2008-11-19 15:12 UTC Віталій Тимчишин <tivv00@gmail.com>
[6+ messages in thread]
Bad performance on simple query
2008-11-17 15:53 UTC Dimi Paun <dimi@lattica.com>
` Re: Bad performance on simple query
2008-11-17 16:28 UTC Alan Hodgson <ahodgson@simkin.ca>
` Re: Bad performance on simple query
2008-11-17 16:53 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Bad performance on simple query
2008-11-17 17:07 UTC Dimi Paun <dimi@lattica.com>
` Re: Bad performance on simple query
2008-11-17 17:16 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Bad performance on simple query
2008-11-17 17:31 UTC Dimi Paun <dimi@lattica.com>
` Re: Bad performance on simple query
2008-11-17 17:40 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Bad performance on simple query
2008-11-17 17:45 UTC ries van Twisk <pg@rvt.dds.nl>
` Re: Bad performance on simple query
2008-11-17 18:14 UTC Dimi Paun <dimi@lattica.com>
` Re: Bad performance on simple query
2008-11-17 20:47 UTC Dave Page <dpage@pgadmin.org>
[10+ messages in thread]
Improve Seq scan performance
2008-11-10 06:50 UTC Lutischán Ferenc <lutischanf@gmail.com>
` Re: Improve Seq scan performance
2008-11-10 06:55 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Improve Seq scan performance
2008-11-10 07:37 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Improve Seq scan performance
2008-11-10 07:59 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Improve Seq scan performance
2008-11-10 08:18 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Improve Seq scan performance
2008-11-10 08:41 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Improve Seq scan performance
2008-11-10 16:19 UTC Lutischán Ferenc <lutischanf@gmail.com>
` Re: Improve Seq scan performance
2008-11-16 14:54 UTC PFC <lists@peufeu.com>
` Re: Improve Seq scan performance
2008-11-17 10:51 UTC PFC <lists@peufeu.com>
[9+ messages in thread]
PostgreSQL OR performance
2008-11-05 11:12 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-05 15:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL OR performance
2008-11-05 16:31 UTC Jeff Davis <pgsql@j-davis.com>
` Re: PostgreSQL OR performance
2008-11-06 10:46 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-06 12:26 UTC Helio Campos Mello de Andrade <helio.campos@gmail.com>
` Re: PostgreSQL OR performance
2008-11-06 16:33 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-06 16:44 UTC Richard Huxton <dev@archonet.com>
` Re: PostgreSQL OR performance
2008-11-06 16:44 UTC Helio Campos Mello de Andrade <helio.campos@gmail.com>
` Re: PostgreSQL OR performance
2008-11-06 17:37 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-07 09:14 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-07 10:07 UTC David Wilson <david.t.wilson@gmail.com>
` Re: PostgreSQL OR performance
2008-11-07 10:45 UTC Richard Huxton <dev@archonet.com>
` Re: PostgreSQL OR performance
2008-11-15 13:55 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-15 13:57 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: PostgreSQL OR performance
2008-11-15 17:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL OR performance
2008-11-17 09:52 UTC Віталій Тимчишин <tivv00@gmail.com>
[16+ messages in thread]
Performance Question
2008-11-12 16:27 UTC - - <themanatuf@yahoo.com>
` Re: Performance Question
2008-11-12 16:48 UTC J Sisson <sisson.j@gmail.com>
` Re: Performance Question
2008-11-12 16:56 UTC tv@fuzzy.cz
` Re: Performance Question
2008-11-12 17:16 UTC Fernando Hevia <fhevia@ip-tel.com.ar>
` Re: Performance Question
2008-11-12 20:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance Question
2008-11-13 02:26 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Performance Question
2008-11-13 08:55 UTC Dave Page <dpage@pgadmin.org>
` Re: Performance Question
2008-11-13 13:05 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Performance Question
2008-11-16 15:20 UTC PFC <lists@peufeu.com>
[9+ messages in thread]
slow full table update
2008-11-10 16:30 UTC firerox@centrum.cz
` Re: slow full table update
2008-11-10 16:41 UTC tv@fuzzy.cz
` Re: slow full table update
2008-11-12 16:25 UTC firerox@centrum.cz
` Re: slow full table update
2008-11-12 16:47 UTC tv@fuzzy.cz
` Re: slow full table update
2008-11-12 17:25 UTC firerox@centrum.cz
` Re: slow full table update
2008-11-12 17:45 UTC Richard Huxton <dev@archonet.com>
` Re: slow full table update
2008-11-12 17:58 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: slow full table update
2008-11-12 20:54 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: slow full table update
2008-11-12 20:55 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: slow full table update
2008-11-12 22:47 UTC firerox@centrum.cz
` Re: slow full table update
2008-11-12 22:58 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: slow full table update
2008-11-13 00:13 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: slow full table update
2008-11-13 00:20 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: slow full table update
2008-11-16 14:50 UTC PFC <lists@peufeu.com>
[14+ messages in thread]
Difference in query plan
2008-11-14 16:14 UTC Patrice Beliveau <pbeliveau@avior.ca>
` Re: Difference in query plan
2008-11-14 16:47 UTC Richard Huxton <dev@archonet.com>
` Re: Difference in query plan
2008-11-14 17:07 UTC Patrice Beliveau <pbeliveau@avior.ca>
` Re: Difference in query plan
2008-11-14 17:14 UTC Richard Huxton <dev@archonet.com>
[4+ messages in thread]
crosstab speed
2008-11-13 20:42 UTC Jeremiah Elliott <jeremiah0@gmail.com>
` Re: crosstab speed
2008-11-13 21:41 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: crosstab speed
2008-11-13 22:06 UTC Joe Conway <mail@joeconway.com>
[3+ messages in thread]
Slow SQL query (14-15 seconds)
2008-11-13 11:02 UTC Bruno Baguette <bruno.baguette@gmail.com>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 13:16 UTC Tomasz Myrta <jasiek@klaster.net>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 13:28 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 13:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 14:19 UTC Bruno Baguette <bruno.baguette@gmail.com>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 14:29 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 14:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 14:39 UTC Bruno Baguette <bruno.baguette@gmail.com>
` Re: Slow SQL query (14-15 seconds)
2008-11-13 15:22 UTC Bruno Baguette <bruno.baguette@gmail.com>
[9+ messages in thread]
Using index for IS NULL query
2008-11-11 19:55 UTC Andrus <kobruleht2@hot.ee>
` Re: Using index for IS NULL query
2008-11-11 20:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Using index for IS NULL query
2008-11-11 20:47 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Using index for IS NULL query
2008-11-11 20:50 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Using index for IS NULL query
2008-11-11 21:01 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Using index for IS NULL query
2008-11-11 23:00 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Using index for IS NULL query
2008-11-11 23:34 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Using index for IS NULL query
2008-11-12 13:29 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Using index for IS NULL query
2008-11-13 00:27 UTC Tomas Vondra <tv@fuzzy.cz>
[9+ messages in thread]
Disk usage question
2008-11-12 17:02 UTC Franck Routier <franck.routier@axege.com>
` Re: Disk usage question
2008-11-12 23:44 UTC Scott Marlowe <scott.marlowe@gmail.com>
[2+ messages in thread]
Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 17:02 UTC Andrus <kobruleht2@hot.ee>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 17:26 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 17:28 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 17:33 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 18:06 UTC Andrus <kobruleht2@hot.ee>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 19:26 UTC Vladimir Sitnikov <sitnikov.vladimir@gmail.com>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 19:39 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 19:44 UTC Andrus <kobruleht2@hot.ee>
` Re: Increasing select max(datecol) from bilkaib wheredatecol<=date'2008-11-01' and (cr='00' or db='00') speed
2008-11-12 19:57 UTC Andrus <kobruleht2@hot.ee>
[9+ messages in thread]
Re: Index usage with sub select or outer joins
2008-11-12 15:09 UTC Julien Theulier <julien@squidsolutions.com>
Index usage with sub select or inner joins
2008-11-12 13:22 UTC Julien Theulier <julien@squidsolutions.com>
` Re: Index usage with sub select or inner joins
2008-11-12 13:54 UTC Joshua Tolley <eggyknap@gmail.com>
[2+ messages in thread]
Re: Oddity with view (now with test case)
2008-11-10 18:36 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view (now with test case)
2008-11-10 19:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Oddity with view (now with test case)
2008-11-10 21:06 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view (now with test case)
2008-11-11 03:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Oddity with view (now with test case)
2008-11-11 18:08 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view (now with test case)
2008-11-11 19:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Oddity with view (now with test case)
2008-11-11 22:42 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view (now with test case)
2008-11-12 02:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
[8+ messages in thread]
Create and drop temp table in 8.3.4
2008-11-05 18:45 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-05 19:05 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-05 23:16 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-06 01:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Create and drop temp table in 8.3.4
2008-11-06 19:02 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-06 19:17 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Create and drop temp table in 8.3.4
2008-11-06 19:35 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-06 21:05 UTC Scott Carey <scott@richrelevance.com>
` Re: Create and drop temp table in 8.3.4
2008-11-06 21:49 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-06 22:05 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Create and drop temp table in 8.3.4
2008-11-06 22:33 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-06 22:45 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Create and drop temp table in 8.3.4
2008-11-06 23:04 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Create and drop temp table in 8.3.4
2008-11-07 00:03 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Create and drop temp table in 8.3.4
2008-11-07 02:21 UTC David Rees <drees76@gmail.com>
` Re: Create and drop temp table in 8.3.4
2008-11-11 14:52 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Create and drop temp table in 8.3.4
2008-11-11 15:07 UTC Aidan Van Dyk <aidan@highrise.ca>
[17+ messages in thread]
Oddity with view
2008-11-10 08:27 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view
2008-11-10 13:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Oddity with view
2008-11-10 18:16 UTC Jim 'Decibel!' Nasby <jnasby@cashnetusa.com>
` Re: Oddity with view
2008-11-10 18:21 UTC Richard Huxton <dev@archonet.com>
` Re: Oddity with view
2008-11-10 18:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
[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