| From: | KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Splitting a table for performance reasons |
| Date: | 2005-06-02 15:33:59 |
| Message-ID: | ED4E30DD9C43D5118DFB00508BBBA76EB1673D@neptun.sonorys.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
I've got a table whose records are more less big. There's however jus one
Int-column changed frequently.
According to postgres' MVCC a whole record gets written, even if just one
bit was changed.
I think of splitting the table now in two parts, connected via the former
PK.
so like:
a|b|data | othercol | int -> a|b| data|othercol + a|int
Will this solve my ongoing performance problem?
Or is the overhead for referencial intergrity and system columns bigger than
what this gives?
BTW: How can I find out how many bytes a record consumes (having just fixed
size data)?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2005-06-02 15:48:21 | Re: [SQL] index row size 2728 exceeds btree maximum, 27 |
| Previous Message | Markus Bertheau | 2005-06-02 15:25:16 | getting details about integrity constraint violation |