pgsql-performance - February 2004

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 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

Feb. 2, 2004

Thread Author Time
Re: views? Richard Huxton 09:48
"Overlaping" indexes Rigmor Ukuhe 14:46
Re: "Overlaping" indexes Tomasz Myrta 15:05
MySQL+InnoDB vs. PostgreSQL test? Josh Berkus 17:21
Mainframe Linux + PostgreSQL Josh Berkus 18:06
Re: MySQL+InnoDB vs. PostgreSQL test? Adam Ruth 18:06
Re: "Overlaping" indexes scott.marlowe 18:30
Re: "Overlaping" indexes Tomasz Myrta 18:43
Re: "Overlaping" indexes scott.marlowe 18:58
Increasing number of PG connections. Kevin Barnard 19:14
Re: "Overlaping" indexes Rod Taylor 19:17
pg_stat_activity Orion Henry 19:27
Re: Increasing number of PG connections. Qing Zhao 19:39
Re: MySQL+InnoDB vs. PostgreSQL test? Robert Treat 20:14
inserting large number of rows was: Re: Increasing number of PG connections. scott.marlowe 20:49
Bulk Record upload (was Re: Increasing number of PG connections) Richard Huxton 20:52
Re: Increasing number of PG connections. scott.marlowe 20:58
Re: views? Loeke 21:26
Re: inserting large number of rows was: Re: Increasing Bill Moran 21:37
Re: Increasing number of PG connections. Kevin Barnard 23:10
Re: Increasing number of PG connections. scott.marlowe 23:45

Feb. 3, 2004

Thread Author Time
Re: MySQL+InnoDB vs. PostgreSQL test? Christopher Kings-Lynne 00:44
COPY from question Slavisa Garic 00:55
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? scott.marlowe 01:18
Re: MySQL+InnoDB vs. PostgreSQL test? Jan Wieck 01:47
Re: MySQL+InnoDB vs. PostgreSQL test? Adam Ruth 02:20
Re: MySQL+InnoDB vs. PostgreSQL test? Christopher Kings-Lynne 03:04
Re: MySQL+InnoDB vs. PostgreSQL test? Josh Berkus 03:41
Re: COPY from question Kris Jurka 04:01
Re: COPY from question Tom Lane 04:07
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Tom Lane 04:08
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Christopher Kings-Lynne 04:30
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Tom Lane 04:43
Re: MySQL+InnoDB vs. PostgreSQL test? Christopher Browne 04:54
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Christopher Kings-Lynne 04:55
Re: MySQL+InnoDB vs. PostgreSQL test? Josh Berkus 05:17
Re: MySQL+InnoDB vs. PostgreSQL test? Christopher Kings-Lynne 05:52
Re: inserting large number of rows was: Re: Increasing Erki Kaldjärv 07:03
PQexecParams and types Czuczy Gergely 07:25
Re: COPY from question Kevin Brown 10:57
cache whole data in RAM David Teran 12:54
Re: cache whole data in RAM Shridhar Daithankar 13:26
Re: cache whole data in RAM Bruno Wolff III 13:27
Re: cache whole data in RAM Chris Trawick 13:32
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Jeff 13:52
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Rigmor Ukuhe 14:02
Re: PQexecParams and types Tom Lane 14:53
Re: PQexecParams and types Czuczy Gergely 14:56
Re: COPY from question Tom Lane 15:10
Re: PQexecParams and types Tom Lane 15:27
Re: Increasing number of PG connections. Kevin Barnard 15:34
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Jeff 15:53
Re: MySQL+InnoDB vs. PostgreSQL test? Joshua D. Drake 16:19
Database conversion woes... Kevin Carpenter 16:42
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Tom Lane 16:46
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Jeff 16:55
Re: Database conversion woes... Jeff 17:00
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Tom Lane 17:03
Re: MySQL+InnoDB vs. PostgreSQL test? scott.marlowe 17:16
Re: Database conversion woes... scott.marlowe 17:30
Re: Database conversion woes... Josh Berkus 19:01
Re: Database conversion woes... Richard Huxton 19:29
Re: Database conversion woes... Christopher Browne 19:59
Compile Vs RPMs Anjan Dave 20:58
Re: Database conversion woes... Kevin Carpenter 22:27
Database conversion woes... Kevin 22:29
Re: Compile Vs RPMs Bill Moran 22:43
Re: Compile Vs RPMs Paul Thomas 23:01
Re: Database conversion woes... Richard Huxton 23:34
Re: Compile Vs RPMs Christopher Browne 23:43

Feb. 4, 2004

Thread Author Time
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Mike Nolan 13:36
Re: Compile Vs RPMs scott.marlowe 16:24
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Jan Wieck 21:54
Re: cache whole data in RAM William Yu 22:44
select is not using index? Mark Harrison 22:55
Re: select is not using index? Corey Edwards 23:22

Feb. 5, 2004

Thread Author Time
Re: COPY from question Slavisa Garic 00:42
7.3 vs 7.4 performance Orion Henry 05:16
Re: 7.3 vs 7.4 performance Josh Berkus 05:27
Re: 7.3 vs 7.4 performance Christopher Browne 05:32
Re: 7.3 vs 7.4 performance Chris Trawick 06:50
Re: 7.3 vs 7.4 performance Carlos Eduardo Smanioto 11:14
Index Performance Help Damien Dougan 12:13
Re: 7.3 vs 7.4 performance Christopher Browne 13:30
Re: 7.3 vs 7.4 performance Tom Lane 15:07
Re: Index Performance Help Richard Huxton 15:54
Re: Index Performance Help Damien Dougan 16:40
Re: select is not using index? Mark Harrison 17:31
Re: 7.3 vs 7.4 performance Orion Henry 18:04
Re: Index Performance Help Josh Berkus 18:28
Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Mark Harrison 23:09

Feb. 6, 2004

Thread Author Time
COPY with INDEXES question Slavisa Garic 00:46
Re: COPY with INDEXES question Slavisa Garic 02:52
Re: COPY with INDEXES question Christopher Kings-Lynne 02:54
Re: COPY with INDEXES question Rod Taylor 02:55
Seq scan on zero-parameters function Octavio Alvarez 07:19
Re: Seq scan on zero-parameters function Octavio Alvarez 08:43
Re: Seq scan on zero-parameters function Richard Huxton 08:50
Re: [PERFORM] Seq scan on zero-parameters function Tomasz Myrta 08:55
Increase performance of a UNION query that thakes 655.07 msec to be runned ? Bruno BAGUETTE 08:58
Re: 7.3 vs 7.4 performance Hannu Krosing 10:43
Re: 7.3 vs 7.4 performance Hannu Krosing 10:44
Re: Seq scan on zero-parameters function Tom Lane 14:55
Re: Increase performance of a UNION query that thakes 655.07 msec to be runned ? Tom Lane 15:28
Re: Increase performance of a UNION query that thakes Stephan Szabo 15:52
RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ? Bruno BAGUETTE 16:34
RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ? Bruno BAGUETTE 16:41
Re: 7.3 vs 7.4 performance markw 17:05
Re: RE : Increase performance of a UNION query that thakes Stephan Szabo 17:13
Re: [PERFORM] Seq scan on zero-parameters function Octavio Alvarez 17:24
Why is query selecting sequential? Karl Denninger 21:36
Re: Why is query selecting sequential? Josh Berkus 21:51
Re: Why is query selecting sequential? Karl Denninger 22:22
Re: Why is query selecting sequential? Josh Berkus 22:36

Feb. 7, 2004

Thread Author Time
Re: 7.3 vs 7.4 performance Orion Henry 01:02
Re: 7.3 vs 7.4 performance Orion Henry 01:03
Re: 7.3 vs 7.4 performance Orion Henry 01:49
Re: Why is query selecting sequential? Karl Denninger 01:53
Re: 7.3 vs 7.4 performance Josh Berkus 02:32
Re: Why is query selecting sequential? Tom Lane 06:51
Re: 7.3 vs 7.4 performance Tom Lane 07:28
Re: Why is query selecting sequential? Karl Denninger 16:10

Feb. 8, 2004

Thread Author Time
RE : RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ? Bruno BAGUETTE 00:26
Re: RE : RE : Increase performance of a UNION query that Stephan Szabo 05:36

Feb. 9, 2004

Thread Author Time
Re: Why is query selecting sequential? Josh Berkus 05:34

Feb. 11, 2004

Thread Author Time
select count(*) from anIntColumn where int_value = 0; is very slow David Teran 13:03
Re: select count(*) from anIntColumn where int_value = 0; Pavel Stehule 13:11
Re: select count(*) from anIntColumn where int_value = 0; is very slow Rigmor Ukuhe 13:12
Re: select count(*) from anIntColumn where int_value = 0; is very slow David Teran 13:32
Re: select count(*) from anIntColumn where int_value = 0; is very slow PC Drew 13:42
update performance stefan bogdan 14:08
Re: select count(*) from anIntColumn where int_value = 0; Christopher Browne 14:14
slow database alemon 14:23
Re: slow database Dennis Bjorklund 14:27
Re: slow database PC Drew 14:28
Re: slow database PC Drew 14:44
Re: slow database Rod Taylor 14:49
Re: slow database Chris Trawick 15:36
Re: slow database Chris Browne 15:39
Re: update performance Richard Huxton 15:53
Re: select count(*) from anIntColumn where int_value = 0; scott.marlowe 16:02
Re: update performance scott.marlowe 16:10
Re: slow database alemon 16:16
Re: slow database scott.marlowe 16:19
Re: update performance scott.marlowe 16:36
Re: slow database Tom Lane 17:00
Re: slow database alemon 17:15
Re: slow database scott.marlowe 17:48
Re: slow database Rod Taylor 17:55
Re: slow database alemon 18:18
Re: slow database scott.marlowe 18:41
coercing int to bigint for indexing purposes Mark Harrison 22:38
Re: coercing int to bigint for indexing purposes Tom Lane 23:24

Feb. 12, 2004

Thread Author Time
Re: slow database Mark Kirkwood 01:27
Re: select count(*) from anIntColumn where int_value = Christopher Kings-Lynne 02:01
Disappointing performance in db migrated from MS SQL Server Leon Out 18:29
Re: Disappointing performance in db migrated from MS SQL Server PC Drew 18:43
Re: Disappointing performance in db migrated from MS SQL Gavin M. Roy 19:03
Re: Disappointing performance in db migrated from MS SQL Server Bruce Momjian 19:05
Re: Disappointing performance in db migrated from MS SQL scott.marlowe 19:15
Re: Disappointing performance in db migrated from MS SQL Server Josh Berkus 20:26
Re: Disappointing performance in db migrated from MS SQL Server Chris Ruprecht 22:19

Feb. 13, 2004

Thread Author Time
optimization ideas for frequent, large(ish) updates in frequently accessed DB? Marinos J. Yannikos 00:58
Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB? Josh Berkus 06:28
Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB? Manfred Koizar 09:26
Re: Disappointing performance in db migrated from MS SQL Server Andrew Sullivan 12:38
Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB? Manfred Koizar 15:21
Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB? Manfred Koizar 16:47
Re: Disappointing performance in db migrated from MS SQL Server Leon Out 20:56
Lengthy pg_restore and high iowait? Leon Out 21:03
Re: Disappointing performance in db migrated from MS SQL matt 22:00
Re: Disappointing performance in db migrated from MS SQL Server Vivek Khera 22:01
Re: Disappointing performance in db migrated from MS SQL Server Vivek Khera 22:03

Feb. 14, 2004

Thread Author Time
slow GIST index creation Rajesh Kumar Mallah 03:39

Feb. 15, 2004

Thread Author Time
Re: optimization ideas for frequent, large(ish) updates Marinos J. Yannikos 02:02
Re: optimization ideas for frequent, large(ish) updates Christopher Kings-Lynne 04:51
Re: optimization ideas for frequent, large(ish) updates Jeff Trout 17:20

Feb. 16, 2004

Thread Author Time
Re: optimization ideas for frequent, large(ish) updates Marinos J. Yannikos 02:53
Re: optimization ideas for frequent, large(ish) updates Tom Lane 03:28
select max(id) from aTable is very slow David Teran 16:51
Re: select max(id) from aTable is very slow Nick Barr 17:56
Re: select max(id) from aTable is very slow Nick Barr 18:02
Re: select max(id) from aTable is very slow David Teran 18:15

Feb. 17, 2004

Thread Author Time
Slow response of PostgreSQL Saleem Burhani Baloch 06:24
Re: Slow response of PostgreSQL Christopher Kings-Lynne 06:59
Re: Slow response of PostgreSQL Stephan Szabo 07:42
Re: Slow response of PostgreSQL Tom Lane 07:45
Re: very large db performance question Eric Jain 10:36
Re: Slow response of PostgreSQL Saleem Burhani Baloch 10:39
Re: Slow response of PostgreSQL Shridhar Daithankar 11:00
UPDATE with subquery too slow Eric Jain 12:38
Re: UPDATE with subquery too slow Leeuw van der, Tim 12:49
Tables on multiple disk drives Konstantin Tokar 12:54
Re: Slow response of PostgreSQL Bill Moran 13:02
Re: Tables on multiple disk drives Richard Huxton 14:56
Re: Slow response of PostgreSQL Tom Lane 15:02
Re: Disappointing performance in db migrated from MS SQL scott.marlowe 15:17
long running query running too long Todd Fulton 17:06
Re: Slow response of PostgreSQL scott.marlowe 17:15
Re: Tables on multiple disk drives scott.marlowe 17:18

Browse Archives

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