Re: [GENERAL] ORDER BY time consuming

2005-08-23 Thread Thomas F. O'Connell
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

[GENERAL] ORDER BY time consuming

2005-08-21 Thread Ben-Nes Yonatan
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

Re: [GENERAL] ORDER BY time consuming

2005-08-21 Thread Jim C. Nasby
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