pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Postgresql Site Search
2+ messages / 2 participants
[nested] [flat]
* Re: Postgresql Site Search
@ 2000-10-23 23:52 The Hermit Hacker <scrappy@hub.org>
parent: Craig May <craig.may@s2.enthdimension.com.au>
0 siblings, 0 replies; 2+ messages in thread
From: The Hermit Hacker @ 2000-10-23 23:52 UTC (permalink / raw)
To: Craig May <craig.may@s2.enthdimension.com.au>; +Cc: pgsql-sql
On Tue, 24 Oct 2000, Craig May wrote:
>
> Considering postgresql performs so well for me here, why is the
> postgres site search so fucking slow??
The search engine used (udmsearch) isn't written to be the most efficient
as far as making use of SQL features are concerned (ie. it was designed
with MySQL limitations in mind) ... I've sent in several suggestions that
provide speed improvements (use of subselects) that haven't been
implemented as it would break MySQL support ...
One of these days, I'll sit down and do the mods and submit it in such a
way that for PostgreSQL, it uses subselects, for MySQL, it doesn't
... unless someone else feels like diving into some code?
The PostgreSQL backend for the site is running on a dedicated PIII-400
with ~512Meg of RAM ... its not like the resources aren't there :(
^ permalink raw reply [nested|flat] 2+ messages in thread
* Postgresql Site Search
@ 2000-10-24 10:37 Craig May <craig.may@s2.enthdimension.com.au>
0 siblings, 1 reply; 2+ messages in thread
From: Craig May @ 2000-10-24 10:37 UTC (permalink / raw)
To: pgsql-sql
Considering postgresql performs so well for me here, why is the postgres site
search so fucking slow??
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-10-24 10:37 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-24 10:37 Postgresql Site Search Craig May <craig.may@s2.enthdimension.com.au>
2000-10-23 23:52 ` The Hermit Hacker <scrappy@hub.org>
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