Re: Very high effective_cache_size == worse performance?

От: Kris Jurka
Тема: Re: Very high effective_cache_size == worse performance?
Дата: ,
Msg-id: alpine.BSO.2.00.1004201418530.30295@leary.csoft.net
(см: обсуждение, исходный текст)
Ответ на: Re: Very high effective_cache_size == worse performance?  (Nikolas Everett)
Список: pgsql-performance

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

Very high effective_cache_size == worse performance?  (David Kerr, )
 Re: Very high effective_cache_size == worse performance?  ("Joshua D. Drake", )
 Re: Very high effective_cache_size == worse performance?  (Robert Haas, )
  Re: Very high effective_cache_size == worse performance?  (David Kerr, )
   Re: Very high effective_cache_size == worse performance?  (Nikolas Everett, )
    Re: Very high effective_cache_size == worse performance?  (Kris Jurka, )
    Re: Very high effective_cache_size == worse performance?  (David Kerr, )
     Re: Very high effective_cache_size == worse performance?  (Scott Marlowe, )
      Re: Very high effective_cache_size == worse performance?  (David Kerr, )
       Re: Very high effective_cache_size == worse performance?  (Scott Marlowe, )
        Re: Very high effective_cache_size == worse performance?  (David Kerr, )
       Re: Very high effective_cache_size == worse performance?  (Scott Marlowe, )
       Re: Very high effective_cache_size == worse performance?  (Greg Smith, )
        Re: Very high effective_cache_size == worse performance?  (David Kerr, )
         Re: Very high effective_cache_size == worse performance?  (Greg Smith, )
   Re: Very high effective_cache_size == worse performance?  (Robert Haas, )
    Re: Very high effective_cache_size == worse performance?  (David Kerr, )
     Re: Very high effective_cache_size == worse performance?  (Scott Marlowe, )
      Re: Very high effective_cache_size == worse performance?  (Scott Carey, )
   Re: Very high effective_cache_size == worse performance?  ("Kevin Grittner", )
    Re: Very high effective_cache_size == worse performance?  (David Kerr, )
 Re: Very high effective_cache_size == worse performance?  (Scott Marlowe, )
  Re: Very high effective_cache_size == worse performance?  (Scott Marlowe, )
 Re: Very high effective_cache_size == worse performance?  ("Joshua D. Drake", )


On Tue, 20 Apr 2010, Nikolas Everett wrote:

> You can absolutely use copy if you like but you need to use a non-standard
> jdbc driver:  kato.iki.fi/sw/db/postgresql/jdbc/copy/.  I've used it in the
> past and it worked.

Copy support has been added to the 8.4 driver.

Kris Jurka


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

От: "Kevin Grittner"
Дата:
Сообщение: Re: significant slow down with various LIMIT
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Very high effective_cache_size == worse performance?