I am running my own database server but I don't have root privilege (and
no hope of getting it.)
I only have 3 tables, with rowcounts of 3000, 48000 and 2 million.
I don't think this is that many rows but most things take a long time to
run. There are a lot of indexes on each table and creating an index on
the 2mil row table takes forever, which I could perhaps live with BUT -
typing something as dumb as \! pwd is not instantaneous either and there
doesn't seem to be anyone else hogging up the CPU.
I am on Linux and due to lack of space in my own account, I have PGDATA
pointing to /tmp.
(This is for a class project to analyze query performance ...I can
recreate the data at any time if necessary.)
Are there any parameters I can set to speed things up?
pgsql-performance by date
|Next:||From: Becky Neville||Date: 2003-05-03 17:57:52|
|Subject: Re: NOT IN doesn't use index? (fwd)|
|Previous:||From: Becky Neville||Date: 2003-05-03 15:13:17|
|Subject: Re: looking for large dataset|