Re: SELECT's take a long time compared to other DBMS

От: Relaxin
Тема: Re: SELECT's take a long time compared to other DBMS
Дата: ,
Msg-id: bj647d$234o$1@news.hub.org
(см: обсуждение, исходный текст)
Ответ на: SELECT's take a long time compared to other DBMS  ("Relaxin")
Ответы: Re: SELECT's take a long time compared to other DBMS  (Rudi Starcevic)
Re: SELECT's take a long time compared to other DBMS  ("Nick Fankhauser")
Список: pgsql-performance

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

SELECT's take a long time compared to other DBMS  ("Relaxin", )
 Re: SELECT's take a long time compared to other DBMS  (Rudi Starcevic, )
 Re: SELECT's take a long time compared to other DBMS  (Rod Taylor, )
 Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
  Re: SELECT's take a long time compared to other DBMS  (Rudi Starcevic, )
   Re: SELECT's take a long time compared to other DBMS  (Neil Conway, )
  Re: SELECT's take a long time compared to other DBMS  ("Nick Fankhauser", )
   Re: SELECT's take a long time compared to other DBMS  (Tom Lane, )
   Re: SELECT's take a long time compared to other DBMS  (Jean-Luc Lachance, )
   Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
 Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
 Re: SELECT's take a long time compared to other DBMS  (Christopher Browne, )
 Re: SELECT's take a long time compared to other DBMS  (Christopher Browne, )
 Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
  Re: SELECT's take a long time compared to other DBMS  ("Shridhar Daithankar", )
  Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
   Re: SELECT's take a long time compared to other DBMS  ("scott.marlowe", )
 Re: SELECT's take a long time compared to other DBMS  (Hannu Krosing, )
 Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
  Re: SELECT's take a long time compared to other DBMS  (Hannu Krosing, )
 Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
 Re: SELECT's take a long time compared to other DBMS  (William Yu, )
 Re: SELECT's take a long time compared to other DBMS  ("scott.marlowe", )
 Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
 Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
 Re: SELECT's take a long time compared to other DBMS  (Christopher Browne, )
 Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
  Re: SELECT's take a long time compared to other DBMS  (Neil Conway, )
  Re: SELECT's take a long time compared to other DBMS  ("Patrick Hatcher", )
  Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
   Re: SELECT's take a long time compared to other DBMS  (Neil Conway, )
  Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
 Re: SELECT's take a long time compared to other DBMS  ("Relaxin", )
  Re: SELECT's take a long time compared to other DBMS  (Eirik Oeverby, )

Yes I Analyze also, but there was no need to because it was a fresh brand
new database.

"Rudi Starcevic" <> wrote in message
news:...
> Hi,
>
>
> >And yes I did a vacuum.
> >
>
> Did you 'Analyze' too ?
>
> Cheers
> Rudi.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>




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

От: "Shridhar Daithankar"
Дата:
Сообщение: Re: PostgreSQL Reliability when fsync = false on Linux-XFS
От: Sean Chittenden
Дата:
Сообщение: Re: PostgreSQL Reliability when fsync = false on Linux-XFS