Search

Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - July 2007

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

Prev | Next

2007-07-02

• [PERFORMANCE] is it possible to force an index to be held in memory? valgog (10:04)
• slow query Vidhya Bondre (10:07)
• Re: slow query Nis Jørgensen (13:20)
• Re: PostgreSQL 8.0 occasionally slow down Greg Smith (22:21)
• Join with lower/upper limits doesn't scale well Craig James (23:30)

2007-07-03

• Re: Join with lower/upper limits doesn't scale well Gregory Stark (00:04)
• Delete Cascade FK speed issue Patric de Waha (06:05)
• Re: Delete Cascade FK speed issue Michael Fuhr (11:33)
• Filesystem Direct I/O and WAL sync option Dimitri (14:54)
• Re: Filesystem Direct I/O and WAL sync option Heikki Linnakangas (15:06)
• Re: Filesystem Direct I/O and WAL sync option Dimitri (15:26)
• Re: Delete Cascade FK speed issue Mark Lewis (16:01)
• Re: PostgreSQL 8.0 occasionally slow down Ho Fat Tsang (17:03)
• Re: PostgreSQL 8.0 occasionally slow down Ho Fat Tsang (17:07)
• Re: PostgreSQL 8.0 occasionally slow down Ho Fat Tsang (17:14)
• Re: PostgreSQL 8.0 occasionally slow down Ho Fat Tsang (17:21)
• Query is taking 5 HOURS to Complete on 8.1 version smiley2211 (17:25)
• Re: Query is taking 5 HOURS to Complete on 8.1 version Bill Moran (17:32)
• Re: Query is taking 5 HOURS to Complete on 8.1 version smiley2211 (18:55)
• Re: Query is taking 5 HOURS to Complete on 8.1 version Richard Huxton (19:18)
• Re: Query is taking 5 HOURS to Complete on 8.1 version smiley2211 (19:23)
• Re: Query is taking 5 HOURS to Complete on 8.1 version Chris Hoover (20:16)
• Re: Query is taking 5 HOURS to Complete on 8.1 version smiley2211 (20:18)
• Re: Query is taking 5 HOURS to Complete on 8.1 version Richard Huxton (20:27)
• Re: Query is taking 5 HOURS to Complete on 8.1 version Richard Huxton (20:28)

2007-07-04

• Re: Filesystem Direct I/O and WAL sync option Gregory Stark (01:13)
• Re: Delete Cascade FK speed issue Axel Rau (07:30)
• Re: Filesystem Direct I/O and WAL sync option Dimitri (10:26)
• Re: Filesystem Direct I/O and WAL sync option Gregory Stark (10:45)

2007-07-05

• Re: PostgreSQL Configuration Tool for Dummies Magnus Hagander (05:15)
• Re: Filesystem Direct I/O and WAL sync option Dimitri (12:01)
• improvement suggestions for performance design tfinneid (12:15)
• Re: improvement suggestions for performance design Heikki Linnakangas (12:59)
• Re: improvement suggestions for performance design tfinneid (13:35)
• Re: improvement suggestions for performance design Y Sidhu (14:57)
• Re: improvement suggestions for performance design tfinneid (15:49)
• Re: improvement suggestions for performance design Y Sidhu (16:10)
• Re: Query is taking 5 HOURS to Complete on 8.1 version smiley2211 (17:49)
• Re: Query is taking 5 HOURS to Complete on 8.1 version Alvaro Herrera (18:05)
• Re: improvement suggestions for performance design Heikki Linnakangas (18:39)
• Re: improvement suggestions for performance design Thomas Finneid (22:23)

2007-07-06

• Direct I/O lai yoke hman (02:28)
• Performance of PostgreSQL and Oracle lai yoke hman (02:44)
• Re: Performance of PostgreSQL and Oracle Tom Lane (03:59)
• Re: PostgreSQL Configuration Tool for Dummies Harald Armin Massa (04:25)
• Re: improvement suggestions for performance design Kalle Hallivuori (11:30)
• Re: Direct I/O Alvaro Herrera (14:40)
• Advice about how to delete Arnau (14:42)
• Re: Advice about how to delete Michael Glaesemann (15:04)
• Re: Advice about how to delete Arnau (15:56)
• Re: Direct I/O Jignesh K. Shah (16:03)
• Re: Advice about how to delete Heikki Linnakangas (16:18)

2007-07-08

• Re: improvement suggestions for performance design Thomas Finneid (10:06)
• Re: improvement suggestions for performance design Kalle Hallivuori (16:25)

2007-07-09

• PostgreSQL publishes first real benchmark Jignesh K. Shah (15:57)
• Re: PostgreSQL publishes first real benchmark Jonah H. Harris (16:21)
• Re: PostgreSQL publishes first real benchmark Heikki Linnakangas (16:27)
• Re: PostgreSQL publishes first real benchmark Joshua D. Drake (16:27)
• Re: PostgreSQL publishes first real benchmark Steinar H. Gunderson (16:52)
• Re: PostgreSQL publishes first real benchmark Joshua D. Drake (17:02)
• Re: PostgreSQL publishes first real benchmark Jignesh K. Shah (17:48)
• Re: PostgreSQL publishes first real benchmark Magnus Hagander (18:23)
• Re: PostgreSQL publishes first real benchmark Vivek Khera (18:38)
• Re: PostgreSQL publishes first real benchmark Greg Smith (18:55)
• Re: PostgreSQL publishes first real benchmark Jonah H. Harris (19:04)
• Re: PostgreSQL publishes first real benchmark Joshua D. Drake (19:17)
• Re: PostgreSQL publishes first real benchmark Jonah H. Harris (19:17)
• Re: Filesystem Direct I/O and WAL sync option Jim C. Nasby (20:32)
• Re: Filesystem Direct I/O and WAL sync option Jonah H. Harris (20:46)
• Re: PostgreSQL publishes first real benchmark Jim C. Nasby (20:53)
• Re: rtree/gist index taking enormous amount of space in 8.2.3 Dolafi, Tom (21:48)

2007-07-10

• Re: PostgreSQL publishes first real benchmark Heiko W.Rupp (08:00)
• Re: Filesystem Direct I/O and WAL sync option Dimitri (12:53)
• Query Analyser Gauri Kanekar (14:47)
• tuning a function to insert/retrieve values from a reference table Marc Mamin (15:03)
• Re: tuning a function to insert/retrieve values from a reference table Tom Lane (15:41)

2007-07-11

• Equivalent queries produce different plans Craig James (00:53)
• Re: Equivalent queries produce different plans Craig James (01:06)
• Re: Equivalent queries produce different plans Tom Lane (01:25)
• best use of an EMC SAN Dave Cramer (13:03)
• Re: best use of an EMC SAN Dan Gorman (13:18)
• Re: best use of an EMC SAN Gregory Stark (14:05)
• Re: Query Analyser Michael Fuhr (14:05)
• Re: best use of an EMC SAN Dave Cramer (14:14)
• Re: PostgreSQL publishes first real benchmark Philippe Amelant (14:16)
• Re: best use of an EMC SAN Cott Lang (14:40)
• WALL on controller without battery? Francisco Reyes (14:48)
• TIMING A QUERY ??? smiley2211 (15:21)
• Weird row estimate Marc Cousin (15:28)
• Re: best use of an EMC SAN Andrew Sullivan (15:33)
• Two questions.. shared_buffers and long reader issue Patric de Waha (15:35)
• Re: WALL on controller without battery? Andrew Sullivan (15:36)
• Re: TIMING A QUERY ??? Andrew Sullivan (15:39)
• Re: WALL on controller without battery? Alan Hodgson (15:47)
• Re: PostgreSQL publishes first real benchmark Jignesh K. Shah (15:48)
• Re: Two questions.. shared_buffers and long reader issue Bryan Murphy (15:51)
• Re: PostgreSQL publishes first real benchmark Heikki Linnakangas (15:59)
• Re: TIMING A QUERY ??? Tom Lane (16:10)
• Re: TIMING A QUERY ??? Gregory Stark (16:11)
• Re: PostgreSQL publishes first real benchmark Jignesh K. Shah (16:33)
• Re: PostgreSQL publishes first real benchmark André Gomes Lamas Otero (16:37)
• Re: Two questions.. shared_buffers and long reader issue Tom Lane (16:57)
• Re: Two questions.. shared_buffers and long reader issue Andrew Sullivan (16:58)
• Re: TIMING A QUERY ??? Andrew Sullivan (17:01)
• Re: PostgreSQL publishes first real benchmark Tom Lane (17:07)
• Re: best use of an EMC SAN Chris Browne (17:39)
• Re: best use of an EMC SAN Jim Nasby (17:58)
• Re: best use of an EMC SAN Andrew Sullivan (18:27)
• Re: PostgreSQL publishes first real benchmark Jignesh K. Shah (18:34)
• Re: best use of an EMC SAN Greg Smith (18:35)
• bitmap-index-scan slower than normal index scan Andreas Kretschmer (18:36)
• Re: best use of an EMC SAN Dave Cramer (18:45)
• Re: bitmap-index-scan slower than normal index scan Alex Deucher (18:52)
• Re: WALL on controller without battery? Greg Smith (18:53)
• Re: bitmap-index-scan slower than normal index scan A. Kretschmer (19:31)
• Re: WALL on controller without battery? Francisco Reyes (19:39)
• Re: WALL on controller without battery? Joshua D. Drake (19:45)
• Re: bitmap-index-scan slower than normal index scan Alex Deucher (20:01)
• Re: bitmap-index-scan slower than normal index scan Alex Deucher (20:01)
• Re: bitmap-index-scan slower than normal index scan Tom Lane (20:04)
• TRUNCATE TABLE Adriaan van Os (20:10)
• Re: bitmap-index-scan slower than normal index scan Andreas Kretschmer (20:19)
• Re: WALL on controller without battery? Francisco Reyes (20:34)
• Re: Weird row estimate Tom Lane (20:35)
• Re: Two questions.. shared_buffers and long reader issue Patric de Waha (20:48)
• Re: TRUNCATE TABLE Tom Lane (21:54)
• Re: TRUNCATE TABLE Gregory Stark (22:15)
• Re: WALL on controller without battery? Greg Smith (23:01)

2007-07-12

• Re: WALL on controller without battery? Francisco Reyes (00:26)
• Estimating WAL volume Greg Smith (03:10)
• Re: bitmap-index-scan slower than normal index scan A. Kretschmer (05:06)
• pg_restore causes 100 Craig James (07:34)
• Re: TRUNCATE TABLE Adriaan van Os (07:37)
• one column from huge view Marcin Stępnicki (08:33)
• Re: one column from huge view Heikki Linnakangas (08:50)
• Re: Weird row estimate Marc Cousin (08:55)
• Re: PostgreSQL publishes first real benchmark Stefan Kaltenbrunner (09:08)
• Re: PostgreSQL publishes first real benchmark Gregory Stark (10:45)
• Re: TIMING A QUERY ??? smiley2211 (12:39)
• Re: one column from huge view Michael Fuhr (12:51)
• Re: one column from huge view Heikki Linnakangas (12:55)
• Re: pg_restore causes 100 Tom Lane (14:27)
• Re: one column from huge view Tom Lane (14:48)
• Re: PostgreSQL publishes first real benchmark Greg Smith (15:00)
• Re: TRUNCATE TABLE Tom Lane (19:20)

2007-07-13

• Re: TRUNCATE TABLE Adriaan van Os (07:47)
• Re: TRUNCATE TABLE Gregory Stark (09:02)
• Re: TRUNCATE TABLE Jean-Max Reymond (09:05)
• Re: TRUNCATE TABLE Thomas Samson (09:21)
• Re: PostgreSQL publishes first real benchmark Philippe Amelant (09:56)
• Re: PostgreSQL publishes first real benchmark Ray Stell (12:08)
• Re: TRUNCATE TABLE Michael Stone (12:44)
• Re: TRUNCATE TABLE Tom Lane (14:40)
• Re: TRUNCATE TABLE Adriaan van Os (16:17)
• Re: TRUNCATE TABLE Steinar H. Gunderson (16:29)
• Re: TRUNCATE TABLE Tom Lane (16:30)
• Database Statistics??? smiley2211 (16:53)
• Re: TRUNCATE TABLE Jim C. Nasby (17:12)
• Re: TRUNCATE TABLE Alvaro Herrera (17:35)
• Re: Database Statistics??? Tom Arthurs (17:39)
• Re: Database Statistics??? Ansgar -59cobalt- Wiechers (17:52)
• Re: Database Statistics??? Mario Weilguni (18:19)
• Re: Database Statistics??? smiley2211 (18:27)
• Re: TRUNCATE TABLE Pavel Stehule (19:12)
• Re: TRUNCATE TABLE Adriaan van Os (19:32)
• Re: Database Statistics??? Alvaro Herrera (21:05)

2007-07-14

• Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Hannes Dorbath (08:29)
• Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Steinar H. Gunderson (08:34)
• Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Gregory Stark (09:57)
• Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Hannes Dorbath (10:19)
• Vacuum full considered useful ;) Patric de Waha (15:50)
• Re: Vacuum full considered useful ;) Joshua D. Drake (16:25)
• Re: Vacuum full considered useful ;) Tom Lane (16:32)
• Re: Vacuum full considered useful ;) Guillaume Lelarge (16:34)

2007-07-15

• Re: Vacuum full considered useful ;) Vivek Khera (02:26)
• slony over LAN and VPN angga erwina (16:37)
• slony over VPN and LAN angga erwina (16:41)

2007-07-16

• Re: Estimating WAL volume Simon Riggs (08:02)
• Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Jim C. Nasby (21:02)
• Re: TRUNCATE TABLE Jim C. Nasby (21:39)

2007-07-17

• Re: TRUNCATE TABLE Tom Lane (00:18)
• Postgres configuration for 64 CPUs, 128 GB RAM... Marc Mamin (14:10)
• Re: Postgres configuration for 64 CPUs, 128 GB RAM... Stefan Kaltenbrunner (15:06)
• Re: Postgres configuration for 64 CPUs, 128 GB RAM... Jim C. Nasby (15:48)
• Re: Postgres configuration for 64 CPUs, 128 GB RAM... Gregory Stark (16:18)
• Re: Postgres configuration for 64 CPUs, 128 GB RAM... Greg Smith (16:46)
• Re: Postgres configuration for 64 CPUs, 128 GB RAM... Strong, David (17:43)
• Re: Postgres configuration for 64 CPUs, 128 GB RAM... PFC (18:04)
• large number of connected connections to postgres database (v8.0) Fei Liu (18:51)
• insert vs select into performance Thomas Finneid (19:38)
• Re: insert vs select into performance Arjen van der Meijden (19:53)
• Re: insert vs select into performance Michael Glaesemann (19:54)
• Re: insert vs select into performance Tom Lane (20:31)
• Re: insert vs select into performance Thomas Finneid (20:50)
• Re: insert vs select into performance Thomas Finneid (20:58)
• Re: insert vs select into performance Michael Stone (20:58)
• Re: insert vs select into performance Mark Lewis (20:59)
• Re: insert vs select into performance Thomas Finneid (21:01)
• Re: insert vs select into performance Michael Glaesemann (21:07)
• Re: insert vs select into performance Thomas Finneid (21:10)

Prev | Next