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

Performance Issues

From: Dhanaraj M <Dhanaraj(dot)M(at)Sun(dot)COM>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Performance Issues
Date: 2006-05-23 11:55:11
Message-ID: 4472F81F.6060509@sun.com (view raw or flat)
Thread:
Lists: pgsql-hackers
I have the following doubts.

1. Does postgres create an index on every primary key?  Usually, queries 
are performed against a table on the primary key, so, an index on it 
will be very useful.

2. If 'm executing a complex query and it takes 10 seconds to return the 
results -- it takes 10 seconds to execute the next time also.  I'm 
wondering if there's any kind of caching that can be enabled -- so, the 
next time it takes <10 seconds to return the results.

Thanks
Dhanaraj

Responses

pgsql-hackers by date

Next:From: Douglas McNaughtDate: 2006-05-23 12:12:48
Subject: Re: Performance Issues
Previous:From: Hannu KrosingDate: 2006-05-23 11:30:55
Subject: Re: error-free disabling of individual child partition

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