pgsql-performance 2004-07 Thread Index (1/2)

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

Peripheral Links

Text Size: Normal / Large
Donate
Contact

Header And Logo

PostgreSQL

|

The world's most advanced open source database.

Site Navigation

pgsql-performance 2004-07 Thread Index (1/2)

Last updated: Wed Jan 18 04:21:46 2012
246 messages

Main Index
[Prev Page]
[Next Page]

[no subject] Unknown (Wed 18 04:21)
Index works with foo.val=bar.val but not foo.val<=bar.val 8lhhxba02 (Thu 29 21:05)
Extremely slow query... pathat (Thu 29 15:54)
my boss want to migrate to ORACLE Stephane Tessier (Wed 28 22:20)

Re: my boss want to migrate to ORACLE Russell Smith (Fri 30 01:21)
Re: my boss want to migrate to ORACLE markir (Fri 30 02:33)
Re: my boss want to migrate to ORACLE markir (Fri 30 02:59)

Re: my boss want to migrate to ORACLE Stephane Tessier (Fri 30 13:56)

Re: my boss want to migrate to ORACLE Scott Marlowe (Fri 30 15:13)
Re: my boss want to migrate to ORACLE Matthew T. O'Connor (Fri 30 17:56)

Re: my boss want to migrate to ORACLE Dan Langille (Fri 30 18:12)

Re: my boss want to migrate to ORACLE Brian Hirt (Fri 30 18:29)

Re: my boss want to migrate to ORACLE Christopher Browne (Sat 31 02:17)

Re: my boss want to migrate to ORACLE Scott Marlowe (Sat 31 04:13)

Re: my boss want to migrate to ORACLE Jeff (Fri 30 12:33)
<Possible follow-ups>
Re: my boss want to migrate to ORACLE Merlin Moncure (Fri 30 14:14)

Optimizer refuses to hash join Stan Bielski (Wed 28 02:14)

Re: Optimizer refuses to hash join Stephan Szabo (Thu 29 16:09)
Re: Optimizer refuses to hash join Tom Lane (Thu 29 17:06)
<Possible follow-ups>
Re: Optimizer refuses to hash join Tom Lane (Fri 30 16:49)

Automagic tuning Markus Schaber (Tue 27 13:15)

Re: Automagic tuning Christopher Kings-Lynne (Wed 28 03:35)

best way to fetch next/prev record based on index Merlin Moncure (Tue 27 13:07)

Re: best way to fetch next/prev record based on index Tom Lane (Wed 28 03:22)
Re: best way to fetch next/prev record based on index Rod Taylor (Wed 28 03:28)
Re: best way to fetch next/prev record based on index Greg Stark (Wed 28 03:29)
Re: best way to fetch next/prev record based on index Markus Schaber (Wed 28 03:30)

Correction of best way to fetch next/prev record based on index Markus Schaber (Wed 28 03:34)

<Possible follow-ups>
Re: best way to fetch next/prev record based on index Merlin Moncure (Wed 28 03:26)

Re: best way to fetch next/prev record based on index Stephan Szabo (Wed 28 04:01)

Re: best way to fetch next/prev record based on index Greg Stark (Wed 28 05:53)

Re: best way to fetch next/prev record based on index Greg Stark (Wed 28 07:15)
Re: best way to fetch next/prev record based on index Tom Lane (Wed 28 14:07)

Re: best way to fetch next/prev record based on index Greg Stark (Wed 28 16:01)
Re: best way to fetch next/prev record based on index Tom Lane (Wed 28 16:56)
Re: best way to fetch next/prev record based on index Greg Stark (Wed 28 22:54)
Re: best way to fetch next/prev record based on index Tom Lane (Wed 28 23:12)

best way to fetch next/prev record based on index Merlin Moncure (Wed 28 03:29)
Re: best way to fetch next/prev record based on index andrew (Wed 28 03:33)
Re: best way to fetch next/prev record based on index Merlin Moncure (Wed 28 03:34)

Re: best way to fetch next/prev record based on index Greg Stark (Wed 28 03:36)

Re: best way to fetch next/prev record based on index Merlin Moncure (Wed 28 03:38)
Re: best way to fetch next/prev record based on index Merlin Moncure (Wed 28 03:41)

Re: best way to fetch next/prev record based on index Markus Schaber (Wed 28 03:24)

Re: best way to fetch next/prev record based on index Merlin Moncure (Wed 28 03:50)
Re: best way to fetch next/prev record based on index Merlin Moncure (Wed 28 03:52)

Re: best way to fetch next/prev record based on index Tom Lane (Wed 28 03:34)

Re: best way to fetch next/prev record based on index Tom Lane (Wed 28 03:47)

Re: best way to fetch next/prev record based on index Tom Lane (Wed 28 03:28)

Re: best way to fetch next/prev record based on index Merlin Moncure (Wed 28 12:48)
Re: best way to fetch next/prev record based on index Merlin Moncure (Wed 28 15:38)

Join performance Pierre-Frédéric Caillaud (Wed 28 16:54)

Re: best way to fetch next/prev record based on index Merlin Moncure (Thu 29 16:48)

Re: best way to fetch next/prev record based on index Greg Stark (Thu 29 17:58)

Re: best way to fetch next/prev record based on index Merlin Moncure (Thu 29 18:23)

Re: best way to fetch next/prev record based on index Tom Lane (Thu 29 18:41)
Re: best way to fetch next/prev record based on index Greg Stark (Thu 29 18:49)

Re: best way to fetch next/prev record based on index Merlin Moncure (Thu 29 20:11)

Little understanding for tuning ... Hervé Piedvache (Tue 27 07:35)
Timestamp-based indexing Harmon S. Nine (Mon 26 14:52)

Re: Timestamp-based indexing Kevin Barnard (Mon 26 15:04)

Re: Timestamp-based indexing Harmon S. Nine (Mon 26 15:42)

Re: Timestamp-based indexing Matthew T. O'Connor (Mon 26 15:10)

Re: Timestamp-based indexing Harmon S. Nine (Mon 26 15:46)
Re: Timestamp-based indexing Tom Lane (Mon 26 15:59)

Re: Timestamp-based indexing Litao Wu (Mon 26 21:26)

Re: Timestamp-based indexing Tom Lane (Mon 26 21:40)

Re: Timestamp-based indexing Christopher Kings-Lynne (Tue 27 01:52)

Re: Timestamp-based indexing Stephan Szabo (Mon 26 16:02)

Re: Timestamp-based indexing Harmon S. Nine (Mon 26 18:37)

arrays and indexes Ross J. Reedstrom (Mon 26 04:57)

Re: arrays and indexes Greg Stark (Mon 26 06:27)

Re: arrays and indexes Ross J. Reedstrom (Mon 26 18:57)

Re: arrays and indexes Pierre-Frédéric Caillaud (Mon 26 20:35)
Re: arrays and indexes Greg Stark (Mon 26 20:40)

Re: arrays and indexes Tom Lane (Mon 26 21:21)

Re: arrays and indexes Greg Stark (Tue 27 04:32)

<Possible follow-ups>
Re: arrays and indexes Merlin Moncure (Mon 26 14:56)

variable length - user defined types/storage place martin . bokler (Fri 23 20:56)
Re: [HACKERS] Wrong index choosen? Gaetano Mendola (Fri 23 17:42)

Re: [HACKERS] Wrong index choosen? Matthew T. O'Connor (Fri 23 18:12)

Re: [HACKERS] Wrong index choosen? Jaime Casanova (Fri 23 21:51)

Re: [HACKERS] Wrong index choosen? Scott Marlowe (Fri 23 22:01)

Re: [HACKERS] Wrong index choosen? Gaetano Mendola (Sat 24 00:08)

Re: [HACKERS] Wrong index choosen? Matthew T. O'Connor (Sat 24 01:49)

Performance over a LAN William Carney (Fri 23 05:53)

Re: Performance over a LAN Christopher Kings-Lynne (Fri 23 05:59)

Re: Performance over a LAN Mark Aufflick (Fri 23 06:20)

Re: Performance over a LAN William Carney (Fri 23 07:59)

Re: Performance over a LAN Jeff (Fri 23 12:05)
Re: Performance over a LAN Gary Cowell (Fri 23 16:26)

Re: Performance over a LAN Scott Marlowe (Fri 23 06:28)
Re: Performance over a LAN Rod Taylor (Fri 23 11:43)
Re: Performance over a LAN Michael Adler (Fri 23 15:34)
Re: Performance over a LAN Greg Stark (Fri 23 17:09)

Beowulf Cluster & Postgresql? joe (Wed 21 20:46)

Re: Beowulf Cluster & Postgresql? Scott Marlowe (Wed 21 21:07)
Re: Beowulf Cluster & Postgresql? Mark Kirkwood (Thu 22 02:47)

Index type Ilia Kantor (Tue 20 21:46)
Unbearably slow cascading deletes andrew (Tue 20 19:19)

Re: Unbearably slow cascading deletes Stephan Szabo (Tue 20 19:45)

Re: Unbearably slow cascading deletes Stephan Szabo (Tue 20 19:55)

Re: Unbearably slow cascading deletes Christopher Kings-Lynne (Wed 21 01:36)
<Possible follow-ups>
Re: Unbearably slow cascading deletes andrew (Tue 20 19:59)
Re: Unbearably slow cascading deletes andrew (Tue 20 20:06)

Réf. : Re: Réf. : Re: NAS, SAN or any alternate solution ? bsimon (Tue 20 10:15)
Réf. : Re: NAS, SAN or any alternate solution ? bsimon (Tue 20 09:29)

Re: Réf. : Re: [PERFORM] NAS, Mark Kirkwood (Tue 20 10:02)
Re: Réf. : Re: NAS, SAN or any Scott Marlowe (Tue 20 15:27)

NAS, SAN or any alternate solution ? bsimon (Tue 20 07:50)

Re: NAS, SAN or any alternate solution ? Scott Marlowe (Tue 20 08:20)
Re: NAS, SAN or any alternate solution ? Grega Bremec (Tue 20 12:26)

Re: NAS, SAN or any alternate solution ? Grega Bremec (Tue 20 13:04)

Re: NAS, SAN or any alternate solution ? Joe Conway (Tue 20 16:44)
Re: NAS, SAN or any alternate solution ? Rod Taylor (Tue 20 17:30)

Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver. Gaetano Mendola (Sun 18 09:42)
Scaling with lazy index updates Fred Moyer (Sat 17 03:30)

Re: Scaling with lazy index updates Josh Berkus (Sun 18 00:02)

same plan, different time Litao Wu (Fri 16 21:36)

Re: same plan, different time Tom Lane (Sat 17 04:43)

Wierd issues Andrew Matthews (Thu 15 19:36)
hardware raid suggestions Brian Hirt (Thu 15 18:07)

Re: hardware raid suggestions Josh Berkus (Fri 16 02:55)
Re: hardware raid suggestions Mark Aufflick (Fri 16 03:25)
Re: hardware raid suggestions Fred Moyer (Sat 17 03:20)
Re: hardware raid suggestions Gaetano Mendola (Mon 26 14:16)

extrem bad performance Stefan (Thu 15 10:30)

Re: extrem bad performance Rod Taylor (Sat 17 02:31)

Re: extrem bad performance Stefan (Wed 21 16:45)

vacuum full 100 mins plus? Patrick Hatcher (Wed 14 21:41)

Re: vacuum full 100 mins plus? Patrick Hatcher (Wed 14 22:48)

Re: vacuum full 100 mins plus? Josh Berkus (Thu 15 00:13)
Re: vacuum full 100 mins plus? Christopher Browne (Thu 15 03:00)

Re: vacuum full 100 mins plus? Tom Lane (Thu 15 04:36)

Re: vacuum full 100 mins plus? Mike Rylander (Thu 15 15:30)

Insert are going slower ... Hervé Piedvache (Tue 13 16:51)

Re: Insert are going slower ... Josh Berkus (Tue 13 17:10)

Re: Insert are going slower ... Hervé Piedvache (Tue 13 23:42)

Re: Insert are going slower ... gnari (Wed 14 10:04)

Re: Insert are going slower ... Shridhar Daithankar (Wed 14 10:13)

Re: Insert are going slower ... Hervé Piedvache (Wed 14 14:08)
Re: Insert are going slower ... Shridhar Daithankar (Wed 14 14:32)

Re: Insert are going slower ... Josh Berkus (Wed 14 16:41)

Re: Insert are going slower ... Hervé Piedvache (Wed 14 21:19)
Re: Insert are going slower ... Hervé Piedvache (Wed 14 21:32)

Re: Insert are going slower ... Shridhar Daithankar (Thu 15 06:22)
Re: Insert are going slower ... Josh Berkus (Thu 15 18:09)
Re: Insert are going slower ... Hervé Piedvache (Fri 16 11:17)
Re: Insert are going slower ... Josh Berkus (Sun 18 17:24)

Re: Insert are going slower ... Gaetano Mendola (Mon 26 14:16)

Re: Insert are going slower ... Gaetano Mendola (Mon 26 14:46)

Re: Insert are going slower ... Scott Marlowe (Mon 26 16:24)

How to create an index for type timestamp column using rtree? Chris Cheston (Tue 13 05:51)

Re: How to create an index for type timestamp column using rtree? Tom Lane (Tue 13 06:25)
Re: How to create an index for type timestamp column using Christopher Kings-Lynne (Tue 13 06:31)

Re: How to create an index for type timestamp column using rtree? Chris Cheston (Tue 13 07:56)

Re: Fw: invitation au "Village du Logiciel Libre" de la Laurent Martelli (Mon 12 18:33)
Swapping in 7.4.3 Jim Ewert (Mon 12 16:59)

Re: Swapping in 7.4.3 Matthew T. O'Connor (Tue 13 20:28)
<Possible follow-ups>
Re: Swapping in 7.4.3 Jim Ewert (Thu 15 13:49)

Re: Swapping in 7.4.3 Scott Marlowe (Thu 15 16:19)

Re: Swapping in 7.4.3 Matt Clark (Fri 16 07:35)

Re: achat borne wifi Laurent Martelli (Sat 10 10:00)
Re: Working on huge RAM based datasets Merlin Moncure (Fri 09 14:16)

Re: Working on huge RAM based datasets Andy Ballingall (Fri 09 16:08)
Re: Working on huge RAM based datasets Jan Wieck (Sun 11 14:14)

Re: Working on huge RAM based datasets Christopher Browne (Sun 11 17:59)

Re: Working on huge RAM based datasets Rod Taylor (Mon 12 14:38)

Re: Working on huge RAM based datasets Josh Berkus (Mon 12 16:38)

Re: Working on huge RAM based datasets Jan Wieck (Mon 12 18:01)

<Possible follow-ups>
Re: Working on huge RAM based datasets Merlin Moncure (Mon 12 14:05)
Re: Working on huge RAM based datasets Merlin Moncure (Mon 12 14:22)

Re: Working on huge RAM based datasets Andy Ballingall (Mon 19 09:12)
Re: Working on huge RAM based datasets abhousehunt (Tue 20 10:45)

query plan wierdness? Joel McGraw (Wed 07 21:27)

Re: query plan wierdness? Guido Barosio (Wed 07 21:44)
Re: query plan wierdness? Stephan Szabo (Wed 07 22:50)
Re: query plan wierdness? Rod Taylor (Thu 08 16:50)

vacuum_mem Litao Wu (Thu 08 18:03)

Re: vacuum_mem Rod Taylor (Thu 08 18:25)

Main Index
[Prev Page]
[Next Page]

Mail converted by MHonArc

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group