pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedHow 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