For performance point of view, are there big differences between:
char(N), varchar(N), varchar, text?
Some comments from google shows:
No difference, under the hood it's all varlena. Check this article
from Depesz:
http://www.depesz.com/index.php/2010/03/02/charx-vs-varcharx-vs-varchar-v
On 10/08/2014 10:22 AM, Emi Lu wrote:
Good morning,
For performance point of view, are there big differences between:
char(N), varchar(N), varchar, text?
Some comments from google shows:
No difference, under the hood it's all varlena. Check this article
from Depesz:
http://www.depesz.com/i
Good morning,
For performance point of view, are there big differences between:
char(N), varchar(N), varchar, text?
Some comments from google shows:
No difference, under the hood it's all varlena. Check this
article from Depesz: http://www.d
Thanks for your reply, Marti, as I answered to Tom couple of days ago
adjusting of 'effective_cache_size' to 80% of RAM and 'random_page_cost'
from 2 to 1 helped me.
On 8 October 2014 00:26, Marti Raudsepp wrote:
> On Fri, Oct 3, 2014 at 6:38 PM, Andrey Lizenko
> wrote:
> > Is it possible to f
07.10.2014, 19:59, "Tom Lane" :
> Vladimir Kamarzin writes:
>> After upgrade from 9.3.1 to 9.3.5 we expirienced a slight performance
>> degradation of all queries. Query time increased to some amount of ms,
>> mostly in range of 100ms. Some actions in our application results in a lot
>> of sm
