pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres Performance
12+ messages / 6 participants
[nested] [flat]
* Postgres Performance
@ 2002-04-23 09:18 Ian Cass <ian.cass@mblox.com>
0 siblings, 0 replies; 12+ messages in thread
From: Ian Cass @ 2002-04-23 09:18 UTC (permalink / raw)
To: pgsql-admin
Hi,
I'm sure this should be a FAQ, but I'm struggling with tuning my Postgres. I
wonder if someone can give me some advice or some pointers, or even a
suggested starting point for tuning.
Some details....
I've got Postgres 7.2.1 running on Debian with kernel 2.4.18. The database
is running on a e2fs filesystem on a large IDE hard drive (IBM 120GB
7200RPM).
The server is a dual 1.2Ghz Athlon with 1GB DDR Ram.
The database is going to contain 3 copies of an index header table
containing anything from 15-30 million lines. There is also 3 copies of a
detail table containing anything up to 4 times larger than it's
corresponding header table.
For the reports I've been writing, all lookups are indexed. Most of the
queries I've been writing are 'group by' selects referencing datasets of up
to 100k lines, returning about 20 lines to my application. Performance is
'adequate'. However, recently I've been trying to do date based index
lookups and these take forever, even for small lookups (~5000 lines).
According to my explains, all lookups are using indexes. I have run vacuum
analyse recently.
Currently, I have...
shared_buffers = 50000
sort_mem = 65536
I did try giving it more buffers, but performance got worse. There is no
system swapping. Disk accessing on heavy usage (indexing, etc) occurs at a
consistent 30-35MB/sec with minimal CPU hit, so disk IO is reasonable.
During a select, the cpu is mostly idle with low disk IO (1-2MB per sec). It
seems to me there's a sweet spot for buffers/system IO cache.
Hope someone can give me the benefit of their experience.
--
Ian Cass
^ permalink raw reply [nested|flat] 12+ messages in thread
* Postgres Performance
@ 2008-03-20 05:38 Aftab Alam <aalam@tsrdarashaw.com>
0 siblings, 2 replies; 12+ messages in thread
From: Aftab Alam @ 2008-03-20 05:38 UTC (permalink / raw)
To: pgsql-admin
Dear All,
I am using postgres 7.0 with linux with 15 GB of database & 3 gb of RAM.
Can anyone suggest what is the best setting for postgres. I am using postgres as web db.
Regards
aftab
________________________________
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Postgres Performance
@ 2008-03-20 09:42 Aftab Alam <aalam@tsrdarashaw.com>
parent: Aftab Alam <aalam@tsrdarashaw.com>
1 sibling, 0 replies; 12+ messages in thread
From: Aftab Alam @ 2008-03-20 09:42 UTC (permalink / raw)
To: pgsql-admin
Dear All,
I am using postgres 7.0 with linux with 15 GB of database & 3 gb of RAM.
Can anyone suggest what is the best setting for postgres. I am using postgres as web db.
Regards
aftab
________________________________
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Postgres Performance
@ 2008-03-20 09:57 hubert depesz lubaczewski <depesz@depesz.com>
0 siblings, 1 reply; 12+ messages in thread
From: hubert depesz lubaczewski @ 2008-03-20 09:57 UTC (permalink / raw)
To: Aftab Alam <aalam@tsrdarashaw.com>; +Cc: pgsql-admin
On Thu, Mar 20, 2008 at 03:12:43PM +0530, Aftab Alam wrote:
> I am using postgres 7.0 with linux with 15 GB of database & 3 gb of RAM.
> Can anyone suggest what is the best setting for postgres. I am using postgres as web db.
the best setting would be to upgrade.
7.0 was released in 2000, and is practically abandoned. the oldest
supported version at the moment is 7.4, but i would strongly suggest to
try to move to newest versions - like 8.3.1
regards,
hubert lubaczewski
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Postgres Performance
@ 2008-03-20 10:32 Aftab Alam <aalam@tsrdarashaw.com>
parent: hubert depesz lubaczewski <depesz@depesz.com>
0 siblings, 1 reply; 12+ messages in thread
From: Aftab Alam @ 2008-03-20 10:32 UTC (permalink / raw)
To: depesz@depesz.com; +Cc: pgsql-admin
Dear Hubert,
I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits
daily, can u suggest the best configuration. Mean while I am trying to
migrate it to 8.3.1
Regards
aftab
-----Original Message-----
From: hubert depesz lubaczewski [mailto:depesz@depesz.com]
Sent: Thursday, March 20, 2008 3:27 PM
To: Aftab Alam
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres Performance
On Thu, Mar 20, 2008 at 03:12:43PM +0530, Aftab Alam wrote:
> I am using postgres 7.0 with linux with 15 GB of database & 3
gb of RAM.
> Can anyone suggest what is the best setting for postgres. I am using
postgres as web db.
the best setting would be to upgrade.
7.0 was released in 2000, and is practically abandoned. the oldest
supported version at the moment is 7.4, but i would strongly suggest to
try to move to newest versions - like 8.3.1
regards,
hubert lubaczewski
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Postgres Performance
@ 2008-03-20 10:36 hubert depesz lubaczewski <depesz@depesz.com>
0 siblings, 0 replies; 12+ messages in thread
From: hubert depesz lubaczewski @ 2008-03-20 10:36 UTC (permalink / raw)
To: Aftab Alam <aalam@tsrdarashaw.com>; +Cc: pgsql-admin
On Thu, Mar 20, 2008 at 04:02:48PM +0530, Aftab Alam wrote:
> I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits
> daily, can u suggest the best configuration. Mean while I am trying to
> migrate it to 8.3.1
7.3 is also pretty old.
as for 2000 hits daily - it's not much. do you have performance issues?
check which queries couse the problems, and "explain analyze" them.
then, with explain analyze output, you can fix performance issues in
those queries.
regards,
depesz
--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Postgres Performance
@ 2008-03-20 11:03 Vishal Arora <aroravishal22@hotmail.com>
parent: Aftab Alam <aalam@tsrdarashaw.com>
0 siblings, 1 reply; 12+ messages in thread
From: Vishal Arora @ 2008-03-20 11:03 UTC (permalink / raw)
To: Aftab Alam <aalam@tsrdarashaw.com>; depesz@depesz.com; +Cc: pgsql-admin
> From: aalam@tsrdarashaw.com> To: depesz@depesz.com> CC: pgsql-admin@postgresql.org> Subject: Re: [ADMIN] Postgres Performance> Date: Thu, 20 Mar 2008 16:02:48 +0530> > Dear Hubert,> > I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits> daily, can u suggest the best configuration. Mean while I am trying to> migrate it to 8.3.1>
Still 7.3 is an older version.
> > I am using postgres 7.0 with linux with 15 GB of database & 3> gb of RAM.> > Can anyone suggest what is the best setting for postgres. I am using> postgres as web db.>
What are the performance issues you are facing? What are the settings you have made in you postgreSQL.conf file? Based on that we can suggest you to tune some parameters or any other solution.
- Vishal
_________________________________________________________________
Fashion Channel : Want to know what’s the latest in the fashion world ? You have it all here on MSN Fashion.
http://lifestyle.in.msn.com/=
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Postgres Performance
@ 2008-03-20 12:33 Aftab Alam <aalam@tsrdarashaw.com>
parent: Vishal Arora <aroravishal22@hotmail.com>
0 siblings, 1 reply; 12+ messages in thread
From: Aftab Alam @ 2008-03-20 12:33 UTC (permalink / raw)
To: Vishal Arora <aroravishal22@hotmail.com>; +Cc: pgsql-admin; depesz@depesz.com
Hi Vishal,
Attached is the conf file for your reference.
Regards
aftab
________________________________
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora
Sent: Thursday, March 20, 2008 4:34 PM
To: Aftab Alam; depesz@depesz.com
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres Performance
________________________________
> From: aalam@tsrdarashaw.com
> To: depesz@depesz.com
> CC: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Postgres Performance
> Date: Thu, 20 Mar 2008 16:02:48 +0530
>
> Dear Hubert,
>
> I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits
> daily, can u suggest the best configuration. Mean while I am trying to
> migrate it to 8.3.1
>
Still 7.3 is an older version.
> > I am using postgres 7.0 with linux with 15 GB of database & 3
> gb of RAM.
> > Can anyone suggest what is the best setting for postgres. I am using
> postgres as web db.
>
What are the performance issues you are facing? What are the settings you have made in you postgreSQL.conf file? Based on that we can suggest you to tune some parameters or any other solution.
- Vishal
________________________________
Coolhotmail : Board of the same old Email ID's? Get a unique one here. Try it now!<http://www.ideacellular.com/IDEA.portal;
________________________________
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.
Attachments:
postgresql.conf (text/plain, 5.2K) download
#
# PostgreSQL configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
# name = value
#
# (The '=' is optional.) White space may be used. Comments are introduced
# with '#' anywhere on a line. The complete list of option names and
# allowed values can be found in the PostgreSQL documentation. The
# commented-out settings shown in this file represent the default values.
#
# Any option can also be given as a command line switch to the
# postmaster, e.g. 'postmaster -c log_connections=on'. Some options
# can be changed at run-time with the 'SET' SQL command.
#
# This file is read on postmaster startup and when the postmaster
# receives a SIGHUP. If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect, or use
# "pg_ctl reload".
#========================================================================
#
# Connection Parameters
#
tcpip_socket = true
#ssl = false
#max_connections = 32
#superuser_reserved_connections = 2
#port = 5432
#hostname_lookup = false
#show_source_port = false
#unix_socket_directory = ''
#unix_socket_group = ''
#unix_socket_permissions = 0777 # octal
#virtual_host = ''
#krb_server_keyfile = ''
#
# Shared Memory Size
#
#shared_buffers = 64 # min max_connections*2 or 16, 8KB each
#max_fsm_relations = 1000 # min 10, fsm is free space map, ~40 bytes
#max_fsm_pages = 10000 # min 1000, fsm is free space map, ~6 bytes
#max_locks_per_transaction = 64 # min 10
#wal_buffers = 8 # min 4, typically 8KB each
#
# Non-shared Memory Sizes
#
sort_mem = 1024 # min 64, size in KB
#vacuum_mem = 8192 # min 1024, size in KB
#
# Write-ahead log (WAL)
#
#checkpoint_segments = 3 # in logfile segments, min 1, 16MB each
#checkpoint_timeout = 300 # range 30-3600, in seconds
#
#commit_delay = 0 # range 0-100000, in microseconds
#commit_siblings = 5 # range 1-1000
#
#fsync = true
#wal_sync_method = fsync # the default varies across platforms:
# # fsync, fdatasync, open_sync, or open_datasync
#wal_debug = 0 # range 0-16
#
# Optimizer Parameters
#
enable_seqscan = true
enable_indexscan = true
enable_tidscan = true
enable_sort = true
enable_nestloop = true
enable_mergejoin = true
enable_hashjoin = true
effective_cache_size = 1000 # typically 8KB each
#random_page_cost = 4 # units are one sequential page fetch cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tuple_cost = 0.001 # (same)
#cpu_operator_cost = 0.0025 # (same)
#from_collapse_limit = 8
#join_collapse_limit = 8 # 1 disables collapsing of explicit JOINs
#default_statistics_target = 10 # range 1-1000
#
# GEQO Optimizer Parameters
#
#geqo = true
#geqo_selection_bias = 2.0 # range 1.5-2.0
#geqo_threshold = 11
#geqo_pool_size = 0 # default based on tables in statement,
# range 128-1024
#geqo_effort = 1
#geqo_generations = 0
#geqo_random_seed = -1 # auto-compute seed
#
# Message display
#
#server_min_messages = notice # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, log, fatal,
# panic
#client_min_messages = notice # Values, in order of decreasing detail:
# debug5, debug4, debug3, debug2, debug1,
# log, info, notice, warning, error
#silent_mode = false
#log_connections = false
#log_pid = false
#log_statement = false
#log_duration = false
#log_timestamp = false
#log_min_error_statement = panic # Values in order of increasing severity:
# debug5, debug4, debug3, debug2, debug1,
# info, notice, warning, error, panic(off)
#debug_print_parse = false
#debug_print_rewritten = false
#debug_print_plan = false
#debug_pretty_print = false
#explain_pretty_print = true
# requires USE_ASSERT_CHECKING
#debug_assertions = true
#
# Syslog
#
#syslog = 0 # range 0-2
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
#
# Statistics
#
#show_parser_stats = false
#show_planner_stats = false
#show_executor_stats = false
#show_statement_stats = false
# requires BTREE_BUILD_STATS
#show_btree_build_stats = false
#
# Access statistics collection
#
#stats_start_collector = true
#stats_reset_on_server_start = true
#stats_command_string = false
#stats_row_level = false
#stats_block_level = false
#
# Lock Tracing
#
#trace_notify = false
# requires LOCK_DEBUG
#trace_locks = false
#trace_userlocks = false
#trace_lwlocks = false
#debug_deadlocks = false
#trace_lock_oidmin = 16384
#trace_lock_table = 0
#
# Misc
#
#autocommit = true
#dynamic_library_path = '$libdir'
#search_path = '$user,public'
#datestyle = 'iso, us'
#timezone = unknown # actually, defaults to TZ environment setting
#australian_timezones = false
#client_encoding = sql_ascii # actually, defaults to database encoding
#authentication_timeout = 60 # 1-600, in seconds
#deadlock_timeout = 1000 # in milliseconds
#default_transaction_isolation = 'read committed'
#max_expr_depth = 10000 # min 10
#max_files_per_process = 1000 # min 25
#password_encryption = true
#sql_inheritance = true
#transform_null_equals = false
#statement_timeout = 0 # 0 is disabled, in milliseconds
#db_user_namespace = false
#
# Locale settings
#
# (initialized by initdb -- may be changed)
LC_MESSAGES = 'en_US.UTF-8'
LC_MONETARY = 'en_US.UTF-8'
LC_NUMERIC = 'en_US.UTF-8'
LC_TIME = 'en_US.UTF-8'
=
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Postgres Performance
@ 2008-03-20 16:52 Vishal Arora <aroravishal22@hotmail.com>
parent: Aftab Alam <aalam@tsrdarashaw.com>
0 siblings, 0 replies; 12+ messages in thread
From: Vishal Arora @ 2008-03-20 16:52 UTC (permalink / raw)
To: Aftab Alam <aalam@tsrdarashaw.com>; +Cc: pgsql-admin
Based on your conf file.. you can increase shared buffers and also you can increase the max_connections. (I am not sure if your version of Postgres supports more than 32 connections. Just check that). Apart from that you can use Explain Analyze on any specific query which you think is having any performance issues.
- Vishal
From: aalam@tsrdarashaw.comTo: aroravishal22@hotmail.comCC: pgsql-admin@postgresql.org; depesz@depesz.comSubject: RE: [ADMIN] Postgres PerformanceDate: Thu, 20 Mar 2008 18:03:13 +0530
Hi Vishal,
Attached is the conf file for your reference.
Regards
aftab
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal AroraSent: Thursday, March 20, 2008 4:34 PMTo: Aftab Alam; depesz@depesz.comCc: pgsql-admin@postgresql.orgSubject: Re: [ADMIN] Postgres Performance
> From: aalam@tsrdarashaw.com> To: depesz@depesz.com> CC: pgsql-admin@postgresql.org> Subject: Re: [ADMIN] Postgres Performance> Date: Thu, 20 Mar 2008 16:02:48 +0530> > Dear Hubert,> > I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits> daily, can u suggest the best configuration. Mean while I am trying to> migrate it to 8.3.1> Still 7.3 is an older version. > > I am using postgres 7.0 with linux with 15 GB of database & 3> gb of RAM.> > Can anyone suggest what is the best setting for postgres. I am using> postgres as web db.> What are the performance issues you are facing? What are the settings you have made in you postgreSQL.conf file? Based on that we can suggest you to tune some parameters or any other solution. - Vishal
Coolhotmail : Board of the same old Email ID’s? Get a unique one here. Try it now!
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail system.
_________________________________________________________________
Fashion Channel : Want to know what’s the latest in the fashion world ? You have it all here on MSN Fashion.
http://lifestyle.in.msn.com/=
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Postgres Performance
@ 2008-03-20 22:13 Steve Crawford <scrawford@pinpointresearch.com>
parent: Aftab Alam <aalam@tsrdarashaw.com>
1 sibling, 1 reply; 12+ messages in thread
From: Steve Crawford @ 2008-03-20 22:13 UTC (permalink / raw)
To: Aftab Alam <aalam@tsrdarashaw.com>; +Cc: pgsql-admin
Aftab Alam wrote:
>
> Dear All,
>
>
>
> I am using postgres 7.0 with linux with 15 GB of database
> & 3 gb of RAM.
>
> Can anyone suggest what is the best setting for postgres. I am using
> postgres as web db.
>
>
I'm going to assume/hope that you mean 8.0. Even then, you would be well
advised to upgrade. 8.0 is over three years old and no amount of tuning
will make it as fast as the newer releases.
Then look at http://www.google.com/search?q=postgresql+tuning
The Varlena articles are good even if dated. After reading a few pages
and trying a bit of experimentation, check back with unanswered
questions. Nobody can recommend a "best setting" without a thorough
understanding of your workload. Or even if they do -
guidelines/suggestions is the best you will find.
Cheers,
Steve
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Postgres Performance
@ 2008-03-21 19:50 Steve Crawford <scrawford@pinpointresearch.com>
parent: Steve Crawford <scrawford@pinpointresearch.com>
0 siblings, 0 replies; 12+ messages in thread
From: Steve Crawford @ 2008-03-21 19:50 UTC (permalink / raw)
To: Aftab Alam <aalam@tsrdarashaw.com>; +Cc: pgsql-admin
> I am using postgres 7.0 with linux with 15 GB of database &
> 3 gb of RAM. Can anyone suggest what is the best setting
> for postgres. I am using postgres as web db.
You mentioned elsewhere that you are getting 2,000 hits/day. I don't
know the nature of your web app but typical web apps involve pretty
simple transactions. Even with an average of 10 database transactions
per hit, your average is less than 0.25 TPS - several orders of
magnitude lower than the likely capacity of your hardware.
If you are experiencing performance problems I think that you may need
to look into more than the config file:
1. Are you vacuuming regularly? If not, you may need a vacuum full
followed by regular vacuuming.
2. Have you established appropriate indexes?
3. Are you running analyze to allow the planner to use the indexes you
created?
Cheers,
Steve
^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Postgres Performance
@ 2008-03-23 03:01 Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 12+ messages in thread
From: Scott Marlowe @ 2008-03-23 03:01 UTC (permalink / raw)
To: Aftab Alam <aalam@tsrdarashaw.com>; +Cc: pgsql-admin
On Wed, Mar 19, 2008 at 11:38 PM, Aftab Alam <aalam@tsrdarashaw.com> wrote:
>
> Dear All,
>
> I am using postgres 7.0 with linux with 15 GB of database & 3 gb
> of RAM.
>
> Can anyone suggest what is the best setting for postgres. I am using
> postgres as web db.
If you really are running 7.0 you need to look at upgrading. That
version has known data eating bugs that will not be fixed.
^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2008-03-23 03:01 UTC | newest]
Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-23 09:18 Postgres Performance Ian Cass <ian.cass@mblox.com>
2008-03-20 05:38 Postgres Performance Aftab Alam <aalam@tsrdarashaw.com>
2008-03-20 09:42 ` Aftab Alam <aalam@tsrdarashaw.com>
2008-03-20 22:13 ` Steve Crawford <scrawford@pinpointresearch.com>
2008-03-21 19:50 ` Steve Crawford <scrawford@pinpointresearch.com>
2008-03-20 09:57 Re: Postgres Performance hubert depesz lubaczewski <depesz@depesz.com>
2008-03-20 10:32 ` Aftab Alam <aalam@tsrdarashaw.com>
2008-03-20 11:03 ` Vishal Arora <aroravishal22@hotmail.com>
2008-03-20 12:33 ` Aftab Alam <aalam@tsrdarashaw.com>
2008-03-20 16:52 ` Vishal Arora <aroravishal22@hotmail.com>
2008-03-20 10:36 Re: Postgres Performance hubert depesz lubaczewski <depesz@depesz.com>
2008-03-23 03:01 Re: Postgres Performance Scott Marlowe <scott.marlowe@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