pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedCurious 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]
Initial database loading and IDE x SCSI
2006-06-02 18:25 UTC carlosreimer@terra.com.br
` Re: Initial database loading and IDE x SCSI
2006-06-02 18:40 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Initial database loading and IDE x SCSI
2006-06-02 18:41 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Initial database loading and IDE x SCSI
2006-06-02 18:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
pg_dump issue
2006-05-30 14:31 UTC mcelroy, tim <tim.mcelroy@bostonstock.com>
` Re: pg_dump issue
2006-05-30 15:15 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_dump issue
2006-05-30 15:33 UTC mcelroy, tim <tim.mcelroy@bostonstock.com>
` Re: pg_dump issue
2006-05-30 16:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: pg_dump issue
2006-05-30 17:12 UTC mcelroy, tim <tim.mcelroy@bostonstock.com>
` Re: pg_dump issue
2006-06-02 12:17 UTC Evgeny Gridasov <eugene@i-free.ru>
[6+ messages in thread]
App very unresponsive while performing simple update
2006-05-28 09:37 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: App very unresponsive while performing simple update
2006-05-28 09:43 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: App very unresponsive while performing simple update
2006-05-28 13:11 UTC Greg Stark <gsstark@mit.edu>
` Re: App very unresponsive while performing simple update
2006-05-28 16:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: App very unresponsive while performing simple update
2006-05-28 17:55 UTC Greg Stark <gsstark@mit.edu>
` Re: App very unresponsive while performing simple update
2006-05-28 19:17 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: App very unresponsive while performing simple update
2006-05-28 21:32 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: App very unresponsive while performing simple update
2006-05-28 23:20 UTC Greg Stark <gsstark@mit.edu>
` Re: App very unresponsive while performing simple update
2006-05-28 23:24 UTC Greg Stark <gsstark@mit.edu>
` Re: App very unresponsive while performing simple update
2006-05-31 06:23 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: App very unresponsive while performing simple update
2006-05-31 06:29 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: App very unresponsive while performing simple update
2006-05-31 12:34 UTC Jan de Visser <jdevisser@digitalfairway.com>
` Re: App very unresponsive while performing simple update
2006-05-31 15:11 UTC Bruno Wolff III <bruno@wolff.to>
` Re: App very unresponsive while performing simple update
2006-05-31 15:24 UTC Greg Stark <gsstark@mit.edu>
` Re: App very unresponsive while performing simple update
2006-05-31 17:34 UTC Brendan Duddridge <brendan@clickspace.com>
` Re: App very unresponsive while performing simple update
2006-05-31 17:43 UTC Jan de Visser <jdevisser@digitalfairway.com>
` Re: App very unresponsive while performing simple update
2006-06-01 03:18 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: App very unresponsive while performing simple update
2006-06-01 04:30 UTC Greg Stark <gsstark@mit.edu>
[18+ messages in thread]
Speedup hint needed, if available? :)
2006-05-30 14:18 UTC Mario Splivalo <mario.splivalo@mobart.hr>
` Re: Speedup hint needed, if available? :)
2006-05-30 15:05 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Speedup hint needed, if available? :)
2006-05-30 15:16 UTC Mario Splivalo <mario.splivalo@mobart.hr>
` Re: Speedup hint needed, if available? :)
2006-05-31 09:28 UTC Nis Jorgensen <nis@superlativ.dk>
[4+ messages in thread]
INSERT OU UPDATE WITHOUT SELECT?
2006-05-30 18:29 UTC Waldomiro <waldomiro@shx.com.br>
` Re: INSERT OU UPDATE WITHOUT SELECT?
2006-05-30 21:05 UTC Jonah H. Harris <jonah.harris@gmail.com>
` Re: INSERT OU UPDATE WITHOUT SELECT?
2006-05-30 22:35 UTC PFC <lists@peufeu.com>
` Re: INSERT OU UPDATE WITHOUT SELECT?
2006-05-30 22:38 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: INSERT OU UPDATE WITHOUT SELECT?
2006-05-30 22:54 UTC Dave Dutcher <dave@tridecap.com>
` Re: INSERT OU UPDATE WITHOUT SELECT?
2006-05-30 23:05 UTC D'Arcy J.M. Cain <darcy@druid.net>
` Re: INSERT OU UPDATE WITHOUT SELECT?
2006-05-31 06:29 UTC Jim C. Nasby <jnasby@pervasive.com>
[7+ messages in thread]
Why the 8.1 plan is worst than 7.4?
2006-05-26 12:04 UTC wmiro@ig.com.br <wmiro@ig.com.br>
` Re: Why the 8.1 plan is worst than 7.4?
2006-05-31 00:38 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Why the 8.1 plan is worst than 7.4?
2006-05-31 03:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
Optimizing a huge_table/tiny_table join
2006-05-24 15:49 UTC kynn@panix.com
` Optimizing a huge_table/tiny_table join
2006-05-24 17:42 UTC kynn@panix.com
` Optimizing a huge_table/tiny_table join
2006-05-25 00:52 UTC kynn@panix.com
` Re: Optimizing a huge_table/tiny_table join
2006-05-25 01:31 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Optimizing a huge_table/tiny_table join
2006-05-25 01:41 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimizing a huge_table/tiny_table join
2006-05-25 16:21 UTC Kynn Jones <kynnjo@gmail.com>
` Re: Optimizing a huge_table/tiny_table join
2006-05-25 16:31 UTC kynn@panix.com
` Re: Optimizing a huge_table/tiny_table join
2006-05-25 16:48 UTC Andrew Sullivan <ajs@crankycanuck.ca>
` Re: Optimizing a huge_table/tiny_table join
2006-05-25 17:07 UTC Dawid Kuroczko <qnex42@gmail.com>
` Re: Optimizing a huge_table/tiny_table join
2006-05-25 22:13 UTC Jim Nasby <decibel@decibel.org>
` Re: Optimizing a huge_table/tiny_table join
2006-05-25 23:27 UTC Mark Kirkwood <markir@paradise.net.nz>
` Re: Optimizing a huge_table/tiny_table join
2006-05-30 22:37 UTC PFC <lists@peufeu.com>
[12+ messages in thread]
Getting even more insert performance (250m+rows/day)
2006-05-24 19:45 UTC Daniel J. Luke <dluke@geeklair.net>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:02 UTC Dave Dutcher <dave@tridecap.com>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:03 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:08 UTC Daniel J. Luke <dluke@geeklair.net>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:09 UTC Daniel J. Luke <dluke@geeklair.net>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:12 UTC Larry Rosenman <lrosenman@pervasive.com>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:13 UTC Steinar H. Gunderson <sgunderson@bigfoot.com>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:18 UTC Daniel J. Luke <dluke@geeklair.net>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:18 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:20 UTC Daniel J. Luke <dluke@geeklair.net>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:24 UTC Larry Rosenman <lrosenman@pervasive.com>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 20:29 UTC Daniel J. Luke <dluke@geeklair.net>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-24 21:32 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-25 03:20 UTC Ian Westmacott <ianw@intellivid.com>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-29 11:11 UTC Markus Schaber <schabi@logix-tt.com>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-30 19:59 UTC Daniel J. Luke <dluke@geeklair.net>
` Re: Getting even more insert performance (250m+rows/day)
2006-05-30 22:03 UTC Daniel J. Luke <dluke@geeklair.net>
[17+ messages in thread]
Split select completes, single select doesn't and becomes IO bound!
2006-05-30 00:26 UTC Anthony Ransley <anthonyr@aurema.com>
` Re: Split select completes, single select doesn't and
2006-05-30 21:53 UTC Ragnar <gnari@hive.is>
[2+ messages in thread]
Adding and filling new column on big table
2006-05-17 01:19 UTC Jonathan Blitz <jb@anykey.co.il>
` Re: Adding and filling new column on big table
2006-05-17 02:31 UTC Michael Fuhr <mike@fuhr.org>
` Re: Adding and filling new column on big table
2006-05-30 03:22 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Adding and filling new column on big table
2006-05-30 09:35 UTC Jonathan Blitz <jb@anykey.co.il>
` Re: Adding and filling new column on big table
2006-05-30 15:58 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Adding and filling new column on big table
2006-05-30 17:11 UTC Jonathan Blitz <jb@anykey.co.il>
` Re: Adding and filling new column on big table
2006-05-30 17:25 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Adding and filling new column on big table
2006-05-30 20:07 UTC Scott Marlowe <smarlowe@g2switchworks.com>
` Re: Adding and filling new column on big table
2006-05-30 20:24 UTC PFC <lists@peufeu.com>
` Re: Adding and filling new column on big table
2006-05-30 20:52 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Adding and filling new column on big table
2006-05-30 21:04 UTC Jonathan Blitz <jb@anykey.co.il>
[11+ messages in thread]
Selects query stats?
2006-05-23 17:40 UTC Dan Gorman <dgorman@hi5.com>
` Re: Selects query stats?
2006-05-23 18:15 UTC Mischa Sandberg <mischa@ca.sophos.com>
` Re: Selects query stats?
2006-05-23 18:15 UTC Dan Gorman <dgorman@hi5.com>
` Re: Selects query stats?
2006-05-23 18:32 UTC Mischa Sandberg <mischa@ca.sophos.com>
` Re: Selects query stats?
2006-05-23 18:33 UTC Dan Gorman <dgorman@hi5.com>
` Re: Selects query stats?
2006-05-23 18:41 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Selects query stats?
2006-05-23 18:51 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Selects query stats?
2006-05-23 19:08 UTC Dan Gorman <dgorman@hi5.com>
` Re: Selects query stats?
2006-05-23 19:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Selects query stats?
2006-05-23 19:50 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: Selects query stats?
2006-05-23 19:55 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Selects query stats?
2006-05-23 20:02 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Selects query stats?
2006-05-23 20:04 UTC Guillaume Smet <guillaume.smet@gmail.com>
` Re: Selects query stats?
2006-05-23 21:47 UTC Simon Riggs <simon@2ndquadrant.com>
` Re: Selects query stats?
2006-05-23 22:18 UTC Mischa Sandberg <mischa@ca.sophos.com>
` Re: Selects query stats?
2006-05-24 10:27 UTC Robin Ericsson <lobbin@gmail.com>
` Re: Selects query stats?
2006-05-24 21:33 UTC Jim C. Nasby <jnasby@pervasive.com>
` Re: Selects query stats?
2006-05-30 03:52 UTC Francisco Reyes <lists@stringsutils.com>
` Re: Selects query stats?
2006-05-30 13:05 UTC Alvis Tunkelis <alvis@datatechlabs.com>
[19+ 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