pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedfunction not called if part of aggregate
2006-06-11 17:18 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: function not called if part of aggregate
2006-06-11 17:31 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: function not called if part of aggregate
2006-06-11 17:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: function not called if part of aggregate
2006-06-11 17:48 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: function not called if part of aggregate
2006-06-11 18:00 UTC Greg Stark <gsstark@mit.edu>
` Re: function not called if part of aggregate
2006-06-13 06:26 UTC Craig A. James <cjames@modgraph-usa.com>
` Re: function not called if part of aggregate
2006-06-13 14:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[7+ messages in thread]
Interesting slow query
2006-06-12 19:42 UTC PFC <lists@peufeu.com>
` Re: Interesting slow query
2006-06-12 22:53 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Interesting slow query
2006-06-13 11:56 UTC PFC <lists@peufeu.com>
[3+ messages in thread]
Re: Posrgres speed problem - solved?
2006-06-13 06:44 UTC Ruben Rubio Rey <ruben@rentalia.com>
` Re: Posrgres speed problem - solved?
2006-06-13 08:11 UTC Guido Neitzer <guido.neitzer@pharmaline.de>
` Re: Posrgres speed problem - solved?
2006-06-13 08:17 UTC Ruben Rubio Rey <ruben@rentalia.com>
` Re: Posrgres speed problem - solved!
2006-06-13 10:33 UTC Ruben Rubio Rey <ruben@rentalia.com>
` Re: Posrgres speed problem - solved!
2006-06-13 11:48 UTC Guido Neitzer <guido.neitzer@pharmaline.de>
[5+ messages in thread]
Posrgres speed problem
2006-06-12 14:38 UTC Ruben Rubio Rey <ruben@rentalia.com>
` Re: Posrgres speed problem
2006-06-12 14:45 UTC Dave Dutcher <dave@tridecap.com>
` Re: Posrgres speed problem
2006-06-12 14:58 UTC Ruben Rubio Rey <ruben@rentalia.com>
` Re: Posrgres speed problem
2006-06-12 15:02 UTC Ruben Rubio Rey <ruben@rentalia.com>
` Re: Posrgres speed problem
2006-06-12 15:05 UTC Michael Fuhr <mike@fuhr.org>
` Re: Posrgres speed problem
2006-06-12 15:17 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Posrgres speed problem
2006-06-12 15:22 UTC Ruben Rubio Rey <ruben@rentalia.com>
` Re: Posrgres speed problem
2006-06-12 15:23 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Posrgres speed problem
2006-06-12 15:25 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Posrgres speed problem
2006-06-12 15:33 UTC Sven Geisler <sgeisler@aeccom.com>
` Re: Posrgres speed problem
2006-06-13 06:37 UTC Ruben Rubio Rey <ruben@rentalia.com>
[11+ messages in thread]
pgsql_tmp and postgres settings
2006-06-09 12:23 UTC Domenico - Sal. F.lli Riva <domenico.mozzanica@fratelliriva.it>
` Re: pgsql_tmp and postgres settings
2006-06-09 15:59 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: pgsql_tmp and postgres settings
2006-06-12 05:56 UTC Gourish Singbal <gourish@gmail.com>
` Re: pgsql_tmp and postgres settings
2006-06-12 15:15 UTC Jim C. Nasby <jnasby@pervasive.com>
[4+ messages in thread]
Variation between query runtimes
2006-06-11 06:35 UTC John Top-k apad <topkapad@gmail.com>
` Re: Variation between query runtimes
2006-06-12 02:50 UTC Qingqing Zhou <zhouqq@cs.toronto.edu>
[2+ messages in thread]
pg_xlog on data partition with BBU RAID
2006-06-09 19:41 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: pg_xlog on data partition with BBU RAID
2006-06-09 20:21 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` FW: pg_xlog on data partition with BBU RAID
2006-06-10 02:24 UTC Jim Nasby <jnasby@pervasive.com>
[3+ messages in thread]
Why date index is not used
2006-06-08 18:53 UTC Andrus <eetasoft@online.ee>
` Re: Why date index is not used
2006-06-08 19:10 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Why date index is not used
2006-06-08 19:20 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Why date index is not used
2006-06-08 19:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why date index is not used
2006-06-08 20:07 UTC Dave Dutcher <dave@tridecap.com>
` Re: Why date index is not used
2006-06-08 21:57 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Why date index is not used
2006-06-08 22:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Why date index is not used
2006-06-09 09:06 UTC Andrus <eetasoft@online.ee>
` Re: Why date index is not used
2006-06-09 09:40 UTC Andrus <eetasoft@online.ee>
` Re: Why date index is not used
2006-06-09 09:52 UTC Andrus <eetasoft@online.ee>
` Re: Why date index is not used
2006-06-09 15:54 UTC Jim C. Nasby <jnasby@pervasive.com>
[11+ messages in thread]
Regarding pg_dump utility
2006-06-08 06:09 UTC soni de <soni.de@gmail.com>
` Re: Regarding pg_dump utility
2006-06-08 15:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Regarding pg_dump utility
2006-06-08 15:16 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Regarding pg_dump utility
2006-06-08 15:42 UTC Geoffrey <esoteric@3times25.net>
` Re: Regarding pg_dump utility
2006-06-08 16:23 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Regarding pg_dump utility
2006-06-08 16:33 UTC Andreas Pflug <pgadmin@pse-consulting.de>
` Re: Regarding pg_dump utility
2006-06-08 16:35 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Regarding pg_dump utility
2006-06-08 16:38 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Regarding pg_dump utility
2006-06-09 01:16 UTC Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
` Re: Regarding pg_dump utility
2006-06-09 01:19 UTC Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>
` Re: Regarding pg_dump utility
2006-06-09 14:22 UTC Paul S <plabrh1@gmail.com>
[11+ messages in thread]
JOIN with inherited table ignores indexes
2006-06-08 11:40 UTC Andreas Pflug <pgadmin@pse-consulting.de>
` Re: JOIN with inherited table ignores indexes
2006-06-08 15:22 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: JOIN with inherited table ignores indexes
2006-06-08 16:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: JOIN with inherited table ignores indexes
2006-06-08 16:42 UTC Andreas Pflug <pgadmin@pse-consulting.de>
[4+ messages in thread]
Regarding ALTER Command
2006-06-07 12:43 UTC soni de <soni.de@gmail.com>
` Re: Regarding ALTER Command
2006-06-07 14:50 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Regarding ALTER Command
2006-06-08 06:07 UTC soni de <soni.de@gmail.com>
` Re: Regarding ALTER Command
2006-06-08 15:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Curious sorting puzzle
2006-06-07 19:26 UTC Ivan Voras <ivoras@fer.hr>
` Re: Curious sorting puzzle
2006-06-07 21:16 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Curious sorting puzzle
2006-06-07 23:04 UTC Ivan Voras <ivoras@fer.hr>
[3+ messages in thread]
vacuuming problems continued
2006-06-01 11:54 UTC Antoine <melser.anton@gmail.com>
` Re: vacuuming problems continued
2006-06-01 15:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: vacuuming problems continued
2006-06-05 14:43 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: vacuuming problems continued
2006-06-05 20:41 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: vacuuming problems continued
2006-06-06 18:51 UTC Mischa Sandberg <mischa@ca.sophos.com>
` Re: vacuuming problems continued
2006-06-06 19:21 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: vacuuming problems continued
2006-06-06 19:38 UTC Mischa Sandberg <mischa@ca.sophos.com>
` Re: vacuuming problems continued
2006-06-07 20:52 UTC Antoine <melser.anton@gmail.com>
` Re: vacuuming problems continued
2006-06-07 22:17 UTC Jim C. Nasby <jnasby@pervasive.com>
[9+ messages in thread]
Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-05 16:40 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-05 16:45 UTC Zoltan Boszormenyi <zboszor@dunaweb.hu>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-05 16:48 UTC Mark Woodward <pgsql@mohawksoft.com>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-05 17:01 UTC Mark Woodward <pgsql@mohawksoft.com>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-05 17:03 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-05 17:17 UTC Zoltan Boszormenyi <zboszor@dunaweb.hu>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-05 17:52 UTC Neil Conway <neilc@samurai.com>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-05 18:10 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-06 12:30 UTC Hannu Krosing <hannu@skype.net>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-06 13:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-06 14:39 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: [PERFORM] psql -A (unaligned format) eats too much
2006-06-06 14:47 UTC Tom Lane <tgl@sss.pgh.pa.us>
[12+ messages in thread]
How to force Postgres to use index on ILIKE
2006-06-05 19:29 UTC Andrus <eetasoft@online.ee>
` Re: How to force Postgres to use index on ILIKE
2006-06-05 21:26 UTC Josh Berkus <josh@agliodbs.com>
` Re: How to force Postgres to use index on ILIKE
2006-06-06 09:57 UTC Andrus <eetasoft@online.ee>
` Re: How to force Postgres to use index on ILIKE
2006-06-06 14:23 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Problem: query becomes slow when calling a fast user defined function.
2006-06-06 00:03 UTC Dan Libby <dan@libby.com>
` Re: Problem: query becomes slow when calling a fast user defined function.
2006-06-06 02:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
psql -A (unaligned format) eats too much memory
2006-06-04 22:01 UTC Zoltan Boszormenyi <zboszor@dunaweb.hu>
` Re: psql -A (unaligned format) eats too much memory
2006-06-04 22:32 UTC Zoltan Boszormenyi <zboszor@dunaweb.hu>
` Re: [PERFORM] psql -A (unaligned format) eats too much memory
2006-06-05 15:22 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: [PERFORM] psql -A (unaligned format) eats too much memory
2006-06-05 15:27 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: [PERFORM] psql -A (unaligned format) eats too much memory
2006-06-05 15:53 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: [PERFORM] psql -A (unaligned format) eats too much memory
2006-06-05 16:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
[6+ messages in thread]
Bulk loading/merging
2006-05-26 18:48 UTC Worky Workerson <worky.workerson@gmail.com>
` Re: Bulk loading/merging
2006-05-26 19:04 UTC Worky Workerson <worky.workerson@gmail.com>
` Re: Bulk loading/merging
2006-05-31 01:09 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Bulk loading/merging
2006-06-01 18:04 UTC Michael Artz <mlartz@gmail.com>
` Re: Bulk loading/merging
2006-06-04 12:00 UTC Ahmad Fajar <ahmadfajar@i2.co.id>
` Re: Bulk loading/merging
2006-06-05 15:04 UTC Jim C. Nasby <jnasby@pervasive.com>
[6+ messages in thread]
help me problems with pg_clog file
2006-06-01 17:17 UTC Joao <joao.junior@conab.gov.br>
` Re: [PERFORM] help me problems with pg_clog file
2006-06-02 07:41 UTC Gourish Singbal <gourish@gmail.com>
` Re: [PERFORM] help me problems with pg_clog file
2006-06-05 14:48 UTC Jim C. Nasby <jnasby@pervasive.com>
[3+ messages in thread]
How can I make this query faster (resend)
2006-05-19 22:56 UTC Cstdenis <cstdenis@voicio.com>
` Re: How can I make this query faster (resend)
2006-05-22 15:20 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: How can I make this query faster (resend)
2006-05-22 15:30 UTC Markus Schaber <schabi@logix-tt.com>
` Re: How can I make this query faster (resend)
2006-05-28 10:49 UTC Cstdenis <cstdenis@voicio.com>
` Re: How can I make this query faster (resend)
2006-05-29 14:33 UTC Cstdenis <cstdenis@voicio.com>
` Re: How can I make this query faster (resend)
2006-05-29 14:35 UTC Cstdenis <cstdenis@voicio.com>
` Re: How can I make this query faster (resend)
2006-06-05 14:35 UTC Jim C. Nasby <jnasby@pervasive.com>
[7+ messages in thread]
INSERT OR UPDATE WITHOUT SELECT
2006-05-30 20:47 UTC wmiro@ig.com.br <wmiro@ig.com.br>
` Re: INSERT OR UPDATE WITHOUT SELECT
2006-06-04 07:40 UTC A. Kretschmer <andreas.kretschmer@schollglas.com>
[2+ messages in thread]
RES: Initial database loading and IDE x SCSI
2006-06-02 19:54 UTC carlosreimer@terra.com.br
` Re: RES: Initial database loading and IDE x SCSI
2006-06-02 20:13 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: RES: Initial database loading and IDE x SCSI
2006-06-03 00:13 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: RES: Initial database loading and IDE x SCSI
2006-06-04 02:03 UTC Bruce Momjian <pgman@candle.pha.pa.us>
` Re: RES: Initial database loading and IDE x SCSI
2006-06-04 02:21 UTC Mark Kirkwood <markir@paradise.net.nz>
[5+ messages in thread]
Re: Répondre
2006-06-03 10:52 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
RES: RES: RES: Initial database loading and IDE x SCSI
2006-06-02 20:55 UTC carlosreimer@terra.com.br
RES: RES: Initial database loading and IDE x SCSI
2006-06-02 20:37 UTC carlosreimer@terra.com.br
` Re: RES: RES: Initial database loading and IDE x SCSI
2006-06-02 20:44 UTC Mark Lewis <mark.lewis@mir3.com>
[2+ 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