Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - January 2004

Prev | Next

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

2004-01-01

pg_restore makes disk busy cnliou (17:14)

2004-01-02

Very slow update + not using clustered index Mike Glover (03:34)
Re: Very slow update + not using clustered index Tom Lane (04:06)
Re: deferred foreign keys Christopher Kings-Lynne (04:57)
Re: Very slow update + not using clustered index Mike Glover (06:16)
Why memory is not used ? Why vacuum so slow ? Hervé Piedvache (09:42)
Tuning Techniques To Avoid? Christopher Browne (12:33)
Re: Why memory is not used ? Why vacuum so slow ? Tom Lane (14:42)
Re: Why memory is not used ? Why vacuum so slow ? Hervé Piedvache (15:18)
Re: Very slow update + not using clustered index Tom Lane (15:45)
Re: Why memory is not used ? Why vacuum so slow ? Tom Lane (15:51)

2004-01-03

Re: Tuning Techniques To Avoid? Greg Stark (02:18)
"fun with multipart primary keys" hobby kit Chris Trawick (05:37)
Re: "fun with multipart primary keys" hobby kit Tom Lane (05:57)
Re: "fun with multipart primary keys" hobby kit Chris Trawick (06:07)

2004-01-04

Indexing a Boolean or Null column? D. Dante Lorenso (01:18)
Re: Indexing a Boolean or Null column? Tom Lane (04:26)
Re: Indexing a Boolean or Null column? Christopher Kings-Lynne (04:32)
Re: Indexing a Boolean or Null column? D. Dante Lorenso (05:24)
Re: Indexing a Boolean or Null column? Christopher Kings-Lynne (07:21)
Re: Indexing a Boolean or Null column? Christopher Kings-Lynne (07:22)
Re: Indexing a Boolean or Null column? Tom Lane (07:48)
Re: Indexing a Boolean or Null column? Christopher Browne (21:39)
Use my (date) index, darn it! John Siracusa (23:36)

2004-01-05

Re: Use my (date) index, darn it! Tom Lane (06:55)
optimizing Postgres queries David Teran (11:28)
Re: optimizing Postgres queries Shridhar Daithankar (11:35)
Re: optimizing Postgres queries David Teran (12:05)
Re: optimizing Postgres queries Shridhar Daithankar (12:10)
Re: optimizing Postgres queries David Teran (12:18)
Re: optimizing Postgres queries Shridhar Daithankar (12:37)
Re: optimizing Postgres queries Christopher Kings-Lynne (15:15)
Re: optimizing Postgres queries Tom Lane (15:22)
Re: Use my (date) index, darn it! John Siracusa (16:19)
Re: Use my (date) index, darn it! Tom Lane (16:29)
Re: deferred foreign keys Vivek Khera (16:33)
Re: Use my (date) index, darn it! Christopher Browne (16:45)
Re: Use my (date) index, darn it! John Siracusa (18:15)
Re: deferred foreign keys Bruno Wolff III (18:38)
Re: optimizing Postgres queries David Teran (18:47)
Re: optimizing Postgres queries Tom Lane (18:52)
Re: deferred foreign keys Stephan Szabo (18:57)
Re: deferred foreign keys Vivek Khera (18:57)
Re: deferred foreign keys Vivek Khera (19:02)
Re: optimizing Postgres queries David Teran (19:02)
Select max(foo) and select count(*) optimization John Siracusa (19:03)
Re: optimizing Postgres queries Tom Lane (19:05)
Re: optimizing Postgres queries David Teran (19:20)
Re: optimizing Postgres queries Tom Lane (19:23)
Re: deferred foreign keys Stephan Szabo (19:48)
Re: Select max(foo) and select count(*) optimization Rod Taylor (19:52)
Re: optimizing Postgres queries David Teran (19:57)
Re: Select max(foo) and select count(*) optimization John Siracusa (20:01)
Re: deferred foreign keys Rod Taylor (20:14)
Re: Select max(foo) and select count(*) optimization Neil Conway (20:23)
Re: Select max(foo) and select count(*) optimization Christopher Browne (20:26)
Re: Use my (date) index, darn it! Christopher Browne (20:27)
Re: deferred foreign keys Stephan Szabo (22:33)

2004-01-06

Re: Select max(foo) and select count(*) optimization Paul Tuckfield (00:24)
Re: Select max(foo) and select count(*) optimization Doug McNaught (00:29)
Re: Select max(foo) and select count(*) optimization Christopher Browne (01:46)
Re: Select max(foo) and select count(*) optimization Christopher Browne (02:31)
Re: optimizing Postgres queries Bruce Momjian (05:25)
Re: Select max(foo) and select count(*) optimization Shridhar Daithankar (06:31)
Re: Select max(foo) and select count(*) optimization Shridhar Daithankar (06:42)
Re: Select max(foo) and select count(*) optimization CoL (11:51)
Re: Select max(foo) and select count(*) optimization D'Arcy J.M. Cain (12:18)
Re: Select max(foo) and select count(*) optimization Shridhar Daithankar (12:20)
Inefficient SELECT with OFFSET and LIMIT Clive Page (15:40)
Re: Select max(foo) and select count(*) optimization Robert Treat (16:03)
Re: Select max(foo) and select count(*) optimization Shridhar Daithankar (16:31)
Re: Inefficient SELECT with OFFSET and LIMIT Greg Stark (18:12)
Re: Inefficient SELECT with OFFSET and LIMIT Tom Lane (18:36)
Re: Select max(foo) and select count(*) optimization Mark Kirkwood (19:28)
PgAdmin startup query VERY slow Michael Shapiro (20:49)
Re: PgAdmin startup query VERY slow Josh Berkus (21:01)
Re: PgAdmin startup query VERY slow Josh Berkus (21:17)
Re: PgAdmin startup query VERY slow Michael Shapiro (21:31)
Re: Select max(foo) and select count(*) optimization D'Arcy J.M. Cain (22:57)
Re: PgAdmin startup query VERY slow Tom Lane (23:12)
Re: Select max(foo) and select count(*) optimization Tom Lane (23:19)

2004-01-07

Find original number of rows before applied LIMIT/OFFSET? D. Dante Lorenso (16:57)
Index creation Eric Jain (17:08)
Re: Index creation Jeff (17:20)
Re: [PERFORM] Find original number of rows before applied LIMIT/OFFSET? Greg Stark (19:41)
RAID array stripe sizes Greg Stark (19:45)
Re: Index creation scott.marlowe (19:51)
failures on machines using jfs Andrew Sullivan (23:06)

2004-01-08

Slow query problem Bradley Tate (05:52)
Re: failures on machines using jfs Josh Berkus (18:52)

2004-01-09

Re: optimizing Postgres queries Rod Taylor (03:16)
Re: Slow query problem Mike Glover (03:27)
PostgreSQL vs. Oracle disk space usage Seum-Lim Gan (04:19)
Re: Slow query problem Bruno Wolff III (04:23)
Re: Slow query problem Tom Lane (05:12)
Re: Slow query problem Dennis Björklund (07:29)
Re: Slow query problem Richard Huxton (08:54)
Re: Slow query problem Dennis Björklund (08:57)
Re: Slow query problem Richard Huxton (09:19)
Explain not accurate Richard van den Berg (14:12)
Re: Slow query problem Bradley Tate (14:53)
Re: Slow query problem Tom Lane (15:07)
Re: Slow query problem Stephan Szabo (15:38)

2004-01-10

Re: failures on machines using jfs Robert Creager (03:28)

2004-01-11

Re: failures on machines using jfs Christopher Browne (02:08)
Postgresql on Quad CPU machine D. Dante Lorenso (15:53)
Re: Postgresql on Quad CPU machine Doug McNaught (16:07)
Re: failures on machines using jfs Spiegelberg, Greg (16:21)
Re: failures on machines using jfs Tom Lane (17:04)
COUNT & Pagination David Shadovitz (18:10)
Re: Explain not accurate Dennis Bjorklund (19:55)
Re: COUNT & Pagination CoL (20:01)
Re: COUNT & Pagination Jeff Fitzmyers (20:59)

2004-01-12

Re: Explain not accurate Christopher Kings-Lynne (00:24)
Re: COUNT & Pagination Christopher Kings-Lynne (00:38)
Re: Explain not accurate Greg Stark (02:55)
annoying query/planner choice Andrew Rawnsley (03:05)
Re: annoying query/planner choice Dennis Bjorklund (03:50)
Re: annoying query/planner choice Christopher Browne (03:56)
Re: annoying query/planner choice Andrew Rawnsley (04:05)
Re: annoying query/planner choice Tom Lane (05:40)
Re: COUNT & Pagination Richard Huxton (10:16)
Re: annoying query/planner choice Andrew Rawnsley (15:02)
Re: COUNT & Pagination David Shadovitz (15:37)
Re: failures on machines using jfs Hannu Krosing (16:12)
Re: failures on machines using jfs Greg Spiegelberg (17:03)
Re: COUNT & Pagination Robert Treat (21:42)
Postgres on Netapp Shankar K (21:45)

2004-01-13

Ignore Some Updates cnliou (03:07)
Re: Ignore Some Updates Tom Lane (04:59)
Re: failures on machines using jfs Hannu Krosing (12:46)
Re: failures on machines using jfs Bill Moran (12:59)
Re: failures on machines using jfs Greg Spiegelberg (15:04)
freebsd 5.2 and max_connections David Hill (16:04)
Re: freebsd 5.2 and max_connections Richard Huxton (17:13)
Re: COUNT & Pagination mallah (17:31)
Re: COUNT & Pagination David Shadovitz (17:45)
Re: COUNT & Pagination scott.marlowe (17:55)

2004-01-14

100 simultaneous connections, critical limit? Jón Ragnarsson (12:42)
100 simultaneous connections, critical limit? Jón Ragnarsson (12:48)
Re: 100 simultaneous connections, critical limit? Shridhar Daithankar (13:01)
Re: 100 simultaneous connections, critical limit? Christopher Browne (13:27)
subquery and table join, index not use for table CoL (13:35)
Re: 100 simultaneous connections, critical limit? Jón Ragnarsson (13:44)
Re: 100 simultaneous connections, critical limit? Nick Barr (14:00)
Re: 100 simultaneous connections, critical limit? Tom Lane (15:04)
Re: 100 simultaneous connections, critical limit? scott.marlowe (17:09)
Re: 100 simultaneous connections, critical limit? Adam Alkins (18:10)
Re: COUNT & Pagination Rajesh Kumar Mallah (18:13)
Re: 100 simultaneous connections, critical limit? Evil Azrael (18:36)
Re: 100 simultaneous connections, critical limit? scott.marlowe (21:35)
Re: COUNT & Pagination scott.marlowe (21:40)
Join optimisation Quandry Ceri Storey (23:10)

2004-01-15

Re: 100 simultaneous connections, critical limit? Christopher Kings-Lynne (01:28)
Re: 100 simultaneous connections, critical limit? Andrew McMillan (02:57)
Trigger question pginfo (13:13)
insert speed - Mac OSX vs Redhat Syd (13:56)
Re: insert speed - Mac OSX vs Redhat Matt Clark (14:17)
Re: insert speed - Mac OSX vs Redhat Tom Lane (15:44)
Weird query speed Rigmor Ukuhe (16:02)
Re: Trigger question Richard Huxton (16:10)
Question about space usage: Jeremy M. Guthrie (16:37)
Re: Weird query speed Tom Lane (16:40)
Re: Trigger question Evil Azrael (17:08)
Re: insert speed - Mac OSX vs Redhat Syd (21:17)
shared_buffer value Anjan Dave (22:49)

2004-01-16

Re: shared_buffer value Richard Huxton (00:17)
Re: shared_buffer value Tom Lane (00:51)
IDE/SCSI disk tools to turn off write caching Syd (02:29)
Re: 100 simultaneous connections, critical limit? Thomas Swan (06:24)
Re: Trigger question Chris Travers (10:19)
Re: Trigger question Harald Fuchs (13:05)
Re: shared_buffer value Anjan Dave (15:29)
Re: [PERFORM] Postgres on Netapp Larry Rosenman (16:53)
Re: [PERFORM] Postgres on Netapp Rod Taylor (17:01)
Re: shared_buffer value scott.marlowe (17:20)
Re: subquery and table join, index not use for table Stephan Szabo (17:48)
Re: Join optimisation Quandry Stephan Szabo (18:17)
Re: Question about space usage: Tom Lane (19:26)
Potential Problem with PostgeSQL performance on SuSE Linux 9.0 Josh Berkus (20:37)
Re: [PERFORM] Potential Problem with PostgeSQL performance on SuSE Mark Kirkwood (22:11)

2004-01-17

Re: Join optimisation Quandry Ceri Storey (01:03)
Re: Potential Problem with PostgeSQL performance on SuSE Josh Berkus (01:13)
Re: Potential Problem with PostgeSQL performance on SuSE Mark Kirkwood (01:51)
Re: Join optimisation Quandry Stephan Szabo (06:05)
Re: Join optimisation Quandry Ceri Storey (10:40)
Re: Join optimisation Quandry Ceri Storey (11:58)
Idle postmaster taking up a lot of CPU John Siracusa (15:34)
Re: [PERFORM] Postgres on Netapp D'Arcy J.M. Cain (16:55)
Re: Idle postmaster taking up a lot of CPU Tom Lane (17:32)
Re: Idle postmaster taking up a lot of CPU John Siracusa (21:33)

2004-01-19

Re: Join optimisation Quandry Tom Lane (02:21)
Re: COUNT & Pagination Neil Conway (23:58)

2004-01-20

Re: Trigger question Neil Conway (00:01)
Re: Trigger question Richard Huxton (08:13)
Re: Trigger question Neil Conway (15:17)
Re: Trigger question Tom Lane (16:02)
Re: Trigger question Harald Fuchs (16:15)
Re: Trigger question Stephan Szabo (16:30)
Re: Trigger question Tom Lane (16:42)

Prev | Next

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group