Re: Admin sloooow with postgresql and a 160k record table

2010-05-28 Thread Marcob
On 27 Mag, 22:58, Alex Gaynor wrote: > FWIW Jacob was wrong, there is another tiket, but I can't find out now > (yay trac search ;)), so don't be offended if I close your ticket. Alex, no offense at all :-) Ah, you don't be offended but I already closed it as a dupe of 8408 (thanks to Jeremy).

Re: Admin sloooow with postgresql and a 160k record table

2010-05-27 Thread Jeremy Dunck
Found via google site:... http://code.djangoproject.com/ticket/8408 On Thu, May 27, 2010 at 4:58 PM, Alex Gaynor wrote: > On Thu, May 27, 2010 at 11:54 PM, Marcob wrote: >> On May 27, 11:13 pm, Jacob Kaplan-Moss wrote: >> >>> I thought there was already a ticket open for this, but I can't seem

Re: Admin sloooow with postgresql and a 160k record table

2010-05-27 Thread Alex Gaynor
On Thu, May 27, 2010 at 11:54 PM, Marcob wrote: > On May 27, 11:13 pm, Jacob Kaplan-Moss wrote: > >> I thought there was already a ticket open for this, but I can't seem >> to find one. Can you open a ticket so that we don't forget? > > To posterity: http://code.djangoproject.com/ticket/13643 > >

Re: Admin sloooow with postgresql and a 160k record table

2010-05-27 Thread Marcob
On May 27, 11:13 pm, Jacob Kaplan-Moss wrote: > I thought there was already a ticket open for this, but I can't seem > to find one. Can you open a ticket so that we don't forget? To posterity: http://code.djangoproject.com/ticket/13643 :-) Ciao. Marco. -- You received this message because yo

Re: Admin sloooow with postgresql and a 160k record table

2010-05-27 Thread Marcob
On 27 Mag, 23:13, Jacob Kaplan-Moss wrote: > I thought there was already a ticket open for this, but I can't seem > to find one. Can you open a ticket so that we don't forget? Sure. Meanwhile I solved my problem with LazyPaginator and a bit of monkey patching. I'll post my ugly code within the

Re: Admin sloooow with postgresql and a 160k record table

2010-05-27 Thread Jacob Kaplan-Moss
rOn Thu, May 27, 2010 at 10:48 PM, Marcob wrote: > I've a table with only 160.000 records (but a record has many fields) > and opening its admin page takes 55 seconds. A select count(*) takes > 50 seconds, so I know it's all a db problem. Yeah, this is a known problem -- there really needs to be

Admin sloooow with postgresql and a 160k record table

2010-05-27 Thread Marcob
With postgresql count(*) is a slow operation because it forces a full table scan: http://groups.google.it/group/pgsql.performance/browse_thread/thread/6f94b296019a0e1e/d2d6ca3018f51cb3?hl=it&ie=UTF-8&q=postgresql+django+slow+count%28*%29#d2d6ca3018f51cb3 I've a table with only 160.000 records (but