Profile

Cover photo
Anton Bushmelev
Lived in moscow
129 followers|188,360 views
AboutPosts

Stream

Anton Bushmelev

Shared publicly  - 
 
#selinux #ssh-key-auth
Trying to SSH in to remote computer but still asking for password,
this solution helps me :
chcon -R -t ssh_home_t .ssh
1
Add a comment...

Anton Bushmelev

Shared publicly  - 
 
Awesome feature! Postgresql is getting best from oracle. Thx to postgresql pro for their work!
1
Add a comment...

Anton Bushmelev

Shared publicly  - 
Oracle 12c Adaptive Query Optimization overhead published on 24.08.2016 Read more posts by the author of Oracle 12c Adaptive Query Optimization overhead, Bushmelev AntonКомментариев к записи Oracle 12c Adaptive Query Optimization overhead нет. Trying to find out overhead of new adaptive ...
1
Add a comment...

Anton Bushmelev

Shared publicly  - 
 
This Hangout On Air is hosted by Anton Bushmelev. The live video broadcast will begin soon.
Q&A
Preview
Live
What you need to know for Postgresql operation
Tue, June 21, 2016, 9:14 AM
Hangouts On Air - Broadcast for free

1
Anton Bushmelev's profile photo
 
https://orabase.org/owncloud/index.php/s/vdqNlAqNqIPLxil
не успел рассказать\дописать про блокировки и hot update + добавил ссылки на полезные материалы
 ·  Translate
Add a comment...

Anton Bushmelev

Shared publicly  - 
 
#oracle vs #postgres Российские реалии :(
 ·  Translate
1
Gleb Poljakov's profile photoAnton Bushmelev's profile photo
2 comments
 
:)) ты не представляешь на сколько. PG активно пилят сейчас, но на данном этапе это выглядит как раз как на картинке
 ·  Translate
Add a comment...

Anton Bushmelev

Shared publicly  - 
 
#oracle #optimizer add to bookmarks: White Papers and Blog Entries for Oracle Optimizer (Doc ID 1337116.1) 
1
Add a comment...

Anton Bushmelev

Shared publicly  - 
 

#postgresql #table_index_usage_info

SELECT
relid::regclass AS table,
indexrelid::regclass AS index,
pg_size_pretty(pg_relation_size(indexrelid::regclass)) AS index_size,
idx_tup_read,
idx_tup_fetch,
idx_scan
FROM
pg_stat_user_indexes
JOIN pg_index USING (indexrelid)
WHERE
relid = 'mc_case'::regclass
order by idx_scan;



select
pg_index.indrelid::regclass as table,
pg_index.indexrelid::regclass as index,
pg_attribute.attname as field,pg_statistic.stanullfrac,
pg_size_pretty(pg_relation_size(pg_index.indexrelid)) as indexsize
--,pg_get_indexdef(pg_index.indexrelid) as indexdef
from pg_index
join pg_attribute ON pg_attribute.attrelid=pg_index.indrelid AND pg_attribute.attnum=ANY(pg_index.indkey)
join pg_statistic ON pg_statistic.starelid=pg_index.indrelid AND pg_statistic.staattnum=pg_attribute.attnum
where pg_statistic.stanullfrac>0.5
and pg_index.indrelid = 'mc_case'::regclass
order by pg_relation_size(pg_index.indexrelid) desc,1,2,3;
1
Add a comment...

Anton Bushmelev

Shared publicly  - 
 
#postgresql tips and trics
PostgreSQL FILLFACTOR for UPDATE. 23 August 2014. This post discusses the performance impact of PostgreSQL FILLFACTOR table storage parameter on an UPDATE OLTP load. Note that this FILLFACTOR is indeed the table storage parameter, although there is also an eponymous parameter for indexes.
1
Add a comment...

Anton Bushmelev

Shared publicly  - 
 
#import_substitution #oracle_vs_postgres )))) а как же до конца года все на postgres перевести ?
 ·  Translate
1
Add a comment...
Story
Tagline
OCE RAC 11gR2, OCE PT 11gR2, ocp 12c, Postgresql associate
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
moscow
Links
Collections Anton is following
Work
Occupation
oracle dba
Skills
Oracle 11g Certified Performance Tuning Expert,Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator, Postgresql dba
Basic Information
Gender
Male