Re: [PERFORM] slow transfer speeds with PostgreSQL

2006-08-11 Thread Markus Schaber
Hi, Hansell, hansell baran wrote: > When we run the following query "SELECT * FROM big_table", we get the > following resutls: Just for Curiosity: Could you try to "COPY big_table TO stdout" from psql[.exe]? (and possibly redirect the psql output to /dev/null or so?) > Is there a way to increa

Re: [PERFORM] slow transfer speeds with PostgreSQL

2006-08-10 Thread Merlin Moncure
On 8/3/06, hansell baran <[EMAIL PROTECTED]> wrote: Hi. I'm new at using PostgreSQL. Where I work, all databases were built with MS Access. The Access files are hosted by computers with Windows 2000 and Windows XP. A new server is on its way and only Open Source Software is going to be installed

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

[PERFORM] slow transfer speeds with PostgreSQL

2006-08-10 Thread hansell baran
Hi. I'm new at using PostgreSQL.Where I work, all databases were built with MS Access. The Access files are hosted by computers with Windows 2000 and Windows XP. A new server is on its way and only Open Source Software is going to be installed. The OS is going to be SUSE Linux 10.1 and we are makin