Re: [PERFORM] how postgresql request the computer resources

2005-10-27 Thread Jim C. Nasby
On Thu, Oct 27, 2005 at 03:58:55PM -0600, Michael Best wrote: > Richard Huxton wrote: > >>WITH ANY OF THIS QUERIES MSSQL TAKES NOT MUCH OF 7 SECONDS > > > > > >In which case they make a bad choice for showing PostgreSQL is faster > >than MSSQL. Is this the only query you have, or are others gi

Re: [PERFORM] how postgresql request the computer resources

2005-10-27 Thread Michael Best
Richard Huxton wrote: WITH ANY OF THIS QUERIES MSSQL TAKES NOT MUCH OF 7 SECONDS In which case they make a bad choice for showing PostgreSQL is faster than MSSQL. Is this the only query you have, or are others giving you problems too? I think count(*) is about the weakest point in PG,

Re: [PERFORM] how postgresql request the computer resources

2005-10-27 Thread Richard Huxton
Sidar López Cruz wrote: Is there something that tells postgres to take the resorces from computer (RAM, HDD, SWAP on linux) as it need, not modifying variables on postgresql.conf and other operating system things? Ah, and how is it to know what to share with other processes? A days ago i am t

[PERFORM] how postgresql request the computer resources

2005-10-27 Thread Sidar López Cruz
Is there something that tells postgres to take the resorces from computer (RAM, HDD, SWAP on linux) as it need, not modifying variables on postgresql.conf and other operating system things? A days ago i am trying to show that postgres is better than mssql but when execute a simple query like: