Re: what is the cause that scan type is showing as 'seq scan' after - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: what is the cause that scan type is showing as 'seq scan' after
Date
Msg-id 3FF973FC.6030004@bigfoot.com
Whole thread Raw
In response to Re: what is the cause that scan type is showing as 'seq scan' after  (Joseph Lemm <joelemm@yahoo.com>)
List 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









pgsql-admin by date:

Previous
From: "Andrzej Schulz"
Date:
Subject: Postgres & XML
Next
From: "Glenn Wiorek"
Date:
Subject: Re: what is the cause that scan type is showing as 'seq scan' after