Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2004-03 Chronological Index (1/3)
Last updated: Wed Jan 18 04:22:07 2012
445 messages
01 April 2004
31 March 2004
Re: select slow? Paul Thomas (17:27)
Re: select slow? Tom Lane (15:40)
Re: select slow? Jaime Casanova (14:27)
Re: What index for 'like (%keyword%)' ??? Richard Huxton (12:08)
What index for 'like (%keyword%)' ??? Priem, Alexander (09:50)
Re: select slow? Richard Huxton (08:33)
Re: LIKE should use index when condition doesn't include Tom Lane (05:33)
Re: LIKE should use index when condition doesn't include Josh Berkus (01:07)
Re: LIKE should use index when condition doesn't include Palle Girgensohn (01:04)
Re: LIKE should use index when condition doesn't include Josh Berkus (00:56)
Re: LIKE should use index when condition doesn't include Palle Girgensohn (00:28)
Re: LIKE should use index when condition doesn't include wildcard Tom Lane (00:16)
30 March 2004
Re: [ADMIN] Raw vs Filesystem Josh Berkus (21:53)
Re: [ADMIN] Raw vs Filesystem Joshua D. Drake (20:59)
Re: Nested Sets WAS: column size too large, is this a bug? Josh Berkus (20:13)
Re: Nested Sets WAS: column size too large, is this a bug? Robert Treat (20:06)
Re: select slow? Paul Thomas (19:39)
select slow? Jaime Casanova (19:25)
Re: [ADMIN] Raw vs Filesystem Richard Huxton (17:29)
Re: [ADMIN] Raw vs Filesystem Josh Berkus (16:44)
Re: Nested Sets WAS: column size too large, is this a bug? Josh Berkus (16:39)
Re: column size too large, is this a bug? Robert Treat (16:27)
Cleanup query takes along time Rob Fielding (14:10)
Re: [ADMIN] Raw vs Filesystem Richard Huxton (08:22)
29 March 2004
Re: postgres eating CPU on HP9000 Josh Berkus (20:24)
Re: postgres eating CPU on HP9000 Fabio Esposito (19:40)
Re: postgres eating CPU on HP9000 Josh Berkus (19:15)
Re: column size too large, is this a bug? Josh Berkus (19:13)
Re: postgres eating CPU on HP9000 Bruno Wolff III (17:33)
Re: column size too large, is this a bug? Jaime Casanova (17:29)
Re: column size too large, is this a bug? Andrew Rawnsley (17:24)
Re: postgres eating CPU on HP9000 Mark Lubratt (17:23)
Re: column size too large, is this a bug? Jaime Casanova (17:05)
Re: postgres eating CPU on HP9000 Fabio Esposito (17:04)
Re: postgres eating CPU on HP9000 Tom Lane (15:36)
Re: postgres eating CPU on HP9000 Fabio Esposito (13:13)
Re: postgres eating CPU on HP9000 Marcus Andree S. Magalhaes (10:57)
28 March 2004
Re: column size too large, is this a bug? Josh Berkus (19:26)
Re: postgres eating CPU on HP9000 Josh Berkus (19:25)
Re: severe performance issue with planner Tom Lane (17:17)
27 March 2004
Re: postgres eating CPU on HP9000 Tom Lane (00:36)
Re: postgres eating CPU on HP9000 Josh Berkus (00:26)
Re: postgres eating CPU on HP9000 scott.marlowe (00:10)
26 March 2004
Re: bigint index not used Tom Lane (23:14)
Re: postgres eating CPU on HP9000 Josh Berkus (23:11)
Re: odd planner choice Tom Lane (23:08)
Re: odd planner choice scott.marlowe (22:24)
Re: postgres eating CPU on HP9000 scott.marlowe (22:22)
Re: postgres eating CPU on HP9000 Tom Lane (21:53)
Re: column size too large, is this a bug? Andrew Rawnsley (18:14)
Re: column size too large, is this a bug? Josh Berkus (18:02)
Re: column size too large, is this a bug? Qing Zhao (17:29)
Re: [HACKERS] fsync method checking markw (17:01)
Re: [HACKERS] fsync method checking Bruce Momjian (16:55)
Re: [HACKERS] fsync method checking markw (16:10)
Re: [HACKERS] fsync method checking Manfred Spraul (06:27)
odd planner choice Ara Anjargolian (05:54)
Re: column size too large, is this a bug? Christopher Kings-Lynne (03:18)
Re: column size too large, is this a bug? Tom Lane (03:11)
Re: column size too large, is this a bug? Christopher Kings-Lynne (02:41)
Re: column size too large, is this a bug? Tom Lane (02:04)
Re: column size too large, is this a bug? Josh Berkus (01:22)
Re: column size too large, is this a bug? Tom Lane (00:39)
25 March 2004
Re: column size too large, is this a bug? Stephan Szabo (22:57)
Re: column size too large, is this a bug? Tom Lane (22:28)
Re: column size too large, is this a bug? Qing Zhao (22:20)
Re: [HACKERS] fsync method checking markw (21:47)
Re: [HACKERS] fsync method checking Josh Berkus (19:11)
Re: [HACKERS] fsync method checking Bruce Momjian (18:53)
Re: column size too large, is this a bug? Tom Lane (18:20)
column size too large, is this a bug? Qing Zhao (17:58)
Re: [HACKERS] fsync method checking markw (17:17)
Re: [HACKERS] fsync method checking Manfred Spraul (06:22)
24 March 2004
Re: slow vacuum performance scott.marlowe (18:18)
Re: slow vacuum performance pginfo (18:04)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Vivek Khera (17:05)
Re: Help with query plan inconsistencies Richard Huxton (16:44)
Re: atrocious update performance Rosser Schwarz (16:38)
Re: slow vacuum performance scott.marlowe (16:31)
Re: slow vacuum performance pginfo (15:35)
Re: slow vacuum performance Bill Moran (14:07)
Re: Help with query plan inconsistencies George Woodring (13:59)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Matt Clark (12:39)
bigint index not used Shiar (12:11)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Andrew Sullivan (12:04)
slow vacuum performance pginfo (11:34)
Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait! Mark Kirkwood (09:24)
Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait! Mark Kirkwood (09:07)
Re: Benchmarking postgres on Solaris/Linux Mark Kirkwood (08:52)
Re: SLOW query with aggregates Greg Stark (03:42)
Re: [ADMIN] Databases Vs. Schemas Adam Ruth (03:31)
23 March 2004
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Subbiah, Stalin (23:18)
Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait! Tom Lane (23:00)
Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait! Josh Berkus (22:55)
Re: atrocious update performance Tom Lane (22:52)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Aaron Werman (22:48)
Re: atrocious update performance Greg Spiegelberg (22:27)
Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait! Tom Lane (22:17)
Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait! Josh Berkus (22:17)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Bill Moran (22:10)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Andrew Sullivan (22:03)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Craig Thomas (21:44)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux scott.marlowe (20:57)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux matt (20:53)
Fwd: FreeBSD, PostgreSQL, semwait and sbwait! Darcy Buskermolen (20:48)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Subbiah, Stalin (20:42)
Re: SLOW query with aggregates Tom Lane (20:32)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Josh Berkus (20:14)
SLOW query with aggregates A Palmblad (20:09)
postgres eating CPU on HP9000 Fabio Esposito (19:25)
Re: Help with query plan inconsistencies Joseph Shraibman (19:25)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Anjan Dave (18:53)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Matt Clark (18:51)
Help with query plan inconsistencies Woody Woodring (18:49)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Subbiah, Stalin (18:40)
Re: [ADMIN] Databases Vs. Schemas Subbiah, Stalin (18:17)
Re: [ADMIN] Benchmarking postgres on Solaris/Linux Andrew Sullivan (17:36)
Re: Optimisation of INTERSECT expressions Tom Lane (17:21)
Re: Optimisation of INTERSECT expressions Josh Berkus (17:18)
Re: Optimisation of INTERSECT expressions Bruno Wolff III (17:02)
Re: Optimisation of INTERSECT expressions Phil Endecott (16:28)
Re: Benchmarking postgres on Solaris/Linux Josh Berkus (16:17)
Re: atrocious update performance Rosser Schwarz (16:08)
Re: Optimisation of INTERSECT expressions Tom Lane (15:48)
Re: Optimisation of INTERSECT expressions Stephan Szabo (15:14)
Re: Optimisation of INTERSECT expressions Stephan Szabo (14:50)
Optimisation of INTERSECT expressions Phil Endecott (14:12)
Re: [ADMIN] Databases Vs. Schemas Adam Ruth (13:54)
Re: Databases Vs. Schemas CoL (11:25)
Re: Benchmarking postgres on Solaris/Linux Mark Kirkwood (05:38)
Re: Benchmarking postgres on Solaris/Linux Josh Berkus (05:20)
Re: Databases Vs. Schemas Josh Berkus (05:20)
Re: severe performance issue with planner Eric Brown (01:30)
Benchmarking postgres on Solaris/Linux Subbiah, Stalin (00:05)
22 March 2004
Databases Vs. Schemas Subbiah, Stalin (21:30)
Databases Vs. Schemas Subbiah, Stalin (21:00)
Re: two seperate queries run faster than queries ORed Tom Lane (20:44)
Re: two seperate queries run faster than queries ORed together Joseph Shraibman (19:39)
Re: two seperate queries run faster than queries ORed Stephan Szabo (19:32)
Re: two seperate queries run faster than queries ORed together Joseph Shraibman (19:00)
Re: two seperate queries run faster than queries ORed together Tom Lane (18:24)
Re: two seperate queries run faster than queries ORed together Joseph Shraibman (17:55)
Re: [HACKERS] fsync method checking Bruce Momjian (17:42)
Re: [HACKERS] fsync method checking Tom Lane (17:41)
Re: [HACKERS] fsync method checking markw (17:34)
Re: two seperate queries run faster than queries ORed together Richard Huxton (16:55)
Re: atrocious update performance Greg Spiegelberg (14:08)
20 March 2004
Re: string casting for index usage Michael Adler (00:17)
19 March 2004
Re: vacuum performance Tom Lane (06:18)
vacuum performance Alan Stange (04:23)
Re: [HACKERS] fsync method checking Bruce Momjian (04:08)
Re: severe performance issue with planner (fwd) Eric Brown (01:59)
Re: severe performance issue with planner (fwd) Eric Brown (01:34)
Re: [HACKERS] fsync method checking Kevin Brown (00:41)
18 March 2004
Re: [HACKERS] fsync method checking Kurt Roeckx (21:09)
Re: [HACKERS] fsync method checking Tom Lane (21:04)
Re: [HACKERS] fsync method checking Tom Lane (21:01)
Re: [HACKERS] fsync method checking Bruce Momjian (20:49)
Re: [HACKERS] fsync method checking Josh Berkus (20:40)
Re: string casting for index usage Tom Lane (20:39)
Re: [HACKERS] fsync method checking Bruce Momjian (20:34)
Re: [HACKERS] fsync method checking Kurt Roeckx (20:26)
Re: [HACKERS] fsync method checking Tom Lane (20:20)
Re: [HACKERS] fsync method checking Bruce Momjian (20:09)
Re: [HACKERS] fsync method checking Tom Lane (20:09)