Re: [PERFORM] How to avoid database bloat

2005-06-05 Thread stig erikson
Mindaugas Riauba wrote: Hello, Our database increases in size 2.5 times during the day. What to do to avoid this? Autovacuum running with quite aggressive settings, FSM settings are high enough. Database size should be more or less constant but it has high turnover rate (100+

Re: [PERFORM] name search query speed

2005-03-04 Thread stig erikson
Jeremiah Jahn wrote: I have about 5M names stored on my DB. Currently the searches are very quick unless, they are on a very common last name ie. SMITH. The Index is always used, but I still hit 10-20 seconds on a SMITH or Jones search, and I average about 6 searches a second and max out at about

Re: [PERFORM] What is the postgres sql command for last_user_id ???

2005-03-04 Thread stig erikson
[EMAIL PROTECTED] wrote: I would like to know whether there is any command which the server will give the record ID back to the client when client puts the data and the server generates an autoincrement ID for that record. For example if many clients try to put the money data to the server and