Re: [PERFORM] shared_buffers > 284263 on OS X

2006-11-27 Thread AgentM
On Nov 27, 2006, at 2:23 , Brian Wipf wrote: On 26-Nov-06, at 11:25 PM, Jim C. Nasby wrote: On Sat, Nov 18, 2006 at 08:13:26PM -0700, Brian Wipf wrote: It certainly is unfortunate if Guido's right and this is an upper limit for OS X. The performance benefit of having high shared_buffers on

Re: [PERFORM] slow transfer speeds with PostgreSQL

2006-08-10 Thread AgentM
On Aug 3, 2006, at 19:39 , hansell baran wrote:When we run the following query "SELECT * FROM big_table", we get the following resutls: Very different results are obtained if a the query "SELECT * from big_table ORDER BY "some_column"". In this scenario  You should perform your test with queries wh