Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Performance Issues
- From: Dhanaraj M <Dhanaraj(dot)M(at)Sun(dot)COM>
- To: pgsql-hackers(at)postgresql(dot)org
- Subject: Performance Issues
- Date: Tue, 23 May 2006 17:25:11 +0530
- Message-id: <4472F81F(dot)6060509(at)sun(dot)com>
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
- Follow-Ups:
- Re: Performance Issues
- From: Richard Huxton
- Re: Performance Issues
- From: Douglas McNaught
- Re: Performance Issues
- Prev by Date: Re: error-free disabling of individual child partition
- Next by Date: Re: Performance Issues
- Previous by thread: Re: error-free disabling of individual child partition
- Next by thread: Re: Performance Issues
- Indexes: