Achilleus,
> > > The pgsql db is indexed on the > > > 'authuser' field, and I've run 'analyze logfile'. > > > > He also needs to index the bytes field and the traffic field. And run > ^^^^^^^ > > Index on an aggregate function??? > > I though we could only index plain normal column iscachable functions. No, you're correct. I meant just to index on the bytes field. -- -Josh Berkus ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
