Skip site navigation (1) Skip section navigation (2)

why is the db so slow?

From: Becky Neville <rebecca(dot)neville(at)yale(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Subject: why is the db so slow?
Date: 2003-05-03 17:40:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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 NevilleDate: 2003-05-03 17:57:52
Subject: Re: NOT IN doesn't use index? (fwd)
Previous:From: Becky NevilleDate: 2003-05-03 15:13:17
Subject: Re: looking for large dataset

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group