Stack Overflow
Stack Overflow

Questions tagged [fillfactor]

Fill-factor is a technique used by some database engines to improve the performance of insertion and modification by reducing data rearrangement. Empty rows are added within sections of occupied rows to reserve space for future insertions or modifications.

26 questions
17
votes
4 answers

How to find out SQL Server table's read/write statistics?

Is there a way to find a statistics on table read and write count on SQL Server 2005/2008? I am specifically looking for DMVs/DMFs without using triggers or audits. The goal here is to find out appropriate fill factor for indexes - got an idea from…
dance2die
  • 35,807
  • 39
  • 131
  • 194
14
votes
2 answers

Changing fillfactor of existing table

Is it possible to change fillfactor of an existing table in PostgreSQL 8.4? Or do I have to create copy of a table with new fillfactor - which is not the best approach because of foreign key problems?
Daimon
  • 3,703
  • 2
  • 28
  • 30
10
votes
1 answer

Checking fillfactor setting for tables and indexes

There is maybe some function to check the fillfactor for indexes and tables? I've tried already \d+ but have basic definition only, without fillfactor value: Index "public.tab1_pkey" Column | Type | Definition | Storage…
Borys
  • 2,676
  • 2
  • 24
  • 37
8
votes
2 answers

Export SqlDatabase to Bacpac using SqlPackage.exe fails on fillfactor

I am using the following command to execute sqlpackage to export a bacpac for a local db. "C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\sqlpackage.exe" /action:Export /tf:".\dbname_Baseline.bacpac"…
peter pan
  • 281
  • 4
  • 14
8
votes
2 answers

How do you measure SQL Fill Factor value

Usually when I'm creating indexes on tables, I generally guess what the Fill Factor should be based on an educated guess of how the table will be used (many reads or many writes). Is there a more scientific way to determine a more accurate Fill…
GateKiller
  • 74,180
  • 73
  • 171
  • 204
7
votes
1 answer

Postgres: Set fillfactor to 50?

I have a table of records that is populated sequentially once, but then every record is updated (the order in which they are updated and the timing of the updates are both random). The updates are not HOT updates. Is there any advantage to setting…
carbocation
  • 8,806
  • 7
  • 25
  • 30
7
votes
6 answers

Sql Server change fill factor value for all indexes by tsql

I have to expoet my DB into a bacpac file to import it into Azure. When I try to export I get an error because any indexes have a fillFactor value. I've found how to set a fillFactor value for all indexes but I can't specify 0, the value have to be…
danielUrrero
  • 71
  • 1
  • 1
  • 2
5
votes
2 answers

MySql Index Fill Factor?

How do you specify the Fill Factor when creating an index in MySql?
GateKiller
  • 74,180
  • 73
  • 171
  • 204
4
votes
1 answer

Tweaking the Fill Factor to reduce fragmentation

I have an non-clustered index that has ~1000 pages, 95% fragmentation and a FillFactor of '0'. I rebuilt the index on Sunday. A week later, the index has 95% (or so) fragmentation again. Is this an indication that I need to change the FillFactor to…
Chris Burgess
  • 5,787
  • 13
  • 54
  • 69
4
votes
2 answers

How is fill factor physically allocated?

I've been trawling books online and google incantations trying to find out what fill factor physically is in a leaf-page (SQL Server 2000 and 2005). I understand that its the amount of room left free on a page when an index is created, but what I've…
Chris J
  • 30,688
  • 6
  • 69
  • 111
4
votes
1 answer

Modify Fill Factor of Primary Keys in all tables in MS SQL 2008 R2

Is there any working method for modifying the Fill Factor arguments of all tables' Primary Keys in a Database?
Babu James
  • 2,740
  • 4
  • 33
  • 50
3
votes
1 answer

Tuning FILLFACTOR for high-UPDATE tables in Postgres 13

HOT and FILLFACTOR Results I've got some high-UPDATE tables where I've adjusted the FILLFACTOR to 95%, and I'm checking back in on them. I don't think that I've got the settings right, and am unclear how to tune them intelligently. I took another…
Morris de Oryx
  • 1,857
  • 10
  • 28
3
votes
1 answer

Fillfactor for a sequential index that is PK

Yes, fillfactor again. I spend many hours reading and I can't decide what's best for each case. I don't understand when and how fragmentation happens. I'm migrating a database from MS SQL Server to PostgreSQL 9.2. Case 1 10-50 inserts / minute in a…
HMarioD
  • 842
  • 10
  • 18
2
votes
1 answer

How to create PostgreSQL table with partition and fill factor

I am trying to create a PostgreSQL table with partition and fillfactor and I am getting an error CREATE TABLE public."Test1" ( col1 int NOT NULL GENERATED BY DEFAULT AS IDENTITY, col2 varchar NULL, col3 date null ) partition by range…
Thaz
  • 35
  • 9
1
vote
1 answer

Fill factor For B-trees. Why fill factor is respected when extending the index at the right and not in other case (except during index creation)?

I'm trying to understand the fillfactor in case of btree indexes. From the postgres documentation: For B-trees, leaf pages are filled to this percentage during initial index build, and also when extending the index at the right (adding new largest…
SGiux
  • 619
  • 3
  • 10
  • 34
1
2