pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How to configure the postgresql.conf files
3+ messages / 2 participants
[nested] [flat]

* How to configure the postgresql.conf files
@ 2003-07-14 03:26 Chris_Wu <Chris.Wu@Sanmina-SCI.Com>
  2003-07-14 03:35 ` Re: How to configure the postgresql.conf files Rudi Starcevic <rudi@oasis.net.au>
  2003-07-14 03:46 ` Re: How to configure the postgresql.conf files Rudi Starcevic <rudi@oasis.net.au>
  0 siblings, 2 replies; 3+ messages in thread

From: Chris_Wu @ 2003-07-14 03:26 UTC (permalink / raw)
  To: pgsql-performance

Hello all!
          I'm a new to Postgresql , I have never used it  before.
          I am having an issue with configure the postgresql.conf file.
          The machine itself is a
      CPU= 2.66GHz P4 w/
      Memory= 2G
          Maybe you can tell me how to configure these parameters.
          shared_buffers=
          max_fsm_relations=
          max_fsm_pages=
          max_locks_per_transaction=
          wal_buffers=
          sort_mem=
          vacuum_mem=
          wal_files=
          wal_sync_method=
          wal_debug =
          commit_delay =
          commit_siblings =
          checkpoint_segments =
          checkpoint_timeout =
          fsync = true
          enable_seqscan =
          enable_indexscan =
          enable_tidscan =
          enable_sort =
          enable_nestloop =
          enable_mergejoin =
          enable_hashjoin =
          ksqo =
          effective_cache_size =
          random_page_cost =
          cpu_tuple_cost =
          cpu_index_tuple_cost =
          cpu_operator_cost =

          Would you mind to send me a copy of examples .(postgresql.conf)
          Thanks
          Sincerely,

Chris.Wu





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

* Re: How to configure the postgresql.conf files
  2003-07-14 03:26 How to configure the postgresql.conf files Chris_Wu <Chris.Wu@Sanmina-SCI.Com>
@ 2003-07-14 03:35 ` Rudi Starcevic <rudi@oasis.net.au>
  1 sibling, 0 replies; 3+ messages in thread

From: Rudi Starcevic @ 2003-07-14 03:35 UTC (permalink / raw)
  To: Chris.Wu@Sanmina-SCI.Com; +Cc: pgsql-performance

Hi Chris,

I suggest you read this tech. document:

http://www.varlena.com/GeneralBits/

I think you'll it's the best place to start.

Cheers
Rudi.

Chris_Wu wrote:

>Hello all!
>          I'm a new to Postgresql , I have never used it  before.
>          I am having an issue with configure the postgresql.conf file.
>          The machine itself is a
>      CPU= 2.66GHz P4 w/
>      Memory= 2G
>          Maybe you can tell me how to configure these parameters.
>          shared_buffers=
>          max_fsm_relations=
>          max_fsm_pages=
>          max_locks_per_transaction=
>          wal_buffers=
>          sort_mem=
>          vacuum_mem=
>          wal_files=
>          wal_sync_method=
>          wal_debug =
>          commit_delay =
>          commit_siblings =
>          checkpoint_segments =
>          checkpoint_timeout =
>          fsync = true
>          enable_seqscan =
>          enable_indexscan =
>          enable_tidscan =
>          enable_sort =
>          enable_nestloop =
>          enable_mergejoin =
>          enable_hashjoin =
>          ksqo =
>          effective_cache_size =
>          random_page_cost =
>          cpu_tuple_cost =
>          cpu_index_tuple_cost =
>          cpu_operator_cost =
>
>          Would you mind to send me a copy of examples .(postgresql.conf)
>          Thanks
>          Sincerely,
>
>Chris.Wu
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>
>  
>





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

* Re: How to configure the postgresql.conf files
  2003-07-14 03:26 How to configure the postgresql.conf files Chris_Wu <Chris.Wu@Sanmina-SCI.Com>
@ 2003-07-14 03:46 ` Rudi Starcevic <rudi@oasis.net.au>
  1 sibling, 0 replies; 3+ messages in thread

From: Rudi Starcevic @ 2003-07-14 03:46 UTC (permalink / raw)
  To: Chris.Wu@Sanmina-SCI.Com; +Cc: pgsql-performance

Chris,

Oops - it's changed !

Here's the link's you need:

http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html

Cheers
Rudi.

Chris_Wu wrote:

>Hello all!
>          I'm a new to Postgresql , I have never used it  before.
>          I am having an issue with configure the postgresql.conf file.
>          The machine itself is a
>      CPU= 2.66GHz P4 w/
>      Memory= 2G
>          Maybe you can tell me how to configure these parameters.
>          shared_buffers=
>          max_fsm_relations=
>          max_fsm_pages=
>          max_locks_per_transaction=
>          wal_buffers=
>          sort_mem=
>          vacuum_mem=
>          wal_files=
>          wal_sync_method=
>          wal_debug =
>          commit_delay =
>          commit_siblings =
>          checkpoint_segments =
>          checkpoint_timeout =
>          fsync = true
>          enable_seqscan =
>          enable_indexscan =
>          enable_tidscan =
>          enable_sort =
>          enable_nestloop =
>          enable_mergejoin =
>          enable_hashjoin =
>          ksqo =
>          effective_cache_size =
>          random_page_cost =
>          cpu_tuple_cost =
>          cpu_index_tuple_cost =
>          cpu_operator_cost =
>
>          Would you mind to send me a copy of examples .(postgresql.conf)
>          Thanks
>          Sincerely,
>
>Chris.Wu
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>
>  
>





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


end of thread, other threads:[~2003-07-14 03:46 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-14 03:26 How to configure the postgresql.conf files Chris_Wu <Chris.Wu@Sanmina-SCI.Com>
2003-07-14 03:35 ` Rudi Starcevic <rudi@oasis.net.au>
2003-07-14 03:46 ` Rudi Starcevic <rudi@oasis.net.au>

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