Postgres Pro
Downloads
Home   >   mailing lists

Re: Maximum size for char or varchar with limit - Mailing list pgsql-general

From Filip Rembiałkowski
Subject Re: Maximum size for char or varchar with limit
Date
Msg-id AANLkTinPxRMOpYgkikmfFL2bh=88KkkCurPXF2Ri9WG9@mail.gmail.com
Whole thread Raw
In response to Re: Maximum size for char or varchar with limit  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-general
Tree view

2010/12/19 Jasen Betts <jasen@xnet.co.nz>
I have some values of perhaps 20Mb that I might want to store samples
of in a partitioned table. (so I can delete them easily) what's the right way?


20 Mbits or 20 MBytes?

how big samples?

answer to your question depends on what you want to do with these samples in SQL.
 
if you could give more background information...


I guess I could just keep them as disk files and rotate the
directories as I rotate partitions.


if only reason is "to store" - then files are probably best idea.



PS. why did you post a reply to this thread? It does not seem related



pgsql-general by date:

Previous
From: Tatsuhito Kasahara
Date:
Subject: Re: pg_statsinfo problem
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: pg_statsinfo problem