cost=0.00..13.92 rows=1
width=72) (actual time=1.146..1.146 rows=0 loops=1)
-> Index Scan using forfallnewgrgfid on
for_f_all_new f_f_all_new (cost=0.00..13.91 rows=1 width=72) (actual
time=1.135..1.135 rows=0 loops=1)
f possible) and add's a
SET work_maintenance_mem="the value calculated" (IF this value is less
than work_maintanence_max_mem. )
3) During the restore phase the appropriate memory is allocated in RAM
and the index creation takes less time since PG does not have to sort
on disk.
-
full pages in Oracle?
-----------
Adi Alurkar wrote:
Greetings,
I am not sure if this applies only to clustering but for storage in
general,
IIRC Oracle has 2 parameters that can be set at table creation :
from Oracle docs
PCTFREE integer :
Specify the percentage of space in each data block of
A high percentage value can result in faster selects and can be
used for
indexes that you do not expect to grow or for mostly read-only indexes.
Regards
Gaetano Mendola
---(end of
broadcast)---
TIP 7: don't forget to increase your free spac
