Re: Postgresql is very slow

От: Jeremy Harris
Тема: Re: Postgresql is very slow
Дата: ,
Msg-id: 485FA6DC.9090204@wizmail.org
(см: обсуждение, исходный текст)
Ответ на: Postgresql is very slow  (bijayant kumar)
Список: pgsql-performance

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

Postgresql is very slow  (bijayant kumar, )
 Re: Postgresql is very slow  (Jan de Visser, )
 Re: Postgresql is very slow  (Jeremy Harris, )
 Re: Postgresql is very slow  (, )
  Re: Postgresql is very slow  (bijayant kumar, )
   Re: Postgresql is very slow  ("Scott Marlowe", )
    Re: Postgresql is very slow  ("Scott Marlowe", )
    Re: Postgresql is very slow  (, )
     Re: Postgresql is very slow  (bijayant kumar, )
      Re: Postgresql is very slow  (, )
       Re: Postgresql is very slow  (bijayant kumar, )
       Re: [SOLVED] Postgresql is very slow  (bijayant kumar, )
      Re: Postgresql is very slow  (PFC, )
       Postgresql update op is very very slow  ("jay", )
        Re: Postgresql update op is very very slow  (Rusty Conover, )
         答复: [PERFORM] Postgresql update op is very very slow  ("jay", )
          PostgreSQL and Ruby on Rails - better accessibility  ("Amol Pujari", )
           Re: PostgreSQL and Ruby on Rails - better accessibility  (Nikhils, )
        Re: Postgresql update op is very very slow  ("Heikki Linnakangas", )
         答复: [PERFORM] Postgresql update op is very very slow  ("jay", )
          Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow  ("Pavan Deolasee", )
           Re: [PERFORM] Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow  ("Scott Marlowe", )
          Re: ??: Postgresql update op is very very slow  ("Heikki Linnakangas", )
          Re: 答复: [PERFORM] Postgresql update op is very very slow  (Tom Lane, )
           Re: [PERFORM] 答复: [PERFORM] Postgresql update op is very very slow  ("Scott Marlowe", )
        Re: Postgresql update op is very very slow  (Greg Smith, )
      Re: ??: Postgresql update op is very very slow  ("Holger Hoffstaette", )
       Re: ??: Postgresql update op is very very slow  (Craig Ringer, )
        Re: ??: Postgresql update op is very very slow  (Andrew Sullivan, )
        Re: ??: Postgresql update op is very very slow  (Greg Smith, )
       Re: ??: Postgresql update op is very very slow  (Andrew Sullivan, )
       Re: ??: Postgresql update op is very very slow  (Mark Mielke, )
       Re: ??: Postgresql update op is very very slow  (Greg Smith, )
    Re: Postgresql is very slow  ("Ian Barwick", )
 Re: Postgresql is very slow  ("Gregory S. Youngblood", )

bijayant kumar wrote:
>  select * from tablename takes 10-15 mins to give the output


There are better ways to dump data than using a database; that's
not a useful query.


> Any query select,insert,update simple or complex behaves in the same way

Have you set up suitable indexes for your operations (and then run analyze)?

Cheers,
   Jeremy


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

От: tv@fuzzy.cz
Дата:
Сообщение: Re: Postgresql is very slow
От: "Gregory S. Youngblood"
Дата:
Сообщение: Re: Postgresql is very slow