Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-performance - February 2007
Prev | Next
2007-02-01
- Slow update Abu Mushayeed (00:57)
- Re: Very slow queries Chad Wagner (01:29)
- Re: Slow update Tomas Vondra (01:32)
- Using statement_timeout as a performance tool? Mark Stosberg (14:10)
- Subselect query enhancement Michael Artz (16:42)
- Re: Subselect query enhancement Richard Huxton (17:23)
- Re: Subselect query enhancement Ted Allen (17:28)
- Re: Subselect query enhancement Michael Artz (18:14)
- Re: Subselect query enhancement Frank Wiles (18:20)
- Re: Subselect query enhancement Michael Artz (18:27)
- Re: Subselect query enhancement Richard Huxton (19:02)
- Re: Subselect query enhancement Michael Artz (19:06)
- Re: int4 vs varchar to store ip addr Michael Artz (19:30)
- Re: Subselect query enhancement Andrew Lazarus (22:37)
2007-02-02
- drive configuration for a new server Ben (00:41)
- index scan through a subquery Bill Howe (01:44)
- Re: Subselect query enhancement Richard Huxton (09:51)
- trouble with a join on OS X Kirk Wythers (13:52)
- Re: trouble with a join on OS X Steinar H. Gunderson (14:41)
- Re: trouble with a join on OS X Richard Huxton (14:45)
- Re: trouble with a join on OS X Gábriel Ákos (14:50)
- Re: trouble with a join on OS X Tom Lane (15:46)
- Re: trouble with a join on OS X Kirk Wythers (15:59)
- Re: trouble with a join on OS X Kirk Wythers (16:05)
- Re: trouble with a join on OS X Steinar H. Gunderson (16:09)
- Re: trouble with a join on OS X Tom Lane (16:11)
- Re: trouble with a join on OS X Kirk Wythers (16:53)
- Re: trouble with a join on OS X Kirk Wythers (17:54)
- Re: trouble with a join on OS X Tom Lane (17:59)
- Re: trouble with a join on OS X Kirk Wythers (18:06)
- Re: drive configuration for a new server Jeff Frost (18:16)
- Re: drive configuration for a new server Ben (18:49)
- OT: Mac OS X disk buffer cache Kevin Murphy (19:26)
- Re: trouble with a join on OS X Tom Lane (22:18)
2007-02-03
- Re: trouble with a join on OS X Luke Lonergan (01:39)
- Re: trouble with a join on OS X Joshua D. Drake (01:48)
- Re: trouble with a join on OS X Luke Lonergan (01:53)
- Re: trouble with a join on OS X Kirk Wythers (02:01)
- Re: trouble with a join on OS X Kirk Wythers (02:03)
- Re: trouble with a join on OS X Joshua D. Drake (02:05)
- Re: trouble with a join on OS X Geoffrey (02:10)
- Re: trouble with a join on OS X Tom Lane (02:32)
- Re: trouble with a join on OS X Joshua D. Drake (02:32)
- Re: trouble with a join on OS X Kirk Wythers (03:19)
- Re: trouble with a join on OS X Joshua D. Drake (03:25)
- Re: trouble with a join on OS X Tom Lane (03:31)
- Re: trouble with a join on OS X Shane Ambler (15:59)
- optimizing a geo_distance() proximity query Mark Stosberg (19:00)
- Re: optimizing a geo_distance() proximity query Oleg Bartunov (19:11)
2007-02-04
- Re: optimizing a geo_distance() proximity query Bruno Wolff III (05:16)
2007-02-05
- Re: trouble with a join on OS X Kirk Wythers (04:29)
- Re: trouble with a join on OS X Shane Ambler (17:50)
- Re: optimizing a geo_distance() proximity query Mark Stosberg (19:47)
- Re: optimizing a geo_distance() proximity query Merlin Moncure (20:15)
- Re: optimizing a geo_distance() proximity query Bruno Wolff III (20:22)
- Re: optimizing a geo_distance() proximity query (example and benchmark) Mark Stosberg (23:01)
2007-02-06
- How long should it take to insert 200,000 records? Karen Hill (00:35)
- Re: How long should it take to insert 200,000 records? Tom Lane (05:33)
- Re: optimizing a geo_distance() proximity query (example and benchmark) Bruno Wolff III (05:40)
- Re: index scan through a subquery Tom Lane (06:52)
- Re: How long should it take to insert 200,000 records? Csaba Nagy (09:33)
- Re: Tuning Harald Armin Massa (10:21)
- Re: optimizing a geo_distance() proximity query (example and benchmark) Merlin Moncure (12:58)
- Re: explain analyze output for review (was: optimizing a geo_distance()...) Mark Stosberg (14:39)
- Re: explain analyze output for review (was: optimizing a geo_distance()...) Hiltibidal, Robert (14:50)
- Re: explain analyze output for review (was: optimizing a geo_distance()...) Adam Rich (14:53)
- Re: explain analyze output: vacuuming made a big difference. Mark Stosberg (14:54)
- Re: explain analyze output for review (was: optimizing a geo_distance()...) Hiltibidal, Robert (15:04)
- Re: explain analyze output for review (was: optimizing a geo_distance()...) Bruno Wolff III (15:45)
- Re: How long should it take to insert 200,000 records? Scott Marlowe (16:14)
- Re: How long should it take to insert 200,000 records? Merlin Moncure (16:40)
- Re: How long should it take to insert 200,000 records? Scott Marlowe (16:55)
- Re: How long should it take to insert 200,000 records? Merlin Moncure (17:01)
- Re: How long should it take to insert 200,000 records? Hiltibidal, Robert (17:04)
- Re: How long should it take to insert 200,000 records? Mark Lewis (18:31)
- Re: How long should it take to insert 200,000 records? Bruno Wolff III (18:37)
- Re: How long should it take to insert 200,000 records? Merlin Moncure (19:06)
- Re: How long should it take to insert 200,000 records? Mark Lewis (19:10)
- Re: index scan through a subquery Bill Howe (19:18)
- Re: How long should it take to insert 200,000 records? Karen Hill (21:39)
2007-02-07
- Re: How long should it take to insert 200,000 records? Mark Kirkwood (02:41)
- Re: How long should it take to insert 200,000 records? Tom Lane (03:07)
- Help Needed Muruganantham M (14:15)
- Re: Help Needed Richard Huxton (15:03)
- tip: faster sorting for proximity queries by using cube_distance() Mark Stosberg (21:30)
2007-02-08
- stats collector process high CPU utilization Benjamin Minshall (16:48)
- Re: Speed up this query Mark Stosberg (17:11)
- Re: stats collector process high CPU utilization Tom Lane (17:17)
- Disk saturation Carlos H. Reimer (17:19)
- Re: stats collector process high CPU utilization Benjamin Minshall (17:25)
- Re: stats collector process high CPU utilization Tom Lane (18:46)
- Re: stats collector process high CPU utilization Benjamin Minshall (21:16)
- Re: stats collector process high CPU utilization Tom Lane (21:24)
- Re: stats collector process high CPU utilization Benjamin Minshall (21:55)
- Re: stats collector process high CPU utilization Tom Lane (22:07)
- Re: stats collector process high CPU utilization Benjamin Minshall (22:29)
2007-02-09
- Re: stats collector process high CPU utilization Tom Lane (02:04)
- Re: stats collector process high CPU utilization minshall (04:13)
- Re: stats collector process high CPU utilization Tom Lane (04:26)
- Re: stats collector process high CPU utilization Alvaro Herrera (14:24)
- Re: stats collector process high CPU utilization Tom Lane (15:08)
- Re: stats collector process high CPU utilization Tom Lane (15:55)
- Re: stats collector process high CPU utilization Benjamin Minshall (16:27)
- Re: stats collector process high CPU utilization Tom Lane (16:33)
- Recreate big table Gábriel Ákos (18:24)
- Re: stats collector process high CPU utilization Benjamin Minshall (18:36)
- Re: Recreate big table Daniel Cristian Cruz (19:10)
- cube operations slower than geo_distance() on production server Mark Stosberg (19:26)
- Re: Can anyone make this code tighter? Too slow, Please help! Mark Stosberg (21:04)
2007-02-10
- Is there an equivalent for Oracle's user_tables.num_rows Virag Saksena (00:00)
- Re: Is there an equivalent for Oracle's user_tables.num_rows Tom Lane (00:45)
- Re: Is there an equivalent for Oracle'suser_tables.num_rows Simon Riggs (01:06)
- Re: Is there an equivalent for Oracle's user_tables.num_rows Virag Saksena (01:08)
- Re: cube operations slower than geo_distance() on production server Merlin Moncure (01:31)
2007-02-12
- Re: cube operations slower than geo_distance() on production server Mark Stosberg (16:11)
- Re: cube operations slower than geo_distance() on production server Merlin Moncure (19:03)
- Re: cube operations slower than geo_distance() on production server Merlin Moncure (19:05)
- Re: cube operations slower than geo_distance() on production server Mark Stosberg (19:48)
- limit + order by is slow if no rows in result set Brian Cox (21:36)
- Re: limit + order by is slow if no rows in result set Heikki Linnakangas (23:26)
2007-02-13
- Re: limit + order by is slow if no rows in result set Brian Cox (00:24)
- Re: limit + order by is slow if no rows in result set Tom Lane (03:36)
- many instances or many databases or many users? ismo.tuononen (08:55)
- Re: many instances or many databases or many users? Heikki Linnakangas (10:07)
- Re: cube operations slower than geo_distance() on production server Merlin Moncure (14:15)
- Re: cube operations slower than geo_distance() on production server Merlin Moncure (14:31)
- Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet (16:32)
- Re: Question about Bitmap Heap Scan/BitmapAnd Tom Lane (16:49)
- Proximity query with GIST and row estimation Guillaume Smet (17:09)
- Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet (17:17)
- Re: Question about Bitmap Heap Scan/BitmapAnd Tom Lane (17:51)
- CPU Usage Campbell, Lance (18:36)
- Re: CPU Usage Alan Hodgson (18:48)
- JOIN to a VIEW makes a real slow query Chuck D. (18:53)
- Re: JOIN to a VIEW makes a real slow query Merlin Moncure (19:16)
- quad or dual core Intel CPUs Kenji Morishige (19:46)
- Re: JOIN to a VIEW makes a real slow query Chuck D. (20:17)
- Re: cube operations slower than geo_distance() on production server Mark Stosberg (20:47)
- Re: JOIN to a VIEW makes a real slow query Tom Lane (20:51)
- Re: quad or dual core Intel CPUs Arjen van der Meijden (21:05)
- Re: quad or dual core Intel CPUs Mark Kirkwood (21:28)
- Re: quad or dual core Intel CPUs Dan Harris (22:21)
- Re: quad or dual core Intel CPUs Guillaume Smet (22:49)
- Re: quad or dual core Intel CPUs Heikki Linnakangas (22:52)
2007-02-14
- Re: Proximity query with GIST and row estimation Paul Ramsey (03:01)
- Re: [PERFORM] Direct I/O issues Bruce Momjian (05:01)
- Re: cube operations slower than geo_distance() on production server Tom Lane (07:15)
- An unwanted seqscan Brian Herlihy (08:40)
- Re: An unwanted seqscan Tom Lane (08:53)
- Re: quad or dual core Intel CPUs Claus Guttesen (09:19)
- Benchmarking PGSQL? Krishna Kumar (10:00)
- Re: Benchmarking PGSQL? Shoaib Mir (10:17)
- Re: cube operations slower than geo_distance() on production server Merlin Moncure (13:58)
- Re: Benchmarking PGSQL? Luke Lonergan (15:35)
- Re: Benchmarking PGSQL? Merlin Moncure (16:20)
- reindex vs 'analyze' (was: Re: cube operations slower than geo_distance() on production server) Mark Stosberg (16:28)
- Re: quad or dual core Intel CPUs Kenji Morishige (17:25)
- Re: reindex vs 'analyze' (was: Re: cube operations slower than geo_distance() on production server) Tom Lane (18:07)
- Re: Proximity query with GIST and row estimation Guillaume Smet (18:12)
- Re: Benchmarking PGSQL? Luke Lonergan (18:23)
- Re: quad or dual core Intel CPUs Claus Guttesen (18:43)
- Re: reindex vs 'analyze' Mark Stosberg (19:05)
- Re: JOIN to a VIEW makes a real slow query Chuck D. (19:12)
- Re: How long should it take to insert 200,000records? Lou O'Quin (22:24)
- Re: Benchmarking PGSQL? Josh Berkus (23:42)
2007-02-15
- Re: An unwanted seqscan Brian Herlihy (01:30)
- Problem with joining queries. Konstantinos Krikellas (12:58)
- Re: Benchmarking PGSQL? Merlin Moncure (13:39)
- Re: Problem with joining queries. Richard Huxton (14:01)
- Re: Problem with joining queries. Konstantinos Krikellas (14:28)
- Slow query with 'or' clause philippe (14:36)
- Re: Slow query with 'or' clause Richard Huxton (15:44)
- Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet (16:05)
- Re: Proximity query with GIST and row estimation Guillaume Smet (16:13)
- Re: Question about Bitmap Heap Scan/BitmapAnd Alvaro Herrera (16:27)
- Re: Question about Bitmap Heap Scan/BitmapAnd Tom Lane (16:34)
- strange issue for certain queries Mike Gargano (17:00)
- Re: Slow query with 'or' clause philippe (17:10)
- Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet (18:09)
2007-02-16
- Re: Question about Bitmap Heap Scan/BitmapAnd Guillaume Smet (00:32)
- Re: Benchmarking PGSQL? Krishna Kumar (06:09)
- Not Picking Index Gauri Kanekar (12:56)
- Re: Not Picking Index Michael Fuhr (14:28)
- Re: Not Picking Index Gauri Kanekar (14:31)
- Re: Not Picking Index Alvaro Herrera (14:46)
- Re: Not Picking Index Tom Lane (14:53)
- Fwd: Not Picking Index Mike Gargano (16:06)
- Re: Not Picking Index Brad Nicholson (18:27)
- Re: Proximity query with GIST and row estimation Guillaume Smet (18:31)
- Re: Not Picking Index Steinar H. Gunderson (18:32)
- Re: Not Picking Index George Pavlov (18:33)
- Re: reindex vs 'analyze' Mark Stosberg (19:25)
- Re: Not Picking Index Tom Lane (19:27)
2007-02-19
- How to debug performance problems Andreas Tille (10:50)
- Query Optimization Reinhard Vicinus (17:03)
- Re: How to debug performance problems Craig A. James (18:02)
- Re: How to debug performance problems Jeff Davis (18:18)
- Re: How to debug performance problems Scott Marlowe (18:24)
2007-02-20
- Re: Query Optimization Tom Lane (04:54)
- slow subselects Marko Niinimaki (07:10)