| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Maksim Likharev <mlikharev(at)aurigin(dot)com> |
| Cc: | PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Datatypes and performance |
| Date: | 2003-07-05 03:12:59 |
| Message-ID: | 20030705031259.GA2435@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 04, 2003 at 06:57:04PM -0700, 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?
In any case the tuple will probably "jerk around" different pages (I
don't think it's different whether the pages are from two tables or from
the same one). I fail to understand how that is a different performance
problem than for any other datatype. I'm sure you've done some
benchmark to determine that the varchar handling is as slow as you
appear to be saying?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Postgres is bloatware by design: it was built to house
PhD theses." (Joey Hellerstein, SIGMOD annual conference 2002)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-07-05 03:22:11 | Re: Are we backwards on the sign of timezones? |
| Previous Message | Maksim Likharev | 2003-07-05 01:57:04 | Re: Datatypes and performance |