Contact: fumanchu@aminus.org

Log in as guest/geniusql to create tickets

Ticket #4 (enhancement)

Opened 2 years ago

Last modified 8 months ago

Make it use type TEXT rather than VARCHAR(255).

Status: closed (fixed)

Reported by: schapman@mischko.com Assigned to: fumanchu
Priority: minor Milestone: 1.0
Component: SQL Version:
Keywords: Cc:
Estimate (total hours):

Postgresql does not suffer a performance penalty when using TEXT instead of VARCHAR so you can remove an arbitrary limitation this way.

Change History

07/29/07 00:11:49: Modified by fumanchu

  • reporter changed from guest to schapman@mischko.com.

Regarding char, varchar, and text, the Postgresql 8.0 docs say: 

There are no performance differences between these three types,
apart from the increased storage size when using the blank-padded
type. While character(n) has performance advantages in some other
database systems, it has no such advantages in PostgreSQL. In most
situations text or character varying should be used instead.

What "performance penalties" were you thinking of?

04/04/08 03:33:19: Modified by fumanchu

  • status changed from new to closed.
  • resolution set to fixed.
  • milestone set to 1.0.

Fixed in [249].