Hello.
I would like to build a shared repository for Enterprise Architect
(http://www.sparxsystems.com.au/ea.htm) using PostgreSQL. I have done it
before with Linux and FreeBSD servers and everything was working out of the
box. The repository is pretty simple database with less than 100 tables
Good afternoon,
We have an application based on opencms6 / Tomcat5. The data management of the
content is kept in a PostgreSQL 8.0.2 base.
The pages' display is extremely slow (it can take up to several minutes per
refresh). Thus, it would not be applicable in production.
Material configuration
Hello.
I would like to build a shared repository for Enterprise Architect
(http://www.sparxsystems.com.au/ea.htm) using PostgreSQL. I have done
it
before with Linux and FreeBSD servers and everything was working out
of
the
box. The repository is pretty simple database with less than 100
On Tue, Sep 13, 2005 at 07:58:20AM -0400, Merlin Moncure wrote:
Can you give specific examples of cases that are not performing like you
expect? If possible, give a few queries with explain analyze times and
all that.
O.K. I have found one particular problem:
2005-09-13 14:43:02 LOG:
On Tue, Sep 13, 2005 at 07:58:20AM -0400, Merlin Moncure wrote:
This command is executed while a model is loaded from the repository.
The table definition is:
CREATE TABLE t_umlpattern (
PatternID INTEGER DEFAULT nextval('patternid_seq'::text) NOT
NULL
PRIMARY KEY,
* Brandon Black ([EMAIL PROTECTED]) wrote:
Ideally I'd like to commit the data seperately, as the data could contain
errors which abort the transaction, but it may come down to batching it and
coding things such that I can catch and discard the offending row and retry
the transaction if it
On Tue, Sep 13, 2005 at 10:20:05AM -0400, Merlin Moncure wrote:
I loaded your dump and was able to select entire table in trivial time
from both pgAdmin and psql shell. I am suspecting some type of tcp
problem here. Can you confirm slow times on unloaded server?
Did you run the select
Did you run the select remotely on a Windows server?
yes.
Yes the server load is practically 0. Note the difference between
local
and
remote execution of the command. I think you are right about the
network
problem possibility. But it is bound to PostgreSQL. MySQL on the same
machine (and
This is sounding suspiciously similar to behavior I've seen with other types of
TCP database connections when the tcp-no-delay option is not on. Is it
possible that the ODBC driver for Windows is not successfully setting this up?
-Kevin
Dalibor Sramek [EMAIL PROTECTED] 09/13/05 9:34 AM
Dalibor Sramek [EMAIL PROTECTED] writes:
select * from t_umlpattern limit 2
takes 1500+ msec on the Windows machine and 60 on a comparable Linux
machine. Both selects performed from remote PgAdmin.
The same select performed localy on the windows machine takes 60 msec.
So it's a networking
On 9/12/05, Christopher Petrilli [EMAIL PROTECTED] wrote:
3) Use 8.1 and strongly look at Bizgres. The data partitioning is critical.
I started looking closer at my options for partitioning (inheritance,
union all), and at Bizgres today. Bizgres partitioning appears to be
basically the same kind
On Mon, 12 Sep 2005 16:04:06 -0500
Brandon Black [EMAIL PROTECTED] wrote:
I've seen serveral tests PostgreSQL on JFS file system, it runs faster than
using ext3.
Our production server works using JFS and RAID10,
we have 250K+ transactions per day and everything is OK.
Try switching to separate
On Tue, 2005-09-13 at 11:30, Brandon Black wrote:
I started looking closer at my options for partitioning (inheritance,
union all), and at Bizgres today. Bizgres partitioning appears to be
basically the same kind of inheritance partitioning one can do in
mainline PostgreSQL. Am I correct in
On Tue, Sep 13, 2005 at 12:16:55PM -0400, Ian Westmacott wrote:
On Tue, 2005-09-13 at 11:30, Brandon Black wrote:
I started looking closer at my options for partitioning (inheritance,
union all), and at Bizgres today. Bizgres partitioning appears to be
basically the same kind of
On Tue, Sep 13, 2005 at 11:32:02AM -0400, Tom Lane wrote:
So it's a networking issue. I haven't paid real close attention to
...
updates. Check through the list archives ...
This one
http://archives.postgresql.org/pgsql-performance/2005-06/msg00593.php
seems to be very similar to my
unsubscribe-digest
Hello All,
We are struggling with a specific query that is killing us. When doing
explain analyze on the entire query, we *seem* to be getting killed by the
estimated number of rows on a case statement calculation.
I've included a snippet from the explain analyze of the much larger query. The
unsubscribe-digest
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hello all!
On my master course, I'm studying the PostgreSQL's optimizer.
I don't know if anyone in this list have been participated from the
PostgreSQL's Optimizer development, but maybe someone can help me on
this question.
PostgreSQL generates all possible plans of executing the query (using
an
Pryscila B Guttoski wrote:
On my master course, I'm studying the PostgreSQL's optimizer.
I don't know if anyone in this list have been participated from the
PostgreSQL's Optimizer development, but maybe someone can help me on this
question.
pgsql-hackers might be more appropriate.
Pryscila B Guttoski wrote:
Hello all!
On my master course, I'm studying the PostgreSQL's optimizer.
I don't know if anyone in this list have been participated from the
PostgreSQL's Optimizer development, but maybe someone can help me on
this question.
PostgreSQL generates all possible plans
I know you almost had read this, but I think it is
a good paper to start with...
http://lca2005.linux.org.au/Papers/Neil%20Conway/Inside%20the%20PostgreSQL%20Query%20Optimizer/pg_query_optimizer.pdf
Anyway, do you know where could I get more info and
theory about database optimizer plan?
Hi, I've reading around there about some way to
help pgsql with the data caching using memcached inside the sps in the database
(not in the application), does anybody have success with that?
Thanks a lot!
Thank's guys!
I'll send to pgsql-hackers...
[]'s
PryscilaOn 9/13/05, Neil Conway [EMAIL PROTECTED] wrote:
Pryscila B Guttoski wrote: On my master course, I'm studying the PostgreSQL's optimizer. I don't know if anyone in this list have been participated from the PostgreSQL's Optimizer
Cristian Prieto wrote:
Anyway, do you know where could I get more info and theory about
database optimizer plan? (in general)
Personally I like this survey paper on query optimization:
http://citeseer.csail.mit.edu/371707.html
The paper also cites a lot of other papers that cover
Neil Conway [EMAIL PROTECTED] writes:
Pryscila B Guttoski wrote:
On my master course, I'm studying the PostgreSQL's optimizer.
I don't know if anyone in this list have been participated from the
PostgreSQL's Optimizer development, but maybe someone can help me on this
question.
Hi guys,
I really appreciate your suggestions abouts papers, specially this one: http://citeseer.csail.mit.edu/371707.html
I found some answers on it, like this:
Q: Why the main query planner uses a nearly-exhaustive search?
A: (Page 20 - 4.2.2) ... up to about ten joins, dynamic programming
27 matches
Mail list logo