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 is
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.
>
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 specific
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 develop
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!
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?
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 of
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.
PostgreSQL
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
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,
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
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 probl
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 inhe
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
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 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 kin
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 networkin
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
> 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
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 remo
* 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
> 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,
> Pa
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: stat
> 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
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 tables (th
27 matches
Mail list logo