pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: reindex vs 'analyze'
2007-02-14 19:05 UTC Mark Stosberg <mark@summersault.com>
` Re: reindex vs 'analyze'
2007-02-16 19:25 UTC Mark Stosberg <mark@summersault.com>
[2+ messages in thread]
Proximity query with GIST and row estimation
2007-02-13 17:09 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Proximity query with GIST and row estimation
2007-02-14 03:01 UTC Paul Ramsey <pramsey@refractions.net>
` Re: Proximity query with GIST and row estimation
2007-02-14 18:12 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Proximity query with GIST and row estimation
2007-02-15 16:13 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Proximity query with GIST and row estimation
2007-02-16 18:31 UTC Guillaume Smet <guillaume.smet@gmail.com>
[5+ messages in thread]
Benchmarking PGSQL?
2007-02-14 10:00 UTC Krishna Kumar <kumar.ramanathan@gmail.com>
` Re: Benchmarking PGSQL?
2007-02-14 10:17 UTC Shoaib Mir <shoaibmir@gmail.com>
` Re: Benchmarking PGSQL?
2007-02-14 15:35 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Benchmarking PGSQL?
2007-02-14 16:20 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Benchmarking PGSQL?
2007-02-14 18:23 UTC Luke Lonergan <llonergan@greenplum.com>
` Re: Benchmarking PGSQL?
2007-02-14 23:42 UTC Josh Berkus <josh@agliodbs.com>
` Re: Benchmarking PGSQL?
2007-02-15 13:39 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Benchmarking PGSQL?
2007-02-16 06:09 UTC Krishna Kumar <kumar.ramanathan@gmail.com>
[8+ messages in thread]
Question about Bitmap Heap Scan/BitmapAnd
2007-02-13 16:32 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-13 16:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-13 17:17 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-13 17:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-15 16:05 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-15 16:27 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-15 16:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-15 18:09 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Question about Bitmap Heap Scan/BitmapAnd
2007-02-16 00:32 UTC Guillaume Smet <guillaume.smet@gmail.com>
[9+ messages in thread]
Slow query with 'or' clause
2007-02-15 14:36 UTC philippe <philippe@camailia.com>
` Re: Slow query with 'or' clause
2007-02-15 15:44 UTC Richard Huxton <dev@archonet.com>
` Re: Slow query with 'or' clause
2007-02-15 17:10 UTC philippe <philippe@camailia.com>
[3+ messages in thread]
strange issue for certain queries
2007-02-15 17:00 UTC Mike Gargano <mrg@infoplusonline.com>
Problem with joining queries.
2007-02-15 12:58 UTC Konstantinos Krikellas <K.Krikellas@sms.ed.ac.uk>
` Re: Problem with joining queries.
2007-02-15 14:01 UTC Richard Huxton <dev@archonet.com>
` Re: Problem with joining queries.
2007-02-15 14:28 UTC Konstantinos Krikellas <K.Krikellas@sms.ed.ac.uk>
[3+ messages in thread]
An unwanted seqscan
2007-02-14 08:40 UTC Brian Herlihy <btherl@yahoo.com.au>
` Re: An unwanted seqscan
2007-02-14 08:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: An unwanted seqscan
2007-02-15 01:30 UTC Brian Herlihy <btherl@yahoo.com.au>
[3+ messages in thread]
How long should it take to insert 200,000 records?
2007-02-06 00:35 UTC Karen Hill <karen_hill22@yahoo.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 05:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How long should it take to insert 200,000 records?
2007-02-06 09:33 UTC Csaba Nagy <nagy@ecircle-ag.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 16:14 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 16:40 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 16:55 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 17:01 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 17:04 UTC Hiltibidal, Robert <Robert.Hiltibidal@argushealth.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 18:31 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 18:37 UTC Bruno Wolff III <bruno@wolff.to>
` Re: How long should it take to insert 200,000 records?
2007-02-06 19:06 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 19:10 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: How long should it take to insert 200,000 records?
2007-02-06 21:39 UTC Karen Hill <karen_hill22@yahoo.com>
` Re: How long should it take to insert 200,000 records?
2007-02-07 02:41 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: How long should it take to insert 200,000 records?
2007-02-07 03:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: How long should it take to insert 200,000 records?
2007-02-14 22:24 UTC Lou O'Quin <LOquin@talleyds.com>
[16+ messages in thread]
JOIN to a VIEW makes a real slow query
2007-02-13 18:53 UTC Chuck D. <pgsql-performance@nullmx.com>
` Re: JOIN to a VIEW makes a real slow query
2007-02-13 19:16 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: JOIN to a VIEW makes a real slow query
2007-02-13 20:17 UTC Chuck D. <pgsql-performance@nullmx.com>
` Re: JOIN to a VIEW makes a real slow query
2007-02-13 20:51 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: JOIN to a VIEW makes a real slow query
2007-02-14 19:12 UTC Chuck D. <pgsql-performance@nullmx.com>
[5+ messages in thread]
quad or dual core Intel CPUs
2007-02-13 19:46 UTC Kenji Morishige <kenjim@juniper.net>
` Re: quad or dual core Intel CPUs
2007-02-13 21:05 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: quad or dual core Intel CPUs
2007-02-13 21:28 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: quad or dual core Intel CPUs
2007-02-13 22:21 UTC Dan Harris <fbsd@drivefaster.net>
` Re: quad or dual core Intel CPUs
2007-02-13 22:49 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: quad or dual core Intel CPUs
2007-02-13 22:52 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: quad or dual core Intel CPUs
2007-02-14 09:19 UTC Claus Guttesen <kometen@gmail.com>
` Re: quad or dual core Intel CPUs
2007-02-14 17:25 UTC Kenji Morishige <kenjim@juniper.net>
` Re: quad or dual core Intel CPUs
2007-02-14 18:43 UTC Claus Guttesen <kometen@gmail.com>
[9+ messages in thread]
reindex vs 'analyze' (was: Re: cube operations slower than geo_distance() on production server)
2007-02-14 16:28 UTC Mark Stosberg <mark@summersault.com>
` Re: reindex vs 'analyze' (was: Re: cube operations slower than geo_distance() on production server)
2007-02-14 18:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
cube operations slower than geo_distance() on production server
2007-02-09 19:26 UTC Mark Stosberg <mark@summersault.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-10 01:31 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-12 16:11 UTC Mark Stosberg <mark@summersault.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-12 19:03 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-12 19:05 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-12 19:48 UTC Mark Stosberg <mark@summersault.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-13 14:15 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-13 14:31 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-13 20:47 UTC Mark Stosberg <mark@summersault.com>
` Re: cube operations slower than geo_distance() on production server
2007-02-14 07:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: cube operations slower than geo_distance() on production server
2007-02-14 13:58 UTC Merlin Moncure <mmoncure@gmail.com>
[11+ messages in thread]
Direct I/O issues
2006-11-23 06:30 UTC Greg Smith <gsmith@gregsmith.com>
` Re: [PERFORM] Direct I/O issues
2006-11-23 16:41 UTC Bruce Momjian <bruce@momjian.us>
` Re: Direct I/O issues
2006-11-23 16:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Direct I/O issues
2006-11-23 16:49 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] Direct I/O issues
2006-11-23 17:20 UTC Bruce Momjian <bruce@momjian.us>
` Re: Direct I/O issues
2006-11-23 18:09 UTC Greg Smith <gsmith@gregsmith.com>
` Re: Direct I/O issues
2006-11-24 04:06 UTC Bruce Momjian <bruce@momjian.us>
` Re: [PERFORM] Direct I/O issues
2006-11-24 18:58 UTC Bruce Momjian <bruce@momjian.us>
` Re: [PERFORM] Direct I/O issues
2006-11-24 19:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [HACKERS] [PERFORM] Direct I/O issues
2006-11-24 23:43 UTC Bruce Momjian <bruce@momjian.us>
` Re: [PERFORM] Direct I/O issues
2007-02-14 05:01 UTC Bruce Momjian <bruce@momjian.us>
[11+ messages in thread]
CPU Usage
2007-02-13 18:36 UTC Campbell, Lance <lance@uiuc.edu>
` Re: CPU Usage
2007-02-13 18:48 UTC Alan Hodgson <ahodgson@simkin.ca>
[2+ messages in thread]
many instances or many databases or many users?
2007-02-13 08:55 UTC ismo.tuononen@solenovo.fi
` Re: many instances or many databases or many users?
2007-02-13 10:07 UTC Heikki Linnakangas <heikki@enterprisedb.com>
[2+ messages in thread]
limit + order by is slow if no rows in result set
2007-02-12 21:36 UTC Brian Cox <brian.cox@ca.com>
` Re: limit + order by is slow if no rows in result set
2007-02-12 23:26 UTC Heikki Linnakangas <heikki@enterprisedb.com>
` Re: limit + order by is slow if no rows in result set
2007-02-13 00:24 UTC Brian Cox <brian.cox@ca.com>
` Re: limit + order by is slow if no rows in result set
2007-02-13 03:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Is there an equivalent for Oracle's user_tables.num_rows
2007-02-10 00:00 UTC Virag Saksena <virag@auptyma.com>
` Re: Is there an equivalent for Oracle's user_tables.num_rows
2007-02-10 00:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Is there an equivalent for Oracle's user_tables.num_rows
2007-02-10 01:08 UTC Virag Saksena <virag@auptyma.com>
[3+ messages in thread]
Re: Is there an equivalent for Oracle'suser_tables.num_rows
2007-02-10 01:06 UTC Simon Riggs <simon@2ndquadrant.com>
Re: Can anyone make this code tighter? Too slow, Please help!
2007-02-09 21:04 UTC Mark Stosberg <mark@summersault.com>
Recreate big table
2007-02-09 18:24 UTC Gábriel Ákos <akos.gabriel@i-logic.hu>
` Re: Recreate big table
2007-02-09 19:10 UTC Daniel Cristian Cruz <danielcristian@gmail.com>
[2+ messages in thread]
Disk saturation
2007-02-08 17:19 UTC Carlos H. Reimer <carlos.reimer@opendb.com.br>
Re: Speed up this query
2007-02-08 17:11 UTC Mark Stosberg <mark@summersault.com>
tip: faster sorting for proximity queries by using cube_distance()
2007-02-07 21:30 UTC Mark Stosberg <mark@summersault.com>
Help Needed
2007-02-07 14:15 UTC Muruganantham M <msgtoanand@gmail.com>
` Re: Help Needed
2007-02-07 15:03 UTC Richard Huxton <dev@archonet.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