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