PROTECTED] nombre de Anjan Dave
Enviado el: viernes, 23 de septiembre de 2005 13:02
Para: pgsql-performance@postgresql.org
Asunto: [PERFORM] slow database, queries accumulating
Hi
We are experiencing consistent slowness on the database for one application.
This is more a reporting type of application
Hi
We are experiencing consistent slowness on the database for
one application. This is more a reporting type of application, heavy on the
bytea data type usage (gets rendered into PDFs in the app server). A lot of
queries, mostly selects and a few random updates, get accumulated on the
my data base is very slow. The machine is a processor Xeon 2GB with
256 MB of RAM DDR. My archive of configuration is this:
#
# PostgreSQL configuration file
# -
#
# This file consists of lines of the
On Feb 11, 2004, at 7:23 AM, [EMAIL PROTECTED] wrote:
#
# Optimizer Parameters
#
enable_seqscan = false
enable_indexscan = false
enable_tidscan = false
enable_sort = false
enable_nestloop = false
enable_mergejoin = false
enable_hashjoin = false
Why did you disable *every* type of query
On Wed, 2004-02-11 at 09:23, [EMAIL PROTECTED] wrote:
my data base is very slow. The machine is a processor Xeon 2GB with
256 MB of RAM DDR. My archive of configuration is this:
I'm not surprised. New values below old.
sort_mem = 131072 # min 64, size in KB
sort_mem = 8192.
On Feb 11, 2004, at 7:23 AM, [EMAIL PROTECTED] wrote:
my data base is very slow. The machine is a processor Xeon 2GB with
256 MB of RAM DDR. My archive of configuration is this:
After looking through the configuration some more, I would definitely
recommend getting rid of your current
[EMAIL PROTECTED] wrote:
my data base is very slow. The machine is a processor Xeon 2GB with
256 MB of RAM DDR. My archive of configuration is this:
This is a joke, right?
chris
---(end of broadcast)---
TIP 6: Have you searched our list
[EMAIL PROTECTED] writes:
my data base is very slow. The machine is a processor Xeon 2GB with
256 MB of RAM DDR. My archive of configuration is this:
sort_mem = 131072 # min 64, size in KB
#vacuum_mem = 8192 # min 1024, size in KB
Change it back to 8192, or perhaps
the normal queries do not present problems, but all the ones
that join has are very slow.
OBS: I am using way ODBC. He will be that they exist some
configuration specifies inside of the same bank or in the ODBC?
Quoting Rod Taylor [EMAIL PROTECTED]:
On Wed, 2004-02-11 at 09:23, [EMAIL
If my boss came to me and asked me to make my database server run as
slowly as possible, I might come up with the exact same postgresql.conf
file as what you posted.
Just installing the default postgresql.conf that came with postgresql
should make this machine run faster.
Read this:
On Wed, 2004-02-11 at 12:15, [EMAIL PROTECTED] wrote:
I already came back the old conditions and I continue slow in the same
way!
Dumb question, but did you restart the database after changing the
config file?
---(end of broadcast)---
TIP 5:
If things are still slow after you have checked your keys as indicated,
then pick one query and post the output from EXPLAIN ANALYZE for the
list to examine.
oh - and ensure you are *not* still using your original postgresql.conf :-)
best wishes
Mark
scott.marlowe wrote:
First thing I would
12 matches
Mail list logo