Search

Peripheral Links

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

pgsql-performance - October 2004

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

Prev | Next

2004-10-01

• Re: Caching of Queries Matt Clark (05:43)
• inconsistent/weird index usage Dustin Sallings (06:30)
• Re: inconsistent/weird index usage John Meinel (13:53)
• Re: inconsistent/weird index usage Tom Lane (14:38)
• Re: inconsistent/weird index usage Richard Huxton (14:43)
• Re: Caching of Queries Jim C. Nasby (15:13)
• Re: Caching of Queries Matt Clark (15:46)
• Re: inconsistent/weird index usage Josh Berkus (16:29)
• Re: inconsistent/weird index usage Tom Lane (16:34)
• Re: Caching of Queries Josh Berkus (17:10)
• Slow update/insert process Patrick Hatcher (18:14)
• Re: Slow update/insert process Aaron Werman (19:48)
• Query planner problem Ryan VanMiddlesworth (22:06)

2004-10-02

• Re: Caching of Queries Aaron Werman (03:13)
• Re: Caching of Queries Josh Berkus (20:04)
• Re: Caching of Queries William Yu (20:47)
• Re: Query planner problem Russell Smith (22:50)
• Re: Caching of Queries Josh Berkus (22:50)
• Re: inconsistent/weird index usage Hannu Krosing (23:20)
• Re: Query planner problem Tom Lane (23:21)
• Re: inconsistent/weird index usage Tom Lane (23:44)

2004-10-03

• Re: Caching of Queries Pierre-Frédéric Caillaud (13:20)
• Re: Caching of Queries Pierre-Frédéric Caillaud (13:27)
• Re: Caching of Queries Pierre-Frédéric Caillaud (13:30)
• Re: Caching of Queries Tatsuo Ishii (15:28)
• Re: index not used when using function Pierre-Frédéric Caillaud (15:29)
• Re: Query planner problem Greg Stark (21:56)

2004-10-04

• Re: Slow update/insert process Patrick Hatcher (17:14)
• Re: Performance suggestions for an update-mostly database? Josh Berkus (17:38)
• Performance suggestions for an update-mostly database? Steve Atkins (17:40)
• Re: Performance suggestions for an update-mostly database? Steve Atkins (18:00)
• Re: Performance suggestions for an update-mostly database? Josh Berkus (19:02)
• Re: Caching of Queries Jim C. Nasby (19:18)
• Re: Performance suggestions for an update-mostly database? Jim C. Nasby (19:22)
• would number of fields in a table affect search-query time? Miles Keaton (23:27)
• Re: would number of fields in a table affect search-query time? Tom Lane (23:32)
• Re: would number of fields in a table affect search-query time? Steinar H. Gunderson (23:34)

2004-10-05

• Re: would number of fields in a table affect search-query time? Josh Berkus (02:06)
• Re: Comparing user attributes with bitwise operators Patrick Clery (06:39)
• EXPLAIN ANALYZE much slower than running query normally Chris Hutchinson (06:49)
• Re: Caching of Queries Matt Clark (15:35)
• Excessive context switching on SMP Xeons Bill Montgomery (16:21)
• Re: Comparing user attributes with bitwise operators Josh Berkus (16:32)
• Re: Excessive context switching on SMP Xeons Josh Berkus (16:47)
• Re: Excessive context switching on SMP Xeons Gaetano Mendola (21:08)
• Re: Excessive context switching on SMP Xeons Bill Montgomery (21:08)
• Re: Excessive context switching on SMP Xeons Josh Berkus (22:38)
• slow rule on update Janning Vygen (22:55)

2004-10-06

• Planner picks the wrong plan? Nichlas Löfdahl (00:42)
• test post Max Baker (03:24)
• Re: Planner picks the wrong plan? Tom Lane (03:29)
• Re: Excessive context switching on SMP Xeons Alan Stange (03:59)
• why my query is not using index?? HyunSung Jang (07:31)
• Re: Excessive context switching on SMP Xeons Greg Stark (07:44)
• sequential scan on select distinct Ole Langbehn (09:30)
• stats on cursor and query execution troubleshooting Alban Médici (NetCentrex) (10:15)
• Re: sequential scan on select distinct Pierre-Frédéric Caillaud (10:19)
• Re: Excessive context switching on SMP Xeons Alan Stange (13:11)
• Re: [PERFORM] stats on cursor and query execution troubleshooting Tom Lane (14:16)
• Re: Excessive context switching on SMP Xeons Bill Montgomery (15:45)
• Re: sequential scan on select distinct Ole Langbehn (16:09)
• Re: sequential scan on select distinct Greg Stark (16:41)
• Re: Excessive context switching on SMP Xeons SZUCS Gábor (17:28)
• Re: sequential scan on select distinct Pierre-Frédéric Caillaud (17:34)
• Re: Comparing user attributes with bitwise operators Patrick Clery (18:55)
• Re: Comparing user attributes with bitwise operators Patrick Clery (19:27)
• Re: sequential scan on select distinct Tom Lane (19:38)
• Re: Comparing user attributes with bitwise operators Greg Stark (19:38)
• Re: sequential scan on select distinct Greg Stark (20:02)
• The never ending quest for clarity on shared_buffers Doug Y (20:04)
• Re: sequential scan on select distinct Tom Lane (20:20)
• Data warehousing requirements Gabriele Bartolini (21:36)
• Re: The never ending quest for clarity on shared_buffers Paul Ramsey (22:26)
• Re: Excessive context switching on SMP Xeons Gaetano Mendola (23:48)

2004-10-07

• Re: Caching of Queries Tatsuo Ishii (01:08)
• Re: The never ending quest for clarity on shared_buffers Neil Conway (01:29)
• Re: Caching of Queries Tom Lane (03:12)
• Re: Excessive context switching on SMP Xeons Alan Stange (03:14)
• Re: Caching of Queries Tatsuo Ishii (07:18)
• Re: Data warehousing requirements Aaron Werman (11:30)
• Re: sequential scan on select distinct Pierre-Frédéric Caillaud (12:01)
• Re: sequential scan on select distinct Tom Lane (15:35)
• Re: Excessive context switching on SMP Xeons Bill Montgomery (15:48)
• Re: Data warehousing requirements Gabriele Bartolini (17:07)
• Re: sequential scan on select distinct Greg Stark (17:08)
• Re: sequential scan on select distinct Ole Langbehn (17:21)
• Re: sequential scan on select distinct Tom Lane (17:26)
• Re: Excessive context switching on SMP Xeons Michael Adler (18:15)
• Re: Excessive context switching on SMP Xeons Alan Stange (18:28)
• Re: Excessive context switching on SMP Xeons Bill Montgomery (18:48)
• Re: sequential scan on select distinct Mischa Sandberg (20:00)
• Re: Data warehousing requirements Josh Berkus (22:50)

2004-10-08

• Re: Data warehousing requirements Aaron Werman (01:19)
• Re: Data warehousing requirements Tom Lane (02:43)
• Re: Data warehousing requirements Josh Berkus (05:53)
• Re: [PERFORM] stats on cursor and query execution troubleshooting Alban Médici (NetCentrex) (08:47)
• Re: sequential scan on select distinct Pierre-Frédéric Caillaud (08:54)
• integer[] indexing. Dawid Kuroczko (09:11)
• Re: integer[] indexing. Pierre-Frédéric Caillaud (09:29)
• Re: sequential scan on select distinct Pierre-Frédéric Caillaud (09:57)
• COPY slows down? Mike Harding (12:10)
• Re: integer[] indexing. Harald Fuchs (12:28)
• Re: Re: Data warehousing requirements simon (12:38)
• Re: [PERFORM] stats on cursor and query execution troubleshooting Tom Lane (13:55)
• Re: integer[] indexing. Tom Lane (14:03)
• Re: Re: Re: Data warehousing requirements Tom Lane (14:22)
• Query Tuning Pallav Kalva (14:49)
• Re: Query Tuning Tom Lane (16:42)
• Re: Query Tuning Pallav Kalva (17:29)
• Odd planner choice? Gary Doades (19:32)
• Re: Odd planner choice? Gary Doades (19:46)
• Re: Odd planner choice? Tom Lane (20:04)
• Re: Odd planner choice? Gary Doades (20:29)
• First set of OSDL Shared Mem scalability results, some wierdness ... Josh Berkus (21:43)
• Re: First set of OSDL Shared Mem scalability results, J. Andrew Rogers (22:13)
• Re: First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane (22:21)
• Re: First set of OSDL Shared Mem scalability results, Tom Lane (22:32)
• Re: First set of OSDL Shared Mem scalability results, Steinar H. Gunderson (22:39)
• Re: First set of OSDL Shared Mem scalability results, Josh Berkus (23:08)
• Re: First set of OSDL Shared Mem scalability results, some wierdness ... Josh Berkus (23:31)

2004-10-09

• Re: First set of OSDL Shared Mem scalability results, some wierdness ... Christopher Browne (02:10)
• Re: First set of OSDL Shared Mem scalability results, some wierdness ... Kevin Brown (11:20)
• Re: First set of OSDL Shared Mem scalability results, some Matthew (15:02)
• Re: First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane (15:07)
• Re: First set of OSDL Shared Mem scalability results, some wierdness ... Kevin Brown (20:37)
• Re: First set of OSDL Shared Mem scalability results, some wierdness ... Kevin Brown (21:01)
• Re: First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane (23:05)

2004-10-10

• kernel 2.6 synchronous directory Gaetano Mendola (09:19)
• Re: First set of OSDL Shared Mem scalability results, some wierdness Gaetano Mendola (09:25)
• Re: First set of OSDL Shared Mem scalability results, some Dennis Bjorklund (21:48)

2004-10-11

• Views, joins and LIMIT Dawid Kuroczko (09:54)
• Re: EXPLAIN ANALYZE much slower than running query normally Janning Vygen (12:15)
• Re: why my query is not using index?? Janning Vygen (12:25)
• Re: Views, joins and LIMIT Tom Lane (14:14)
• Re: COPY slows down? Tom Lane (14:22)
• Re: why my query is not using index?? Tom Lane (14:26)
• Re: [PERFORM] stats on cursor and query execution Alban Médici (NetCentrex) (15:39)
• IBM P-series machines (was: Excessive context switching on SMP Xeons) Andrew Sullivan (17:38)
• Re: IBM P-series machines (was: Excessive context Rod Taylor (18:20)
• Re: why my query is not using index?? Francisco Reyes (20:49)
• Understanding explains Francisco Reyes (21:04)
• Normal case or bad query plan? Gabriele Bartolini (21:05)
• Re: Normal case or bad query plan? Kris Jurka (21:17)
• Re: why my query is not using index?? Janning Vygen (21:26)
• Re: Normal case or bad query plan? Tom Lane (21:33)
• Re: Understanding explains Rosser Schwarz (22:03)
• TestPerf Project started Josh Berkus (23:52)

2004-10-12

• Re: why my query is not using index?? John Meinel (00:12)
• Re: EXPLAIN ANALYZE much slower than running query normally Tom Lane (00:28)
• Re: why my query is not using index?? Greg Stark (01:13)
• Re: IBM P-series machines (was: Excessive context Christopher Browne (01:34)
• Re: why my query is not using index?? Francisco Reyes (04:56)
• Re: Understanding explains Francisco Reyes (04:59)
• Re: Normal case or bad query plan? Gabriele Bartolini (05:26)
• Re: why my query is not using index?? Tom Lane (05:26)
• Re: Normal case or bad query plan? Tom Lane (05:45)
• Re: IBM P-series machines Matt Clark (06:53)
• Re: execute cursor fetch my ho (11:43)
• Re: Normal case or bad query plan? Aaron Werman (12:20)
• Re: execute cursor fetch Pierre-Frédéric Caillaud (12:36)
• Re: execute cursor fetch Stef (13:05)
• Re: execute cursor fetch Tom Lane (14:07)
• Re: Normal case or bad query plan? Gabriele Bartolini (14:29)
• Re: Normal case or bad query plan? Steinar H. Gunderson (14:40)
• Which plattform do you recommend I run PostgreSQL for best performance? nd02tsk (15:45)
• Re: Which plattform do you recommend I run PostgreSQL for Matt Clark (15:47)
• Re: Which plattform do you recommend I run PostgreSQL for Francisco Reyes (16:27)
• Re: Normal case or bad query plan? Mischa Sandberg (16:56)
• Re: Which plattform do you recommend I run PostgreSQL for best performance? Christopher Browne (20:02)
• Re: Which plattform do you recommend I run PostgreSQL for best performance? Josh Berkus (20:32)

2004-10-13

• Re: Caching of Queries Bruce Momjian (01:02)
• Re: Which plattform do you recommend I run PostgreSQL for best CoL (08:46)
• query problem Robin Ericsson (09:21)
• Re: query problem ken (14:37)
• Re: query problem Tom Lane (15:03)
• Opteron vs RHAT Chris Browne (15:52)
• Re: query problem Robin Ericsson (16:01)
• Free PostgreSQL Training, Philadelphia, Oct 30 Aaron Mulder (16:21)
• Re: Free PostgreSQL Training, Philadelphia, Oct 30 Bryan Encina (16:23)
• Re: [PERFORM] query problem Robin Ericsson (16:27)
• Re: [PERFORM] query problem Robin Ericsson (16:36)
• [Fwd: Re: [GENERAL] query problem] Robin Ericsson (16:36)
• Re: Opteron vs RHAT Matt Clark (16:47)
• futex results with dbt-3 Mark Wong (18:57)
• Re: Free PostgreSQL Training, Philadelphia, Oct 30 Aaron Glenn (20:10)
• Re: Free PostgreSQL Training, Philadelphia, Oct 30 Josh Berkus (22:36)

2004-10-14

• Re: First set of OSDL Shared Mem scalability results, some Jan Wieck (00:49)
• Re: First set of OSDL Shared Mem scalability results, some Jan Wieck (00:52)
• Re: futex results with dbt-3 Neil Conway (02:30)
• Re: Free PostgreSQL Training, Philadelphia, Oct 30 Bruce Momjian (03:47)
• Re: First set of OSDL Shared Mem scalability results, some Greg Stark (03:52)
• Re: First set of OSDL Shared Mem scalability results, some Jan Wieck (04:17)
• Re: First set of OSDL Shared Mem scalability results, some Greg Stark (04:22)
• Re: First set of OSDL Shared Mem scalability results, some Jan Wieck (04:29)
• Performance on Win32 vs Cygwin MikeSmialek2@Hotmail.com (17:01)
• Re: Performance on Win32 vs Cygwin Magnus Hagander (17:29)
• Performance vs Schemas Igor Maciel Macaubas (18:38)
• Re: Performance vs Schemas Gregory S. Williamson (18:45)
• Re: Performance vs Schemas Aaron Werman (19:27)
• Re: Performance on Win32 vs Cygwin Reini Urban (19:40)

Prev | Next