SEO

#1 (**permalink**) 04-10-2008, 05:33 AM

Hi,

I have a question about checkpoint in pg_version 7.4.
What is this and how affect performance of database?
How can i configure this variable for more performance?

Thanks
Diego Ziquinatti
From Brazil

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#2 (**permalink**) 04-10-2008, 05:33 AM

Diego,

Please read the following documentation for a quick start, and then come
back with further questions / doubts:

http://www.postgresql.org/docs/7.4/i...heckpoint.html

Best whishes,
Guido

On 12/7/05, Diego <diego@unimedijui.com.br> wrote:
>
> Hi,
>
> I have a question about checkpoint in pg_version 7.4.
> What is this and how affect performance of database?
> How can i configure this variable for more performance?
>
> Thanks
> Diego Ziquinatti
> From Brazil
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

--
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Checkpoint...