pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedslower with the time
2003-07-01 07:47 UTC Juraj Porada <porada@pe-muc.de>
` Re: slower with the time
2003-07-01 07:48 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: slower with the time
2003-07-01 08:10 UTC Juraj Porada <porada@pe-muc.de>
` Re: slower with the time
2003-07-01 08:17 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
[4+ messages in thread]
Query planner plans very inefficient plans
2003-06-30 17:57 UTC Robert Wille <a2om6sy02@sneakemail.com>
` Re: Query planner plans very inefficient plans
2003-06-30 19:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query planner plans very inefficient plans
2003-06-30 21:13 UTC Sean Chittenden <sean@chittenden.org>
[3+ messages in thread]
'best practises' to speed up sorting? tuning postgresql.conf
2003-06-28 11:31 UTC Chris Hutchinson <chris@hutchinsonsoftware.com>
` Re: 'best practises' to speed up sorting? tuning postgresql.conf
2003-06-28 11:37 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: 'best practises' to speed up sorting? tuning postgresql.conf
2003-06-28 11:58 UTC Arjen van der Meijden <acm@tweakers.net>
[3+ messages in thread]
Large querie with several EXISTS which will be often runned
2003-06-27 14:32 UTC Bruno BAGUETTE <pgsql-ml@baguette.net>
` Re: Large querie with several EXISTS which will be often runned
2003-06-27 15:41 UTC Josh Berkus <josh@agliodbs.com>
` Re: Large querie with several EXISTS which will be often runned
2003-06-28 09:35 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
[3+ messages in thread]
RE : Large querie with several EXISTS which will be often runned
2003-06-28 09:17 UTC Bruno BAGUETTE <pgsql-ml@baguette.net>
problem with pg_statistics
2003-06-26 13:15 UTC Andre Schubert <andre@km3.de>
` Re: problem with pg_statistics
2003-06-26 14:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem with pg_statistics
2003-06-26 15:51 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: problem with pg_statistics
2003-06-26 16:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: problem with pg_statistics
2003-06-27 06:07 UTC Andre Schubert <andre.schubert@km3.de>
` Re: problem with pg_statistics
2003-06-27 06:13 UTC Andre Schubert <andre.schubert@km3.de>
` Re: problem with pg_statistics
2003-06-27 08:43 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: problem with pg_statistics
2003-06-27 09:10 UTC Andre Schubert <andre@km3.de>
` Re: problem with pg_statistics
2003-06-27 10:05 UTC Manfred Koizar <mkoi-pg@aon.at>
[9+ messages in thread]
Similar querys, better execution time on worst execution plan
2003-06-25 19:25 UTC Fernando Papa <fpapa@claxson.com>
` Re: Similar querys, better execution time on worst execution plan
2003-06-26 10:30 UTC SZUCS Gábor <surrano@mailbox.hu>
` Re: Similar querys, better execution time on worst execution plan
2003-06-26 13:33 UTC Fernando Papa <fpapa@claxson.com>
` Re: Similar querys, better execution time on worst execution plan
2003-06-26 15:06 UTC SZUCS Gábor <surrano@mailbox.hu>
[4+ messages in thread]
Performance advice
2003-06-24 07:39 UTC Michael Mattox <michael.mattox@verideon.com>
` Re: Performance advice
2003-06-24 07:59 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Performance advice
2003-06-24 08:19 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Performance advice
2003-06-24 09:02 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Performance advice
2003-06-24 11:33 UTC Richard Huxton <dev@archonet.com>
` Re: Performance advice
2003-06-24 12:16 UTC Michael Mattox <michael.mattox@verideon.com>
` Re: Performance advice
2003-06-24 14:10 UTC Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: Performance advice
2003-06-24 14:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance advice
2003-06-24 15:47 UTC Michael Mattox <michael.mattox@verideon.com>
` Re: Performance advice
2003-06-24 16:04 UTC Josh Berkus <josh@agliodbs.com>
` Re: Performance advice
2003-06-24 17:00 UTC Rod Taylor <rbt@rbt.ca>
` Re: Performance advice
2003-06-25 06:48 UTC Michael Mattox <michael.mattox@verideon.com>
` Re: Performance advice
2003-06-25 06:51 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: Performance advice
2003-06-25 08:12 UTC Hilary Forbes <hforbes@dmr.co.uk>
` Re: Performance advice
2003-06-25 08:58 UTC Howard Oblowitz <HowardO@LEWIS-STORES.com>
` Re: Performance advice
2003-06-25 09:47 UTC Michael Mattox <michael.mattox@verideon.com>
` Re: Performance advice
2003-06-25 09:58 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Performance advice
2003-06-25 11:06 UTC Rod Taylor <rbt@rbt.ca>
` Re: Performance advice
2003-06-25 11:09 UTC Rod Taylor <rbt@rbt.ca>
` Re: Performance advice
2003-06-25 11:52 UTC Paul Thomas <paul@tmsl.demon.co.uk>
` Re: Performance advice
2003-06-25 13:04 UTC pgsql@newtopia.com
` Re: Performance advice
2003-06-25 16:32 UTC Achilleus Mantzios <achill@matrix.gatewaynet.com>
` Re: Performance advice
2003-06-26 12:49 UTC Manfred Koizar <mkoi-pg@aon.at>
[23+ messages in thread]
Query running slower than same on Oracle
2003-06-25 21:33 UTC Sailer, Denis (YBUSA-CDR) <Denis.Sailer@Yellowbook.com>
` Re: Query running slower than same on Oracle
2003-06-25 21:50 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query running slower than same on Oracle
2003-06-25 21:51 UTC Josh Berkus <josh@agliodbs.com>
[3+ messages in thread]
Deleting one record from a table taking 17s.
2003-06-20 15:53 UTC Yusuf <yusuf0478@netscape.net>
` Re: Deleting one record from a table taking 17s.
2003-06-20 16:06 UTC Rod Taylor <rbt@rbt.ca>
` Re: Deleting one record from a table taking 17s.
2003-06-20 16:59 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Deleting one record from a table taking 17s.
2003-06-20 17:06 UTC Yusuf <yusuf0478@netscape.net>
` Re: Deleting one record from a table taking 17s.
2003-06-20 22:04 UTC Rod Taylor <rbt@rbt.ca>
[5+ messages in thread]
Recent 7.4 change slowed down a query by a factor of 3
2003-06-18 15:02 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Recent 7.4 change slowed down a query by a factor of 3
2003-06-18 15:18 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Recent 7.4 change slowed down a query by a factor of 3
2003-06-18 15:43 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Recent 7.4 change slowed down a query by a factor of 3
2003-06-18 15:45 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Recent 7.4 change slowed down a query by a factor of 3
2003-06-18 15:53 UTC Bruno Wolff III <bruno@wolff.to>
` Re: Recent 7.4 change slowed down a query by a factor of 3
2003-06-18 16:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Postgres Connections Requiring Large Amounts of Memory
2003-06-16 08:32 UTC Dawn Hollingsworth <dmh@airdefense.net>
` Re: Postgres Connections Requiring Large Amounts of Memory
2003-06-16 08:57 UTC Dawn Hollingsworth <dmh@airdefense.net>
` Re: Postgres Connections Requiring Large Amounts of Memory
2003-06-16 20:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Connections Requiring Large Amounts of Memory
2003-06-16 21:34 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Connections Requiring Large Amounts of Memory
2003-06-17 06:46 UTC Dawn Hollingsworth <dmh@airdefense.net>
` Re: Postgres Connections Requiring Large Amounts of Memory
2003-06-17 09:42 UTC Dawn Hollingsworth <dmh@airdefense.net>
` Re: Postgres Connections Requiring Large Amounts of Memory
2003-06-17 11:03 UTC Dawn Hollingsworth <dmh@airdefense.net>
` Re: Postgres Connections Requiring Large Amounts of Memory
2003-06-17 19:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Connections Requiring Large Amounts of Memory
2003-06-17 22:03 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Connections Requiring Large Amounts of Memory
2003-06-17 23:21 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Postgres Connections Requiring Large Amounts of Memory
2003-06-18 07:11 UTC SZŰCS Gábor <surrano@mailbox.hu>
[11+ messages in thread]
Interesting incosistent query timing
2003-06-16 22:46 UTC Ernest E Vogelsinger <ernest@vogelsinger.at>
` Re: Interesting incosistent query timing
2003-06-16 23:45 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: [PERFORM] Interesting incosistent query timing
2003-06-17 02:20 UTC Nikolaus Dilger <nikolaus@dilger.cc>
` Re: [PERFORM] Interesting incosistent query timing
2003-06-17 02:54 UTC Ernest E Vogelsinger <ernest@vogelsinger.at>
` Re: [PERFORM] Interesting incosistent query timing
2003-06-17 22:45 UTC nikolaus@dilger.cc
` Re: [PERFORM] Interesting incosistent query timing
2003-06-17 23:01 UTC Ernest E Vogelsinger <ernest@vogelsinger.at>
` Re: [PERFORM] Interesting incosistent query timing
2003-06-18 00:12 UTC Tom Lane <tgl@sss.pgh.pa.us>
[7+ messages in thread]
Limiting Postgres memory usage
2003-06-17 09:53 UTC Howard Oblowitz <HowardO@LEWIS-STORES.com>
` Re: Limiting Postgres memory usage
2003-06-17 10:25 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
[2+ messages in thread]
approve xec5mm unsubscribe pgsql-performance jgimenez@sipec.es
2003-06-17 07:43 UTC Jordi Giménez <jgimenez@sipec.es>
sequential scans on few columns tables
2003-06-16 19:49 UTC Tomasz Myrta <jasiek@klaster.net>
` Re: sequential scans on few columns tables
2003-06-16 19:55 UTC Bruno Wolff III <bruno@wolff.to>
` Re: sequential scans on few columns tables
2003-06-16 20:32 UTC Tomasz Myrta <jasiek@klaster.net>
` Re: sequential scans on few columns tables
2003-06-16 22:45 UTC Jim C. Nasby <jim@nasby.net>
[4+ messages in thread]
left join performance problem
2003-06-11 15:35 UTC pginfo <pginfo@t1.unisoftbg.com>
` Re: left join performance problem
2003-06-12 02:57 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: left join performance problem
2003-06-12 04:48 UTC pginfo <pginfo@t1.unisoftbg.com>
` Re: left join performance problem
2003-06-16 05:10 UTC Jim C. Nasby <jim@nasby.net>
` Re: left join performance problem
2003-06-16 05:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: left join performance problem
2003-06-16 05:36 UTC Jim C. Nasby <jim@nasby.net>
` Re: left join performance problem
2003-06-16 08:07 UTC Bruno Wolff III <bruno@wolff.to>
` Re: left join performance problem
2003-06-16 13:26 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: left join performance problem
2003-06-16 22:41 UTC Jim C. Nasby <jim@nasby.net>
[9+ messages in thread]
Partial index where clause not filtering through
2003-06-16 05:31 UTC Jim C. Nasby <jim@nasby.net>
` Re: Partial index where clause not filtering through
2003-06-16 05:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Partial index where clause not filtering through
2003-06-16 06:24 UTC Jim C. Nasby <jim@nasby.net>
` Re: Partial index where clause not filtering through
2003-06-16 14:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Partial index where clause not filtering through
2003-06-16 22:32 UTC Jim C. Nasby <jim@nasby.net>
` Re: Partial index where clause not filtering through
2003-06-16 22:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
functional indexes instead of regular index on field(s)?
2003-06-16 17:38 UTC Tomaz Borstnar <tomaz.borstnar@over.net>
` Re: functional indexes instead of regular index on field(s)?
2003-06-16 17:58 UTC Bruno Wolff III <bruno@wolff.to>
[2+ messages in thread]
A bit OT- RE: [PERFORM] Re-ordering .CONF params ... questions for this list
2003-06-14 14:40 UTC Nick Fankhauser <nickf@ontko.com>
` Re: A bit OT- RE: [PERFORM] Re-ordering .CONF params ... questions for this list
2003-06-16 16:28 UTC Josh Berkus <josh@agliodbs.com>
[2+ messages in thread]
7.3 vs 7.2 - different query plan, bad performance
2003-06-13 18:45 UTC Ryszard Lach <siaco@autograf.pl>
` Re: 7.3 vs 7.2 - different query plan, bad performance
2003-06-13 18:54 UTC Bruno Wolff III <bruno@wolff.to>
` Re: 7.3 vs 7.2 - different query plan, bad performance
2003-06-15 19:48 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: 7.3 vs 7.2 - different query plan, bad performance
2003-06-16 06:38 UTC siaco@allegro.pl
` Re: 7.3 vs 7.2 - different query plan, bad performance
2003-06-16 10:31 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: 7.3 vs 7.2 - different query plan, bad performance
2003-06-16 11:41 UTC Ryszard Lach <siaco@autograf.pl>
` Re: 7.3 vs 7.2 - different query plan, bad performance
2003-06-16 13:24 UTC Manfred Koizar <mkoi-pg@aon.at>
` Re: 7.3 vs 7.2 - different query plan, bad performance
2003-06-16 13:55 UTC Ryszard Lach <siaco@autograf.pl>
` Re: 7.3 vs 7.2 - different query plan, bad performance
2003-06-16 14:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
[9+ messages in thread]
any way to use indexscan to get last X values with "order by Y limit X" clause?
2003-06-15 14:26 UTC Tomaz Borstnar <tomaz.borstnar@over.net>
` Re: any way to use indexscan to get last X values with "order by Y limit X" clause?
2003-06-15 14:31 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: any way to use indexscan to get last X values
2003-06-15 15:17 UTC Tomaz Borstnar <tomaz.borstnar@over.net>
` Re: any way to use indexscan to get last X values with
2003-06-15 16:33 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: any way to use indexscan to get last X values with "order by Y limit X" clause?
2003-06-15 16:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: any way to use indexscan to get last X values
2003-06-15 22:37 UTC Tomaz Borstnar <tomaz.borstnar@over.net>
` Re: any way to use indexscan to get last X values
2003-06-15 23:21 UTC Tomaz Borstnar <tomaz.borstnar@over.net>
` Re: any way to use indexscan to get last X values
2003-06-16 06:15 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: any way to use indexscan to get last X values
2003-06-16 07:08 UTC Tomaz Borstnar <tomaz.borstnar@over.net>
` Re: any way to use indexscan to get last X values
2003-06-16 07:22 UTC Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
[10+ messages in thread]
tweaking costs to favor nestloop
2003-06-11 19:33 UTC Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: tweaking costs to favor nestloop
2003-06-11 20:17 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: tweaking costs to favor nestloop
2003-06-13 12:39 UTC Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: tweaking costs to favor nestloop
2003-06-13 14:07 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: tweaking costs to favor nestloop
2003-06-16 05:17 UTC Jim C. Nasby <jim@nasby.net>
[5+ messages in thread]
Re-ordering .CONF params ... questions for this list
2003-06-10 18:01 UTC Josh Berkus <josh@agliodbs.com>
` Re: Re-ordering .CONF params ... questions for this list
2003-06-10 19:05 UTC Richard Huxton <richardh@archonet.com>
` Re: Re-ordering .CONF params ... questions for this list
2003-06-10 20:05 UTC Joe Conway <mail@joeconway.com>
` Re: Re-ordering .CONF params ... questions for this list
2003-06-10 20:57 UTC Josh Berkus <josh@agliodbs.com>
` Re: Re-ordering .CONF params ... questions for this list
2003-06-10 21:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Re-ordering .CONF params ... questions for this list
2003-06-10 21:29 UTC Josh Berkus <josh@agliodbs.com>
` Re: Re-ordering .CONF params ... questions for this list
2003-06-10 21:45 UTC Josh Berkus <josh@agliodbs.com>
` Re: Re-ordering .CONF params ... questions for this list
2003-06-13 22:31 UTC Nick Fankhauser <nickf@ontko.com>
` Re: Re-ordering .CONF params ... questions for this list
2003-06-13 22:51 UTC Josh Berkus <josh@agliodbs.com>
[9+ messages in thread]
db growing out of proportion
2003-05-29 16:32 UTC Tomas Szepe <szepe@pinerecords.com>
` Re: db growing out of proportion
2003-05-29 17:37 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: db growing out of proportion
2003-05-30 07:24 UTC Tomas Szepe <szepe@pinerecords.com>
` Re: db growing out of proportion
2003-05-30 09:21 UTC Peter Childs <blue.dragon@blueyonder.co.uk>
` Re: db growing out of proportion
2003-05-30 13:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: db growing out of proportion
2003-05-30 14:25 UTC Todd Nemanich <todd@twopunks.org>
` Re: db growing out of proportion
2003-05-30 15:40 UTC Stephan Szabo <sszabo@megazone23.bigpanda.com>
` Re: db growing out of proportion
2003-05-30 22:59 UTC Tomas Szepe <szepe@pinerecords.com>
` Re: db growing out of proportion
2003-05-30 23:00 UTC Tomas Szepe <szepe@pinerecords.com>
` Re: db growing out of proportion
2003-05-30 23:08 UTC Tomas Szepe <szepe@pinerecords.com>
` Re: db growing out of proportion
2003-05-31 03:21 UTC Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: db growing out of proportion
2003-05-31 04:11 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: db growing out of proportion
2003-05-31 04:50 UTC Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: db growing out of proportion
2003-05-31 16:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: db growing out of proportion
2003-06-13 05:34 UTC Tomas Szepe <szepe@pinerecords.com>
[15+ messages in thread]
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox