pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Checkpoint...
2+ messages / 2 participants
[nested] [flat]

* Checkpoint...
@ 2005-12-07 12:46 Diego <diego@unimedijui.com.br>
  2005-12-07 11:54 ` Re: Checkpoint... Guido Barosio <gbarosio@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Diego @ 2005-12-07 12:46 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Checkpoint...
  2005-12-07 12:46 Checkpoint... Diego <diego@unimedijui.com.br>
@ 2005-12-07 11:54 ` Guido Barosio <gbarosio@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Guido Barosio @ 2005-12-07 11:54 UTC (permalink / raw)
  To: Diego <diego@unimedijui.com.br>; +Cc: pgsql-admin

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/interactive/sql-checkpoint.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.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-12-07 12:46 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-07 12:46 Checkpoint... Diego <diego@unimedijui.com.br>
2005-12-07 11:54 ` Guido Barosio <gbarosio@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox