Karl Denninger [EMAIL PROTECTED] writes:
akcs= explain analyze select forum, (replied (select lastview from forumlog where
forumlog.login='genesis' and forumlog.forum='General' and number=post.number)) as
newflag, * from post where forum = 'General' and toppost = 1 order by pinned desc,
On Fri, 6 Feb 2004, Bruno BAGUETTE wrote:
In addition to what Tom said, the row estimates look suspiciously
default. You mention vacuuming, but do you ever analyze
the tables?
I run VACUUM FULL ANALYZE with the postgres user on all the
PostgreSQL
databases on the server,