Re: pg_migrator and an 8.3-compatible tsvector data type
From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Josh Berkus <josh(at)agliodbs(dot)com>
Cc:
Bruce Momjian <bruce(at)momjian(dot)us>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>,
Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, Teodor Sigaev <teodor(at)sigaev(dot)ru>
Subject:
Re: pg_migrator and an 8.3-compatible tsvector data type
Date:
2009-05-28 22:16:56
Message-ID:
1629.1243549016@sss.pgh.pa.us (view raw or flat )
Thread:
2009-05-26 01:45:59 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-28 21:26:20 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-28 21:30:39 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-28 21:39:33 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-05-28 21:42:27 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-28 21:44:32 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-05-28 21:46:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-28 22:19:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-05-28 22:26:52 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-28 22:42:45 from Greg Stark <stark(at)enterprisedb(dot)com>
2009-05-28 22:52:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-05-28 23:32:05 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-05-28 23:53:46 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-28 23:56:31 from Greg Stark <stark(at)enterprisedb(dot)com>
2009-05-28 23:58:17 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-29 00:26:01 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-05-29 00:53:47 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-29 01:00:07 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-05-29 01:25:46 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2009-05-29 14:27:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-05-29 01:03:21 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-05-29 12:58:45 from Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
2009-05-29 01:23:28 from Greg Smith <gsmith(at)gregsmith(dot)com>
2009-05-28 22:16:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-05-28 22:20:11 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-05-29 18:16:19 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-29 18:36:45 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-05-29 18:44:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-05-29 18:59:39 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-30 12:11:47 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-30 14:02:11 from Greg Stark <stark(at)enterprisedb(dot)com>
2009-05-30 14:12:48 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-05-30 17:22:30 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-30 17:25:10 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-31 03:56:39 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-31 13:47:21 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-30 15:33:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-05-30 17:23:50 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-30 17:30:29 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-30 21:26:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-05-31 02:29:07 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-30 23:03:17 from Greg Stark <stark(at)enterprisedb(dot)com>
2009-05-31 03:58:57 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-06-01 03:28:37 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-06-01 03:45:51 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-06-01 03:49:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-06-01 15:03:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-06-01 15:10:57 from Greg Stark <stark(at)enterprisedb(dot)com>
2009-06-01 15:18:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-06-01 15:39:15 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-06-01 16:02:15 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-06-01 15:34:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-06-01 16:02:48 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-31 14:04:29 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-31 14:30:09 from Greg Stark <stark(at)enterprisedb(dot)com>
2009-05-31 20:13:26 from Bruce Momjian <bruce(at)momjian(dot)us>
2009-05-29 13:27:34 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
2009-05-29 15:28:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-05-29 15:39:18 from Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
Lists:
pgsql-hackers
Josh Berkus <josh(at)agliodbs(dot)com> writes:
> Bruce,
>> The ordering of the lexems was changed:
> What does that get us in terms of performance etc.?
It was changed to support partial-match tsvector queries. Without it,
a partial match query would have to scan entire tsvectors instead
of applying binary search. I don't know if Oleg and Teodor did any
actual performance tests on the size of the hit, but it seems like
it could be pretty awful for large documents.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2009-05-28 22:19:01Subject : Re: pg_migrator and an 8.3-compatible tsvector data type Previous :From : Tom LaneDate : 2009-05-28 22:09:24Subject : Re: Clean shutdown and warm standby
