[PERFORM] Variable versus constrant size tuples
Is there any performance benefit of using constant size tuples? -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] Variable versus constrant size tuples
On 8/19/2011 4:03 AM, Krzysztof Chodak wrote: Is there any performance benefit of using constant size tuples? If you are referring to varchar(80) vs text, then no, there is no benefit. -Andy -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] Variable versus constrant size tuples
On Fri, Aug 19, 2011 at 4:03 AM, Krzysztof Chodak krzysztof.cho...@gmail.com wrote: Is there any performance benefit of using constant size tuples? not really. If your tuple size is under a known maximum length, then a toast table doesn't have to be created. that's a pretty minor detail though. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] Reports from SSD purgatory
On 08/15/2011 07:49 PM, Greg Smith wrote: News update for anyone else who's trapped like me, waiting for a fix to the Intel 320 SSD bug where they can truncate themselves to 8MB. Over the weekend Intel has announced a firmware fix for the problem is done, and is due to ship within the next two weeks: http://communities.intel.com/thread/24121 http://communities.intel.com/thread/24205 http://downloadcenter.intel.com/Detail_Desc.aspx?agr=YDwnldID=18363 I can't believe I'm going to end up using FreeDos to fix this problem. -- Greg Smith 2ndQuadrant USg...@2ndquadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance