[HACKERS] Using Small Size SSDs to improve performance?

2010-08-04 Thread Nilson
scheme. In case of the fast volume full condition, postgreSQL should use the main volume. The (2) solution is more delicate because introduce a new type of file to hold data. But, if the gain worths, it should be examinated ... Well, that´s it. -- Nilson

Re: [HACKERS] Toward a column reorder solution

2010-07-27 Thread Nilson Damasceno
a primary key for attributes is almost the same of the current solutions to reorder the columns: a) recreate the table b) "shift" the columns. Nilson On Tue, Jul 27, 2010 at 6:45 PM, Andrew Dunstan wrote: > > > Nilson wrote: > > Quoting "wiki.postgresql.

[HACKERS] Toward a column reorder solution

2010-07-27 Thread Nilson
angeable. So, when *attnum *becomes read/write, all that software will be ready. Cons - More 4 bytes in each row of the catalog. Nilson