Re: what is the cause that scan type is showing as 'seq scan' after

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Cc: Joseph Lemm <joelemm(at)yahoo(dot)com>
Subject: Re: what is the cause that scan type is showing as 'seq scan' after
Date: 2004-01-05 14:26:04
Message-ID: 3FF973FC.6030004@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Joseph Lemm wrote:

> Gaetano, thanks.
>
> My db has only one table (about 29,000 records), so I thought leaving
> postgreqsql.conf at its defaults would be OK: the params you mention are
> commented out, so they must be at their defaults, tho I can't tell what the
> defaults are.

The values on the line commented are the default values.

> Are there any docs that talk specificially about how to set these params and
> what the defaults are (the official docs don't say much)?

Take a look at performance NG, at least is what I use to do.

Regards
Gaetano Mendola

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Glenn Wiorek 2004-01-05 14:35:19 Re: what is the cause that scan type is showing as 'seq scan' after
Previous Message ma101kg 2004-01-05 14:20:47 query