pgsql-performance - February 2007

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 12 13 14 15 16 19 20 21 22 23 24 25 26 27 28

Feb. 1, 2007

Thread Author Time
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

Feb. 2, 2007

Thread Author Time
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

Feb. 3, 2007

Thread Author Time
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

Feb. 4, 2007

Thread Author Time
Re: optimizing a geo_distance() proximity query Bruno Wolff III 05:16

Feb. 5, 2007

Thread Author Time
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

Feb. 6, 2007

Thread Author Time
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

Feb. 7, 2007

Thread Author Time
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

Feb. 8, 2007

Thread Author Time
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

Feb. 9, 2007

Thread Author Time
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

Feb. 10, 2007

Thread Author Time
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

Feb. 12, 2007

Thread Author Time
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

Feb. 13, 2007

Thread Author Time
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

Feb. 14, 2007

Thread Author Time
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,000 records? Lou O'Quin 22:24
Re: Benchmarking PGSQL? Josh Berkus 23:42

Feb. 15, 2007

Thread Author Time
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

Feb. 16, 2007

Thread Author Time
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

Feb. 19, 2007

Thread Author Time
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

Feb. 20, 2007

Thread Author Time
Re: Query Optimization Tom Lane 04:54
slow subselects Marko Niinimaki 07:10

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 12 13 14 15 16 19 20 21 22 23 24 25 26 27 28