You're also free to set sort_mem (7.4.x) or work_mem (8.0.x) on a per
session basis, so you could try experimenting with raising the value
of those settings during sessions in which your query is running.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open
Hi All,
I got a table with about 4.5 millions rows in it which is connected to
another table with about 60 millions rows which are used as keywords for
searching.
I succeded to create fast queries on the first table that finds a row at
the first table which is connected to up to 4 diffrent
On Sun, Aug 21, 2005 at 12:04:01PM +0200, Ben-Nes Yonatan wrote:
Hi All,
I got a table with about 4.5 millions rows in it which is connected to
another table with about 60 millions rows which are used as keywords for
searching.
I succeded to create fast queries on the first table that