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

Adjusting fsm values was Re: [BUGS] db growing out of proportion
  2003-06-13 03:49 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>

new monster box CONF suggestion please
  2003-06-12 16:33 UTC  Patrick Hatcher <PHatcher@macys.com>

Table Relationships
  2003-05-30 09:23 UTC  Jeandre du Toit <jeandre@itvs.co.za>
` Re: Table Relationships
  2003-05-30 10:10 UTC  Victor Yegorov <viktors.jegorovs@nordlb.lv>
` Re: Table Relationships
  2003-05-30 12:11 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Table Relationships
  2003-05-30 13:34 UTC  Jeandre du Toit <jeandre@itvs.co.za>
` Re: Table Relationships
  2003-05-30 16:06 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Table Relationships
  2003-05-30 16:19 UTC  Jeandre du Toit <jeandre@itvs.co.za>
` Re: Table Relationships
  2003-05-30 16:39 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Table Relationships
  2003-05-30 17:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Table Relationships
  2003-05-30 17:20 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Table Relationships
  2003-05-30 18:18 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Table Relationships
  2003-05-30 19:54 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Table Relationships
  2003-06-12 09:32 UTC  Andreas Kostyrka <andreas@mtg.co.at>
  [12+ messages in thread]

FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-09 09:18 UTC  Howard Oblowitz <HowardO@LEWIS-STORES.com>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 05:15 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 15:46 UTC  Josh Berkus <josh@agliodbs.com>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 15:56 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 16:03 UTC  Josh Berkus <josh@agliodbs.com>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 17:21 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 18:12 UTC  Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 18:28 UTC  Josh Berkus <josh@agliodbs.com>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 19:08 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 19:43 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 23:10 UTC  Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-10 23:25 UTC  Vincent van Leeuwen <pgsql.spam@vinz.nl>
` Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  2003-06-11 03:52 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
  [13+ messages in thread]

Hash or merge join instead of inner loop
  2003-06-09 20:40 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Hash or merge join instead of inner loop
  2003-06-10 06:15 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Hash or merge join instead of inner loop
  2003-06-10 08:56 UTC  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
` Re: Hash or merge join instead of inner loop
  2003-06-10 19:42 UTC  Jim C. Nasby <jim@nasby.net>
` Re: Hash or merge join instead of inner loop
  2003-06-10 20:56 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [5+ messages in thread]

[Fwd: Re: Enabling and disabling run time configuration parameters.]
  2003-06-06 18:53 UTC  Yusuf <yusuf0478@netscape.net>

Enabling and disabling run time configuration parameters.
  2003-06-05 15:35 UTC  Yusuf <yusuf0478@netscape.net>
` Re: Enabling and disabling run time configuration parameters.
  2003-06-05 16:14 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Enabling and disabling run time configuration parameters.
  2003-06-05 16:15 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Enabling and disabling run time configuration parameters.
  2003-06-05 16:19 UTC  Josh Berkus <josh@agliodbs.com>
` Re: Enabling and disabling run time configuration parameters.
  2003-06-05 16:39 UTC  Andrew Sullivan <andrew@libertyrms.info>
` Re: Enabling and disabling run time configuration parameters.
  2003-06-05 16:42 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [6+ messages in thread]

Degrading performance
  2003-06-02 05:33 UTC  Mindaugas Riauba <mind@bi.lt>
` Re: Degrading performance
  2003-06-02 13:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Degrading performance
  2003-06-02 16:34 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Degrading performance
  2003-06-02 17:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Degrading performance
  2003-06-02 17:42 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [5+ messages in thread]

Enabling and Disabling Sequencial Scan
  2003-05-30 20:33 UTC  Yusuf <yusuf0478@netscape.net>
` Re: Enabling and Disabling Sequencial Scan
  2003-05-30 20:46 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Enabling and Disabling Sequencial Scan
  2003-05-31 03:28 UTC  Robert Creager <Robert_Creager@LogicalChaos.org>
` Re: Enabling and Disabling Sequencial Scan
  2003-05-31 15:07 UTC  Nikolaus Dilger <nikolaus@dilger.cc>
` Re: Enabling and Disabling Sequencial Scan
  2003-06-02 15:20 UTC  scott.marlowe <scott.marlowe@ihs.com>
` Re: Enabling and Disabling Sequencial Scan
  2003-06-02 15:23 UTC  scott.marlowe <scott.marlowe@ihs.com>
  [6+ messages in thread]

Re: Index speeds up one row table (why)?
  2003-05-31 22:56 UTC  Dave E Martin XXIII <postgresql-to.dave@dave.to>
` Re: Index speeds up one row table (why)?
  2003-06-01 02:29 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Index speeds up one row table (why)?
  2003-06-01 05:33 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index speeds up one row table (why)?
  2003-06-01 07:20 UTC  Dave E Martin XXIII <postgresql-to.dave@dave.to>
` Re: Index speeds up one row table (why)?
  2003-06-01 12:14 UTC  Rod Taylor <rbt@rbt.ca>
` Re: Index speeds up one row table (why)?
  2003-06-01 19:04 UTC  Bruno Wolff III <bruno@wolff.to>
` Re: Index speeds up one row table (why)?
  2003-06-02 07:14 UTC  Dave E Martin XXIII <postgresql-to.dave@dave.to>
` Re: Index speeds up one row table (why)?
  2003-06-02 07:51 UTC  Peter Childs <blue.dragon@blueyonder.co.uk>
  [8+ messages in thread]

FW: Query Plan problem
  2003-06-02 04:56 UTC  George Papastamatopoulos <George.Papastamatopoulos@lawlex.com.au>
` Re: FW: Query Plan problem
  2003-06-02 05:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: FW: Query Plan problem
  2003-06-02 05:35 UTC  Paul Smith <Paul.Smith@lawlex.com.au>
  [3+ 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