Res: [SQL] UPDATE and DELEte with a lot of register is to slow...

2008-11-20 Thread paulo matadr
did you make analyse(vacuum ) in you database? De: Craig Ringer <[EMAIL PROTECTED]> Para: John Dizaro <[EMAIL PROTECTED]> Cc: pgsql-sql@postgresql.org Enviadas: Quinta-feira, 20 de Novembro de 2008 8:29:55 Assunto: Re: [SQL] UPDATE and DELEte with a lot of reg

Re: [SQL] [GENERAL] date range query help

2008-11-20 Thread Frank Bax
novice wrote: 2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>: On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote: sorry I get nothing :( Of course not. None of the dates you gave in the example overlap. But it should still have the 1st entry with the name Ben? Am

Re: [SQL] UPDATE and DELEte with a lot of register is to slow...

2008-11-20 Thread Craig Ringer
John Dizaro wrote: I have to execute some times an UPDATE an some times a DELETE to register +- 5 , every time when i do that the database be to slow do we any way to DELETE or UPDATE by part??? I'm not sure your post really contains enough information to answer your question. If

[SQL] UPDATE and DELEte with a lot of register is to slow...

2008-11-20 Thread John Dizaro
I have to execute some times an UPDATE an some times a DELETE to register +- 5 , every time when i do that the database be to slow do we any way to DELETE or UPDATE by part??? Thanks -- John Evan Dizaro -