Skip to content

a1: alignment padding report#6

Merged
NikolayS merged 45 commits into
masterfrom
alignment
Jan 30, 2018
Merged

a1: alignment padding report#6
NikolayS merged 45 commits into
masterfrom
alignment

Conversation

@NikolayS
Copy link
Copy Markdown
Owner

@NikolayS NikolayS commented Jan 8, 2018 •
edited
Loading

see #5

Simple example:

create table bad1  as select 2::int2, 8::int8, 4::int4 from generate_series(1, 1000000);
create table good1 as select 2::int2, 4::int4, 8::int8 from generate_series(1, 1000000);

and then use :dba: and select a1 report to see the difference:

screen shot 2018-01-30 at 15 26 55

NikolayS added 30 commits January 7, 2018 17:38
@NikolayS
draft a1: alignment padding report
479907f
@NikolayS
do not use current_setting for custom GUC (for server 9.5-)
a669c35
@NikolayS
Merge branch 'master' of github.com:NikolayS/PostgresDBA into alignment
67402f4
@NikolayS
first real working fraft for alignment estimation
8cd45c8
@NikolayS
first real working fraft for alignment estimation
0250b5e
@NikolayS
first real working fraft for alignment estimation
d19af1f
@NikolayS
TODO note to fix a warning
1cba5d5
@NikolayS
a1: padding for types with typalign=c
2622162
@NikolayS
a1: char(N), reworked algorithm, more details in "wide" mode
b5e8f93
@NikolayS
Update a1_alignment_padding.sql
0125562
@NikolayS
psql, server version checks
dcb4fd6
@NikolayS
Merge branch 'master' of github.com:NikolayS/PostgresDBA into alignment
5042add
@NikolayS
Merge branch 'alignment' of github.com:NikolayS/PostgresDBA into alig…
4be130e 
…nment
@NikolayS
typo
e19ee49
@NikolayS
fix wide mode
81d8294
@NikolayS
Merge branch 'master' of github.com:NikolayS/postgres_dba into alignment
ab727a6
@NikolayS
setup circleci
e0b9d91
@NikolayS
setup circleci
aacc012
@NikolayS
setup circleci
723890d
@NikolayS
setup circleci
213d68b
@NikolayS
setup circleci
c412dac
@NikolayS
setup circleci
61cb432
@NikolayS
setup circleci
3ca20cf
@NikolayS
setup circleci
1645f6a
@NikolayS
setup circleci
218b501
@NikolayS
setup circleci
464c27c
@NikolayS
setup circleci
fca4c44
@NikolayS
lsb_release does not work, user hardcoded ubuntu name
89f3b94
@NikolayS
test a1
70c4b9b
@NikolayS
test a1
a846999
@NikolayS NikolayS merged commit bba0a98 into master Jan 30, 2018
@NikolayS NikolayS changed the title [WIP] draft a1: alignment padding report a1: alignment padding report Jan 30, 2018
@NikolayS NikolayS deleted the alignment branch January 30, 2018 23:34
@NikolayS NikolayS restored the alignment branch January 30, 2018 23:34
@NikolayS NikolayS deleted the alignment branch January 30, 2018 23:34
@NikolayS NikolayS mentioned this pull request Apr 21, 2026
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

1 participant

@NikolayS