online_analyze.git
3 months agoFix tests, thanks to Ekaterina Sokolova.
Teodor Sigaev [Mon, 15 Jul 2024 18:27:58 +0000 (21:27 +0300)]
Fix tests, thanks to Ekaterina Sokolova.

3 months agoAdd COPY command support, thanks for Andrew Bille for test patch
Teodor Sigaev [Thu, 11 Jul 2024 10:50:42 +0000 (13:50 +0300)]
Add COPY command support, thanks for Andrew Bille for test patch

6 months agoRemove _PG_fini Mikhail Litsarev
Teodor Sigaev [Thu, 4 Apr 2024 11:58:48 +0000 (14:58 +0300)]
Remove _PG_fini Mikhail Litsarev

6 months agoReplace BackendIds with 0-based ProcNumbers Marina Polyakova <m.polyakova@postgrespro.ru>
Teodor Sigaev [Tue, 2 Apr 2024 11:42:05 +0000 (14:42 +0300)]
Replace BackendIds with 0-based ProcNumbers Marina Polyakova <m.polyakova@postgrespro.ru>

18 months agoAdd simple tests and meson build. Maxim Orlov <m.orlov@postgrespro.ru>
Teodor Sigaev [Mon, 24 Apr 2023 15:16:31 +0000 (18:16 +0300)]
Add simple tests and meson build. Maxim Orlov <m.orlov@postgrespro.ru>

21 months agov16 support. Dmitry Koval
Teodor Sigaev [Wed, 18 Jan 2023 13:09:49 +0000 (16:09 +0300)]
v16 support. Dmitry Koval

22 months agoSupport v16devel
Teodor Sigaev [Wed, 21 Dec 2022 08:03:43 +0000 (11:03 +0300)]
Support v16devel
Marina Polyakova

2 years agoSupport for v15
Teodor Sigaev [Thu, 6 Oct 2022 13:50:39 +0000 (16:50 +0300)]
Support for v15
Dmitry Koval

2 years agoadd pgproee support
Teodor Sigaev [Tue, 14 Dec 2021 21:31:54 +0000 (00:31 +0300)]
add pgproee support

3 years agoFix mistype include/exclude. Per Pavel Saphonov.
Teodor Sigaev [Mon, 18 Oct 2021 16:06:22 +0000 (19:06 +0300)]
Fix mistype  include/exclude. Per Pavel Saphonov.

3 years agoFix usage of include_tables/exclude_tables in case of preloaded libraries.
Teodor Sigaev [Thu, 7 Oct 2021 15:35:33 +0000 (18:35 +0300)]
Fix usage of include_tables/exclude_tables in case of preloaded libraries.

Code makes a catalog search while process is not yet connected
to database and fails. Now catalog lookups are delayed until
system catalog is accessible. The idea was taken from plantuner module.

3 years agoSupport for v14
Teodor Sigaev [Mon, 21 Jun 2021 10:00:13 +0000 (13:00 +0300)]
Support for v14
Marina Polyakova <m.polyakova@postgrespro.ru>

4 years agoAdd commemt about fallback in switch. Add missed break in switch
Teodor Sigaev [Thu, 18 Jun 2020 08:57:03 +0000 (11:57 +0300)]
Add commemt about fallback in switch. Add missed break in switch

4 years agosupport v13
Teodor Sigaev [Mon, 15 Jun 2020 20:49:45 +0000 (23:49 +0300)]
support v13

5 years agoready for v12
Teodor Sigaev [Mon, 22 Jul 2019 11:46:03 +0000 (14:46 +0300)]
ready for v12

5 years agolet analyze runs with NOWAIT option, it prevents self-deadlock in corner cases
Teodor Sigaev [Fri, 25 Jan 2019 10:54:44 +0000 (13:54 +0300)]
let analyze runs with NOWAIT option, it prevents self-deadlock in corner cases

6 years agoChanged call AllocSetContextCreate in the online_analyze.c
Teodor Sigaev [Tue, 24 Jul 2018 13:31:42 +0000 (16:31 +0300)]
Changed call AllocSetContextCreate in the online_analyze.c
Victor Spirin

6 years agofix forcing online analyze in case of analyze command
Teodor Sigaev [Fri, 15 Jun 2018 13:07:48 +0000 (16:07 +0300)]
fix forcing online analyze in case of analyze command

6 years agoadd assert
Teodor Sigaev [Fri, 15 Jun 2018 12:35:55 +0000 (15:35 +0300)]
add assert

6 years agofix support of v11
Teodor Sigaev [Fri, 15 Jun 2018 12:17:29 +0000 (15:17 +0300)]
fix support of v11

6 years agov11 support
Teodor Sigaev [Thu, 14 Jun 2018 18:05:18 +0000 (21:05 +0300)]
v11 support

7 years agoFix visibility of analyze.
Teodor Sigaev [Fri, 13 Oct 2017 14:17:01 +0000 (17:17 +0300)]
Fix visibility of analyze.
Dmitry Ivanov <d.ivanov@postgrespro.ru>

7 years agoFix crashing on database-wide vacuum/analyze
Teodor Sigaev [Fri, 21 Jul 2017 14:05:28 +0000 (17:05 +0300)]
Fix crashing on database-wide vacuum/analyze

7 years agoFix wrong usage of RegisterXactCallback()
Teodor Sigaev [Wed, 14 Jun 2017 12:22:11 +0000 (15:22 +0300)]
Fix wrong usage of RegisterXactCallback()

7 years agocleanup local hash on drop table command n_tuples_limit
Teodor Sigaev [Wed, 10 May 2017 16:09:55 +0000 (19:09 +0300)]
cleanup local hash  on drop table command

7 years agoadd locl_tracking GUC
Teodor Sigaev [Wed, 10 May 2017 15:02:24 +0000 (18:02 +0300)]
add locl_tracking GUC

7 years agoadd support for vacuum/analyze
Teodor Sigaev [Thu, 20 Apr 2017 14:05:04 +0000 (17:05 +0300)]
add support for vacuum/analyze

7 years agoturn off reread flag in case of truncation
Teodor Sigaev [Thu, 13 Apr 2017 15:21:22 +0000 (18:21 +0300)]
turn off reread flag in case of truncation

7 years agoimprove support for fasttruncate
Teodor Sigaev [Tue, 11 Apr 2017 12:16:50 +0000 (15:16 +0300)]
improve support for fasttruncate

7 years agoMerge branch 'n_tuples_limit' of ssh://hook.sigaev.ru/spool/git/online_analyze into...
Teodor Sigaev [Mon, 10 Apr 2017 16:30:36 +0000 (19:30 +0300)]
Merge branch 'n_tuples_limit' of ssh://hook.sigaev.ru/spool/git/online_analyze into n_tuples_limit

7 years agoadd working with fasttruncate
Teodor Sigaev [Mon, 10 Apr 2017 16:25:59 +0000 (19:25 +0300)]
add working with fasttruncate

7 years agofix accounting of n tpules after truncate, athough it should not affect anything
Teodor Sigaev [Mon, 10 Apr 2017 16:25:59 +0000 (19:25 +0300)]
fix accounting of n tpules after truncate, athough it should not affect anything

7 years agoreduce stat rereads
Teodor Sigaev [Fri, 7 Apr 2017 14:20:25 +0000 (17:20 +0300)]
reduce stat rereads

7 years agoMerge branch 'local_hash' into n_tuples_limit
Teodor Sigaev [Fri, 7 Apr 2017 14:13:37 +0000 (17:13 +0300)]
Merge branch 'local_hash' into n_tuples_limit

7 years agotry to optimize reread stat
Teodor Sigaev [Fri, 7 Apr 2017 14:10:56 +0000 (17:10 +0300)]
try to optimize reread stat

7 years agocheck online_analyze.enable for create table as
Teodor Sigaev [Wed, 5 Apr 2017 15:44:08 +0000 (18:44 +0300)]
check online_analyze.enable for create table as

7 years agosupport pgsql 10
Teodor Sigaev [Wed, 5 Apr 2017 15:39:41 +0000 (18:39 +0300)]
support pgsql 10

7 years agoadd online_analyze.lower_limit, use int64 to count changes rows
Teodor Sigaev [Fri, 3 Feb 2017 14:39:08 +0000 (17:39 +0300)]
add online_analyze.lower_limit, use int64 to count changes rows

7 years agofix compile with pg < 9.6, fix memory context allocation local_hash
Teodor Sigaev [Thu, 24 Nov 2016 09:04:21 +0000 (12:04 +0300)]
fix compile with pg < 9.6, fix memory context allocation

7 years agodo not sore permanent table in local cache and add limit for table cache
Teodor Sigaev [Thu, 10 Nov 2016 16:36:48 +0000 (19:36 +0300)]
do not sore permanent table in local cache and add limit for table cache

7 years agoUse local cache for tracking changes to reduce reading file
Teodor Sigaev [Wed, 9 Nov 2016 17:01:17 +0000 (20:01 +0300)]
Use local cache for tracking changes to reduce reading file

8 years agoDo not miss relkind check
Teodor Sigaev [Tue, 18 Oct 2016 07:52:20 +0000 (10:52 +0300)]
Do not miss relkind check

8 years agoTry to reduce CPU consumption
Teodor Sigaev [Mon, 17 Oct 2016 15:04:03 +0000 (18:04 +0300)]
Try to reduce CPU consumption

1 use only one hash lookup to get Relation
2 move pgstat_fetch_stat_tabentry() to the last check, because
  this call is rather expensive

8 years agocleanup formatting
Teodor Sigaev [Mon, 29 Aug 2016 14:25:16 +0000 (17:25 +0300)]
cleanup formatting

8 years agodistinguish unknown and zero number of affected rows
Teodor Sigaev [Mon, 29 Aug 2016 14:19:14 +0000 (17:19 +0300)]
distinguish unknown and zero number of affected rows

9 years agomakeRangeVar for 9.5
Teodor Sigaev [Tue, 3 Nov 2015 16:32:19 +0000 (19:32 +0300)]
makeRangeVar for 9.5

9 years agoInitial 9.5
Teodor Sigaev [Fri, 18 Sep 2015 15:47:45 +0000 (18:47 +0300)]
Initial 9.5

9 years agosupport 9.4
Teodor Sigaev [Fri, 21 Nov 2014 13:17:08 +0000 (16:17 +0300)]
support 9.4

11 years agofix docs
Teodor Sigaev [Tue, 10 Sep 2013 08:33:45 +0000 (12:33 +0400)]
fix docs

11 years agosupport of 9.3.0
Teodor Sigaev [Tue, 10 Sep 2013 08:31:55 +0000 (12:31 +0400)]
support of 9.3.0

12 years agofix custom variable
Teodor Sigaev [Tue, 25 Sep 2012 13:13:16 +0000 (17:13 +0400)]
fix custom variable

12 years agokeep compiler quiet
Teodor Sigaev [Mon, 17 Sep 2012 15:37:47 +0000 (19:37 +0400)]
keep compiler quiet

12 years agocheck relation type
Teodor Sigaev [Mon, 17 Sep 2012 14:19:41 +0000 (18:19 +0400)]
check relation type

12 years agofix MSVS2010 compile problem
Teodor Sigaev [Mon, 17 Sep 2012 08:37:50 +0000 (12:37 +0400)]
fix MSVS2010 compile problem

12 years agomake beauty
Teodor Sigaev [Thu, 13 Sep 2012 15:45:53 +0000 (19:45 +0400)]
make beauty

12 years agomake work CREATE TABLE AS/SELECT INTO in 9.2.
Teodor Sigaev [Thu, 13 Sep 2012 15:42:13 +0000 (19:42 +0400)]
make work CREATE TABLE AS/SELECT INTO in 9.2.

12 years agomake compile on 9.2, although CREATE TABLE AS/SELECT INTO is not working yet
Teodor Sigaev [Tue, 11 Sep 2012 18:27:38 +0000 (22:27 +0400)]
make compile on 9.2, although CREATE TABLE AS/SELECT INTO is not working yet

12 years agoadd .gitignore
Teodor Sigaev [Wed, 25 Apr 2012 15:00:13 +0000 (19:00 +0400)]
add .gitignore

13 years agofix typos
teodor [Mon, 3 Oct 2011 14:38:32 +0000 (14:38 +0000)]
fix typos

13 years agosupport 9.1
teodor [Mon, 3 Oct 2011 14:31:26 +0000 (14:31 +0000)]
support 9.1

13 years agonew GUC variables
teodor [Mon, 3 Oct 2011 14:22:08 +0000 (14:22 +0000)]
new GUC variables

13 years agoadd copyright
teodor [Thu, 29 Sep 2011 12:32:26 +0000 (12:32 +0000)]
add copyright

13 years agoInitial revision
teodor [Thu, 29 Sep 2011 12:26:25 +0000 (12:26 +0000)]
Initial revision