On Wed, Jan 08, 2003 at 17:04:40 +0100, Nikola Ivacic <[EMAIL PROTECTED]> wrote: > Hi > > I have trouble executing count(*) statement. > On a large dataset it takes quite a while to return result. > Is there any other way to get number of tupples in relation > or is the only way to optimize count() function to index it?
Indexes won't help count. If you retrieve counts a lot more than you do updates that will change their value, then you may want to keep the counts in another table and use triggers to keep them updated. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
