Re: Insertion to temp table deteriorating over time
| От | Steven Flatt |
|---|---|
| Тема | Re: Insertion to temp table deteriorating over time |
| Дата | |
| Msg-id | 357fa7590612151026t4ae033f6w5367cac9d0b67064@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Insertion to temp table deteriorating over time (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Insertion to temp table deteriorating over time
|
| Список | pgsql-performance |
Good question, and I agree with your point.
Are the removable rows in pg_class even an issue? So what if 5000-6000 dead tuples are generated every hour then vacuumed? Performance continues to steadily decline over a few days time. Memory usage does not appear to be bloating. Open file handles remain fairly fixed. Is there anything else I can monitor (perhaps something to do with the odbc connection) that I could potentially correlate with the degrading performance?
Steve
On 12/15/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Oh, then where *are* the removable rows coming from? At this point I
think that the truncate/refill thing is not the culprit, or at any rate
is only one part of a problematic usage pattern that we don't see all of
yet.
regards, tom lane
В списке pgsql-performance по дате отправления: