Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2003-06 Chronological Index (1/2)
Last updated: Wed Jan 18 04:23:06 2012
209 messages
28 June 2003
Re: 'best practises' to speed up sorting? tuning postgresql.conf Shridhar Daithankar (11:38)
'best practises' to speed up sorting? tuning postgresql.conf Chris Hutchinson (11:32)
Re: Large querie with several EXISTS which will be often runned Shridhar Daithankar (09:36)
RE : Large querie with several EXISTS which will be often runned Bruno BAGUETTE (09:26)
27 June 2003
Re: Memory question Arjen van der Meijden (20:55)
Re: Memory question Arjen van der Meijden (20:49)
Re: Memory question Matthew Hixson (20:31)
Re: Memory question Jord Tanner (20:17)
Re: Memory question Patrick Hatcher (20:06)
Re: Memory question Patrick Hatcher (20:05)
Re: Memory question Josh Berkus (19:56)
Re: Memory question scott.marlowe (19:51)
Memory question Patrick Hatcher (19:16)
Re: Large querie with several EXISTS which will be often runned Josh Berkus (15:43)
Large querie with several EXISTS which will be often runned Bruno BAGUETTE (14:31)
Re: problem with pg_statistics Manfred Koizar (10:05)
Re: problem with pg_statistics Andre Schubert (09:11)
Re: problem with pg_statistics Manfred Koizar (08:43)
Re: problem with pg_statistics Andre Schubert (06:13)
Re: problem with pg_statistics Andre Schubert (06:07)
26 June 2003
Re: problem with pg_statistics Manfred Koizar (15:52)
Re: Similar querys, better execution time on worst execution plan SZUCS Gábor (15:06)
Re: problem with pg_statistics Tom Lane (14:08)
Re: Similar querys, better execution time on worst execution plan Fernando Papa (13:33)
problem with pg_statistics Andre Schubert (13:15)
Re: Performance advice Manfred Koizar (12:50)
Re: Similar querys, better execution time on worst execution plan SZUCS Gábor (10:30)
25 June 2003
Re: Query running slower than same on Oracle Tom Lane (21:50)
Query running slower than same on Oracle Sailer, Denis (YBUSA-CDR) (21:33)
Similar querys, better execution time on worst execution plan Fernando Papa (19:26)
Re: How to optimize monstrous query, sorts instead of using index Tom Lane (16:39)
Re: How to optimize monstrous query, sorts instead of Tom Lane (15:55)
Re: How to optimize monstrous query, sorts instead of Michael Mattox (15:09)
Re: How to optimize monstrous query, sorts instead of using index Michael Mattox (14:48)
Re: How to optimize monstrous query, sorts instead of SZUCS Gábor (14:30)
Re: How to optimize monstrous query, sorts instead of Rod Taylor (14:28)
Re: How to optimize monstrous query, sorts instead of using index SZUCS Gábor (14:22)
Re: How to optimize monstrous query, sorts instead of Michael Mattox (14:10)
Re: How to optimize monstrous query, sorts instead of Rod Taylor (13:35)
Re: Performance advice pgsql (13:03)
Re: How to optimize monstrous query, sorts instead of Michael Mattox (12:48)
Re: How to optimize monstrous query, sorts instead of Rod Taylor (12:12)
Re: How to optimize monstrous query, sorts instead of using index Michael Mattox (12:00)
Re: How to optimize monstrous query, sorts instead of using index Rod Taylor (11:54)
Re: Performance advice Paul Thomas (11:52)
How to optimize monstrous query, sorts instead of using index Michael Mattox (11:46)
Re: Performance advice Achilleus Mantzios (11:30)
Re: Performance advice Rod Taylor (11:09)
Re: Performance advice Rod Taylor (11:06)
Re: Performance advice Shridhar Daithankar (09:59)
Re: Performance advice Michael Mattox (09:47)
Re: Performance advice Howard Oblowitz (09:05)
Re: Performance advice Hilary Forbes (08:12)
Re: Performance advice Manfred Koizar (06:51)
Re: Performance advice Michael Mattox (06:48)
24 June 2003
Re: Performance advice Josh Berkus (16:05)
Re: Performance advice Michael Mattox (15:47)
Re: Performance advice Tom Lane (14:19)
Re: Performance advice Michael Mattox (12:16)
Re: Performance advice Richard Huxton (11:33)
Re: Performance advice Shridhar Daithankar (09:03)
Re: Performance advice Achilleus Mantzios (08:54)
Re: Performance advice Shridhar Daithankar (08:20)
Re: Performance advice Shridhar Daithankar (08:00)
Performance advice Michael Mattox (07:39)
23 June 2003
20 June 2003
Re: Deleting one record from a table taking 17s. Yusuf (17:06)
Re: Deleting one record from a table taking 17s. Tom Lane (16:59)
Re: Deleting one record from a table taking 17s. Rod Taylor (16:06)
Deleting one record from a table taking 17s. Yusuf (15:53)
18 June 2003
Re: Recent 7.4 change slowed down a query by a factor of 3 Bruno Wolff III (15:50)
Re: Recent 7.4 change slowed down a query by a factor of 3 Bruno Wolff III (15:42)
Re: Recent 7.4 change slowed down a query by a factor of 3 Bruno Wolff III (15:40)
Re: Recent 7.4 change slowed down a query by a factor of 3 Tom Lane (15:18)
Recent 7.4 change slowed down a query by a factor of 3 Bruno Wolff III (14:59)
Re: Postgres Connections Requiring Large Amounts of Memory SZÅCS GÃbor (07:10)
Re: Interesting incosistent query timing Tom Lane (00:12)
17 June 2003
Re: Postgres Connections Requiring Large Amounts of Memory Dawn Hollingsworth (23:05)
Re: Interesting incosistent query timing Ernest E Vogelsinger (23:01)
Re: Interesting incosistent query timing nikolaus (22:45)
Re: Postgres Connections Requiring Large Amounts of Memory Tom Lane (22:03)
Re: Postgres Connections Requiring Large Amounts of Memory Dawn Hollingsworth (21:44)
Re: Postgres Connections Requiring Large Amounts of Memory Tom Lane (19:38)
Re: Postgres Connections Requiring Large Amounts of Memory Dawn Hollingsworth (18:48)
Re: Limiting Postgres memory usage Shridhar Daithankar (10:26)
Limiting Postgres memory usage Howard Oblowitz (10:00)
approve xec5mm unsubscribe pgsql-performance jgimenez(at)sipec(dot)es Jordi Giménez (07:41)
Re: Interesting incosistent query timing Ernest E Vogelsinger (02:55)
Re: Interesting incosistent query timing Nikolaus Dilger (02:21)
16 June 2003
Interesting incosistent query timing Ernest E Vogelsinger (22:47)
Re: sequential scans on few columns tables Jim C. Nasby (22:45)
Re: left join performance problem Jim C. Nasby (22:41)
Re: Partial index where clause not filtering through Tom Lane (22:39)
Re: Partial index where clause not filtering through Jim C. Nasby (22:32)
Re: Postgres Connections Requiring Large Amounts of Memory Tom Lane (21:34)
Re: Postgres Connections Requiring Large Amounts of Memory Dawn Hollingsworth (20:59)
Re: Postgres Connections Requiring Large Amounts of Memory Tom Lane (20:45)
Postgres Connections Requiring Large Amounts of Memory Dawn Hollingsworth (20:34)
Re: sequential scans on few columns tables Tomasz Myrta (20:32)
Re: sequential scans on few columns tables Bruno Wolff III (19:53)
sequential scans on few columns tables Tomasz Myrta (19:49)
Re: functional indexes instead of regular index on field(s)? Bruno Wolff III (17:56)
functional indexes instead of regular index on field(s)? Tomaz Borstnar (17:39)
Re: A bit OT- RE: Re-ordering .CONF params ... questions for this list Josh Berkus (16:31)
Re: 7.3 vs 7.2 - different query plan, bad performance Tom Lane (14:17)
Re: Partial index where clause not filtering through Tom Lane (14:11)
Re: 7.3 vs 7.2 - different query plan, bad performance Ryszard Lach (13:55)
Re: left join performance problem Tom Lane (13:26)
Re: 7.3 vs 7.2 - different query plan, bad performance Manfred Koizar (13:25)
Re: 7.3 vs 7.2 - different query plan, bad performance Ryszard Lach (11:41)
Re: 7.3 vs 7.2 - different query plan, bad performance Manfred Koizar (10:31)
Re: left join performance problem Bruno Wolff III (08:04)
Re: any way to use indexscan to get last X values Shridhar Daithankar (07:23)
Re: any way to use indexscan to get last X values Tomaz Borstnar (07:09)
Re: 7.3 vs 7.2 - different query plan, bad performance siaco (06:40)
Re: Partial index where clause not filtering through Jim C. Nasby (06:25)
Re: any way to use indexscan to get last X values Shridhar Daithankar (06:16)
Re: Partial index where clause not filtering through Tom Lane (05:43)
Re: left join performance problem Jim C. Nasby (05:36)
Partial index where clause not filtering through Jim C. Nasby (05:31)
Re: left join performance problem Tom Lane (05:28)
Re: tweaking costs to favor nestloop Jim C. Nasby (05:17)
Re: left join performance problem Jim C. Nasby (05:10)
15 June 2003
Re: any way to use indexscan to get last X values Tomaz Borstnar (22:38)
Re: 7.3 vs 7.2 - different query plan, bad performance Manfred Koizar (19:48)
Re: any way to use indexscan to get last X values with "order by Y limit X" clause? Tom Lane (16:53)
Re: any way to use indexscan to get last X values with Stephan Szabo (16:33)
Re: any way to use indexscan to get last X values Tomaz Borstnar (15:17)
Re: any way to use indexscan to get last X values with "order by Y limit X" clause? Shridhar Daithankar (14:32)
any way to use indexscan to get last X values with "order by Y limit X" clause? Tomaz Borstnar (14:26)
14 June 2003
13 June 2003
Re: Re-ordering .CONF params ... questions for this list Nick Fankhauser (22:33)
Re: 7.3 vs 7.2 - different query plan, bad performance Bruno Wolff III (18:51)
7.3 vs 7.2 - different query plan, bad performance Ryszard Lach (18:45)
Re: tweaking costs to favor nestloop Tom Lane (14:07)
Re: tweaking costs to favor nestloop Vincent van Leeuwen (12:39)
Adjusting fsm values was Re: [BUGS] db growing out of proportion Robert Creager (03:50)
12 June 2003
Re: Table Relationships Andreas Kostyrka (09:32)
Re: left join performance problem pginfo (05:52)
Re: left join performance problem Tom Lane (02:58)
11 June 2003
tweaking costs to favor nestloop Vincent van Leeuwen (19:33)
left join performance problem pginfo (16:43)
Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Bruce Momjian (03:52)
10 June 2003
Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Vincent van Leeuwen (23:10)
Re: Re-ordering .CONF params ... questions for this list Josh Berkus (21:46)
Re: Re-ordering .CONF params ... questions for this list Josh Berkus (21:30)
Re: Re-ordering .CONF params ... questions for this list Tom Lane (21:28)
Re: Re-ordering .CONF params ... questions for this list Josh Berkus (20:58)
Re: Hash or merge join instead of inner loop Tom Lane (20:56)
Re: Re-ordering .CONF params ... questions for this list Joe Conway (20:07)
Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Tom Lane (19:43)
Re: Hash or merge join instead of inner loop Jim C. Nasby (19:42)
Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Bruce Momjian (19:08)
Re: Re-ordering .CONF params ... questions for this list Richard Huxton (19:05)
Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Josh Berkus (18:28)
Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Vincent van Leeuwen (18:13)
Re-ordering .CONF params ... questions for this list Josh Berkus (18:02)
Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Bruno Wolff III (17:19)
Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Josh Berkus (16:05)
Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Shridhar Daithankar (15:57)
Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Josh Berkus (15:48)