Re: PostgreSQL does CAST implicitely between int and a domain derived from int

От: Kevin Grittner
Тема: Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Дата: ,
Msg-id: 4A9578DB020000250002A36D@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответы: Re: PostgreSQL does CAST implicitely between int and a domain derived from int  ("Kevin Grittner")
Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Jean-Michel Pouré)
Список: pgsql-performance

Скрыть дерево обсуждения

Re: PostgreSQL does CAST implicitely between int and a domain derived from int  ("Kevin Grittner", )
 Re: PostgreSQL does CAST implicitely between int and a domain derived from int  ("Kevin Grittner", )
  Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Jean-Michel Pouré, )
   Re: PostgreSQL does CAST implicitely between int and adomain derived from int  ("Kevin Grittner", )
    Re: PostgreSQL does CAST implicitely between int and adomain derived from int  (Jean-Michel Pouré, )
     Re: PostgreSQL does CAST implicitely between int andadomain derived from int  ("Kevin Grittner", )
      Re: PostgreSQL does CAST implicitely between int andadomain derived from int  (Jean-Michel Pouré, )
       Re: PostgreSQL does CAST implicitely between int and a domain derived from int  ("Kevin Grittner", )
        Re: PostgreSQL  (Jean-Michel Pouré, )
        Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Robert Haas, )
         Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Tom Lane, )
          Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Jean-Michel Pouré, )
           Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Bruce Momjian, )
            Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Jean-Michel Pouré, )
             Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Tom Lane, )
              Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Jean-Michel Pouré, )
               Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Tom Lane, )
                Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Greg Stark, )
         Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Jean-Michel Pouré, )
 Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Jean-Michel Pouré, )
  Re: PostgreSQL does CAST implicitely between int and adomain derived from int  ("Kevin Grittner", )
   Re: PostgreSQL does CAST implicitely between int and adomain derived from int  (Jean-Michel Pouré, )

Jean-Michel Pouré<> wrote:

> [no postgresql.conf changes except]
> shared_buffer 24M.

That's part of your problem.  (Well, that's understating it; we don't
have any real evidence that you have any performance problems *not*
resulting from failure to do normal configuration.)  If you download
the configurator tool I referenced in another email you can get a
start on fixing this.  Or search the lists -- this stuff had been
discussed many, many times.  Or do a google search; I typed

postgresql performance configuration

and got many hits.  If you spend even one hour closely reviewing any
of the top few hits and testing a more optimal configuration for your
hardware and workload, most of your performance problems would
probably go away.

Then, if you *still* have any performance problems, people could help
you diagnose and fine-tune from a base which should be much closer.

The truth is, with a proper configuration your "biggest problem",
which you've misdiagnosed as the result of casting, would probably go
away.  I will take another look at it now that you have the results of
EXPLAIN ANALYZE posted, but I seriously doubt that it's going to do
well without tuning the configuration.

-Kevin


В списке pgsql-performance по дате сообщения:

От: "Kevin Grittner"
Дата:
Сообщение: Re: PostgreSQL does CAST implicitely between int and a domain derived from int
От: Jean-Michel Pouré
Дата:
Сообщение: Re: PostgreSQL does CAST implicitely between int and a domain derived from int