Re: Performance
От | Diego Schvartzman |
---|---|
Тема | Re: Performance |
Дата | |
Msg-id | 008101bfbea7$ad1df220$e80a0a0a@redfed8 обсуждение исходный текст |
Ответ на | Performance ("Diego Schvartzman" <dschvar@yahoo.com>) |
Ответы |
Re: Performance
Re: Performance |
Список | pgsql-general |
I have an application via PHP. For example, a SELECT query that must return one and only one row, with a where clause with and index (I droped it and created again) that took about 3 seconds (v6.5.3), now (v7.0.0) takes about 15 seconds. Really I don't lnow what is happening. Same hardware, same php version, etc etc. Thanks again! Diego Schvartzman Email: diego.schvartzman@usa.net ICQ# 1779434 ----- Original Message ----- From: Alfred Perlstein <bright@wintelcom.net> To: Diego Schvartzman <dschvar@yahoo.com> Cc: Lista PGSQL <pgsql-general@postgresql.org> Sent: Monday, May 15, 2000 5:18 PM Subject: Re: [GENERAL] Performance > * Diego Schvartzman <dschvar@yahoo.com> [000515 12:25] wrote: > > Hi all! > > I've upgraded to PGSQL 7.0.0 beta 2 from 6.5.3. Unloaded and loaded my db, > > vacuumed it, everything ok. I'm not using foreign keys. But now I see that > > performance is so much slower !. Is this supposed to be? Do I have to do > > something else? > > > > English is my second language. Thanks in advance ! > > A lot of people have said that performance has increased, if you want > any help you'll need to be more specific, give examples of what's > worse now than before. > > -- > -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org] > "I have the heart of a child; I keep it in a jar on my desk." >
В списке pgsql-general по дате отправления: