pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
slower 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