Re: [GENERAL] PostgreSQL Arrays and Performance

2006-01-08 Thread Marc Philipp
rapidly increasing > database size. Can you tell me more about free-space map settings? What exactly is the free-space map? The information in the documentation is not very helpful. How can dead tuples leak? Regards, Marc Philipp ---(end of broadcast)--

Re: [GENERAL] PostgreSQL Arrays and Performance

2006-01-08 Thread Marc Philipp
s. But there is not upper bound for their size. Regards, Marc Philipp ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Arrays and Performance

2006-01-08 Thread Marc Philipp
No, we don't get deadlock errors, but when running a vacuum and another process writing into the database there progress will stop at some point and nothing happens until one process is being killed. I think we used to vacuum every two nights and did a full vacuum once a week. Regards,

Re: [GENERAL] Arrays and Performance

2006-01-08 Thread Marc Philipp
Sorry for the duplicate post! My first post was stalled and my mail server down for a day or so. I will reply to your original posts. Regards, Marc Philipp ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an

[GENERAL] PostgreSQL Arrays and Performance

2006-01-03 Thread Marc Philipp
with the other columns or merely as a pointer to another file? Would it be more efficient to not use an array for this purpose but split the table in two parts? Any help is appreciated! Marc Philipp ---(end of broadcast)--- TIP 1: if posti