Re: [Pypgsql-users] Help needed on performance

[Dick K. <D.J...@ch...>]

Hi,

I think this is the wrong list for this question. Go to the Postgres
lists. (Not that I'm not willing to help). It looks to me as a real
Postgres problem. Tuning of a database is a very specialized field, and
turning some knobs on the database sometimes drastically improves (or
deteriorates) performance.

Wish you luck.

Dick

On Fri, 2003-06-13 at 08:04, Dave Strickler wrote:
> If there's a good FAQ on this, please just point me there....
>  
> Background
> ------------
> I have a database that has 3 tables in it. One of the tables has about
> 15-20 fields in it, a number of them are strings, and so I have defined
> them as TEXT. The others are mostly INT4.
> I have indexes on 4 of the TEXT fields, and on one other INT4 fields. 
>  
> The table has 500k to 1m (size fluxuates) rows in it and is run on a
> Dual Processor 2.4 Xenon, with 2GB of RAM and a single IDE drive. Its
> running RH8, and has Apache running as well as Postgresql.
> 
>  
>  
> Problem
> ----------
> The crux of the problem is performance. At somewhere around 500k
> records in the table, the speed of SELECTs and DELETEs gets really poor.
> 'Poor' as in 2-3 minutes to do a DELETE of 1k rows. Under this number,
> the speed is excellent.
>  
> Any ideas on this?
>  
> TIA,
>  
>  
>  
> Dave Strickler 
> MailWise, LLC
> (617) 848-5942
> ------------------------------------
> Want to get rid of SPAM, Viruses, and unwanted content?
> MailWise Filter - nothing to install, maintain or upgrade.
> "Intelligent Email Protection(tm)" 
> Info at  http://www.mailwise.com
> ----
> 

> BEGIN:VCARD
> VERSION:2.1
> X-GWTYPE:USER
> FN:Dave Strickler
> TEL;WORK:617-267-0044 Ext. 10
> TEL;PREF;FAX:617-267-0055
> EMAIL;WORK;PREF;NGW:Dst...@ma...
> N:Strickler;Dave
> TITLE:President - DWS / MailWise
> END:VCARD
>