| From: | Dennis Björklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Maksim Likharev <mlikharev(at)aurigin(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Datatypes and performance |
| Date: | 2003-07-05 05:17:48 |
| Message-ID: | Pine.LNX.4.44.0307050711440.1516-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 4 Jul 2003, Maksim Likharev wrote:
> Ok, then if I store 4K - 1byte in a varchar and after that 4K + 1 byte,
> and again and again, you are saying me that my text will be jerking
> around 2 tables?
Updates in postgresql is not done inplace. It just adds the new data and
the old is kept around so that other concurrent transactions can still run
and use the old data. This gives a lot of speed when you have many
concurrent users.
Vacuum cleans out old unused data.
--
/Dennis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maksim Likharev | 2003-07-05 05:50:17 | Re: Datatypes and performance |
| Previous Message | Tom Lane | 2003-07-05 03:22:11 | Re: Are we backwards on the sign of timezones? |