On Sun, Dec 27, 2020 at 10:55 PM Masahiko Sawada wrote:
> > As you said, the next question must be: How do we teach lazy vacuum to
> > not do what gets requested by amvacuumcleanup() when it cannot respect
> > the wishes of one individual indexes, for example when the
> > accumulation of LP_DEAD
Hello Sawada-San
On Monday, December 28, 2020 2:29 PM Masahiko Sawada
wrote:
> On Thu, Dec 3, 2020 at 12:14 PM osumi.takami...@fujitsu.com
> wrote:
> >
> > I've made a new patch v05 that took in comments to filter out WALs
> > more strictly and addressed some minor fixes that were discussed
>
On Thu, Dec 24, 2020 at 12:59 PM Peter Geoghegan wrote:
>
> On Tue, Dec 22, 2020 at 2:54 PM Masahiko Sawada wrote:
> > I've started this separate thread from [1] for discussing the general
> > API design of index vacuum.
>
> This is a very difficult and very important problem. Clearly defining
>
> 28 дек. 2020 г., в 10:20, Dilip Kumar написал(а):
>
> On Sun, Dec 27, 2020 at 12:40 PM Andrey Borodin wrote:
>>
>>
>>
>>> 25 дек. 2020 г., в 14:34, Dilip Kumar написал(а):
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>> Maybe add Lz4\Zlib WAL FPI compression on top of this patchset? I'm
On Sun, Dec 27, 2020 at 2:28 PM Bharath Rupireddy <
bharath.rupireddyforpostg...@gmail.com> wrote:
>
> On Sat, Dec 26, 2020 at 9:20 PM vignesh C wrote:
> > +-- parallel inserts must occur
> > +select explain_pictas(
> > +'create table parallel_write as select length(stringu1) from tenk1;');
> >
On Thu, Dec 3, 2020 at 12:14 PM osumi.takami...@fujitsu.com
wrote:
>
> Hello
>
>
> I've made a new patch v05 that took in comments
> to filter out WALs more strictly and addressed some minor fixes
> that were discussed within past few days.
> Also, I changed the documentations, considering those
po 28. 12. 2020 v 0:55 odesílatel Tom Lane napsal:
> Pavel Stehule writes:
> > Now, the behavior of SELECT INTO is behind the assign statement and this
> > fact should be documented. Usually we don't need to use array's fields
> > here, but somebody can try it.
>
> It's been behind all along
On Sun, Dec 27, 2020 at 12:40 PM Andrey Borodin wrote:
>
>
>
> > 25 дек. 2020 г., в 14:34, Dilip Kumar написал(а):
> >
> >
> >
> >
> >
> >
> >
>
> Maybe add Lz4\Zlib WAL FPI compression on top of this patchset? I'm not
> insisting on anything, it just would be so cool to have it...
>
On Sun, Dec 27, 2020 at 2:20 PM Bharath Rupireddy
wrote:
>
> On Sat, Dec 26, 2020 at 11:11 AM Dilip Kumar wrote:
> > I have reviewed part of v15-0001 patch, I have a few comments, I will
> > continue to review this.
>
> Thanks a lot.
>
> > 1.
> > Why is this temporary hack? and what is the plan
https://postgr.es/m/20201031163518.gb4039...@rfd.leadboat.com gave $SUBJECT as
one of the constituent projects for changing the public schema default ACL.
This feature stands on its own, hence the new thread. I showed syntax "ALTER
SCHEMA public OWNER TO DATABASE_OWNER" and anticipated a new
On Thu, Dec 24, 2020 at 6:59 AM Thomas Munro wrote:
> On Thu, Dec 17, 2020 at 10:22 PM Andy Fan
> wrote:
> > Let me try to understand your point. Suppose process 1 extends a file to
> > 2 blocks from 1 block, and fsync is not called, then a). the lseek *may*
> still
> > return 1 based on the
Pavel Stehule writes:
> Now, the behavior of SELECT INTO is behind the assign statement and this
> fact should be documented. Usually we don't need to use array's fields
> here, but somebody can try it.
It's been behind all along --- this patch didn't really change that.
But I don't mind
so 26. 12. 2020 v 19:00 odesílatel Pavel Stehule
napsal:
> Hi
>
> I repeated tests. I wrote a set of simple functions. It is a synthetical
> test, but I think it can identify potential problems well.
>
> I calculated the average of 3 cycles and I checked the performance of each
> function. I
Whoa that's perfect! Thank you so much.
On Thu, Dec 24, 2020 at 4:59 PM Ian Lawrence Barwick
wrote:
> 2020年12月23日(水) 22:05 Eric Hanson :
> >
> > I'm trying to store connection to postgres_fdw in the database I want
> to be able to store the full breadth of connection styles and all the
>
On Thu, Dec 24, 2020 at 05:12:02PM +0900, Michael Paquier wrote:
> I have applied most of it on HEAD, except 0011 and the things noted
> above. Thanks again.
Thank you.
I see that I accidentally included ZSTD_COMPRESSION in pg_backup_archiver.h
while cherry-picking from the branch where I first
vacuum_cost_page_miss has a default value of 10, while
vacuum_cost_page_dirty has a default value of 20. This has been the
case since cost-based delays were introduced by commit f425b605f4e
back in 2004. The obvious implication is that dirtying a page is on
average only twice as expensive as a
Hi,
When developing extensions, I find myself spending time on manually checking
if my update scripts (invoked via ALTER EXTENSION ... UPDATE) gives the same
result as
CREATE EXTENSION ... would do if installing the latest version from scratch
without any previous version.
I thought it would
For v16-0002-Tuple-Cost-Adjustment-for-Parallel-Inserts-in-CTAS.patch:
+ if (ignore &&
+ (root->parse->CTASParallelInsInfo &
+CTAS_PARALLEL_INS_TUP_COST_CAN_IGN))
I wonder why CTAS_PARALLEL_INS_TUP_COST_CAN_IGN is checked again in the
above if since when
On Sun, Dec 27, 2020 at 9:07 PM David Fetter wrote:
> On Sun, Dec 27, 2020 at 09:53:13AM -0800, Zhihong Yu wrote:
> > This is not an ideal way to index multirages, but something we can
> > easily have.
>
> What sort of indexing improvements do you have in mind?
Approximation of multirange as a
On Sun, Dec 27, 2020 at 8:52 PM Zhihong Yu wrote:
> This is not an ideal way to index multirages, but something we can easily
> have.
>
> typo: multiranges
Thanks for catching. I will revise the commit message before committing.
--
Regards,
Alexander Korotkov
On Wed, Dec 16, 2020 at 11:22:23AM -0600, Justin Pryzby wrote:
> On Sun, Dec 06, 2020 at 12:02:48PM -0600, Justin Pryzby wrote:
> > I meant to notice if the binary format is accidentally changed again, which
> > was
> > what happened here:
> > 7c15cef86 Base information_schema.sql_identifier
On Sun, Dec 27, 2020 at 09:53:13AM -0800, Zhihong Yu wrote:
> Hi,
>
> This is not an ideal way to index multirages, but something we can
> easily have.
What sort of indexing improvements do you have in mind?
Best,
David.
--
David Fetter http://fetter.org/
Phone: +1 415 235 3778
Remember to
Hi,
This is not an ideal way to index multirages, but something we can easily
have.
typo: multiranges
Cheers
On Sun, Dec 27, 2020 at 1:50 AM Alexander Korotkov
wrote:
> On Thu, Dec 17, 2020 at 10:10 PM Alexander Korotkov
> wrote:
> >
> > I think this patch is very close to committable. I'm
On Sun, Dec 27, 2020 at 09:14:53AM -0400, Fabien COELHO wrote:
> > src/test/regress/sql/create_am.sql:CREATE ACCESS METHOD heap2 TYPE TABLE
> > HANDLER heap_tableam_handler;
> > ...
> > src/test/regress/sql/create_am.sql:DROP ACCESS METHOD heap2;
>
> > Or maybe using SET default_tablespace
On Sat, Dec 19, 2020 at 11:45:08AM +, Alastair Turner wrote:
> On Fri, 18 Dec 2020 at 21:36, Stephen Frost wrote:
> > These ideas don't seem too bad but I'd think we'd pass which key we want
> > on the command-line using a %i or something like that, rather than using
> > stdin, unless there's
> 8 дек. 2020 г., в 16:44, Denis Smirnov написал(а):
>
> Andrey, thanks for your feedback!
>
> I agree that AMs with fix sized blocks can have much alike code in
> acquire_sample_rows() (though it is not a rule). But there are several points
> about current master sampling.
>
> * It is
On Fri, 2020-12-25 at 20:28 +0900, Masahiro Ikeda wrote:
> As a user, I want this feature to know whether
> clients' session activities are as expected.
>
> I have some comments about the patch.
>
> 1. pg_proc.dat
>
> The unit of "session time" and so on says "in seconds".
> But, is "in
Hello Justin,
src/test/regress/sql/create_am.sql:CREATE ACCESS METHOD heap2 TYPE TABLE
HANDLER heap_tableam_handler;
...
src/test/regress/sql/create_am.sql:DROP ACCESS METHOD heap2;
Or maybe using SET default_tablespace instead of modifying the CREATE sql.
That'd need to be done separately
On Thu, Dec 17, 2020 at 10:10 PM Alexander Korotkov
wrote:
>
> I think this patch is very close to committable. I'm going to spend
> some more time further polishing it and commit (if I don't find a
> major issue or face objections).
The main patch is committed. I've prepared a set of
On Sat, Dec 26, 2020 at 9:20 PM vignesh C wrote:
> +-- parallel inserts must occur
> +select explain_pictas(
> +'create table parallel_write as select length(stringu1) from tenk1;');
> +select count(*) from parallel_write;
> +drop table parallel_write;
>
> We can change comment "parallel inserts
On Fri, Dec 04, 2020 at 06:09:13PM +0800, Julien Rouhaud wrote:
> On Fri, Dec 04, 2020 at 12:06:10PM +0300, Sergei Kornilov wrote:
> > Hello
> >
> > Seems we need also change PGSS_FILE_HEADER.
>
> Indeed, thanks! v2 attached.
There was a conflict on PGSS_FILE_HEADER since some recent commit,
31 matches
Mail list logo
