PROTECTED]
[mailto:[EMAIL 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 repo
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
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
First thing I would check is to make sure all those foreign keys are the
same type.
Second, make sure you've got indexes to go with them. I.e. on a multi-key
fk, have a multi-key index.
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
> the version is 7.3.2 in a connective 9.
> the hen foot is w
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: Ha
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
> I already came back the old conditions and I continue slow in the same
> way!
OK, we need some things from you to help troubleshoot this problem.
Postgresql version
schema of your tables
output of "explain analyze your query here"
a chicken foot (ha
the version is 7.3.2 in a connective 9.
the hen foot is without nails at the moment: =)
|
/|\
this is a principal table of system:
CREATE TABLE public.compra_prod_forn
(
nu_seq_prod_forn numeric(12) NOT NULL,
cd_fabricante numeric(6),
cd_moeda numeric(4) NOT NULL,
cd_compra numeric(12) N
I already came back the old conditions and I continue slow in the same
way!
Quoting Tom Lane <[EMAIL PROTECTED]>:
> [EMAIL PROTECTED] writes:
> > the normal queries do not present problems, but all the ones
> > that join has are very slow.
>
> No surprise, as you've disabled all but the stupides
[EMAIL PROTECTED] writes:
> the normal queries do not present problems, but all the ones
> that join has are very slow.
No surprise, as you've disabled all but the stupidest join algorithm...
As others already pointed out, you'd be a lot better off with the
default configuration settings than wit
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:
http://ww
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 PROT
[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 perh
[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 archives
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 postgresq
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:
#
# 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 metho
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
> somebody please knows to give tips to me to increase the
> performance
Run VACUUM ANALYZE. Find one query that is slow. Run EXPLAIN ANALYZE on
that query. Read the plan and figure out why it is slow. Fix it.
--
/Dennis Björklund
-
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 f
18 matches
Mail list logo