pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedHow exactly PostgreSQL allocates memory for its needs?
2010-02-10 05:10 UTC Anton Maksimenkov <anton200@gmail.com>
` Re: How exactly PostgreSQL allocates memory for its needs?
2010-02-10 16:43 UTC Justin Graf <justin@magwerks.com>
` Re: How exactly PostgreSQL allocates memory for its needs?
2010-02-11 03:46 UTC Scott Marlowe <scott.marlowe@gmail.com>
[3+ messages in thread]
PostgreSQL - case studies
2010-02-10 04:09 UTC Jayadevan M <Jayadevan.Maymala@ibsplc.com>
` Re: PostgreSQL - case studies
2010-02-10 04:38 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: PostgreSQL - case studies
2010-02-10 05:49 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: [PERFORM] PostgreSQL - case studies
2010-02-10 09:47 UTC Ing. Marcos L. Ortiz Valmaseda <mlortiz@uci.cu>
` Re: [PERFORM] PostgreSQL - case studies
2010-02-10 15:47 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: [PERFORM] PostgreSQL - case studies
2010-02-10 15:55 UTC Stephen Frost <sfrost@snowman.net>
` Re: [PERFORM] PostgreSQL - case studies
2010-02-10 16:10 UTC David Boreham <david_list@boreham.org>
[7+ messages in thread]
DISTINCT vs. GROUP BY
2010-02-09 21:46 UTC Dimi Paun <dimi@lattica.com>
` Re: DISTINCT vs. GROUP BY
2010-02-09 22:22 UTC Thom Brown <thombrown@gmail.com>
` Re: DISTINCT vs. GROUP BY
2010-02-09 22:38 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: DISTINCT vs. GROUP BY
2010-02-10 01:43 UTC Dimi Paun <dimi@lattica.com>
[4+ messages in thread]
foreign key constraint lock behavour in postgresql
2010-02-04 04:05 UTC wangyuxiang <wyx6fox@gmail.com>
` Re: foreign key constraint lock behavour in postgresql
2010-02-04 05:40 UTC david@lang.hm
` Re: foreign key constraint lock behavour in postgresql
2010-02-05 02:11 UTC Robert Haas <robertmhaas@gmail.com>
` Re: foreign key constraint lock behavour in postgresql
2010-02-05 09:00 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: foreign key constraint lock behavour in postgresql
2010-02-05 18:17 UTC Robert Haas <robertmhaas@gmail.com>
` Re: foreign key constraint lock behavour in postgresql
2010-02-08 08:57 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: foreign key constraint lock behavour in postgresql
2010-02-09 15:22 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[7+ messages in thread]
index on partitioned table
2010-02-05 12:32 UTC Wojtek <foo@twine.pl>
` Re: index on partitioned table
2010-02-05 15:08 UTC Nikolas Everett <nik9000@gmail.com>
` Re: index on partitioned table
2010-02-05 18:23 UTC Robert Haas <robertmhaas@gmail.com>
[3+ messages in thread]
Slow-ish Query Needs Some Love
2010-02-02 00:53 UTC Matt White <mattw922@gmail.com>
` Re: Slow-ish Query Needs Some Love
2010-02-02 13:06 UTC Edgardo Portal <egportal2002@yahoo.com>
` Re: Slow-ish Query Needs Some Love
2010-02-02 19:03 UTC Matt White <mattw922@gmail.com>
` Re: Slow-ish Query Needs Some Love
2010-02-02 20:11 UTC Andy Colson <andy@squeakycode.net>
` Re: Slow-ish Query Needs Some Love
2010-02-03 18:50 UTC Andy Colson <andy@squeakycode.net>
` Re: Slow-ish Query Needs Some Love
2010-02-05 01:49 UTC Robert Haas <robertmhaas@gmail.com>
[6+ messages in thread]
bigint integers up to 19 digits.
2010-02-04 18:15 UTC Tory M Blue <tmblue@gmail.com>
` Re: bigint integers up to 19 digits.
2010-02-04 18:43 UTC Craig James <craig_james@emolecules.com>
` Re: bigint integers up to 19 digits.
2010-02-04 18:47 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: bigint integers up to 19 digits.
2010-02-04 18:51 UTC Tory M Blue <tmblue@gmail.com>
` Re: bigint integers up to 19 digits.
2010-02-04 19:01 UTC Jochen Erwied <jochen@pgsql-performance.erwied.eu>
` Re: bigint integers up to 19 digits.
2010-02-04 20:09 UTC Alvaro Herrera <alvherre@commandprompt.com>
[6+ messages in thread]
Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-03 15:10 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-03 15:12 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-03 16:19 UTC Reid Thompson <reid.thompson@ateb.com>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-03 16:35 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-03 18:41 UTC Andy Colson <andy@squeakycode.net>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-03 20:43 UTC Robert Haas <robertmhaas@gmail.com>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-03 21:59 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-04 08:59 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-04 09:02 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-04 09:16 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-04 09:40 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-04 09:52 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-04 10:07 UTC Amitabh Kant <amitabhkant@gmail.com>
` Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
2010-02-04 11:19 UTC Matthew Wakeling <matthew@flymine.org>
[14+ messages in thread]
Air-traffic benchmark
2010-01-07 12:38 UTC Lefteris <lsidir@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 13:24 UTC Gurgel, Flavio <flavio@4linux.com.br>
` Re: Air-traffic benchmark
2010-01-07 13:32 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: Air-traffic benchmark
2010-01-07 13:36 UTC Arjen van der Meijden <acmmailing@tweakers.net>
` Re: Air-traffic benchmark
2010-01-07 13:40 UTC Lefteris <lsidir@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 13:47 UTC Lefteris <lsidir@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 13:59 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: Air-traffic benchmark
2010-01-07 14:02 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: Air-traffic benchmark
2010-01-07 14:05 UTC Jochen Erwied <jochen@pgsql-performance.erwied.eu>
` Re: Air-traffic benchmark
2010-01-07 14:10 UTC Lefteris <lsidir@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 14:14 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Air-traffic benchmark
2010-01-07 14:16 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Air-traffic benchmark
2010-01-07 14:23 UTC Lefteris <lsidir@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 14:51 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Air-traffic benchmark
2010-01-07 15:05 UTC Lefteris <lsidir@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 15:16 UTC Grzegorz Jaśkiewicz <gryzman@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 15:45 UTC Gurgel, Flavio <flavio@4linux.com.br>
` Re: Air-traffic benchmark
2010-01-07 15:57 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Air-traffic benchmark
2010-01-07 16:03 UTC Lefteris <lsidir@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 16:23 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Air-traffic benchmark
2010-01-07 16:31 UTC Craig James <craig_james@emolecules.com>
` Re: Air-traffic benchmark
2010-01-07 17:57 UTC Gurgel, Flavio <flavio@4linux.com.br>
` Re: Air-traffic benchmark
2010-01-07 18:02 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 18:10 UTC Gurgel, Flavio <flavio@4linux.com.br>
` Re: Air-traffic benchmark
2010-01-07 18:11 UTC Nikolas Everett <nik9000@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 22:21 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Air-traffic benchmark
2010-01-07 22:57 UTC Lefteris <lsidir@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 23:08 UTC Lefteris <lsidir@gmail.com>
` Re: Air-traffic benchmark
2010-01-07 23:39 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: Air-traffic benchmark
2010-01-08 00:38 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Air-traffic benchmark
2010-01-08 03:31 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Air-traffic benchmark
2010-01-08 03:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Air-traffic benchmark
2010-01-08 03:45 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: Air-traffic benchmark
2010-02-04 10:41 UTC Simon Riggs <simon@2ndQuadrant.com>
[34+ messages in thread]
some problems when i use postgresql 8.4.2 in my projects .
2010-02-03 02:28 UTC wyx6fox@sina.com
` Re: some problems when i use postgresql 8.4.2 in my projects .
2010-02-03 14:58 UTC Robert Haas <robertmhaas@gmail.com>
` Re: some problems when i use postgresql 8.4.2 in my projects .
2010-02-03 15:16 UTC Leo Mannhart <leo.mannhart@beecom.ch>
` Re: some problems when i use postgresql 8.4.2 in my projects .
2010-02-04 07:32 UTC Pierre Frédéric Caillaud <lists@peufeu.com>
[4+ messages in thread]
System overload / context switching / oom, 8.3
2010-02-02 19:11 UTC Rob <rclemley@yahoo.com>
` Re: System overload / context switching / oom, 8.3
2010-02-02 20:25 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: System overload / context switching / oom, 8.3
2010-02-02 20:29 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: System overload / context switching / oom, 8.3
2010-02-02 20:36 UTC Andy Colson <andy@squeakycode.net>
` Re: System overload / context switching / oom, 8.3
2010-02-02 20:47 UTC Andy Colson <andy@squeakycode.net>
` Re: System overload / context switching / oom, 8.3
2010-02-02 21:44 UTC Rob <rclemley@yahoo.com>
` Re: System overload / context switching / oom, 8.3
2010-02-02 21:59 UTC Rob <rclemley@yahoo.com>
` Re: System overload / context switching / oom, 8.3
2010-02-03 07:48 UTC Greg Smith <greg@2ndquadrant.com>
` Re: System overload / context switching / oom, 8.3
2010-02-03 11:30 UTC Matthew Wakeling <matthew@flymine.org>
` Re: System overload / context switching / oom, 8.3
2010-02-03 20:40 UTC Robert Haas <robertmhaas@gmail.com>
` Re: System overload / context switching / oom, 8.3
2010-02-04 01:27 UTC Rob Lemley <rclemley@yahoo.com>
` Re: System overload / context switching / oom, 8.3
2010-02-04 02:17 UTC Greg Smith <greg@2ndquadrant.com>
[12+ messages in thread]
Queries within a function
2010-02-02 18:17 UTC Mridula Mahadevan <mmahadevan@stratify.com>
` Re: Queries within a function
2010-02-02 19:07 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: Queries within a function
2010-02-02 19:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Queries within a function
2010-02-02 19:59 UTC "Ing. Marcos Ortiz Valmaseda" <mlortiz@uci.cu>
` Re: Queries within a function
2010-02-02 20:36 UTC Mridula Mahadevan <mmahadevan@stratify.com>
` Re: Queries within a function
2010-02-02 20:53 UTC Mridula Mahadevan <mmahadevan@stratify.com>
` Re: Queries within a function
2010-02-03 04:24 UTC ramasubramanian <ramasubramanian.g@renaissance-it.com>
` Re: Queries within a function
2010-02-03 16:10 UTC Віталій Тимчишин <tivv00@gmail.com>
` Re: Queries within a function
2010-02-03 20:06 UTC Mridula Mahadevan <mmahadevan@stratify.com>
[9+ messages in thread]
queries with subquery constraints on partitioned tables not optimized?
2010-02-02 09:48 UTC Davor J. <DavorJ@live.com>
` Re: queries with subquery constraints on partitioned tables not optimized?
2010-02-03 00:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: queries with subquery constraints on partitioned tables not optimized?
2010-02-03 10:23 UTC Dimitri Fontaine <dfontaine@hi-media.com>
` Re: queries with subquery constraints on partitioned tables not optimized?
2010-02-03 15:54 UTC Nikolas Everett <nik9000@gmail.com>
[4+ messages in thread]
the jokes for pg concurrency write performance
2010-02-02 04:57 UTC wyx6fox@sina.com
` Re: the jokes for pg concurrency write performance
2010-02-02 05:08 UTC david@lang.hm
` Re: the jokes for pg concurrency write performance
2010-02-02 05:54 UTC Richard Broersma <richard.broersma@gmail.com>
` Re: the jokes for pg concurrency write performance
2010-02-02 16:12 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: the jokes for pg concurrency write performance
2010-02-02 16:20 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: the jokes for pg concurrency write performance
2010-02-02 16:27 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: the jokes for pg concurrency write performance
2010-02-03 07:35 UTC Greg Smith <greg@2ndquadrant.com>
` Re: the jokes for pg concurrency write performance
2010-02-03 08:31 UTC J Sisson <sisson.j@gmail.com>
[8+ messages in thread]
Re: 回复：Re: [PERFORM] the jokes for pg concurrency write performance
2010-02-02 15:43 UTC Richard Broersma <richard.broersma@gmail.com>
` Re: Re: 回复：Re: [PERFORM] the jokes for pg concurrency write performance
2010-02-02 19:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
use pgsql in a big project, but i found pg has some big problem on concurrency write operation, maybe a joke for myself !
2010-02-02 04:39 UTC wyx6fox@sina.com
` Re: use pgsql in a big project, but i found pg has some big problem on concurrency write operation, maybe a joke for myself !
2010-02-02 05:06 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: use pgsql in a big project, but i found pg has some big problem on concurrency write operation, maybe a joke for myself !
2010-02-02 16:08 UTC Greg Stark <gsstark@mit.edu>
[3+ messages in thread]
Sincere apology for my insults and hand-waving in these mails:the jokes for pg concurrency write performance
2010-02-02 06:55 UTC wyx6fox@sina.com
Re: Constraint propagating for equal fields
2010-02-01 13:30 UTC Віталій Тимчишин <tivv00@gmail.com>
New server to improve performance on our large and busy DB - advice?
2010-01-14 19:17 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: New server to improve performance on our large and busy DB - advice?
2010-01-14 19:54 UTC Joshua D. Drake <jd@commandprompt.com>
` New server to improve performance on our large and busy DB - advice? (v2)
2010-01-14 21:25 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: New server to improve performance on our large and busy DB - advice?
2010-01-14 21:43 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: New server to improve performance on our large and busy DB - advice? (v2)
2010-01-14 22:35 UTC Dave Crooke <dcrooke@gmail.com>
` Re: New server to improve performance on our large and busy DB - advice? (v2)
2010-01-15 00:46 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: New server to improve performance on our large and busy DB - advice?
2010-01-15 05:17 UTC Greg Smith <greg@2ndquadrant.com>
` Re: New server to improve performance on our large and busy DB - advice?
2010-01-15 07:12 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Re: New server to improve performance on our large and busy DB - advice? (v2)
2010-01-15 09:19 UTC Ing. Marcos L. Ortiz Valmaseda <mlortiz@uci.cu>
[9+ messages in thread]
Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 14:29 UTC fkater@googlemail.com <fkater@googlemail.com>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 14:49 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 15:04 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 15:07 UTC Aidan Van Dyk <aidan@highrise.ca>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 15:14 UTC Florian Weimer <fweimer@bfk.de>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 16:08 UTC Pierre Frédéric Caillaud <lists@peufeu.com>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 20:09 UTC fkater@googlemail.com <fkater@googlemail.com>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 20:14 UTC fkater@googlemail.com <fkater@googlemail.com>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 20:18 UTC fkater@googlemail.com <fkater@googlemail.com>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 21:23 UTC fkater@googlemail.com <fkater@googlemail.com>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 21:27 UTC fkater@googlemail.com <fkater@googlemail.com>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 21:28 UTC fkater@googlemail.com <fkater@googlemail.com>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 21:33 UTC Fernando Hevia <fhevia@ip-tel.com.ar>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-14 23:19 UTC Pierre Frédéric Caillaud <lists@peufeu.com>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-15 05:38 UTC Magnus Hagander <magnus@hagander.net>
` Re: Inserting 8MB bytea: just 25% of disk perf used?
2010-01-15 08:02 UTC Florian Weimer <fweimer@bfk.de>
[16+ messages in thread]
new server I/O setup
2010-01-14 20:03 UTC Fernando Hevia <fhevia@ip-tel.com.ar>
` Re: new server I/O setup
2010-01-14 21:22 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: new server I/O setup
2010-01-15 05:46 UTC Greg Smith <greg@2ndquadrant.com>
[3+ messages in thread]
Massive table (500M rows) update nightmare
2010-01-07 07:17 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Massive table (500M rows) update nightmare
2010-01-07 07:49 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Massive table (500M rows) update nightmare
2010-01-07 13:14 UTC Leo Mannhart <leo.mannhart@beecom.ch>
` Re: Massive table (500M rows) update nightmare
2010-01-07 15:18 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Massive table (500M rows) update nightmare
2010-01-07 15:47 UTC Leo Mannhart <leo.mannhart@beecom.ch>
` Re: Massive table (500M rows) update nightmare
2010-01-07 16:38 UTC Ludwik Dylag <ldylag@gmail.com>
` Re: Massive table (500M rows) update nightmare
2010-01-07 16:57 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Massive table (500M rows) update nightmare
2010-01-07 17:46 UTC Kevin Kempter <kevink@consistentstate.com>
` Re: Massive table (500M rows) update nightmare
2010-01-07 17:49 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Massive table (500M rows) update nightmare
2010-01-07 17:56 UTC Greg Sabino Mullane <greg@turnstep.com>
` Re: Massive table (500M rows) update nightmare
2010-01-07 17:56 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Massive table (500M rows) update nightmare
2010-01-07 21:05 UTC marcin mank <marcin.mank@gmail.com>
` Re: Massive table (500M rows) update nightmare
2010-01-07 21:48 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Massive table (500M rows) update nightmare
2010-01-08 00:18 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Massive table (500M rows) update nightmare
2010-01-08 01:40 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Massive table (500M rows) update nightmare
2010-01-08 06:02 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Massive table (500M rows) update nightmare
2010-01-08 06:14 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Massive table (500M rows) update nightmare
2010-01-08 06:21 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Massive table (500M rows) update nightmare
2010-01-08 11:19 UTC Eduardo Morras <emorras@s21sec.com>
` Re: Massive table (500M rows) update nightmare
2010-01-08 14:11 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Massive table (500M rows) update nightmare
2010-01-08 17:06 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Massive table (500M rows) update nightmare
2010-01-08 17:21 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Massive table (500M rows) update nightmare
2010-01-08 17:38 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Massive table (500M rows) update nightmare
2010-01-08 18:08 UTC Kenneth Marshall <ktm@rice.edu>
` Re: Massive table (500M rows) update nightmare
2010-01-08 18:12 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Massive table (500M rows) update nightmare
2010-01-08 18:12 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Massive table (500M rows) update nightmare
2010-01-09 08:15 UTC Pierre Frédéric Caillaud <lists@peufeu.com>
` Re: Massive table (500M rows) update nightmare
2010-01-14 19:20 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
` Re: Massive table (500M rows) update nightmare
2010-01-14 21:19 UTC Craig James <craig_james@emolecules.com>
` Re: Massive table (500M rows) update nightmare
2010-01-14 22:05 UTC Carlo Stonebanks <stonec.register@sympatico.ca>
[30+ messages in thread]
a heavy duty operation on an "unused" table kills my server
2010-01-13 04:59 UTC Eduardo Piombino <drakorg@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 05:14 UTC Craig James <craig_james@emolecules.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 05:41 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 05:47 UTC Eduardo Piombino <drakorg@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 06:02 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 07:03 UTC Eduardo Piombino <drakorg@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 07:39 UTC Greg Smith <greg@2ndquadrant.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 08:27 UTC Eduardo Piombino <drakorg@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 10:58 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 14:06 UTC Euler Taveira de Oliveira <euler@timbira.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 15:53 UTC Eduardo Piombino <drakorg@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 16:23 UTC Robert Haas <robertmhaas@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 16:52 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 17:54 UTC Eduardo Piombino <drakorg@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 18:11 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 18:46 UTC Greg Smith <greg@2ndquadrant.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-13 19:13 UTC Eduardo Piombino <drakorg@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-14 05:36 UTC Craig Ringer <craig@postnewspapers.com.au>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-14 14:49 UTC Andy Colson <andy@squeakycode.net>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-14 16:16 UTC Pierre Frédéric Caillaud <lists@peufeu.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-14 18:07 UTC Greg Smith <greg@2ndquadrant.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-14 18:15 UTC Andy Colson <andy@squeakycode.net>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-14 18:30 UTC Greg Smith <greg@2ndquadrant.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-14 20:49 UTC Eduardo Piombino <drakorg@gmail.com>
` Re: a heavy duty operation on an "unused" table kills my server
2010-01-14 21:01 UTC Eduardo Piombino <drakorg@gmail.com>
[25+ messages in thread]
Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 14:58 UTC tom <toabctl@googlemail.com>
` Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 15:11 UTC Matthew Wakeling <matthew@flymine.org>
` Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 15:18 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
` Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 15:47 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 15:59 UTC Ivan Voras <ivoras@freebsd.org>
` Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 16:03 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 18:01 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 18:12 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 18:25 UTC Greg Smith <greg@2ndquadrant.com>
` Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 18:33 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: Slow "Select count(*) ..." query on table with 60 Mio. rows
2010-01-14 18:49 UTC Greg Smith <greg@2ndquadrant.com>
[11+ messages in thread]
bad execution plan for subselects containing windowing-function
2010-01-14 17:03 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: bad execution plan for subselects containing windowing-function
2010-01-14 17:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: bad execution plan for subselects containing windowing-function
2010-01-14 17:30 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: bad execution plan for subselects containing windowing-function
2010-01-14 17:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: bad execution plan for subselects containing windowing-function
2010-01-14 18:03 UTC Andreas Kretschmer <akretschmer@spamfence.net>
` Re: bad execution plan for subselects containing windowing-function
2010-01-14 18:31 UTC Andreas Kretschmer <akretschmer@spamfence.net>
[6+ 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